SAP ABAP Table VSADR (Change Document Structure; generated by RSSCD000)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	INTTAB	Structure
Structure	VSADR	Table Relationship Diagram
Short Description	Change Document Structure; generated by RSSCD000

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 Management: Company Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
4	NATIO	☐	INTER	NATION	CHAR	1	0	International address version ID	*
5	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
6	NAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
7	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
8	NAME3	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
9	NAME4	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
10	PSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
11	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
12	ORT02	☐	ORT02_BAS	TEXT35	CHAR	35	0	District
13	PSTL2	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
14	PFACH	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
15	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
16	STRS2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
17	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
18	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
19	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	SORTL	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
21	SORT2	☐	SORT20	CHAR20	CHAR	20	0	Sort field
22	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
23	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
26	TELF1	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
27	FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
28	TELFX	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
29	FLAG2	☐	XFELD	XFELD	CHAR	1	0	Checkbox
30	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
31	FLAG3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
32	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
33	FLAG4	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	MAIAD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
35	MAILN	☐	OBJ_NAM	DOC_NAM	CHAR	12	0	Addresses: Document name
36	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
37	STDCOM	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
38	DBNAME	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
39	KLASSE	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
40	ANREK	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
41	CRNAM	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
42	CRDAT	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
43	CRTIM	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
44	CHNAM	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
45	CHDAT	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
46	CHTIM	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
47	DUEFL	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
48	TXJCD	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
49	PFORT	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
50	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
51	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
52	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
53	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*
54	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
55	.INCLUDE	☐				0	0	Structures for generating change document update programs
56	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VSADR	LAND1	T005	LAND1	REF	1	CN
2	VSADR	LZONE	TZONE	ZONE1	REF	1	CN
3	VSADR	MANDT	T000	MANDT	KEY	1	CN
4	VSADR	REGIO	T005S	BLAND	REF	1	CN
5	VSADR	SPRAS	T002	SPRAS	REF	1	CN
6	VSADR	TZONE	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in