SAP ABAP Table EISU_IL_MD_CONNOBJ (IS-U IC WebClient: Transfer Connection Object by RFC)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	EISU_IL_MD_CONNOBJ	Table Relationship Diagram
Short Description	IS-U IC WebClient: Transfer Connection Object by RFC

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	472