SAP table J_3GBELART (Document Types)

SAP table J_3GBELART has 2 primary key fields being MANDT,J_3GBLART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
J_3GBLART Document Type CHAR 4 0 J_3GBLART
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
VBTYP CEM Document Category CHAR 1 0 J_3GBLTYP
1 PBE document
2 Shipping document
AUART Sales Document Type (Internal Equipment Activity) CHAR 4 0 TVAK J_3GAUARTI
J_3GAUARTE Sales Document Type (External Equipment Activity) CHAR 4 0 TVAK J_3GAUARTE
J_3GSTDBEL Indicator for Allowing Standard Document CHAR 1 0 J_3GSTDBEL
J_3GABREM Indicator for Settlement Recipient CHAR 1 0 J_3GABREMP
J_3GPARKEN Indicator: Park CEM Documents CHAR 1 0 J_3GPARKEN
J_3GSOPR Indicator for Entering Special Price CHAR 1 0 J_3GSONDPR
J_3GMIEMP Indicator for Intermediate Recipient CHAR 1 0 J_3GMIEMPF
Intermediate recipient not allowed
1 Intermediate recipient allowed (storage bin of sender)
2 Intermediate recipient allowed and can be entered
J_3GPOSINK Item Increment CHAR 4 0 J_3GPOSINK
J_3GDOLMB Obsolete. Do Not Use Anymore. CHAR 1 0 J_3GOBSOLET
J_3GDOMB Obsolete. Do Not Use Anymore. CHAR 1 0 J_3GOBSOLET
J_3GKZBEL Indicator Allowing Entry of External Document Number - Y/N CHAR 1 0 J_3GKZBELE
J_3GWOFFS Offset for Presentation of Weeks NUMC 1 0 J_3GWOFFS
0 Monday
1 Tuesday
2 Wednesday
3 Thursday
4 Friday
5 Saturday
6 Sunday
J_3GSLWID_KO Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
J_3GSLWID_PO Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
J_3GKENNGEW Indicator for Total Weight Determination CHAR 1 0 J_3GKENNGEW
J_3GMEINS SI unit UNIT 3 0 T006 MSSIE
J_3GAUART_MAT_I Sales Document Type/Material (Internal) CHAR 4 0 TVAK J_3GAUART_MAT_I
J_3GAUART_MAT_E Sales Document Type/Material (External) CHAR 4 0 TVAK J_3GAUART_MAT_E
J_3GAUART_PERS_I Sales Document Type/Personnel (Internal) CHAR 4 0 TVAK J_3GAUART_PERS_I
J_3GAUART_PERS_E Sales Document Type/Personnel (External) CHAR 4 0 TVAK J_3GAUART_PERS_E
J_3GRKAUF_MAT_I Repurchase of Internal Material CHAR 4 0 TVAK J_3GRKAUF_MAT_I
J_3GRKAUF_MAT_E Repurchase of External Material CHAR 4 0 TVAK J_3GRKAUF_MAT_E
J_3GDRUCKREP Name of Report for Print of Shipping Document CHAR 40 0 TRDIR J_3GDRUCKREP
J_3GZULRESS Allowed Resources NUMC 1 0 J_3GZULRESS
1 Equipment and material
2 Equipment
3 Material
J_3GABS_EQ_EMPF Indicator: Sender = Recipient CHAR 1 0 J_3GABS_EQ_EMPF
J_3GANZTAGE Number of Days for Future Entry NUMC 5 0 J_3GANZTAGE
J_3GMP_DIALOG Measurement Document Maintenance Dialog NUMC 1 0 J_3GMP_DIALOG
J_3GBW_ZU Measurement Doc. - Receiving Construction Site CHAR 1 0 J_3GBW_ZU
J_3GBW_AB Measurement Doc. - Sending Construction Site CHAR 1 0 J_3GBW_AB
J_3GBW_ALL Measurement Doc. - Receiving and Sending Construction Site CHAR 1 0 J_3GBW_ALL
J_3GERFGEN Indicator for Entry or Generation of Hours CHAR 1 0 J_3GERFGEN
J_3GLG_VAR Display Variant for PBE Report CHAR 1 0 J_3GLG_VAR
Weekly report
1 Daily report (multiple item entry)
2 Daily report (single item entry)
WFKNZ Indicator: Generate Event for Workflow CHAR 1 0 /SAPCEM/WFKNZ
/SAPCEM/BTAG Number of Days for Start of Search NUMC 3 0 /SAPCEM/BTAG
/SAPCEM/ETAG Number of Days for End of Search for Req. Check NUMC 3 0 /SAPCEM/ETAG
EQHIE Indicator: Explode Equipment Hierarchy or Package NUMC 1 0 /SAPCEM/HIEPAK
0 Do Not Explode Equipment Hierarchy
1 Explode Equipment Hierarchy
2 Explode Package BOM
3 Manual Decision by User
LEVUP Number of hierarchy levels to be exploded above NUMC 2 0 LEVUP
LEVDO Number of hierarchy levels to be exploded below NUMC 2 0 LEVDO
LOGFLAG Indicator for writing change documents CHAR 1 0 LOGFLAG

J_3GBELART foreign key relationships

Table Field Check Table Check Field
0 J_3GBELART AUART TVAK Sales Document Types MANDT
0 J_3GBELART AUART TVAK Sales Document Types AUART
1 J_3GBELART J_3GAUARTE TVAK Sales Document Types MANDT
1 J_3GBELART J_3GAUARTE TVAK Sales Document Types AUART
0 J_3GBELART J_3GAUART_MAT_E TVAK Sales Document Types MANDT
0 J_3GBELART J_3GAUART_MAT_E TVAK Sales Document Types AUART
1 J_3GBELART J_3GAUART_MAT_I TVAK Sales Document Types MANDT
1 J_3GBELART J_3GAUART_MAT_I TVAK Sales Document Types AUART
0 J_3GBELART J_3GAUART_PERS_E TVAK Sales Document Types MANDT
0 J_3GBELART J_3GAUART_PERS_E TVAK Sales Document Types AUART
1 J_3GBELART J_3GAUART_PERS_I TVAK Sales Document Types MANDT
1 J_3GBELART J_3GAUART_PERS_I TVAK Sales Document Types AUART
0 J_3GBELART J_3GDRUCKREP TRDIR Generated Table for View NAME
1 J_3GBELART J_3GMEINS T006 Units of Measurement MANDT
1 J_3GBELART J_3GMEINS T006 Units of Measurement MSEHI
0 J_3GBELART J_3GRKAUF_MAT_E TVAK Sales Document Types MANDT
0 J_3GBELART J_3GRKAUF_MAT_E TVAK Sales Document Types AUART
1 J_3GBELART J_3GRKAUF_MAT_I TVAK Sales Document Types MANDT
1 J_3GBELART J_3GRKAUF_MAT_I TVAK Sales Document Types AUART
0 J_3GBELART J_3GSLWID_KO TCN00 Key Word ID for PS User Fields MANDT
1 J_3GBELART J_3GSLWID_PO TCN00 Key Word ID for PS User Fields MANDT
0 J_3GBELART MANDT T000 Clients MANDT