SAP ABAP Table CRMT_ISALES_BUPA_ADDRESSDATA (Business Partner Address Data)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISA (Application Component) Internet Sales
     ⤷ CRM_ISALES (Package) CRM Internet Sales
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_ISALES_BUPA_ADDRESSDATA   Table Relationship Diagram
Short Description Business Partner Address Data    
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 .INCLUDE       0   0   BAPI Structure with Business Partner/Address Numbers  
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
3 ADDRESSGUID BU_ADDRESS_GUID_BAPI SYSUUID_C CHAR 32   0   GUID of a BP Address in CHAR 32 Format for BAPIs  
4 ADDRESSTYPE AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
5 COMPANY_PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
6 .INCLUDE       0   0   Internet Sales: Externally Visible/Maintainable Address Data  
7 .INCLUDE       0   0   Internet Sales: General Titles  
8 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
9 TITLE AD_TITLETX TEXT30 CHAR 30   0   Title text  
10 .INCLUDE       0   0   Internet Sales: Special Person-Related Titles  
11 TITLE_ACA1_KEY AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
12 TITLE_ACA1 AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
13 .INCLUDE       0   0   Internet Sales: Name Fields for a Person  
14 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
15 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
16 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
17 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
18 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
19 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
20 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
21 .INCLUDE       0   0   Internet Sales: Name Fields for an Organization  
22 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
23 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
24 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
25 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
26 .INCLUDE       0   0   Internet Sales: Postal Address  
27 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
28 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
29 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
30 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
31 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
32 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
33 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
34 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
35 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
36 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
37 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
38 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
39 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
40 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
41 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
42 STREET AD_STREET TEXT60 CHAR 60   0   Street  
43 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
44 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
45 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
46 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
47 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
48 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
49 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
50 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
51 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
52 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
53 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
54 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
55 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
56 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
57 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
58 .INCLUDE       0   0   Internet Sales: Communication Data Address  
59 TEL1_NUMBR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
60 TEL1_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
61 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
62 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
63 E_MAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_ISALES_BUPA_ADDRESSDATA PARTNER BUT000 PARTNER KEY 1 CN
History
Last changed by/on SAP  20130604 
SAP Release Created in 400