SAP ABAP Table CRM_ISU_CONNOBJ_ATTR (Attribute Structure for Gen.Interact.Layer Object IsuConnobj)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-IC-IO (Application Component) Utilities Industry: Identification, Overviews
     ⤷ CRM_IU_IL_MD (Package) Utilities: Generic IL Implementation - Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ISU_CONNOBJ_ATTR	Table Relationship Diagram
Short Description	Attribute Structure for Gen.Interact.Layer Object IsuConnobj

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Connection Object Without Customer Include
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	HAUS	☐	CRM_ISU_HAUS	TPLNR	CHAR	30	0	Connection Object	*
4	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
5	PLTXT	☐	CRM_ISU_PLTXT	TEXT40	CHAR	40	0	Description of Functional Location
6	KZLTX	☐	CRM_ISU_KZLTX	XFELD	CHAR	1	0	Indicator: More Long Text Exists
7	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	*
8	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	*
9	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
10	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
11	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	*
12	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
13	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
14	IWERKI	☐	CRM_ISU_INH_IWERKI	INHER	CHAR	1	0	Data Origin for Planning Plant Field
15	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
16	ISTYP	☐	CRM_ISU_ILOM_ISTYP	CRM_ISU_ILOM_ISTYP	CHAR	1	0	Object Category for Industry Solutions (IS)
17	PREMS	☐	CRM_ISU_ILOM_PREMS	CHAR10	CHAR	10	0	Premise
18	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
19	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
20	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
22	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
23	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
24	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
25	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
26	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
27	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
28	IEQUII	☐	CRM_ISU_INH_IEQUII	INHER	CHAR	1	0	Data Origin for Equip. Inst. Allowed Field
29	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
30	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
31	REGPOLIT	☐	CRM_ISU_REGPOLIT	CRM_ISU_REGPOLIT	CHAR	8	0	Political Regional Structure Element
32	REGIOGROUP_PERM	☐	CRM_ISU_REGIOGROUP_PERMIT	REGIOGROUP	CHAR	8	0	Regional Structure Group for Supply Permit Processing	*
33	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
34	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
35	ERNAM	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
36	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
37	AENAM	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
38	CRM_GUID	☐	CRM_ISU_EHAU_GUID	SYSUUID	RAW	16	0	CRM GUID of Connection Object
39	.INCLUDE	☐				0	0
40	V_HAUS	☐	CRM_ISU_HAUS	TPLNR	CHAR	30	0	Connection Object	*
41	COUNCTXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
42	REGGRPTXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
43	REGPOLTXT	☐	CRM_ISU_REGNAME	TEXT30	CHAR	30	0	Text for a Regional Structure Element
44	REGPERMTXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
45	SCHLWORT	☐	CRM_ISU_SCHLWORT	CRM_ISU_SCHLWORT	CHAR	10	0	Short Description for Hierarchy Levels
46	SWERKTXT	☐	NAME1	TEXT30	CHAR	30	0	Name
47	BEGRUTXT	☐	IAUTX	TEXT20	CHAR	20	0	Text for the Authorization Group for the Data Object
48	PLTXT_TPLMA	☐	CRM_ISU_MPTXT	TEXT40	CHAR	40	0	Description of Superior Functional Location
49	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
50	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
51	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
52	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
53	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
54	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	ADRCITY
55	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
56	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
57	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
58	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
59	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
60	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
61	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
62	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
63	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	TSAD12
64	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
65	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
66	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	ADRCITY
67	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
68	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
69	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
70	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
71	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
72	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	TSAD12
73	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
74	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
75	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
76	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
77	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
78	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
79	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
80	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
81	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
82	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
83	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
84	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
85	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
86	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
87	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
88	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
89	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
90	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
91	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	TSAD6
92	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
93	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
94	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
95	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
96	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
97	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
98	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
99	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_ISU_CONNOBJ_ATTR	ADDRORIGIN	TSAD6	ORIGIN	REF	C	CN
2	CRM_ISU_CONNOBJ_ATTR	CITYH_CODE	ADRCITY	CITY_CODE	REF	C	CN
3	CRM_ISU_CONNOBJ_ATTR	CITYP_CODE	ADRCITYPRT	CITYP_CODE	REF	C	CN
4	CRM_ISU_CONNOBJ_ATTR	CITY_CODE	ADRCITY	CITY_CODE	REF	C	CN
5	CRM_ISU_CONNOBJ_ATTR	CITY_CODE2	ADRCITY	CITY_CODE	REF	C	CN
6	CRM_ISU_CONNOBJ_ATTR	COUNTRY	T005	LAND1	REF	C	CN
7	CRM_ISU_CONNOBJ_ATTR	DEFLT_COMM	TSAC	COMM_TYPE	REF	C	CN
8	CRM_ISU_CONNOBJ_ATTR	DONT_USE_P	TSAD12	UNDELIVER	KEY	C	CN
9	CRM_ISU_CONNOBJ_ATTR	DONT_USE_S	TSAD12	UNDELIVER	REF	C	CN
10	CRM_ISU_CONNOBJ_ATTR	LANGU	T002	SPRAS	REF	C	CN
11	CRM_ISU_CONNOBJ_ATTR	LANGU_CREA	T002	SPRAS	REF	C	CN
12	CRM_ISU_CONNOBJ_ATTR	PO_BOX_CTY	T005	LAND1	REF	C	CN
13	CRM_ISU_CONNOBJ_ATTR	PO_BOX_REG	T005S	BLAND	REF	C	CN
14	CRM_ISU_CONNOBJ_ATTR	REGION	T005S	BLAND	REF	C	CN
15	CRM_ISU_CONNOBJ_ATTR	STREETABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
16	CRM_ISU_CONNOBJ_ATTR	STREETCODE	ADRSTREET	STRT_CODE	REF	C	CN
17	CRM_ISU_CONNOBJ_ATTR	TIME_ZONE	TTZZ	TZONE	REF	C	CN
18	CRM_ISU_CONNOBJ_ATTR	TRANSPZONE	TZONE	ZONE1	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	400