SAP ABAP Table SADRVB (Reference structure for XSADR/YSADR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VS (Package) Application development R/3 sales master data

Basic Data

Table Category	INTTAB	Structure
Structure	SADRVB	Table Relationship Diagram
Short Description	Reference structure for XSADR/YSADR

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	Address work area
2	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
3	ANRED	☐	ANRED_VP	ANRED	CHAR	15	0	Form of address
4	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
5	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
6	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
7	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
8	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
9	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
10	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
11	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
12	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
13	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
14	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
15	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
16	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
17	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
18	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
19	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
20	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
21	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
22	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
23	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
24	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
25	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
27	HAUSN	☐	HSNMR	NUMC6	NUMC	6	0	House Number
28	PARGE	☐	PARGE	GESCH	CHAR	1	0	Partner's gender
29	NAME_LIST	☐	NAME_LIST	NAME	CHAR	35	0	Name for list displays
30	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
31	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
32	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
33	DUEFL	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
34	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
35	STRS2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
36	STRASNA	☐	STRAS_NA	TEXT35	CHAR	35	0	Street Name (Without House Number)
37	EMAIL_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
38	MOBNUM	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
39	.INCLUDE	☐				0	0	Dynamic Part
40	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
41	ADDR_RENUMBERED	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SADRVB	CITYC	T005G	CITYC
2	SADRVB	COUNC	T005E	COUNC
3	SADRVB	LAND1	T005	LAND1
4	SADRVB	LZONE	TZONE	ZONE1
5	SADRVB	REGIO	T005S	BLAND
6	SADRVB	SPRAS	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in