J_3GBELART SAP (Document Types) Table details

Dictionary Type: Table
Description: Document Types




ABAP Code to SELECT data from J_3GBELART
Related tables to J_3GBELART
Access table J_3GBELART




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
J_3GBLARTDocument Type J_3GBLARTCHAR4J_3GBLART
NUMKINumber range in the case of internal number assignment NUMKICHAR2NUMKR
VBTYPCEM Document Category J_3GBLTYPCHAR1J_3GBLTYP
AUARTSales Document Type (Internal Equipment Activity) J_3GAUARTICHAR4TVAKAUARTAUARTAAT
J_3GAUARTESales Document Type (External Equipment Activity) J_3GAUARTECHAR4TVAKAUARTAUARTAAT
J_3GSTDBELIndicator for Allowing Standard Document J_3GSTDBELCHAR1X
J_3GABREMIndicator for Settlement Recipient J_3GABREMPCHAR1X
J_3GPARKENIndicator: Park CEM Documents J_3GPARKENCHAR1X
J_3GSOPRIndicator for Entering Special Price J_3GSONDPRCHAR1X
J_3GMIEMPIndicator for Intermediate Recipient J_3GMIEMPFCHAR1J_3GMIEMPF
J_3GPOSINKItem Increment J_3GPOSINKCHAR4NUMCVSPOSN
J_3GDOLMBObsolete. Do Not Use Anymore. J_3GOBSOLETCHAR1CHAR1
J_3GDOMBObsolete. Do Not Use Anymore. J_3GOBSOLETCHAR1CHAR1
J_3GKZBELIndicator Allowing Entry of External Document Number - Y/N J_3GKZBELECHAR1X
J_3GWOFFSOffset for Presentation of Weeks J_3GWOFFSNUMC1J_3GWOFFS
J_3GSLWID_KOKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
J_3GSLWID_POKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
J_3GKENNGEWIndicator for Total Weight Determination J_3GKENNGEWCHAR1X
J_3GMEINSSI unit MSSIEUNIT3T006CUNITMEINS
J_3GAUART_MAT_ISales Document Type/Material (Internal) J_3GAUART_MAT_ICHAR4TVAKAUARTAUARTAAT
J_3GAUART_MAT_ESales Document Type/Material (External) J_3GAUART_MAT_ECHAR4TVAKAUARTAUARTAAT
J_3GAUART_PERS_ISales Document Type/Personnel (Internal) J_3GAUART_PERS_ICHAR4TVAKAUARTAUARTAAT
J_3GAUART_PERS_ESales Document Type/Personnel (External) J_3GAUART_PERS_ECHAR4TVAKAUARTAUARTAAT
J_3GRKAUF_MAT_IRepurchase of Internal Material J_3GRKAUF_MAT_ICHAR4TVAKAUARTAUARTAAT
J_3GRKAUF_MAT_ERepurchase of External Material J_3GRKAUF_MAT_ECHAR4TVAKAUARTAUARTAAT
J_3GDRUCKREPName of Report for Print of Shipping Document J_3GDRUCKREPCHAR40TRDIRPROGNAME
J_3GZULRESSAllowed Resources J_3GZULRESSNUMC1J_3GZULRESS
J_3GABS_EQ_EMPFIndicator: Sender = Recipient J_3GABS_EQ_EMPFCHAR1X
J_3GANZTAGENumber of Days for Future Entry J_3GANZTAGENUMC5NUMC
J_3GMP_DIALOGMeasurement Document Maintenance Dialog J_3GMP_DIALOGNUMC1J_3GMBDIA
J_3GBW_ZUMeasurement Doc. - Receiving Construction Site J_3GBW_ZUCHAR1J_3GBW_ZU
J_3GBW_ABMeasurement Doc. - Sending Construction Site J_3GBW_ABCHAR1J_3GBW_AB
J_3GBW_ALLMeasurement Doc. - Receiving and Sending Construction Site J_3GBW_ALLCHAR1J_3GBW_ALL
J_3GERFGENIndicator for Entry or Generation of Hours J_3GERFGENCHAR1X
J_3GLG_VARDisplay Variant for PBE Report J_3GLG_VARCHAR1J_3GLG_VAR
WFKNZIndicator: Generate Event for Workflow /SAPCEM/WFKNZCHAR1X
/SAPCEM/BTAGNumber of Days for Start of Search /SAPCEM/BTAGNUMC3NUM3
/SAPCEM/ETAGNumber of Days for End of Search for Req. Check /SAPCEM/ETAGNUMC3NUM3
EQHIEIndicator: Explode Equipment Hierarchy or Package /SAPCEM/HIEPAKNUMC1/SAPCEM/HIEPAK
LEVUPNumber of hierarchy levels to be exploded above LEVUPNUMC2NUM2
LEVDONumber of hierarchy levels to be exploded below LEVDONUMC2NUM2
LOGFLAGIndicator for writing change documents LOGFLAGCHAR1AS4FLAG

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!