1. Home
  2. Resources
  3. SAP Tables
  4. BUS_EI_BUPA_ADDRESS - External Interface: Data for Creating an Address

SAP Table BUS_EI_BUPA_ADDRESS

External Interface: Data for Creating an Address

BUS_EI_BUPA_ADDRESS (External Interface: Data for Creating an Address) 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 BUS_EI_BUPA_ADDRESS to other SAP tables.

Source: BUS_EI_BUPA_ADDRESS (External Interface: Data for Creating an Address)

BUS_EI_BUPA_ADDRESS table fields

Field Data element Checktable Datatype Length Decimals
TASK External Interface: Change Indicator Address BUS_EI_ADDRESS_TASK CHAR 1 0
I Insert
U Update
M Modify
D Delete
S Standard
1 Logical Key Insert
2 Logical Key Update
4 Logical Key Delete
5 Logical Key Modify
DATA_KEY BUS_EI_BUPA_ADDRESS_KEY STRU 0 0
GUID UUID in character form SYSUUID_C CHAR 32 0
OPERATION Transaction for BP Address Determination BU_OPERATION CHAR 6 0
DATA BUS_EI_BUPA_ADDRESS_DATA STRU 0 0
POSTAL BUS_EI_BUPA_POSTAL_ADDRESS STRU 0 0
DATA BUS_EI_STRUC_ADDRESS STRU 0 0
STANDARDADDRESS Indicator: Address is standard address BU_XDFADR CHAR 1 0
X Update for the field
NULL No update for the field
C_O_NAME c/o name AD_NAME_CO CHAR 40 0
CITY City AD_CITY1 CHAR 40 0
DISTRICT District AD_CITY2 CHAR 40 0
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
POSTL_COD1 City postal code AD_PSTCD1 CHAR 10 0
POSTL_COD2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POSTL_COD3 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
PO_W_O_NO Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Update for the field
NULL No update for the field
PO_BOX_CIT PO Box city AD_POBXLOC CHAR 40 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
POBOX_CTRY PO box country AD_POBXCTY CHAR 3 0
PO_CTRYISO Country ISO code INTCA CHAR 2 0
STREET Street AD_STREET CHAR 60 0
STR_ABBR (Not Supported) Abbreviation of Street Name AD_STRABBR CHAR 2 0
HOUSE_NO House Number AD_HSNM1 CHAR 10 0
HOUSE_NO2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NO3 (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
ROOM_NO Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
COUNTRYISO Country ISO code INTCA CHAR 2 0
REGION Region (State, Province, County) REGIO CHAR 3 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
LANGU Language Key SPRAS LANG 1 0
LANGUISO 2-Character SAP Language Code LAISO CHAR 2 0
COMM_TYPE Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
EXTADDRESSNUMBER Address number in external system BU_ADEXT CHAR 20 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
MOVE_ADDR_GUID UUID in character form SYSUUID_C CHAR 32 0
CITY_NO City code for city/street file AD_CITYNUM CHAR 12 0
DISTRCT_NO District code for City and Street file AD_CITYPNM CHAR 8 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
X Update for the field
NULL No update for the field
PBOXCIT_NO City PO box code (City file) AD_CIT2NUM CHAR 12 0
STREET_NO Street Number for City/Street File AD_STRNUM CHAR 12 0
HOMECITYNO Different city for city/street file AD_CITYHNM CHAR 12 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
COUNTY_NO County code for county AD_CNTYNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
TOWNSHIP_NO Township code for Township AD_TWSHPNUM CHAR 8 0
DATAX BUS_EI_STRUC_ADDRESS_X STRU 0 0
STANDARDADDRESS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
C_O_NAME Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
CITY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DISTRICT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
REGIOGROUP Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
POSTL_COD1 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
POSTL_COD2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
POSTL_COD3 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PCODE1_EXT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PCODE2_EXT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PCODE3_EXT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_BOX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_W_O_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_BOX_CIT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_BOX_REG Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
POBOX_CTRY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_CTRYISO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STREET Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STR_ABBR Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
HOUSE_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
HOUSE_NO2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
HOUSE_NO3 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STR_SUPPL1 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STR_SUPPL2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STR_SUPPL3 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LOCATION Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
BUILDING Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
FLOOR Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
ROOM_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
COUNTRY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
COUNTRYISO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
REGION Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
TIME_ZONE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
TAXJURCODE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
HOME_CITY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
TRANSPZONE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LANGU Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LANGU_ISO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
COMM_TYPE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
EXTADDRESSNUMBER Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DONT_USE_P Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DONT_USE_S Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
MOVE_DATE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
MOVE_ADDRESS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VALIDFROMDATE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VALIDTODATE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
MOVE_ADDR_GUID Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
CITY_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DISTRCT_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
CHCKSTATUS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PBOXCIT_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
STREET_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
HOMECITYNO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PO_BOX_LOBBY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DELI_SERV_TYPE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
DELI_SERV_NUMBER Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
COUNTY Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
COUNTY_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
TOWNSHIP Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
TOWNSHIP_NO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
REMARK BUS_EI_ADDRESSREMARK STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
REMARKS BUS_EI_BUPA_ADDRESSREMARK_T TTYP 0 0
COMMUNICATION BUS_EI_COMMUNICATION STRU 0 0
PHONE BUS_EI_TEL_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
PHONE BUS_EI_BUPA_TELEPHONE_T TTYP 0 0
FAX BUS_EI_FAX_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
FAX BUS_EI_BUPA_FAX_T TTYP 0 0
TTX BUS_EI_TTX_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
TTX BUS_EI_BUPA_TTX_T TTYP 0 0
TLX BUS_EI_TLX_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
TLX BUS_EI_BUPA_TLX_T TTYP 0 0
SMTP BUS_EI_SMTP_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
SMTP BUS_EI_BUPA_SMTP_T TTYP 0 0
RML BUS_EI_RML_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
RML BUS_EI_BUPA_RML_T TTYP 0 0
X400 BUS_EI_X400_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
X400 BUS_EI_BUPA_X400_T TTYP 0 0
RFC BUS_EI_RFC_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
RFC BUS_EI_BUPA_RFC_T TTYP 0 0
PRT BUS_EI_PRT_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
PRT BUS_EI_BUPA_PRT_T TTYP 0 0
SSF BUS_EI_SSF_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
SSF BUS_EI_BUPA_SSF_T TTYP 0 0
URI BUS_EI_URI_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
URI BUS_EI_BUPA_URI_T TTYP 0 0
PAGER BUS_EI_PAG_DATA STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
PAGER BUS_EI_BUPA_PAG_T TTYP 0 0
TIME_DEPENDENT External Interface: Data in Source System Time-Dependent BUS_EI_TIME_DEPENDENT CHAR 1 0
NULL Data Not Maintained Time-Dependently in Source System
X Data Maintained Time-Dependently in Source System
ADDR_USAGE BUS_EI_ADDRESSUSAGE STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
ADDR_USAGES BUS_EI_BUPA_ADDRESSUSAGE_T TTYP 0 0
VERSION BUS_EI_VERSION STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data BUS_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
VERSIONS BUS_EI_BUPA_VERSION_T TTYP 0 0
CURRENTLY_VALID External Interface: Data Currently Valid BUS_EI_CURRENTLY_VALID CHAR 1 0
NULL Data Currently Not Valid
X Data Currently Valid
I Data Became Valid Today
D Data Became Invalid Today