J_3GBELK SAP (Document File - Header Data) Table details

Dictionary Type: Table
Description: Document File - Header Data




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




Table field list including key, data, relationships and ABAP select examples

J_3GBELK is a standard SAP Table which is used to store Document File - Header Data data and is available within R/3 SAP systems depending on the version and release level.

The J_3GBELK table consists of various fields, each holding specific information or linking keys about Document File - Header Data data available in SAP. These include J_3GBELNRI (Document Number), ERNAM (Name of Person who Created the Object), ERZET (Entry time), ERDAT (Date on Which Record Was Created).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_3GBELK 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_3GBELNRIDocument Number J_3GBELNRICHAR10ALPHAJ_3GBELNRJ2QJ_3GB
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
ERDATDate on Which Record Was Created ERDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
AEZETTime last change was made AEZETTIMS6UZEIT
AEDTMChanged On AEDATDATS8DATUM
J_3GABSENDSender J_3GABSENDCHAR10KNA1ALPHAKUNNR
J_3GABSREFReference Type Sender J_3GABSREFCHAR2J_3GREFTYP
J_3GABSPSPWBS Element Sender J_3GABSPSPNUMC8PRPSABPSPPS_POSNR
J_3GABSPROProject Number Sender J_3GABSPRONUMC8PROJKONPDPS_PSPNR
J_3GABSKOSCost Center Sender J_3GABSKOSCHAR10CSKSALPHAKOSTL
J_3GABSKOKControlling Area Sender J_3GABSKOKCHAR4TKA01CACCD
J_3GABSACOSender of CO Order J_3GABSACOCHAR12AUFKALPHAAUFNR
J_3GABSAPMSender of PM Order J_3GABSAPMCHAR12AUFKALPHAAUFNR
J_3GABSWRKPlant Sender J_3GABSWRKCHAR4T001WWERKS
J_3GABSLAGStorage Location/Warehouse Sender J_3GABSLAGCHAR4T001LLGORT
J_3GABSEXTExternal Ship-to Party - Sender J_3GABSEXTCHAR10KNA1ALPHAKUNNR
J_3GABSDEBDebtor of Sender J_3GABSDEBCHAR10KNA1ALPHAKUNNR
J_3GEMPFAERecipient J_3GEMPFAECHAR10KNA1ALPHAKUNNR
J_3GEMPREFReceiving Reference Type J_3GEMPREFCHAR2J_3GREFTYP
J_3GEMPPSPReceiving WBS Element J_3GEMPPSPNUMC8PRPSABPSPPS_POSNR
J_3GEMPPROReceiving Project Number J_3GEMPPRONUMC8PROJKONPDPS_PSPNR
J_3GEMPKOSReceiving Cost Center J_3GEMPKOSCHAR10CSKSALPHAKOSTL
J_3GEMPKOKReceiving Controlling Area J_3GEMPKOKCHAR4TKA01CACCD
J_3GEMPACOCO Order Recipient J_3GEMPACOCHAR12AUFKALPHAAUFNR
J_3GEMPAPMPM Order Recipient J_3GEMPAPMCHAR12AUFKALPHAAUFNR
J_3GEMPWRKReceiving Plant J_3GEMPWRKCHAR4T001WWERKS
J_3GEMPLAGReceiving Storage Location J_3GEMPLAGCHAR4T001LLGORT
J_3GEMPEXTExternal Ship-To Party - Recipient J_3GEMPEXTCHAR10KNA1ALPHAKUNNR
J_3GEMPDEBDebtor of Recipient J_3GEMPDEBCHAR10KNA1ALPHAKUNNR
J_3GMITTLEIntermediate Recipient J_3GMITTLECHAR10KNA1ALPHAKUNNRDEBI
J_3GMITREFReference Type - Intermediate Recipient J_3GMITREFCHAR2J_3GREFTYP
J_3GMITPSPWBS Element - Intermediate Recipient J_3GMITPSPNUMC8PRPSABPSPPS_POSNR
J_3GMITPROProject Number - Intermediate Recipient J_3GMITPRONUMC8PROJKONPDPS_PSPNR
J_3GMITKOSCost Center - Intermediate Recipient J_3GMITKOSCHAR10CSKSALPHAKOSTL
J_3GMITKOKControlling Area - Intermediate Recipient J_3GMITKOKCHAR4TKA01CACCD
J_3GMITACOCO Order - Intermediate Recipient J_3GMITACOCHAR12AUFKALPHAAUFNR
J_3GMITAPMPM Order Recipient J_3GMITAPMCHAR12AUFKALPHAAUFNR
J_3GMITWRKPlant - Intermediate Recipient J_3GMITWRKCHAR4T001WWERKS
J_3GMITLAGStorage Location - Intermediate Recipient J_3GMITLAGCHAR4T001LLGORT
J_3GFREMDPIndicator for External Employees J_3GFREMDPCHAR1X
PERNRPersonal Number J_3GPERNRNUMC8Assigned to domainJ_3GPERNR
NACHNLast Name NACHNCHAR25NACHN
J_3GEMPPERReceiving Cost Center for Personnel J_3GEMPPERCHAR10KNA1ALPHAKUNNR
J_3GBELSTAInternal Document Status J_3GBELSTACHAR1J_3GBELSTA
J_3GPIABSDocument Flat Rate Indicator (Internal) - Sender J_3GPIABSCHAR1J_3GPAUSCH
J_3GPEABSDocument Flat Rate Indicator (External) - Sender J_3GPEABSCHAR1J_3GPAUSCH
J_3GPIEMPFDocument Flat Rate Indicator (Internal) - Recipient J_3GPIEMPSCHAR1J_3GPAUSCH
J_3GPEEMPSDocument Flat Rate Indicator (External) - Recipient J_3GPEEMPSCHAR1J_3GPAUSCH
J_3GBETR1Internal Flat Rate - Sender J_3GBETR1CURR15(2) WERTV8
J_3GBETR2External Flat Rate - Sender J_3GBETR2CURR15(2) WERTV8
J_3GBETR3Internal Flat Rate - Recipient J_3GBETR3CURR15(2) WERTV8
J_3GBETR4External Flat Rate - Recipient J_3GBETR4CURR15(2) WERTV8
J_3GWAERS1Currency Flat Rate Amount (Internal) - Sender J_3GWAERS1CUKY5TCURCWAERS
J_3GWAERS2Currency Flat Rate Amount (External) - Sender J_3GWAERS2CUKY5TCURCWAERS
J_3GWAERS3Currency Flat Rate Amount (Internal) - Recipient J_3GWAERS3CUKY5TCURCWAERS
J_3GWAERS4Currency Flat Rate Amount (External) - Recipient J_3GWAERS4CUKY5TCURCWAERS
J_3GFAKTABBilling Indicator - Sender J_3GFAKTABCHAR1J_3GFAKTKZ
J_3GFAKTEMBilling Indicator - Recipient J_3GFAKTEMCHAR1J_3GFAKTKZ
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
J_3GTPLKZCatalog Code J_3GTPLKZCHAR5J_3GT370SJ_3GTPLKZJ2R
J_3GKATNRCNumber in Catalog J_3GKATNRCCHAR30J_3GKATALJ_3GKATNRCJ2GKAL
LFDNRSequence Number J_3GLFDNR4NUMC4NUMC4
J_3GDOMLMBPricing Dominancy (Provider/Intermediate Recipient/Debtor) J_3GDOMLMBCHAR1J_3GDOMLMB
J_3GDOMMBPricing Dominancy (Intermediate Recipient/Debtor) J_3GDOMMBCHAR1J_3GDOMLMB
J_3GBELNRExternal Document Number J_3GBELNRCHAR10ALPHAJ_3GBELNR
J_3GBLARTDocument Type J_3GBLARTCHAR4J_3GBELARTJ_3GBLART
J_3GBLTYPCEM Document Category J_3GBLTYPCHAR1J_3GBLTYP
J_3GBELDATCEM Document Date J_3GBELDATDATS8DATUM
VKORGSales Organization, but Obsolete /SAPCEM/VKORGCHAR4TVKOVKORGVKOH_TVKO
VTWEGDistribution Channel, but Obsolete /SAPCEM/VTWEGCHAR2TVTWVTWEGVTWCSH_TVTW
SPARTDivision, but Obsolete /SAPCEM/SPARTCHAR2TSPASPARTSPACSH_TSPA
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
J_3GBEWEGInternal Indicator for Transaction Type J_3GBEWEGCHAR1J_3GBEWEG
J_3GBELSTEExternal Document Status J_3GBELSTECHAR1J_3GBELSTA
SLWIDKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
USR00User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR01User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR02User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR03User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR04User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE04User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR05User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE05User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USR06User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE06User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR07User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE07User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USR08User field for date USRDATEDATS8USRDATE
USR09User field for date USRDATEDATS8USRDATE
USR10User-defined field: Indicator for reports USRFLAGCHAR1FLAG
USR11User-defined field: Indicator for reports USRFLAGCHAR1FLAG
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
ETYPEEquity type JV_ETYPECHAR3T8JGALPHAJV_ETYPE
JV_OTYPEJoint Venture Object Type JV_OTYPECHAR4ALPHAJV_OTYPE
JV_JIBCLJIB/JIBE Class JV_JIBCLCHAR3T8J6AJV_JIBCLJIB
JV_JIBSAJIB/JIBE Subclass A JV_JIBSACHAR5T8J6CJV_JIBSAJBS
JV_OCOJV original cost object JV_OR_COCHAR1JV_OR_COB
DUMMY_CI_AFVUSingle-Character Indicator CHAR1CHAR1CHAR1
SPARAMETER1Scheduling Parameters for External Scheduling SPARAMETERCHAR4
SPARAMETER2Scheduling Parameters for External Scheduling SPARAMETERCHAR4
SPARAMETER3Scheduling Parameters for External Scheduling SPARAMETERCHAR4
.INCLU--AP 0
/MRSS/ID_PROFILERequirements Profile Was Changed Manually /MRSS/T_REQU_UPDCHAR1/MRSS/_HCM_BOOLEAN
/MRSS/PROF_KEYProfile Key /MRSS/T_RSG_REQUIDCHAR10ALPHA/MRSS/RSG_REQUID
/MRSS/PROF_GUIDCharacter field, length 32 CHAR32CHAR32CHAR32
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/DEM_COUNTCounter for Demands in Operation /MRSS/T_DEM_COUNTNUMC4NUMC4
/MRSS/SUPERV_CNTNumber of Site Supervisors /MRSS/T_RAP_SUPERVISOR_COUNTCHAR2ALPHA/MRSS/_RAP_SUPERVISOR_COUNT
/MRSS/RULE_IDTime Rule Id /MRSS/T_RSG_TIME_RULE_IDCHAR25TEXT25
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/REFF_RCNTDetermination of Remaining Demand: No. of Resources /MRSS/T_REM_EFFORT_RES_COUNTNUMC3NUMC3
/MRSS/REFF_E_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_E_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/RELEVANTOperation Set as MRS-Relevant /MRSS/T_RELEVANT_FOR_MRSCHAR1FLAG
/MRSS/TEAM_PLANTeam Planning flag for Demand /MRSS/T_RSG_TEAM_PLANNINGCHAR1/MRSS/_RSG_TEAM_PLANNING
/MRSS/SINGL_RESIndicator for Forcing a Single Resource /MRSS/T_RSG_FORCE_SINGLE_RESCHAR1/MRSS/_BOOLEAN
/MRSS/TO_BEGDATField of type DATS DATSDATS8DATS
/MRSS/TO_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_ENDDATField of type DATS DATSDATS8DATS
/MRSS/TO_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/TO_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/TO_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/TO_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
/MRSS/FR_BEGDATField of type DATS DATSDATS8DATS
/MRSS/FR_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_ENDDATField of type DATS DATSDATS8DATS
/MRSS/FR_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/FR_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/FR_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/FR_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
.INCLU--AP 0
ILART_OPMaintenance activity type ILACHAR3Assigned to domainILARTH_T350I
.INCLU--AP 0
FERC_INDRegulatory indicator FE_INDCHAR4FERC_C7ALPHAFE_IND
J_3GVVCOM1Comment J_3GVVCOMCHAR40CHAR40
J_3GVVCOM2Comment J_3GVVCOMCHAR40CHAR40
GSGEWTotal Weight GSGEWQUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
J_3GABS_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
J_3GABS_GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
J_3GEMP_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
J_3GEMP_GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
J_3GABSNPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
J_3GABSVORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
J_3GEMPNPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
J_3GEMPVORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN

Key field Non-key field



How do I retrieve data from SAP table J_3GBELK using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_3GBELK to SELECT all data from the table
DATA: WA_J_3GBELK TYPE J_3GBELK.

SELECT SINGLE *
FROM J_3GBELK
INTO CORRESPONDING FIELDS OF WA_J_3GBELK
WHERE...

How to access SAP table J_3GBELK

Within an ECC or HANA version of SAP you can also view further information about J_3GBELK 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!