SAP Table

J_3GBELART Document Types

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

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

/ Fields

J_3GBELART columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyJ_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
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
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
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
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
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
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
/ Relationships

J_3GBELART foreign keys.

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