J_3GBELART SAP (Document Types) Table details
Dictionary Type: Table
Description: Document Types
Description: Document Types
Table field list including key, data, relationships and ABAP select examples
J_3GBELART is a standard SAP Table which is used to store Document Types data and is available within R/3 SAP systems depending on the version and release level.
The J_3GBELART table consists of various fields, each holding specific information or linking keys about Document Types data available in SAP. These include J_3GBLART (Document Type), NUMKI (Number range in the case of internal number assignment), VBTYP (CEM Document Category), AUART (Sales Document Type (Internal Equipment Activity)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = J_3GBLARTT
SAP J_3GBELART table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
J_3GBLART | Document Type | J_3GBLART | CHAR | 4 | J_3GBLART | ||||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
VBTYP | CEM Document Category | J_3GBLTYP | CHAR | 1 | J_3GBLTYP | ||||
AUART | Sales Document Type (Internal Equipment Activity) | J_3GAUARTI | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GAUARTE | Sales Document Type (External Equipment Activity) | J_3GAUARTE | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GSTDBEL | Indicator for Allowing Standard Document | J_3GSTDBEL | CHAR | 1 | X | ||||
J_3GABREM | Indicator for Settlement Recipient | J_3GABREMP | CHAR | 1 | X | ||||
J_3GPARKEN | Indicator: Park CEM Documents | J_3GPARKEN | CHAR | 1 | X | ||||
J_3GSOPR | Indicator for Entering Special Price | J_3GSONDPR | CHAR | 1 | X | ||||
J_3GMIEMP | Indicator for Intermediate Recipient | J_3GMIEMPF | CHAR | 1 | J_3GMIEMPF | ||||
J_3GPOSINK | Item Increment | J_3GPOSINK | CHAR | 4 | NUMCV | SPOSN | |||
J_3GDOLMB | Obsolete. Do Not Use Anymore. | J_3GOBSOLET | CHAR | 1 | CHAR1 | ||||
J_3GDOMB | Obsolete. Do Not Use Anymore. | J_3GOBSOLET | CHAR | 1 | CHAR1 | ||||
J_3GKZBEL | Indicator Allowing Entry of External Document Number - Y/N | J_3GKZBELE | CHAR | 1 | X | ||||
J_3GWOFFS | Offset for Presentation of Weeks | J_3GWOFFS | NUMC | 1 | J_3GWOFFS | ||||
J_3GSLWID_KO | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
J_3GSLWID_PO | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
J_3GKENNGEW | Indicator for Total Weight Determination | J_3GKENNGEW | CHAR | 1 | X | ||||
J_3GMEINS | SI unit | MSSIE | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GAUART_MAT_I | Sales Document Type/Material (Internal) | J_3GAUART_MAT_I | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GAUART_MAT_E | Sales Document Type/Material (External) | J_3GAUART_MAT_E | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GAUART_PERS_I | Sales Document Type/Personnel (Internal) | J_3GAUART_PERS_I | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GAUART_PERS_E | Sales Document Type/Personnel (External) | J_3GAUART_PERS_E | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GRKAUF_MAT_I | Repurchase of Internal Material | J_3GRKAUF_MAT_I | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GRKAUF_MAT_E | Repurchase of External Material | J_3GRKAUF_MAT_E | CHAR | 4 | TVAK | AUART | AUART | AAT | |
J_3GDRUCKREP | Name of Report for Print of Shipping Document | J_3GDRUCKREP | CHAR | 40 | TRDIR | PROGNAME | |||
J_3GZULRESS | Allowed Resources | J_3GZULRESS | NUMC | 1 | J_3GZULRESS | ||||
J_3GABS_EQ_EMPF | Indicator: Sender = Recipient | J_3GABS_EQ_EMPF | CHAR | 1 | X | ||||
J_3GANZTAGE | Number of Days for Future Entry | J_3GANZTAGE | NUMC | 5 | NUMC | ||||
J_3GMP_DIALOG | Measurement Document Maintenance Dialog | J_3GMP_DIALOG | NUMC | 1 | J_3GMBDIA | ||||
J_3GBW_ZU | Measurement Doc. - Receiving Construction Site | J_3GBW_ZU | CHAR | 1 | J_3GBW_ZU | ||||
J_3GBW_AB | Measurement Doc. - Sending Construction Site | J_3GBW_AB | CHAR | 1 | J_3GBW_AB | ||||
J_3GBW_ALL | Measurement Doc. - Receiving and Sending Construction Site | J_3GBW_ALL | CHAR | 1 | J_3GBW_ALL | ||||
J_3GERFGEN | Indicator for Entry or Generation of Hours | J_3GERFGEN | CHAR | 1 | X | ||||
J_3GLG_VAR | Display Variant for PBE Report | J_3GLG_VAR | CHAR | 1 | J_3GLG_VAR | ||||
WFKNZ | Indicator: Generate Event for Workflow | /SAPCEM/WFKNZ | CHAR | 1 | X | ||||
/SAPCEM/BTAG | Number of Days for Start of Search | /SAPCEM/BTAG | NUMC | 3 | NUM3 | ||||
/SAPCEM/ETAG | Number of Days for End of Search for Req. Check | /SAPCEM/ETAG | NUMC | 3 | NUM3 | ||||
EQHIE | Indicator: Explode Equipment Hierarchy or Package | /SAPCEM/HIEPAK | NUMC | 1 | /SAPCEM/HIEPAK | ||||
LEVUP | Number of hierarchy levels to be exploded above | LEVUP | NUMC | 2 | NUM2 | ||||
LEVDO | Number of hierarchy levels to be exploded below | LEVDO | NUMC | 2 | NUM2 | ||||
LOGFLAG | Indicator for writing change documents | LOGFLAG | CHAR | 1 | AS4FLAG |
Key field | Non-key field |
How do I retrieve data from SAP table J_3GBELART using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_3GBELART to SELECT all data from the tableDATA: WA_J_3GBELART TYPE J_3GBELART.
SELECT SINGLE *
FROM J_3GBELART
INTO CORRESPONDING FIELDS OF WA_J_3GBELART
WHERE...
How to access SAP table J_3GBELART
Within an ECC or HANA version of SAP you can also view further information about J_3GBELART and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects