SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

J_3GBELP Table in SAP | Document Data - Item Data Table & Fields List

J_3GBELP is a SAP table coming under IS module and ECC-DIMP component.View details, Fields & related tables of J_3GBELP in SAP.

  • Table description : Document Data - Item Data
  • Module : IS-EC-CEM
  • Parent Module : IS
  • Package : J3GD
  • Software Component : ECC-DIMP
J_3GBELP table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP J_3GBELP Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
J_3GBELNRIDocument NumberJ_3GBELNRIJ_3GBELNR
J_3GPOSNRIDocument ItemJ_3GBELPOSJ_3GPOSNR
J_3GUPOSNRSub-Item NumberJ_3GUPOSNRNUMC2
.INCLUDEAdministrative Data for CEM Documents    
ERNAMName of Person who Created the ObjectERNAMUSNAM
ERZETEntry timeERZETUZEIT
ERDATDate on which the record was createdERDATDATUM
UNAMEName of Person Who Changed ObjectAENAMUSNAM
AEZETTime last change was madeAEZETUZEIT
AEDTMLast Changed OnAEDATDATUM
J_3GABSENDSenderJ_3GABSENDKUNNR
J_3GABSREFReference Type SenderJ_3GABSREFJ_3GREFTYP
J_3GABSPSPWBS Element SenderJ_3GABSPSPPS_POSNR
J_3GABSPROProject Number SenderJ_3GABSPROPS_PSPNR
J_3GABSKOSCost Center SenderJ_3GABSKOSKOSTL
J_3GABSKOKControlling Area SenderJ_3GABSKOKCACCD
J_3GABSACOSender of CO OrderJ_3GABSACOAUFNR
J_3GABSAPMSender of PM OrderJ_3GABSAPMAUFNR
J_3GABSWRKPlant SenderJ_3GABSWRKWERKS
J_3GABSLAGStorage Location/Warehouse SenderJ_3GABSLAGLGORT
J_3GABSEXTExternal Ship-to Party - SenderJ_3GABSEXTKUNNR
J_3GABSDEBDebtor of SenderJ_3GABSDEBKUNNR
J_3GEMPFAERecipientJ_3GEMPFAEKUNNR
.INCLUDEGeneral Data Fields for Document Header and Items    
J_3GEMPREFReceiving Reference TypeJ_3GEMPREFJ_3GREFTYP
J_3GEMPPSPReceiving WBS ElementJ_3GEMPPSPPS_POSNR
J_3GEMPPROReceiving Project NumberJ_3GEMPPROPS_PSPNR
J_3GEMPKOSReceiving Cost CenterJ_3GEMPKOSKOSTL
J_3GEMPKOKReceiving Controlling AreaJ_3GEMPKOKCACCD
J_3GEMPACOCO Order RecipientJ_3GEMPACOAUFNR
J_3GEMPAPMPM Order RecipientJ_3GEMPAPMAUFNR
J_3GEMPWRKReceiving PlantJ_3GEMPWRKWERKS
J_3GEMPLAGReceiving Storage LocationJ_3GEMPLAGLGORT
J_3GEMPEXTExternal Ship-To Party - RecipientJ_3GEMPEXTKUNNR
J_3GEMPDEBDebtor of RecipientJ_3GEMPDEBKUNNR
J_3GMITTLEIntermediate RecipientJ_3GMITTLEKUNNR
J_3GMITREFReference Type - Intermediate RecipientJ_3GMITREFJ_3GREFTYP
J_3GMITPSPWBS Element - Intermediate RecipientJ_3GMITPSPPS_POSNR
J_3GMITPROProject Number - Intermediate RecipientJ_3GMITPROPS_PSPNR
J_3GMITKOSCost Center - Intermediate RecipientJ_3GMITKOSKOSTL
J_3GMITKOKControlling Area - Intermediate RecipientJ_3GMITKOKCACCD
J_3GMITACOCO Order - Intermediate RecipientJ_3GMITACOAUFNR
J_3GMITAPMPM Order RecipientJ_3GMITAPMAUFNR
J_3GMITWRKPlant - Intermediate RecipientJ_3GMITWRKWERKS
J_3GMITLAGStorage Location - Intermediate RecipientJ_3GMITLAGLGORT
J_3GFREMDPIndicator for External EmployeesJ_3GFREMDPX
PERNRPersonal NumberJ_3GPERNRJ_3GPERNR
NACHNLast NameNACHNNACHN
J_3GEMPPERReceiving Cost Center for PersonnelJ_3GEMPPERKUNNR
J_3GBELSTAInternal Document StatusJ_3GBELSTAJ_3GBELSTA
J_3GPIABSDocument Flat Rate Indicator (Internal) - SenderJ_3GPIABSJ_3GPAUSCH
J_3GPEABSDocument Flat Rate Indicator (External) - SenderJ_3GPEABSJ_3GPAUSCH
J_3GPIEMPFDocument Flat Rate Indicator (Internal) - RecipientJ_3GPIEMPSJ_3GPAUSCH
J_3GPEEMPSDocument Flat Rate Indicator (External) - RecipientJ_3GPEEMPSJ_3GPAUSCH
J_3GBETR1Internal Flat Rate - SenderJ_3GBETR1WERTV8
J_3GBETR2External Flat Rate - SenderJ_3GBETR2WERTV8
J_3GBETR3Internal Flat Rate - RecipientJ_3GBETR3WERTV8
J_3GBETR4External Flat Rate - RecipientJ_3GBETR4WERTV8
J_3GWAERS1Currency Flat Rate Amount (Internal) - SenderJ_3GWAERS1WAERS
J_3GWAERS2Currency Flat Rate Amount (External) - SenderJ_3GWAERS2WAERS
J_3GWAERS3Currency Flat Rate Amount (Internal) - RecipientJ_3GWAERS3WAERS
J_3GWAERS4Currency Flat Rate Amount (External) - RecipientJ_3GWAERS4WAERS
J_3GFAKTABBilling Indicator - SenderJ_3GFAKTABJ_3GFAKTKZ
J_3GFAKTEMBilling Indicator - RecipientJ_3GFAKTEMJ_3GFAKTKZ
EQUNREquipment NumberEQUNREQUNR
J_3GTPLKZCatalog CodeJ_3GTPLKZJ_3GTPLKZ
J_3GKATNRCNumber in CatalogJ_3GKATNRCJ_3GKATNRC
LFDNRSequence NumberJ_3GLFDNR4NUMC4
J_3GDOMLMBPricing Dominancy (Provider/Intermediate Recipient/Debtor)J_3GDOMLMBJ_3GDOMLMB
J_3GDOMMBPricing Dominancy (Intermediate Recipient/Debtor)J_3GDOMMBJ_3GDOMLMB
J_3GBELNRExternal Document NumberJ_3GBELNRJ_3GBELNR
J_3GPOSNRDocument ItemJ_3GBELPOSJ_3GPOSNR
J_3GGRUNDInternal Indicator for Transaction TypeJ_3GBEWEGJ_3GBEWEG
J_3GLFDNRSequence NumberJ_3GLFDNR2NUMC2
J_3GLVARTActivity TypeJ_3GLVARTJ_3GLVART
J_3GMENGEQuantityJ_3GMENGEMENG13
J_3GMEINSUnit of measureMEINAMEINS
J_3GMENGE2QuantityJ_3GMENGEMENG13
J_3GMEINS2Unit of measureMEINAMEINS
J_3GKZLATRActivity Type SeparationJ_3GKZLATRJ_3GKZLATR
J_3GVBELNENumber of External Billing DocumentJ_3GVBELNEVBELN
EQUNR2Equipment NumberEQUNREQUNR
J_3GKZMENGItem/Multipart IndicatorJ_3GKZMENGJ_3GKZMENG
MATNRMaterial NumberMATNRMATNR
J_3GGENSTAGeneration StatusJ_3GGENSTAJ_3GGENSTA
J_3GKZFRISUsage Period IndicatorJ_3GKZFRISJ_3GKZFRIS
J_3GEINENDEnd of Usage PeriodJ_3GEINENDDATUM
J_3GDATLABDate of Activity OutputJ_3GDATLABDATUM
J_3GKZLADIIndicator: Internal Loading CostsJ_3GKZLADIJ_3GKZLAD
J_3GKZLADEIndicator: External (Un)Loading CostsJ_3GKZLADEJ_3GKZLAD
J_3GKZBERGIndicator for Provision FeesJ_3GKZBERGJ_3GKZBERG
J_3GBESTEMInventory Management - RecipientJ_3GBESTEMKUNNR
J_3GKZSPILIndicator: Special Price for Internal Provider of ServiceJ_3GKZSPILJ_3GKZSOPR
J_3GKZSPELIndicator: Special Price for External Provider of ServiceJ_3GKZSPELJ_3GKZSOPR
J_3GKZSPIBIndicator: Special Price for Internal Recipient of ServiceJ_3GKZSPIBJ_3GKZSOPR
J_3GKZSPEBIndicator: Special Price for External Recipient of ServiceJ_3GKZSPEBJ_3GKZSOPR
J_3GKZLVOIIndicator: Calculate Internal PBE as TBEJ_3GKZLVOIX
J_3GKZLVOEIndicator: Calculate external PBE as TBEJ_3GKZLVOEX
J_3GUMVERIRedirection Settlement Type - InternalJ_3GUMVERIJ_3GLVART
J_3GUMVERERedirection Settlement Type - ExternalJ_3GUMVEREJ_3GLVART
.INCLUDEMeasuring Points Document Entry (Structure)    
J_3GIMPT1Actual Value of Measuring PointJ_3GIMPT1IMRC_POINT
J_3GIMPT2Calculated Value of Measuring PointJ_3GIMPT2IMRC_POINT
J_3GMPOBJObject Number for the Measuring Point ObjectIMRC_MPOBJJ_OBJNR
J_3GMPBEG1Actual Start of Measuring PointJ_3GMPBEG1NUM10
J_3GMPEND1Actual End of Measuring PointJ_3GMPEND1NUMC10
J_3GCDIFFCounter Reading DifferenceJ_3GCDIFFNUMC10
J_3GMDOCM1Measurement DocumentIMRC_MDOCMIMRC_MDOCM
J_3GMDOCM2Measurement DocumentIMRC_MDOCMIMRC_MDOCM
J_3GIDATEDate of the MeasurementIMRC_IDATEDATUM
J_3GITIMETime of MeasurementIMRC_ITIMEUZEIT
J_3GBELSTEExternal Document StatusJ_3GBELSTEJ_3GBELSTA
.INCLUDEUser-Defined Fields    
.INCLUDEInclude structure of the user fields of the operation    
SLWIDKey word ID for user-defined fieldsSLWIDSLWID
USR00User field with 20 charactersUSRCHAR20USRCHAR20
USR01User field with 20 charactersUSRCHAR20USRCHAR20
USR02User field with 10 charactersUSRCHAR10USRCHAR10
USR03User field with 10 charactersUSRCHAR10USRCHAR10
USR04User field for quantity (length 10.3)USRQUAN13USRQUAN13
USE04User field: Unit for quantity fieldsUSRUNITMEINS
USR05User field for quantity (length 10.3)USRQUAN13USRQUAN13
USE05User field: Unit for quantity fieldsUSRUNITMEINS
USR06User-defined field for values (length 10,3)USRCURR13USRCURR13
USE06User field: Unit for value fieldsUSRCUKYWAERS
USR07User-defined field for values (length 10,3)USRCURR13USRCURR13
USE07User field: Unit for value fieldsUSRCUKYWAERS
USR08User field for dateUSRDATEUSRDATE
USR09User field for dateUSRDATEUSRDATE
USR10User-defined field: Indicator for reportsUSRFLAGFLAG
USR11User-defined field: Indicator for reportsUSRFLAGFLAG
.INCLUDEJV data: (GJV_DATA_2),jv_oco    
.INCLUDEJV data: (vname,recid,etype),jv_otype,jv_jibcl,jv_jibsa    
.INCLUDEGeneral assignments of application objects    
VNAMEJoint ventureJV_NAMEJV_NAME
RECIDRecovery IndicatorJV_RECINDJV_RECIND
ETYPEEquity typeJV_ETYPEJV_ETYPE
JV_OTYPEJoint Venture Object TypeJV_OTYPEJV_OTYPE
JV_JIBCLJIB/JIBE ClassJV_JIBCLJV_JIBCL
JV_JIBSAJIB/JIBE Subclass AJV_JIBSAJV_JIBSA
JV_OCOJV original cost objectJV_OR_COJV_OR_COB
.INCLUDE   
SPARAMETER1Scheduling Parameters for External SchedulingSPARAMETER  
SPARAMETER2Scheduling Parameters for External SchedulingSPARAMETER  
SPARAMETER3Scheduling Parameters for External SchedulingSPARAMETER  
.INCLU--APAFVUI APPEND for Operation Account Assignment    
ILART_OPMaintenance activity typeILAILART
.INCLU--APAppend structure for Regulatory Reporting    
FERC_INDRegulatory indicatorFE_INDFE_IND
J_3GVVCOM1CommentJ_3GVVCOMCHAR40
J_3GVVCOM2CommentJ_3GVVCOMCHAR40
J_3GGEWICHTGross weight of itemBRGEW_APMENG15
J_3GGEWEIWeight UnitGEWEIMEINS
J_3GPAKKENNSettlement Package IndicatorJ_3GPAKKENNX
CHARGEBatch NumberCHARG_DCHARG
J_3GPKOKRSControlling AreaKOKRSCACCD
J_3GPKOSTLCost CenterKOSTLKOSTL
J_3GRESTYPResource IndicatorJ_3GRESTYPJ_3GRESTYP
J_3GLVART_WLActivity Type for RedeliveryJ_3GLVART_WLJ_3GLVART
J_3GBFARTInventory Management TypeJ_3GBFARTJ_3GBFART
/SAPCEM/BDNUMNumber of Requisition Note/SAPCEM/BDNUM/SAPCEM/BDNUM
/SAPCEM/BDPOSRequisition Note Item/SAPCEM/BDPOS/SAPCEM/BDPOS
/SAPCEM/FRISTDATEnd of Deadline/SAPCEM/FRISTDATDATUM
J_3GEMP_CHARGEBatch NumberCHARG_DCHARG
RSNUMNumber of reservation/dependent requirementsRSNUMRSNUM
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSRSPOS
J_3GABSNPLNRNetwork Number for Account AssignmentNPLNRAUFNR
J_3GABSVORNROperation/Activity NumberVORNRVORNR
J_3GEMPNPLNRNetwork Number for Account AssignmentNPLNRAUFNR
J_3GEMPVORNROperation/Activity NumberVORNRVORNR
RUECKCompletion confirmation number for the operationCO_RUECKCO_RUECK
RMZHLConfirmation counterCO_RMZHLCIM_COUNT
/SAPCEM/BDENDURequirement End: Time/SAPCEM/BDENDUT
BEDIDID of the capacity requirements recordBEDIDBEDID
BEDZLInternal counterCIM_COUNTCIM_COUNT
CANUMCounters for cap. rqmts. records (various caps. + indiv.capsCY_COUNTCY_COUNT
/SAPCEM/AUFNROrder NumberAUFNRAUFNR
/SAPCEM/VORNROperation/Activity NumberVORNRVORNR
/SAPCEM/UVORNSuboperationUVORNVORNR

J_3GBELP related tables

TableNote
CRMC_FICA_AR_ITMItem Categories (Adjustment Request Item - FI-CA Document)
KBLEDocument Item Processing: Manual Document Entry
KBLPDocument Item: Manual Document Entry
T161PCheck of Document Type, Document Category, Item Category
TPMT_DEDOC_LOTPODerivatives Document: Document Item Per Lot
TPMT_DEDOC_POSDerivatives Document: Document Item
WBRFNDocument Flow of Reference Document to Agency Document
J_3GBELPDocument Data - Item Data
CACS_DOCFI_TData Transfer: FI Document (Tax Item)
DFKKKOHeader Data in Open Item Accounting Document
EKPVShipping Data For Stock Transfer of Purchasing Document Item
EWAELOCSDAllocation Table: Container Loc.Data <-> Sales Document Item
FKK_JFRP_SHORTItem Data for IS-M/SD Billing Document - Extracts
FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts
JFRPIS-M/SD: Billing Document - Item Data
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com