SAP ABAP Table /SAPCEM/V_SHDOC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/SAPCEM/V_SHDOC	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	J_3GBELNRI	☑	J_3GBELNRI	J_3GBELNR	CHAR	10	0	Document Number
3	J_3GPOSNRI	☑	J_3GBELPOS	J_3GPOSNR	NUMC	5	0	Document Item
4	J_3GUPOSNR	☑	J_3GUPOSNR	NUMC2	NUMC	2	0	Sub-Item Number
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
9	J_3GABSEND	☐	J_3GABSEND	KUNNR	CHAR	10	0	Sender	KNA1
10	J_3GABSDEB	☐	J_3GABSDEB	KUNNR	CHAR	10	0	Debtor of Sender	KNA1
11	J_3GABSEXT	☐	J_3GABSEXT	KUNNR	CHAR	10	0	External Ship-to Party - Sender	KNA1
12	J_3GEMPFAE	☐	J_3GEMPFAE	KUNNR	CHAR	10	0	Recipient	KNA1
13	J_3GEMPDEB	☐	J_3GEMPDEB	KUNNR	CHAR	10	0	Debtor of Recipient	KNA1
14	J_3GEMPEXT	☐	J_3GEMPEXT	KUNNR	CHAR	10	0	External Ship-To Party - Recipient	KNA1
15	J_3GMITTLE	☐	J_3GMITTLE	KUNNR	CHAR	10	0	Intermediate Recipient	KNA1
16	J_3GBELSTIK	☐	J_3GBELSTA	J_3GBELSTA	CHAR	1	0	Internal Document Status
17	J_3GFAKTAB	☐	J_3GFAKTAB	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Sender
18	J_3GFAKTEM	☐	J_3GFAKTEM	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Recipient
19	J_3GDOMLMB	☐	J_3GDOMLMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Provider/Intermediate Recipient/Debtor)
20	J_3GDOMMB	☐	J_3GDOMMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Intermediate Recipient/Debtor)
21	J_3GBELNR	☐	J_3GBELNR	J_3GBELNR	CHAR	10	0	External Document Number
22	J_3GBLART	☐	J_3GBLART	J_3GBLART	CHAR	4	0	Document Type	J_3GBELART
23	J_3GBELDAT	☐	J_3GBELDAT	DATUM	DATS	8	0	CEM Document Date
24	VKORG	☐	/SAPCEM/VKORG	VKORG	CHAR	4	0	Sales Organization, but Obsolete	TVKO
25	VTWEG	☐	/SAPCEM/VTWEG	VTWEG	CHAR	2	0	Distribution Channel, but Obsolete	TVTW
26	SPART	☐	/SAPCEM/SPART	SPART	CHAR	2	0	Division, but Obsolete	TSPA
27	J_3GBEWEG	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type
28	J_3GBELSTEK	☐	J_3GBELSTE	J_3GBELSTA	CHAR	1	0	External Document Status
29	J_3GCOMM1K	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
30	J_3GCOMM2K	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
31	GSGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
32	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
33	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
34	J_3GRESTYP	☐	J_3GRESTYP	J_3GRESTYP	CHAR	2	0	Resource Indicator
35	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
36	J_3GTPLKZ	☐	J_3GTPLKZ	J_3GTPLKZ	CHAR	5	0	Catalog Code	J_3GT370S
37	J_3GKATNRC	☐	J_3GKATNRC	J_3GKATNRC	CHAR	30	0	Number in Catalog	J_3GKATAL
38	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
39	J_3GGRUND	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type	J_3GZUABGR
40	J_3GLFDNR	☐	J_3GLFDNR2	NUMC2	NUMC	2	0	Sequence Number	J_3GZUABGR
41	J_3GLVART	☐	J_3GLVART	J_3GLVART	CHAR	4	0	Activity Type	J_3GLEIART
42	J_3GMENGE	☐	J_3GMENGE	MENG13	QUAN	13	3	Quantity
43	J_3GMEINS	☐	MEINA	MEINS	UNIT	3	0	Unit of measure	T006
44	J_3GKZMENG	☐	J_3GKZMENG	J_3GKZMENG	CHAR	1	0	Item/Multipart Indicator
45	PERNR	☐	J_3GPERNR	J_3GPERNR	NUMC	8	0	Personal Number
46	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
47	J_3GBELSTIP	☐	J_3GBELSTA	J_3GBELSTA	CHAR	1	0	Internal Document Status
48	J_3GBELSTEP	☐	J_3GBELSTE	J_3GBELSTA	CHAR	1	0	External Document Status
49	J_3GKZFRIS	☐	J_3GKZFRIS	J_3GKZFRIS	CHAR	1	0	Usage Period Indicator
50	J_3GEINEND	☐	J_3GEINEND	DATUM	DATS	8	0	End of Usage Period
51	J_3GKZLADI	☐	J_3GKZLADI	J_3GKZLAD	CHAR	1	0	Indicator: Internal Loading Costs
52	J_3GKZLADE	☐	J_3GKZLADE	J_3GKZLAD	CHAR	1	0	Indicator: External (Un)Loading Costs
53	J_3GKZBERG	☐	J_3GKZBERG	J_3GKZBERG	CHAR	1	0	Indicator for Provision Fees
54	J_3GCOMM1P	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
55	J_3GCOMM2P	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
56	J_3GGEWICHT	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
57	J_3GGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
58	J_3GPAKKENN	☐	J_3GPAKKENN	X	CHAR	1	0	Settlement Package Indicator
59	J_3GLVART_WL	☐	J_3GLVART_WL	J_3GLVART	CHAR	4	0	Activity Type for Redelivery
60	J_3GABSPSP	☐	J_3GABSPSP	PS_POSNR	NUMC	8	0	WBS Element Sender	PRPS
61	J_3GABSKOS	☐	J_3GABSKOS	KOSTL	CHAR	10	0	Cost Center Sender	CSKS
62	J_3GABSKOK	☐	J_3GABSKOK	CACCD	CHAR	4	0	Controlling Area Sender	TKA01
63	J_3GABSACO	☐	J_3GABSACO	AUFNR	CHAR	12	0	Sender of CO Order	AUFK
64	J_3GABSAPM	☐	J_3GABSAPM	AUFNR	CHAR	12	0	Sender of PM Order	AUFK
65	J_3GEMPPSP	☐	J_3GEMPPSP	PS_POSNR	NUMC	8	0	Receiving WBS Element	PRPS
66	J_3GEMPKOS	☐	J_3GEMPKOS	KOSTL	CHAR	10	0	Receiving Cost Center	CSKS
67	J_3GEMPKOK	☐	J_3GEMPKOK	CACCD	CHAR	4	0	Receiving Controlling Area	TKA01
68	J_3GEMPACO	☐	J_3GEMPACO	AUFNR	CHAR	12	0	CO Order Recipient	AUFK
69	J_3GEMPAPM	☐	J_3GEMPAPM	AUFNR	CHAR	12	0	PM Order Recipient	AUFK
70	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
71	J_3GEMP_CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPCEM/V_SHDOC	CHARGE	MCH1	CHARG
2	/SAPCEM/V_SHDOC	EQUNR	EQUI	EQUNR
3	/SAPCEM/V_SHDOC	J_3GABSACO	AUFK	AUFNR
4	/SAPCEM/V_SHDOC	J_3GABSAPM	AUFK	AUFNR
5	/SAPCEM/V_SHDOC	J_3GABSDEB	KNA1	KUNNR
6	/SAPCEM/V_SHDOC	J_3GABSEND	KNA1	KUNNR
7	/SAPCEM/V_SHDOC	J_3GABSEXT	KNA1	KUNNR
8	/SAPCEM/V_SHDOC	J_3GABSKOK	TKA01	KOKRS
9	/SAPCEM/V_SHDOC	J_3GABSKOS	CSKS	KOSTL
10	/SAPCEM/V_SHDOC	J_3GABSPSP	PRPS	PSPNR
11	/SAPCEM/V_SHDOC	J_3GBLART	J_3GBELART	J_3GBLART
12	/SAPCEM/V_SHDOC	J_3GEMPACO	AUFK	AUFNR
13	/SAPCEM/V_SHDOC	J_3GEMPAPM	AUFK	AUFNR
14	/SAPCEM/V_SHDOC	J_3GEMPDEB	KNA1	KUNNR
15	/SAPCEM/V_SHDOC	J_3GEMPEXT	KNA1	KUNNR
16	/SAPCEM/V_SHDOC	J_3GEMPFAE	KNA1	KUNNR
17	/SAPCEM/V_SHDOC	J_3GEMPKOK	TKA01	KOKRS
18	/SAPCEM/V_SHDOC	J_3GEMPKOS	CSKS	KOSTL
19	/SAPCEM/V_SHDOC	J_3GEMPPSP	PRPS	PSPNR
20	/SAPCEM/V_SHDOC	J_3GGRUND	J_3GZUABGR	J_3GGRUND
21	/SAPCEM/V_SHDOC	J_3GKATNRC	J_3GKATAL	J_3GKATNRC
22	/SAPCEM/V_SHDOC	J_3GLFDNR	J_3GZUABGR	J_3GLFDNR
23	/SAPCEM/V_SHDOC	J_3GLVART	J_3GLEIART	J_3GLVART
24	/SAPCEM/V_SHDOC	J_3GMEINS	T006	MSEHI	REF	C	CN
25	/SAPCEM/V_SHDOC	J_3GMITTLE	KNA1	KUNNR
26	/SAPCEM/V_SHDOC	J_3GTPLKZ	J_3GT370S	J_3GTPLKZ
27	/SAPCEM/V_SHDOC	MANDT	T000	MANDT	KEY	1	CN
28	/SAPCEM/V_SHDOC	MATNR	MARA	MATNR	REF	C	CN
29	/SAPCEM/V_SHDOC	SPART	TSPA	SPART		1	CN
30	/SAPCEM/V_SHDOC	VKORG	TVKO	VKORG	REF	1	CN
31	/SAPCEM/V_SHDOC	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in