SAP ABAP Table CRMST_ADDRESS_VERSION_BUIL (BUIL: Structure for Address Versions)

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_ADDRESS_VERSION_BUIL	Table Relationship Diagram
Short Description	BUIL: Structure for Address Versions

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	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
2	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
3	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
4	NAME_2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
5	NAME_3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
6	NAME_4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
7	CONV_NAME	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
8	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
9	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
10	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
11	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
12	DELIV_DIS	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
13	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
14	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
15	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
16	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
17	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
18	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
19	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
20	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
21	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
22	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
23	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
24	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
25	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
26	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
27	TITLE_P	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
28	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
29	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
30	BIRTH_NAME	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
31	MIDDLENAME	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
32	SECONDNAME	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
33	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
34	FULLNAME_X	☐	AD_NAMCONV	AD_NAMCONV	CHAR	1	0	Status of Field 'Full Name' NAME_TEXT
35	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
36	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
37	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
38	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
39	TITLE_SPPL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
40	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
41	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
42	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
43	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
44	NAMCTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
45	PROFESSION	☐	AD_PROFESS	TEXT40	CHAR	40	0	Profession
46	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
47	SORT2_P	☐	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_ADDRESS_VERSION_BUIL	NAMCOUNTRY	T005	LAND1	REF	C	CN
2	CRMST_ADDRESS_VERSION_BUIL	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
3	CRMST_ADDRESS_VERSION_BUIL	PREFIX1	TSAD4	PREFIX_KEY	REF	C	CN
4	CRMST_ADDRESS_VERSION_BUIL	PREFIX2	TSAD4	PREFIX_KEY	REF	C	CN
5	CRMST_ADDRESS_VERSION_BUIL	TITLE	TSAD3	TITLE	REF	C	CN
6	CRMST_ADDRESS_VERSION_BUIL	TITLE_ACA1	TSAD2	TITLE_KEY	REF	C	CN
7	CRMST_ADDRESS_VERSION_BUIL	TITLE_ACA2	TSAD2	TITLE_KEY	REF	C	CN
8	CRMST_ADDRESS_VERSION_BUIL	TITLE_P	TSAD3	TITLE	REF	C	CN
9	CRMST_ADDRESS_VERSION_BUIL	TITLE_SPPL	TSAD5	TITLE_KEY	REF	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in