SAP ABAP Table BBP_ADRC_45 (Addresses (Central Address Management) Release 4.5)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_BUPA (Package) Business Partner
Basic Data
Table Category INTTAB    Structure 
Structure BBP_ADRC_45   Table Relationship Diagram
Short Description Addresses (Central Address Management) Release 4.5    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client *
2 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
3 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
4 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
5 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
6 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
7 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
8 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
9 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
10 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
11 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
12 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
13 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
14 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
15 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
16 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
17 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
18 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping *
19 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
20 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
21 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
22 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
23 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
24 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
25 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
26 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
27 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
28 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
29 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
30 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
31 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
32 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
33 STREET AD_STREET TEXT60 CHAR 60   0   Street  
34 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
35 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name *
36 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
37 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
38 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
39 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
40 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
41 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
42 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
43 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
44 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
45 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
46 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
47 LANGU SPRAS SPRAS LANG 1   0   Language Key *
48 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
49 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) *
50 FLAGGROUPS AD_FLGGP XFELD CHAR 1   0   Flag: There are more address group assignments  
51 PERS_ADDR AD_PRSADDR XFELD CHAR 1   0   Flag: This is a personal address  
52 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
53 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
54 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
55 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
56 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
57 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
58 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
59 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
60 FLAGCOMM2 AD_FLGCM02 XFELD CHAR 1   0   Flag: Telephone number(s) maintained  
61 FLAGCOMM3 AD_FLGCM03 XFELD CHAR 1   0   Flag: Fax number(s) maintained  
62 FLAGCOMM4 AD_FLGCM04 XFELD CHAR 1   0   Flag: Teletex number(s) maintained  
63 FLAGCOMM5 AD_FLGCM05 XFELD CHAR 1   0   Flag: Telex number(s) maintained  
64 FLAGCOMM6 AD_FLGCM06 XFELD CHAR 1   0   Indicator: E-Mail Address(es) Maintained  
65 FLAGCOMM7 AD_FLGCM07 XFELD CHAR 1   0   Flag: RML (remote mail) addresse(s) maintained  
66 FLAGCOMM8 AD_FLGCM08 XFELD CHAR 1   0   Flag: X.400 addresse(s) maintained  
67 FLAGCOMM9 AD_FLGCM09 XFELD CHAR 1   0   Flag: RFC destination(s) maintained  
68 FLAGCOMM10 AD_FLGCM10 XFELD CHAR 1   0   Flag: Printer maintained  
69 FLAGCOMM11 AD_FLGCM11 XFELD CHAR 1   0   Flag: SSF maintained  
70 FLAGCOMM12 AD_FLGCM12 XFELD CHAR 1   0   Flag: URI/FTP address maintained  
71 FLAGCOMM13 AD_FLGCM13 XFELD CHAR 1   0   Flag: Pager address maintained  
72 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) *
73 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
74 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
75 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
76 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
77 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
78 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone *
79 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
80 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
81 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language *
History
Last changed by/on SAP  20130604 
SAP Release Created in 20A