SAP Table CRMT_BUS_ADDRESS

SAP BP: BAPI Struc.f. Addr.Data(Texts instd of Fixed Values)

CRMT_BUS_ADDRESS (SAP BP: BAPI Struc.f. Addr.Data(Texts instd of Fixed Values)) 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 CRMT_BUS_ADDRESS to other SAP tables.

CRMT_BUS_ADDRESS table fields

Field Data element Checktable Datatype Length Decimals
STANDARDADDRESS Indicator: Address is standard address BU_XDFADR CHAR 1 0
X Yes
NULL No
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 ADRREGGRP 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 Yes
NULL No
PO_BOX_CIT PO Box city AD_POBXLOC CHAR 40 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) CRMT_PO_BOX_REGION_TEXT CHAR 20 0
POBOX_CTRY PO box country CRMT_BUS_POBXCTY_TEXT CHAR 15 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 CRMT_BUS_LAND1_TEXT CHAR 15 0
REGION Region (State, Province, County) CRMT_BUS_REGIO_TEXT CHAR 20 0
TIME_ZONE Time Zone Text TZNDESCTZN CHAR 30 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 CRMT_BUS_SPRAS_TEXT CHAR 16 0
COMM_TYPE Communication type description AD_COM_TX CHAR 20 0

CRMT_BUS_ADDRESS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CRMT_BUS_ADDRESS REGIOGROUP SYST MANDT ADRREGGRP Regional structure grouping CLIENT
CRMT_BUS_ADDRESS REGIOGROUP CRMT_BUS_ADDRESS REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP