SAP ABAP Table CRMST_ALL_ADDRESS_BUIL (all address attributes including address version fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUIL (Package) Interaction Layer for Business Partner (Until 5.0)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_ALL_ADDRESS_BUIL	Table Relationship Diagram
Short Description	all address attributes including address version fields

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	BUIL: Structure of the (Standard)Address Object
2	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
3	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Address Data
4	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
5	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
6	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
7	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
8	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
9	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
11	POSTL_COD3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
12	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
13	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
14	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
15	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
16	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
17	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
18	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
19	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
20	PO_CTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
21	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
22	STR_ABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
23	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
24	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
25	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
26	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
27	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
28	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
29	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
30	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
31	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
32	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
33	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
34	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
35	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
36	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
37	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
38	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
39	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
40	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
41	LANGUISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
42	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
43	EXTADDRESSNUMBER	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
44	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	*
45	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
46	MOVE_DATE	☐	BU_MOVEDAT	DATUM	DATS	8	0	Date of Move
47	MOVE_ADDRESS	☐	BU_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves	*
48	VALIDFROMDATE	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
49	VALIDTODATE	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
50	MOVE_ADDR_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
51	CITY_NO	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
52	DISTRCT_NO	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
53	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
54	PBOXCIT_NO	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
55	STREET_NO	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
56	HOMECITYNO	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
57	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
58	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	*
59	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
60	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
61	COUNTY_NO	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
62	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
63	TOWNSHIP_NO	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*
64	STRTYPE	☐	CRM_MD_STRTYPE	TEXT30	CHAR	30	0	Street Type (Tab. ADRSTRTYPT)
65	ADR_NOTES	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
66	ADDR_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
67	.INCLU-TEL	☐				0	0	BUIL: Structure of the Telephone Number Object
68	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
69	COUNTRYTEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
70	COUNTRYISOTEL	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
71	STD_NOTEL	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
72	TELEPHONETEL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
73	EXTENSIONTEL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
74	TEL_NOTEL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
75	CALLER_NOTEL	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
76	STD_RECIPTEL	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
77	R_3_USERTEL	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
78	HOME_FLAGTEL	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
79	CONSNUMBERTEL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
80	ERRORFLAGTEL	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
81	FLG_NOUSETEL	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
82	VALID_FROMTEL	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
83	VALID_TOTEL	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
84	LANGUTEL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
85	LANGU_ISOTEL	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
86	COMM_NOTESTEL	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
87	VALIDFROMDATETEL	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
88	VALIDTODATETEL	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
89	.INCLU-FAX	☐				0	0	BUIL : structure for Fax numbers
90	.INCLUDE	☐				0	0	BAPI Structure for Fax Numbers (Business Address Services)
91	COUNTRYFAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
92	COUNTRYISOFAX	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
93	STD_NOFAX	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
94	FAXFAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
95	EXTENSIONFAX	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
96	FAX_NOFAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
97	SENDER_NOFAX	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
98	FAX_GROUPFAX	☐	AD_FXGRP	AD_FXGRP	CHAR	1	0	Fax group (G3, G4, ...)
99	STD_RECIPFAX	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
100	R_3_USERFAX	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
101	HOME_FLAGFAX	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
102	CONSNUMBERFAX	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
103	ERRORFLAGFAX	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
104	FLG_NOUSEFAX	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
105	VALID_FROMFAX	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
106	VALID_TOFAX	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
107	LANGUFAX	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
108	LANGU_ISOFAX	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
109	COMM_NOTESFAX	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
110	VALIDFROMDATEFAX	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
111	VALIDTODATEFAX	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
112	.INCLU-SMT	☐				0	0	BUIL: structure for Email Addresses
113	.INCLUDE	☐				0	0	BAPI Structure for E-Mail Addresses (Bus. Address Services)
114	STD_NOSMT	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
115	E_MAILSMT	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
116	EMAIL_SRCHSMT	☐	AD_SMTPAD2	CHAR20	CHAR	20	0	E-Mail Address Search Field
117	STD_RECIPSMT	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
118	R_3_USERSMT	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
119	ENCODESMT	☐	AD_ENCODE	AD_ENCODE	CHAR	1	0	Desired Data Coding (E-Mail)
120	TNEFSMT	☐	AD_TNEF6	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via SMTP
121	HOME_FLAGSMT	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
122	CONSNUMBERSMT	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
123	ERRORFLAGSMT	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
124	FLG_NOUSESMT	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
125	VALID_FROMSMT	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
126	VALID_TOSMT	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
127	LANGUSMT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
128	LANGU_ISOSMT	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
129	COMM_NOTESSMT	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
130	VALIDFROMDATESMT	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
131	VALIDTODATESMT	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
132	.INCLU-MOB	☐				0	0	BUIL: Structure of the Telephone Number Object
133	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
134	COUNTRYMOB	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
135	COUNTRYISOMOB	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
136	STD_NOMOB	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
137	TELEPHONEMOB	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
138	EXTENSIONMOB	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
139	TEL_NOMOB	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
140	CALLER_NOMOB	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
141	STD_RECIPMOB	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
142	R_3_USERMOB	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
143	HOME_FLAGMOB	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
144	CONSNUMBERMOB	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
145	ERRORFLAGMOB	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
146	FLG_NOUSEMOB	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
147	VALID_FROMMOB	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
148	VALID_TOMOB	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
149	LANGUMOB	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
150	LANGU_ISOMOB	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
151	COMM_NOTESMOB	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
152	VALIDFROMDATEMOB	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
153	VALIDTODATEMOB	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
154	.INCLU-URI	☐				0	0	BUPA IL: Structure for URI Addresses
155	.INCLUDE	☐				0	0	BAPI Structure for URI Addresses (Business Address Services)
156	STD_NOURI	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
157	URI_TYPEURI	☐	AD_URITYPE	AD_URITYPE	CHAR	3	0	URI type flag
158	URIURI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
159	STD_RECIPURI	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
160	HOME_FLAGURI	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
161	CONSNUMBERURI	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
162	URI_PART1URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
163	URI_PART2URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
164	URI_PART3URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
165	URI_PART4URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
166	URI_PART5URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
167	URI_PART6URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
168	URI_PART7URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
169	URI_PART8URI	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
170	URI_PART9URI	☐	AD_URI_9	TEXT48	CHAR	48	0	Universal Resource Identifier (URI) - Part 9
171	ERRORFLAGURI	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
172	FLG_NOUSEURI	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
173	VALID_FROMURI	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
174	VALID_TOURI	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
175	LANGUURI	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
176	LANGU_ISOURI	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
177	COMM_NOTESURI	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
178	VALIDFROMDATEURI	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
179	VALIDTODATEURI	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
180	REM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
181	.INCLU-PRT	☐				0	0	BUPA IL: Structure for printer
182	.INCLUDE	☐				0	0	BAPI Structure for PRT Addresses (Business Address Services)
183	STD_NOPRT	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
184	PRINT_DESTPRT	☐	RSPOPNAME	RSPOPNAME	CHAR	4	0	Spool: Output device	TSP03
185	STD_RECIPPRT	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
186	HOME_FLAGPRT	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
187	CONSNUMBERPRT	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
188	ERRORFLAGPRT	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
189	FLG_NOUSEPRT	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
190	VALID_FROMPRT	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
191	VALID_TOPRT	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
192	VALIDFROMDATEPRT	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
193	VALIDTODATEPRT	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
194	.INCLU-VER	☐				0	0	BUIL: Structure for Address Versions
195	ADDR_VERSVER	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
196	TITLEVER	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
197	NAMEVER	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
198	NAME_2VER	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
199	NAME_3VER	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
200	NAME_4VER	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
201	CONV_NAMEVER	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
202	C_O_NAMEVER	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
203	CITYVER	☐	AD_CITY1	TEXT40	CHAR	40	0	City
204	DISTRICTVER	☐	AD_CITY2	TEXT40	CHAR	40	0	District
205	PO_BOX_CITVER	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
206	DELIV_DISVER	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
207	STREETVER	☐	AD_STREET	TEXT60	CHAR	60	0	Street
208	HOUSE_NOVER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
209	HOUSE_NO2VER	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
210	HOUSE_NO3VER	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
211	STR_SUPPL1VER	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
212	STR_SUPPL2VER	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
213	STR_SUPPL3VER	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
214	LOCATIONVER	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
215	BUILDINGVER	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
216	FLOORVER	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
217	ROOM_NOVER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
218	SORT1VER	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
219	SORT2VER	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
220	HOME_CITYVER	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
221	TITLE_PVER	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
222	FIRSTNAMEVER	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
223	LASTNAMEVER	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
224	BIRTH_NAMEVER	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
225	MIDDLENAMEVER	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
226	SECONDNAMEVER	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
227	FULLNAMEVER	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
228	FULLNAME_XVER	☐	AD_NAMCONV	AD_NAMCONV	CHAR	1	0	Status of Field 'Full Name' NAME_TEXT
229	TITLE_ACA1VER	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
230	TITLE_ACA2VER	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
231	PREFIX1VER	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
232	PREFIX2VER	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
233	TITLE_SPPLVER	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
234	NICKNAMEVER	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
235	INITIALSVER	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
236	NAMEFORMATVER	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
237	NAMCOUNTRYVER	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
238	NAMCTRYISOVER	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
239	PROFESSIONVER	☐	AD_PROFESS	TEXT40	CHAR	40	0	Profession
240	SORT1_PVER	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
241	SORT2_PVER	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMST_ALL_ADDRESS_BUIL	COUNTRY	T005	LAND1	REF	1	CN
2	CRMST_ALL_ADDRESS_BUIL	COUNTRYFAX	T005	LAND1	REF	C	CN
3	CRMST_ALL_ADDRESS_BUIL	COUNTRYMOB	T005	LAND1	REF	C	CN
4	CRMST_ALL_ADDRESS_BUIL	COUNTRYTEL	T005	LAND1	REF	C	CN
5	CRMST_ALL_ADDRESS_BUIL	NAMCOUNTRYVER	T005	LAND1	REF	C	CN
6	CRMST_ALL_ADDRESS_BUIL	NAMEFORMATVER	T005N	NAMEFORMAT	REF	C	CN
7	CRMST_ALL_ADDRESS_BUIL	POBOX_CTRY	T005	LAND1	REF	C	CN
8	CRMST_ALL_ADDRESS_BUIL	PO_BOX_REG	T005S	BLAND		C	CN
9	CRMST_ALL_ADDRESS_BUIL	PREFIX1VER	TSAD4	PREFIX_KEY	REF	C	CN
10	CRMST_ALL_ADDRESS_BUIL	PREFIX2VER	TSAD4	PREFIX_KEY	REF	C	CN
11	CRMST_ALL_ADDRESS_BUIL	PRINT_DESTPRT	TSP03	PADEST	REF	C	CN
12	CRMST_ALL_ADDRESS_BUIL	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
13	CRMST_ALL_ADDRESS_BUIL	REGION	T005S	BLAND	REF	C	CN
14	CRMST_ALL_ADDRESS_BUIL	STR_ABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
15	CRMST_ALL_ADDRESS_BUIL	TIME_ZONE	TTZZ	TZONE	REF	C	CN
16	CRMST_ALL_ADDRESS_BUIL	TITLEVER	TSAD3	TITLE	REF	C	CN
17	CRMST_ALL_ADDRESS_BUIL	TITLE_ACA1VER	TSAD2	TITLE_KEY	REF	C	CN
18	CRMST_ALL_ADDRESS_BUIL	TITLE_ACA2VER	TSAD2	TITLE_KEY	REF	C	CN
19	CRMST_ALL_ADDRESS_BUIL	TITLE_PVER	TSAD3	TITLE	REF	C	CN
20	CRMST_ALL_ADDRESS_BUIL	TITLE_SPPLVER	TSAD5	TITLE_KEY	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in	500