SAP ABAP Table CRMS_EMAIL_PARTNER_ADDRESS (Partner Address)
Hierarchy
☛ WEBCUIF (Software Component) SAP Web UI Framework
   ⤷ CA-WUI (Application Component) WebClient UI
     ⤷ CRM_EMAIL_BASE (Package) E-Mail Functions
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_EMAIL_PARTNER_ADDRESS   Table Relationship Diagram
Short Description Partner Address    
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 .INCLU-LET       0   0   SAP BP: BAPI Structure for Address Data  
2 STANDARDADDRESSLET BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
3 C_O_NAMELET AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
4 CITYLET AD_CITY1 TEXT40 CHAR 40   0   City  
5 DISTRICTLET AD_CITY2 TEXT40 CHAR 40   0   District  
6 REGIOGROUPLET REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
7 POSTL_COD1LET AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
8 POSTL_COD2LET AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
9 POSTL_COD3LET AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
10 PCODE1_EXTLET AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
11 PCODE2_EXTLET AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
12 PCODE3_EXTLET AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
13 PO_BOXLET AD_POBX CHAR10 CHAR 10   0   PO Box  
14 PO_W_O_NOLET AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
15 PO_BOX_CITLET AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
16 PO_BOX_REGLET AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
17 POBOX_CTRYLET AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
18 PO_CTRYISOLET INTCA INTCA CHAR 2   0   Country ISO code  
19 STREETLET AD_STREET TEXT60 CHAR 60   0   Street  
20 STR_ABBRLET AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
21 HOUSE_NOLET AD_HSNM1 TEXT10 CHAR 10   0   House Number  
22 HOUSE_NO2LET AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
23 HOUSE_NO3LET AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
24 STR_SUPPL1LET AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
25 STR_SUPPL2LET AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
26 STR_SUPPL3LET AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
27 LOCATIONLET AD_LCTN TEXT40 CHAR 40   0   Street 5  
28 BUILDINGLET AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
29 FLOORLET AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
30 ROOM_NOLET AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
31 COUNTRYLET LAND1 LAND1 CHAR 3   0   Country Key T005
32 COUNTRYISOLET INTCA INTCA CHAR 2   0   Country ISO code  
33 REGIONLET REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
34 TIME_ZONELET AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
35 TAXJURCODELET AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
36 HOME_CITYLET AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
37 TRANSPZONELET LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
38 LANGULET SPRAS SPRAS LANG 1   0   Language Key *
39 LANGUISOLET LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
40 COMM_TYPELET AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
41 EXTADDRESSNUMBERLET BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
42 DONT_USE_PLET AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag *
43 DONT_USE_SLET AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag *
44 MOVE_DATELET BU_MOVEDAT DATUM DATS 8   0   Date of Move  
45 MOVE_ADDRESSLET BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves *
46 VALIDFROMDATELET BU_DATFROM DATUM DATS 8   0   Validity Date (Valid From)  
47 VALIDTODATELET BU_DATTO DATUM DATS 8   0   Validity Date (Valid To)  
48 MOVE_ADDR_GUIDLET SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
49 CITY_NOLET AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
50 DISTRCT_NOLET AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
51 CHCKSTATUSLET AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
52 PBOXCIT_NOLET AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
53 STREET_NOLET AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
54 HOMECITYNOLET AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file *
55 PO_BOX_LOBBYLET AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
56 DELI_SERV_TYPELET AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service *
57 DELI_SERV_NUMBERLET AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
58 COUNTYLET AD_COUNTY TEXT40 CHAR 40   0   County  
59 COUNTY_NOLET AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county *
60 TOWNSHIPLET AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
61 TOWNSHIP_NOLET AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township *
62 .INCLU-EML       0   0   BAPI Structure for E-Mail Addresses (Bus. Address Services)  
63 STD_NOEML AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
64 E_MAILEML AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
65 EMAIL_SRCHEML AD_SMTPAD2 CHAR20 CHAR 20   0   E-Mail Address Search Field  
66 STD_RECIPEML AD_DFTRCNR XFELD CHAR 1   0   Flag: Recipient is standard recipient for this number  
67 R_3_USEREML AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
68 ENCODEEML AD_ENCODE AD_ENCODE CHAR 1   0   Desired Data Coding (E-Mail)  
69 TNEFEML AD_TNEF6 XFELD CHAR 1   0   Flag: Receiver can receive TNEF coding via SMTP  
70 HOME_FLAGEML AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
71 CONSNUMBEREML AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
72 ERRORFLAGEML AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
73 FLG_NOUSEEML AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
74 VALID_FROMEML AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
75 VALID_TOEML AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
76 .INCLU-TEL       0   0   BAPI Structure for Telephone Numbers (Bus. Address Services)  
77 COUNTRYTEL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number T005
78 COUNTRYISOTEL INTCA INTCA CHAR 2   0   Country ISO code  
79 STD_NOTEL AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
80 TELEPHONETEL AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
81 EXTENSIONTEL AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
82 TEL_NOTEL AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
83 CALLER_NOTEL AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
84 STD_RECIPTEL AD_FLGSMS AD_FLGSMS CHAR 1   0   Indicator: Telephone is SMS-Enabled  
85 R_3_USERTEL AD_FLGMOB AD_FLGMOB CHAR 1   0   Indicator: Telephone is a Mobile Telephone  
86 HOME_FLAGTEL AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
87 CONSNUMBERTEL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
88 ERRORFLAGTEL AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
89 FLG_NOUSETEL AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
90 VALID_FROMTEL AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
91 VALID_TOTEL AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
92 .INCLU-MOB       0   0   BAPI Structure for Telephone Numbers (Bus. Address Services)  
93 COUNTRYMOB AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number T005
94 COUNTRYISOMOB INTCA INTCA CHAR 2   0   Country ISO code  
95 STD_NOMOB AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
96 TELEPHONEMOB AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
97 EXTENSIONMOB AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
98 TEL_NOMOB AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
99 CALLER_NOMOB AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
100 STD_RECIPMOB AD_FLGSMS AD_FLGSMS CHAR 1   0   Indicator: Telephone is SMS-Enabled  
101 R_3_USERMOB AD_FLGMOB AD_FLGMOB CHAR 1   0   Indicator: Telephone is a Mobile Telephone  
102 HOME_FLAGMOB AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
103 CONSNUMBERMOB AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
104 ERRORFLAGMOB AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
105 FLG_NOUSEMOB AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
106 VALID_FROMMOB AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
107 VALID_TOMOB AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
108 .INCLU-FAX       0   0   BAPI Structure for Fax Numbers (Business Address Services)  
109 COUNTRYFAX AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number T005
110 COUNTRYISOFAX INTCA INTCA CHAR 2   0   Country ISO code  
111 STD_NOFAX AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
112 FAXFAX AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
113 EXTENSIONFAX AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
114 FAX_NOFAX AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
115 SENDER_NOFAX AD_FAXNRCL CHAR30 CHAR 30   0   Fax number for finding sender  
116 FAX_GROUPFAX AD_FXGRP AD_FXGRP CHAR 1   0   Fax group (G3, G4, ...)  
117 STD_RECIPFAX AD_DFTRCNR XFELD CHAR 1   0   Flag: Recipient is standard recipient for this number  
118 R_3_USERFAX AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
119 HOME_FLAGFAX AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
120 CONSNUMBERFAX AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
121 ERRORFLAGFAX AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
122 FLG_NOUSEFAX AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
123 VALID_FROMFAX AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
124 VALID_TOFAX AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMS_EMAIL_PARTNER_ADDRESS COUNTRYFAX T005 LAND1 REF C CN
2 CRMS_EMAIL_PARTNER_ADDRESS COUNTRYLET T005 LAND1 REF 1 CN
3 CRMS_EMAIL_PARTNER_ADDRESS COUNTRYMOB T005 LAND1 REF C CN
4 CRMS_EMAIL_PARTNER_ADDRESS COUNTRYTEL T005 LAND1 REF C CN
5 CRMS_EMAIL_PARTNER_ADDRESS POBOX_CTRYLET T005 LAND1 REF C CN
6 CRMS_EMAIL_PARTNER_ADDRESS PO_BOX_REGLET T005S BLAND C CN
7 CRMS_EMAIL_PARTNER_ADDRESS REGIOGROUPLET ADRREGGRP REGIOGROUP REF C CN
8 CRMS_EMAIL_PARTNER_ADDRESS REGIONLET T005S BLAND REF C CN
9 CRMS_EMAIL_PARTNER_ADDRESS STR_ABBRLET ADRSTRTYPE STRTYPEAB REF C CN
10 CRMS_EMAIL_PARTNER_ADDRESS TIME_ZONELET TTZZ TZONE REF C CN
History
Last changed by/on SAP  20141013 
SAP Release Created in 400