SAP ABAP Table JVSOH (IS-M/SD Shipping Order Header)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVSOH	Table Relationship Diagram
Short Description	IS-M/SD Shipping Order Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	TEXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
4	SOLDTOPARTY	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
5	ORDNBR_CUST	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
6	PUBLICATION	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
7	EDITION	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
8	MEDIAPRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	MARA
9	MEDIAISSUE	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	DELIV_TYPE	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
11	VALIDFROM	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
12	VALIDTO	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
13	PLANDAYS	☐	JV_PLANDAYS	JKTAGE	NUMC	3	0	IS-M/SD: Number of days for planning in advance
14	XDELIV_FIXED	☐	XDELIV_FIXED	XFELD	CHAR	1	0	IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
15	ORDER_TYPE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
16	DELTA_DATE	☐	JVDELTA_DATE	DATUM	DATS	8	0	Shipping date of last delta import
17	DELTA_NBR	☐	JVDELTA_NBR	JVDELTA_NBR	NUMC	5	0	Sequence Number for Delta Imports
18	MAXPOSNBR	☐	SHIPORDPOSNBR	SHIPORDPOSNBR	NUMC	8	0	Address-Based Shipping Order Item Number	*
19	PLANNEDTO	☐	JV_PLANNEDTO	DATUM	DATS	8	0	IS-M/SD: Date to which planning has taken place
20	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
21	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
22	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
23	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
24	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
25	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
26	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVSOH	CLIENT	T000	MANDT	KEY	1	CN
2	JVSOH	DELIV_TYPE	TJV01	LIEFERART	KEY	1	CN
3	JVSOH	EDITION	JDTPVA	PVA	KEY	1	CN
4	JVSOH	MEDIAISSUE	MARA	MATNR	KEY	1	CN
5	JVSOH	MEDIAPRODUCT	MARA	MATNR	REF	1	CN
6	JVSOH	ORDER_TYPE	TJAK	AUART	KEY	1	CN
7	JVSOH	PUBLICATION	JDTDRER	DRERZ	KEY	1	CN
8	JVSOH	SOLDTOPARTY	JGTGPNR	GPNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in