SAP ABAP Table JVVVSPADR_AV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JVVVSPADR_AV	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUNDNR	☑	BUND	BUND	CHAR	12	0	Bundle	JVTBUND
3	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
4	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
5	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
6	LFNDR	☑	LFNDR_MNG	NUMC8	NUMC	8	0	IS-M: Sequence Number for Quantity Schedule Line
7	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
8	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
9	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
10	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
11	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
12	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
13	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
14	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
15	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
16	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
17	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
18	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
19	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
20	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
21	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
22	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
23	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
24	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
25	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
26	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
27	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
28	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
29	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
30	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
31	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
32	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
33	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
34	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
35	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
36	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
37	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
38	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
39	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVVVSPADR_AV	ADRNR	JGTSADR	ADRNR	KEY	1	CN
2	JVVVSPADR_AV	ANRED	TJG43	JANRED	REF	C	CN
3	JVVVSPADR_AV	BUNDNR	JVTBUND	BUNDNR	KEY	1	CN
4	JVVVSPADR_AV	CITYC	T005G	CITYC	REF	C	CN
5	JVVVSPADR_AV	COUNC	T005E	COUNC	REF	C	CN
6	JVVVSPADR_AV	ETENR	JKEP	ETENR	KEY	1	CN
7	JVVVSPADR_AV	LAND1	T005	LAND1	REF	C	CN
8	JVVVSPADR_AV	MANDT	T000	MANDT	KEY	1	CN
9	JVVVSPADR_AV	NAMZU	T535N	TITEL
10	JVVVSPADR_AV	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
11	JVVVSPADR_AV	POSNR	JKAP	POSNR	KEY	1	CN
12	JVVVSPADR_AV	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
13	JVVVSPADR_AV	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
14	JVVVSPADR_AV	REGIO	T005S	BLAND	REF	C	CN
15	JVVVSPADR_AV	SPRAS	T002	SPRAS	REF	C	CN
16	JVVVSPADR_AV	TITEL	T535N	TITEL
17	JVVVSPADR_AV	VBELN	JKAK	VBELN	KEY	1	CN
18	JVVVSPADR_AV	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in