1. Home
  2. Resources
  3. SAP Tables
  4. EIAC_SERVICE_ADDR - Structure EIAC_SERVICE_ADDR for IAC initial data creation

SAP Table EIAC_SERVICE_ADDR

Structure EIAC_SERVICE_ADDR for IAC initial data creation

EIAC_SERVICE_ADDR (Structure EIAC_SERVICE_ADDR for IAC initial data creation) 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 EIAC_SERVICE_ADDR to other SAP tables.

EIAC_SERVICE_ADDR table fields

Field Data element Checktable Datatype Length Decimals
CONN_OBJ Connection Object HAUS CHAR 30 0
PREMISES Premise VSTELLE CHAR 10 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
XDFADR Indicator: Address is standard address BU_XDFADR CHAR 1 0
X Yes
NULL No
ADEXT Address number in external system BU_ADEXT CHAR 20 0
NAME_CO c/o name AD_NAME_CO 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 CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM CHAR 8 0
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
PO_BOX PO Box AD_POBX CHAR 10 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 CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY 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 CHAR 10 0
STREET Street AD_STREET CHAR 60 0
STREETCODE Street Number for City/Street File AD_STRNUM CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR 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
COUNTRY_ISO Country ISO code INTCA CHAR 2 0
LANGU Language Key SPRAS LANG 1 0
LANGU_ISO 2-Character SAP Language Code LAISO CHAR 2 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 CHAR 4 0
EXTENSION1 Extension (only for data conversion) (data line/telebox) AD_EXTENS CHAR 40 0
EXTENSION2 Extension (only for data conversion) (data line/telebox) AD_EXTENS CHAR 40 0
TIME_ZONE Address time zone AD_TZONE 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
DEFLT_COMM Standard communication type AD_DFLTCMM CHAR 3 0
TEL_NUMBER Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
TEL_EXTENS Telephone no.: Extension AD_TLXTNS CHAR 10 0
FAX_NUMBER Fax number: dialling code+number AD_FXNMBR CHAR 30 0
FAX_EXTENS Fax no.: Extension AD_FXXTNS CHAR 10 0
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 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
E_MAIL E-Mail Address AD_SMTPADR CHAR 241 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
HOMECITYNO Different city for city/street file AD_CITYHNM CHAR 12 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP CHAR 4 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES CHAR 4 0
MOVE_DATE Date of Move BU_MOVEDAT DATS 8 0
MOVE_ADDRESS Number of Move Target Address for Address Moves BU_MOVE_ADDR CHAR 10 0
VALIDFROMDATE Validity Date (Valid From) BU_DATFROM DATS 8 0
VALIDTODATE Validity Date (Valid To) BU_DATTO DATS 8 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0

EIAC_SERVICE_ADDR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EIAC_SERVICE_ADDR COUNTRY SY MANDT T005 Countries MANDT
EIAC_SERVICE_ADDR COUNTRY EIAC_SERVICE_ADDR COUNTRY T005 Countries LAND1
EIAC_SERVICE_ADDR REGION EIAC_SERVICE_ADDR REGION T005S Taxes: Region (Province) Key BLAND
EIAC_SERVICE_ADDR REGION SY MANDT T005S Taxes: Region (Province) Key MANDT
EIAC_SERVICE_ADDR REGION EIAC_SERVICE_ADDR COUNTRY T005S Taxes: Region (Province) Key LAND1