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