SAP ABAP Table JVVSOPDV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JVVSOPDV	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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ORDNBR	☑	SHIPORDNBR	SHIPORDNBR	CHAR	10	0	Address-Based Shipping Order Number
3	PUBLICATION	☑	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
4	EDITION	☑	PVA	PVA	CHAR	8	0	Edition	JDTPVA
5	POSNBR	☑	SHIPORDPOSNBR	SHIPORDPOSNBR	NUMC	8	0	Address-Based Shipping Order Item Number
6	ADDRESS	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
7	ADDRESS_VARIANT	☑	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
8	DOCNBR_CUST	☑	JV_DOCNBR_CUST	VBELN	CHAR	10	0	IS-M/SD: Customer Document Number
9	DOCPOSNBR_CUST	☑	JV_DOCPOSNBR_CUST	POSNR	NUMC	6	0	IS-M/SD: Customer Document Item Number
10	DOCNBR_TYPE	☑	JV_DOCNBR_TYPE	JV_DOCNBR_TYPE	CHAR	3	0	IS-M/SD: Origin of document number
11	REFDOC	☑	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
12	QUANTITY	☑	JVQUANTITY	LIEFRMENG2	QUAN	9	0	Quantity for Shipping Order Item
13	UNIT	☑	MEINLIEF	MEINS	UNIT	3	0	Unit of Measure for Delivery Quantity	T006
14	INCOMPLETE	☑	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
15	ADDRESS_CHANGED	☑	JVADDRESS_CHANGED	XFELD	CHAR	1	0	IS-M/SD: Address changed
16	VALIDFROM	☑	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
17	HOME_DEL_ELE	☑	HOME_DEL_ELE	HOME_DEL_ELE	CHAR	8	0	IS-M/SD: Home Delivery Alternation Element	TJV87
18	VALIDTO	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
19	VIABILITY	☐	LIEFBARNR	LIEFBARNR	CHAR	9	0	Sequence number for delivery/home delivery viability set
20	DISTRICT	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
21	DELIV_ROUND	☐	BEZRUNDE	BEZRUNDE	CHAR	10	0	IS-M: Delivery Round	JVTRUNDE
22	PLANT	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
23	HOME_DEL_GROUP	☐	HOME_DEL_GROUP	HOME_DEL_GROUP	CHAR	10	0	IS-M/SD: Home Delivery Alternation Group	TJV89
24	X_MONTAG_HD	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
25	X_DIENSTAG_HD	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
26	X_MITTWOCH_HD	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
27	X_DONNETAG_HD	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
28	X_FREITAG_HD	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
29	X_SAMSTAG_HD	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
30	X_SONNTAG_HD	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVVSOPDV	ADDRESS	JGTSADR	ADRNR	KEY	1	CN
2	JVVSOPDV	CLIENT	T000	MANDT	KEY	1	CN
3	JVVSOPDV	DELIV_ROUND	JVTRUNDE	RUNDE	KEY	1	CN
4	JVVSOPDV	DISTRICT	JVTBEZIRK	BEZIRK	REF	C	CN
5	JVVSOPDV	EDITION	JDTPVA	PVA	KEY	1	CN
6	JVVSOPDV	HOME_DEL_ELE	TJV87	HOME_DEL_ELE	KEY	1	CN
7	JVVSOPDV	HOME_DEL_GROUP	TJV89	HOME_DEL_GROUP	KEY	1	CN
8	JVVSOPDV	PLANT	T001W	WERKS	KEY	1	CN
9	JVVSOPDV	PUBLICATION	JDTDRER	DRERZ	KEY	1	CN
10	JVVSOPDV	UNIT	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in