SAP ABAP Table JVVVSPADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JVVVSPADR	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	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
13	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
14	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
17	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
18	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
19	GPNR	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
20	ETEEX	☐	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
21	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
22	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
23	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
24	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
25	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
26	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
27	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
28	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
29	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
30	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
31	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
32	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
33	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
34	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
35	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
36	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
37	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
38	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
39	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
40	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
41	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
42	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
43	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
44	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
45	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
46	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
47	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
48	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
49	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	ADRNR	JGTSADR	ADRNR	KEY	1	CN
2	JVVVSPADR	ANRED	TJG43	JANRED	REF	C	CN
3	JVVVSPADR	AUART	TJAK	AUART	REF	1	CN
4	JVVVSPADR	BUNDNR	JVTBUND	BUNDNR	KEY	1	CN
5	JVVVSPADR	CITYC	T005G	CITYC	REF	C	CN
6	JVVVSPADR	COUNC	T005E	COUNC	REF	C	CN
7	JVVVSPADR	ETENR	JKEP	ETENR	KEY	1	CN
8	JVVVSPADR	GPAG	JGTGPNR	GPNR	KEY	1	CN
9	JVVVSPADR	GPNR	JGTGPNR	GPNR	REF	C	CN
10	JVVVSPADR	KDGRP	T151	KDGRP	REF	C	CN
11	JVVVSPADR	LAND1	T005	LAND1	REF	C	CN
12	JVVVSPADR	MANDT	T000	MANDT	KEY	1	CN
13	JVVVSPADR	NAMZU	T535N	TITEL
14	JVVVSPADR	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
15	JVVVSPADR	POART	TJAP	POART	REF	1	CN
16	JVVVSPADR	POSNR	JKAP	POSNR	KEY	1	CN
17	JVVVSPADR	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
18	JVVVSPADR	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
19	JVVVSPADR	REGIO	T005S	BLAND	REF	C	CN
20	JVVVSPADR	SPRAS	T002	SPRAS	REF	C	CN
21	JVVVSPADR	TITEL	T535N	TITEL
22	JVVVSPADR	VBELN	JKAK	VBELN	KEY	1	CN
23	JVVVSPADR	VKORG	TVKO	VKORG	KEY	1	CN
24	JVVVSPADR	VORSW	T535N	TITEL
25	JVVVSPADR	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in