SAP ABAP View ISTV_TCTEL (Telephone Number Management)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IT-BTX (Application Component) Business Transaction
     ⤷ ISTCRM03 (Package) IS-T: Object/Telephone Number Management

Basic Data

View Type	D	Database View
Database View	ISTV_TCTEL
Short Description	Telephone Number Management
Root table	ISTT_TC_OBJ	Generic Attributes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ISTT_TC_OBJ	ISTT_TC_OBJ
2	ISTT_TC_TELNR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ISTT_TC_OBJ	CLIENT	JL	EQ				0	0
2	ISTT_TC_TELNR	CLIENT	JR	EQ			AND	0	0
3	ISTT_TC_OBJ	OBJ_GUID	JL	EQ				0	0
4	ISTT_TC_TELNR	OBJ_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ISTT_TC_TELNR	CLIENT		☐	MANDT	☐	Client
2	TELNR_GUID	ISTT_TC_TELNR	TELNR_GUID		☐	ISTT_TEL_GUID	☐	GUID for an Entry in the Telephone Number Management Table
3	OBJ_GUID	ISTT_TC_TELNR	OBJ_GUID		☐	ISTT_OBJ_GUID	☐	GUID for an Entry in Object Management Table
4	TELNUM_COMP	ISTT_TC_TELNR	TELNUM_COMP		☐	ISTT_TEL_TELNUM_COMP	☐	Telephone Number - Full
5	AREA_CODE	ISTT_TC_TELNR	AREA_CODE		☐	ISTT_TEL_AREACODE	☐	Area Code
6	TELNUM	ISTT_TC_TELNR	TELNUM		☐	ISTT_TEL_TELNUM	☐	Telephone Number
7	COUNTRY_CODE	ISTT_TC_TELNR	COUNTRY_CODE		☐	ISTT_TEL_CCODE	☐	Country Code
8	K_ISDN	ISTT_TC_TELNR	K_ISDN		☐	ISTT_TEL_ISDN	☐	ISDN Indicator
9	K_PNUM	ISTT_TC_TELNR	K_PNUM		☐	ISTT_TEL_PNUM	☐	Indicator: Permanent Telephone Number
10	SERVICE	ISTT_TC_OBJ	SERVICE		☐	ISTT_SERVICE	☐	Type of Service
11	PARTNER_GUID	ISTT_TC_OBJ	PARTNER_GUID		☐	BU_PARTNER_GUID	☐	Business Partner GUID
12	ORDER_GUID	ISTT_TC_OBJ	ORDER_GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
13	ORDERPOS_GUID	ISTT_TC_OBJ	ORDERPOS_GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
14	GROUP_ID	ISTT_TC_OBJ	GROUP_ID		☐	ISTT_GROUP_ID	☐	Group ID
15	CANCELED	ISTT_TC_OBJ	CANCELED		☐	ISTT_CANCELED	☐	Indicator: Object is Terminated
16	CANCEL_REASON	ISTT_TC_OBJ	CANCEL_REASON		☐	ISTT_CANCELREASON	☐	Termination Reason
17	VALID_FROM	ISTT_TC_OBJ	VALID_FROM		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	VALID_TO	ISTT_TC_OBJ	VALID_TO		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
19	LOCKED	ISTT_TC_OBJ	LOCKED		☐	ISTT_LOCKED	☐	Indicator: Object is Locked
20	LOCK_TYPE	ISTT_TC_OBJ	LOCK_TYPE		☐	ISTT_LOCKTYPE	☐	Lock Type
21	LOCK_REASON	ISTT_TC_OBJ	LOCK_REASON		☐	ISTT_LOCKREASON	☐	Reason for Lock
22	NO_LOCK	ISTT_TC_OBJ	NO_LOCK		☐	ISTT_NOLOCK	☐	Reconnection Indicator
23	NO_LOCK_REASON	ISTT_TC_OBJ	NO_LOCK_REASON		☐	ISTT_NOLOCK_REASON	☐	Reconnection Reason
24	HOME_SYSTEM	ISTT_TC_OBJ	HOME_SYSTEM		☐	ISTT_LOGSYS	☐	Logical System in Which Entry is Created
25	VKONT	ISTT_TC_OBJ	VKONT		☐	ISTT_VKONT	☐	Number of Contract Account

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110908
SAP Release Created in	20C