SAP table reference
J_3GBELART
Document TypesExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table J_3GBELART.
SAP table J_3GBELART has 2 primary key fields: MANDT,J_3GBLART.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
J_3GBELART fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||
| Key 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 | ||||||||||||||||
| |||||||||||||||||||||
| 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 relationships.
| 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 |