SAP Table J_3GBELART

Document Types

J_3GBELART (Document Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_3GBELART to other SAP tables.

J_3GBELART table fields

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

J_3GBELART foreign key relationships

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