IST_TELNH - IS-T: Telephone Numbers

IS-T: Telephone Numbers information is stored in SAP table IST_TELNH.
It is part of development package CRM_PRODUCT_TELNR in software component CRM-IT. This development package consists of objects that can be grouped under "Set Type for Phone Numbers".

Fields for table IST_TELNH

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		COMT_FRGH_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
FRG_GUID	Set GUID	X	COMT_FRG_GUID	RAW	16
VALID_TO	Valid To (Time Stamp)	X	COMT_VALID_TO	DEC	8
.INCLUDE				COMT_FRAGMENTH_ADM	0
VALID_FROM	Valid From (Time Stamp)		COMT_VALID_FROM	DEC	8
UPNAME	Name of the User Who Last Changed the Set		COMT_UPNAME	CHAR	24
ACODE	Area Code		ISTTEL_AREA_CODE	CHAR	14
ADDKEY	Additional Key		ISTTEL_ADDKEY	CHAR	64
BGUID	Contract Account GUID		ISTTEL_BUAG_GUID	CHAR	64
CANCELED	Cancelled Indicator		ISTTEL_CANCELED	CHAR	2
CANCELR	Termination Reason		ISTTEL_CANCEL_REASON	CHAR	4
CCODE	Country Code		ISTTEL_COUNTRY_CODE	CHAR	14
GROUP_ID	Grouping Information		ISTTEL_GROUP_ID	CHAR	64
KISDN	ISDN Indicator		ISTTEL_K_ISDN	CHAR	2
KLEAD	Leading Phone Number Indicator		ISTTEL_K_LEAD	CHAR	2
KPNUM	Permanent Call Number Indicator		ISTTEL_K_PNUM	CHAR	2
LOCKED	Locked Indicator		ISTTEL_LOCKED	CHAR	2
LOCK_R	Disconnection Reason		ISTTEL_LOCK_REASON	CHAR	4
LOCK_T	Disconnection Type		ISTTEL_LOCK_TYPE	CHAR	4
NOLOCK	No Lock Indicator		ISTTEL_NO_LOCK	CHAR	2
NOLOCK_R	Reason for Lock Release		ISTTEL_NO_LOCK_R	CHAR	4
OGUID	Contract Item GUID		ISTTEL_ORDERPOS_GUID	CHAR	64
PGUID	Business Partner GUID		ISTTEL_PARTNER_GUID	CHAR	64
TCOMP	Telephone Number - Full		ISTTEL_TELNUM_COMP	CHAR	30
TELNUM	Telephone Number		ISTTEL_TELNUM	CHAR	18
KGSM	Mobile Telephone Number Indicator		ISTTEL_K_GSM	CHAR	2