SAP Table EISU_IL_MD_CONNOBJ

IS-U IC WebClient: Transfer Connection Object by RFC

EISU_IL_MD_CONNOBJ (IS-U IC WebClient: Transfer Connection Object by RFC) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EISU_IL_MD_CONNOBJ to other SAP tables.

EISU_IL_MD_CONNOBJ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
HAUS Connection Object HAUS CHAR 30 0
SPRAS Language Key SPRAS LANG 1 0
PLTXT Description of functional location PLTXT CHAR 40 0
KZLTX Indicator: More long text exists KZLTX CHAR 1 0
X Yes
NULL No
TPLKZ Functional location structure indicator TPLKZ CHAR 5 0
FLTYP Functional location category FLTYP CHAR 1 0
TPLMA Superior functional location TPLMA CHAR 30 0
DATAB Valid-From Date DATAB DATS 8 0
BEGRU Technical object authorization group IAUTG CHAR 4 0
EINZLI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IWERK Maintenance Planning Plant IWERK CHAR 4 0
IWERKI Data origin for planning plant field INH_IWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
POSNR Position in superior technical object ILOM_POSNR CHAR 4 0
ISTYP Object category for Industry Solutions (IS) ILOM_ISTYP CHAR 1 0
D Device location IS-U
C Connection object IS-U
PREMS Premise ILOM_PREMS CHAR 10 0
EQFNR Sort field EQFNR CHAR 30 0
SWERK Maintenance plant SWERK CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
IEQUI Installation of equipment allowed at the functional location IEQUI CHAR 1 0
X Yes
NULL No
IEQUII Data origin for equip. inst. allowed field INH_IEQUII CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
COUNC County Code COUNC CHAR 3 0
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
REGPOLIT Political regional structure element REGPOLIT CHAR 8 0
REGIOGROUP_PERM Regional structure group for supply permit processing REGIOGROUP_PERMIT CHAR 8 0
OBJNR Object number J_OBJNR CHAR 22 0
ERDAT Date on which the object was created ICRDT DATS 8 0
ERNAM Name of User Who Created the Object ICRNA CHAR 12 0
AEDAT Date on which the object was last changed IUPDT DATS 8 0
AENAM Name of the user who last changed the object IUPNA CHAR 12 0
CRM_GUID CRM GUID of Connection Object EHAU_GUID RAW 16 0
V_HAUS Connection Object HAUS CHAR 30 0
COUNCTXT Description BEZEI20 CHAR 20 0
REGGRPTXT Text Field TEXT50 CHAR 50 0
REGPOLTXT Text for a regional structure element REGNAME CHAR 30 0
REGPERMTXT Text Field TEXT50 CHAR 50 0
SCHLWORT Short description for hierarchy levels SCHLWORT CHAR 10 0
SWERKTXT Name NAME1 CHAR 30 0
BEGRUTXT Text for the Authorization Group for the Data Object IAUTX CHAR 20 0
PLTXT_TPLMA Description of superior functional location MPTXT CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM ADRCITY CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM ADRCITYPRT CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM ADRCITY CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP TSAD12 CHAR 4 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
CITY_CODE2 City PO box code (City file) AD_CIT2NUM ADRCITY CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG T005S CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY T005 CHAR 3 0
POSTALAREA (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES TSAD12 CHAR 4 0
STREETCODE Street Number for City/Street File AD_STRNUM ADRSTREET CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR ADRSTRTYPE CHAR 2 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
LANGU Language Key SPRAS T002 LANG 1 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
SORT1 Search Term 1 AD_SORT1 CHAR 20 0
SORT2 Search Term 2 AD_SORT2 CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA TSAD6 CHAR 4 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE TTZZ CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
REMARK Address notes AD_REMARK1 CHAR 50 0
LANGU_CREA Address record creation original language AD_LANGUCR T002 LANG 1 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM TSAC CHAR 3 0

EISU_IL_MD_CONNOBJ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EISU_IL_MD_CONNOBJ ADDRORIGIN * TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
EISU_IL_MD_CONNOBJ ADDRORIGIN EISU_IL_MD_CONNOBJ ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
EISU_IL_MD_CONNOBJ CITYH_CODE * ADRCITY Postal cities CLIENT
EISU_IL_MD_CONNOBJ CITYH_CODE EISU_IL_MD_CONNOBJ COUNTRY ADRCITY Postal cities COUNTRY
EISU_IL_MD_CONNOBJ CITYH_CODE EISU_IL_MD_CONNOBJ CITYH_CODE ADRCITY Postal cities CITY_CODE
EISU_IL_MD_CONNOBJ CITYP_CODE EISU_IL_MD_CONNOBJ COUNTRY ADRCITYPRT Postal districts COUNTRY
EISU_IL_MD_CONNOBJ CITYP_CODE EISU_IL_MD_CONNOBJ CITY_CODE ADRCITYPRT Postal districts CITY_CODE
EISU_IL_MD_CONNOBJ CITYP_CODE EISU_IL_MD_CONNOBJ CITYP_CODE ADRCITYPRT Postal districts CITYP_CODE
EISU_IL_MD_CONNOBJ CITYP_CODE * ADRCITYPRT Postal districts CLIENT
EISU_IL_MD_CONNOBJ CITY_CODE EISU_IL_MD_CONNOBJ COUNTRY ADRCITY Postal cities COUNTRY
EISU_IL_MD_CONNOBJ CITY_CODE EISU_IL_MD_CONNOBJ CITY_CODE ADRCITY Postal cities CITY_CODE
EISU_IL_MD_CONNOBJ CITY_CODE * ADRCITY Postal cities CLIENT
EISU_IL_MD_CONNOBJ CITY_CODE2 * ADRCITY Postal cities CLIENT
EISU_IL_MD_CONNOBJ CITY_CODE2 EISU_IL_MD_CONNOBJ COUNTRY ADRCITY Postal cities COUNTRY
EISU_IL_MD_CONNOBJ CITY_CODE2 EISU_IL_MD_CONNOBJ CITY_CODE2 ADRCITY Postal cities CITY_CODE
EISU_IL_MD_CONNOBJ COUNTRY * T005 Countries MANDT
EISU_IL_MD_CONNOBJ COUNTRY EISU_IL_MD_CONNOBJ COUNTRY T005 Countries LAND1
EISU_IL_MD_CONNOBJ DEFLT_COMM EISU_IL_MD_CONNOBJ DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
EISU_IL_MD_CONNOBJ DONT_USE_P SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
EISU_IL_MD_CONNOBJ DONT_USE_P EISU_IL_MD_CONNOBJ DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
EISU_IL_MD_CONNOBJ DONT_USE_S SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
EISU_IL_MD_CONNOBJ DONT_USE_S EISU_IL_MD_CONNOBJ DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
EISU_IL_MD_CONNOBJ LANGU EISU_IL_MD_CONNOBJ LANGU T002 Language Keys (Component BC-I18) SPRAS
EISU_IL_MD_CONNOBJ LANGU_CREA EISU_IL_MD_CONNOBJ LANGU_CREA T002 Language Keys (Component BC-I18) SPRAS
EISU_IL_MD_CONNOBJ PO_BOX_CTY * T005 Countries MANDT
EISU_IL_MD_CONNOBJ PO_BOX_CTY EISU_IL_MD_CONNOBJ PO_BOX_CTY T005 Countries LAND1
EISU_IL_MD_CONNOBJ PO_BOX_REG EISU_IL_MD_CONNOBJ PO_BOX_CTY T005S Taxes: Region (Province) Key LAND1
EISU_IL_MD_CONNOBJ PO_BOX_REG EISU_IL_MD_CONNOBJ PO_BOX_REG T005S Taxes: Region (Province) Key BLAND
EISU_IL_MD_CONNOBJ PO_BOX_REG * T005S Taxes: Region (Province) Key MANDT
EISU_IL_MD_CONNOBJ REGION * T005S Taxes: Region (Province) Key MANDT
EISU_IL_MD_CONNOBJ REGION EISU_IL_MD_CONNOBJ COUNTRY T005S Taxes: Region (Province) Key LAND1
EISU_IL_MD_CONNOBJ REGION EISU_IL_MD_CONNOBJ REGION T005S Taxes: Region (Province) Key BLAND
EISU_IL_MD_CONNOBJ STREETABBR * ADRSTRTYPE Street type CLIENT
EISU_IL_MD_CONNOBJ STREETABBR EISU_IL_MD_CONNOBJ COUNTRY ADRSTRTYPE Street type COUNTRY
EISU_IL_MD_CONNOBJ STREETABBR EISU_IL_MD_CONNOBJ STREETABBR ADRSTRTYPE Street type STRTYPEAB
EISU_IL_MD_CONNOBJ STREETCODE EISU_IL_MD_CONNOBJ STREETCODE ADRSTREET Streets STRT_CODE
EISU_IL_MD_CONNOBJ STREETCODE * ADRSTREET Streets CLIENT
EISU_IL_MD_CONNOBJ STREETCODE EISU_IL_MD_CONNOBJ COUNTRY ADRSTREET Streets COUNTRY
EISU_IL_MD_CONNOBJ TIME_ZONE * TTZZ Time zones CLIENT
EISU_IL_MD_CONNOBJ TIME_ZONE EISU_IL_MD_CONNOBJ TIME_ZONE TTZZ Time zones TZONE
EISU_IL_MD_CONNOBJ TRANSPZONE EISU_IL_MD_CONNOBJ TRANSPZONE TZONE Customers: Regional zones ZONE1
EISU_IL_MD_CONNOBJ TRANSPZONE * TZONE Customers: Regional zones MANDT
EISU_IL_MD_CONNOBJ TRANSPZONE EISU_IL_MD_CONNOBJ COUNTRY TZONE Customers: Regional zones LAND1