SAP Table CMS_STR_ADDRESS_PRINTFORM_BUF

CMS BUPA BadI: Structure for Address in print Form-Internal

CMS_STR_ADDRESS_PRINTFORM_BUF (CMS BUPA BadI: Structure for Address in print Form-Internal) 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 CMS_STR_ADDRESS_PRINTFORM_BUF to other SAP tables.

Source: CMS_STR_ADDRESS_PRINTFORM_BUF (CMS BUPA BadI: Structure for Address in print Form-Internal)

CMS_STR_ADDRESS_PRINTFORM_BUF table fields

Field Data element Checktable Datatype Length Decimals
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
ADDRESS_TYPE Address Type BU_ADRKIND CHAR 10 0
ADDRESS_PF ADRS_PRINT STRU 0 0
LINE0 Address line LINES CHAR 80 0
LINE1 Address line LINES CHAR 80 0
LINE2 Address line LINES CHAR 80 0
LINE3 Address line LINES CHAR 80 0
LINE4 Address line LINES CHAR 80 0
LINE5 Address line LINES CHAR 80 0
LINE6 Address line LINES CHAR 80 0
LINE7 Address line LINES CHAR 80 0
LINE8 Address line LINES CHAR 80 0
LINE9 Address line LINES CHAR 80 0
ADDRESS_SF One-line short form of formatted address AD_LINE_S CHAR 80 0
ADDRESS_SFS One-line short form of formatted address AD_LINE_S CHAR 80 0
ADDRESS_DC Short form of the formatted address for the data medium AD_LINE_DC CHAR 80 0
ADDRESS_DC0 Short form of the formatted address for the data medium AD_LINE_DC CHAR 80 0
NOUL Number of lines in address ANZEI DEC 2 0
ADDRESS_PF_TABLE CMS_TAB_ADDRESS_PFTLINE TTYP 0 0
ADDRESS_PF_TABLE_10 CMS_TAB_ADDRESS_PFTLINE TTYP 0 0
BUS020_EXT BUS020_EXT STRU 0 0
PARTNER Business Partner Number BU_PARTNER 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
NATION Version ID for International Addresses AD_NATION CHAR 1 0
GUID UUID in character form SYSUUID_C CHAR 32 0
MOVE_ADDR Number of Move Target Address for Address Moves BU_MOVE_ADDR CHAR 10 0
DATE_FROM Date Obsolete BU_DATE_OBSOLETE DATS 8 0
ADDRESS_GUID GUID of a Business Partner Address BU_ADDRESS_GUID RAW 16 0
ADDR_VALID_FROM Validity Start of a Business Partner Address BU_ADDR_VALID_FROM DEC 15 0
ADDR_VALID_TO Validity End of a Business Partner Address BU_ADDR_VALID_TO DEC 15 0
ADDR_MOVE_DATE Date of Move for Address Moves BU_ADDR_MOVE_DATE DEC 15 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
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM 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
REGIOGROUP Regional structure grouping REGIOGROUP 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
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 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 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
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES CHAR 4 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 CHAR 3 0
LANGU Language Key SPRAS LANG 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
SORT1 Search Term 1 AD_SORT1UL CHAR 20 0
SORT2 Search Term 2 AD_SORT2UL 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) (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 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 LANG 1 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_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 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
VALID_FROM Valid From BU_VALID_FROM_DATS DATS 8 0
VALID_TO Valid To BU_VALID_TO_DATS DATS 8 0