SAP TABLES | Industry Solution Engineering & Construction | Construction Equipment Management(IS-EC-CEM) SAP IS

J_3GBELP SAP Document Data - Item Data Table and data







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

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP J_3GBELP Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP J_3GBELP Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
J_3GBELNRIJ_3GBELNRICHAR10 J_3GBELKDocument NumberALPHA
J_3GPOSNRIJ_3GBELPOSNUMC5 Document Item
J_3GUPOSNRJ_3GUPOSNRNUMC2 Sub-Item Number
.INCLUDEJ_3GBELEGV Administrative Data for CEM Documents
ERNAMERNAMCHAR12 Name of Person who Created the Object
ERZETERZETTIMS6 Entry time
ERDATERDATDATS8 Date on Which Record Was Created
UNAMEAENAMCHAR12 Name of Person Who Changed Object
AEZETAEZETTIMS6 Time last change was made
AEDTMAEDATDATS8 Changed On
J_3GABSENDJ_3GABSENDCHAR10 KNA1SenderALPHA
J_3GABSREFJ_3GABSREFCHAR2 Reference Type Sender
J_3GABSPSPJ_3GABSPSPNUMC8 PRPSWBS Element SenderABPSP
J_3GABSPROJ_3GABSPRONUMC8 PROJProject Number SenderKONPD
J_3GABSKOSJ_3GABSKOSCHAR10 CSKSCost Center SenderALPHA
J_3GABSKOKJ_3GABSKOKCHAR4 TKA01Controlling Area Sender
J_3GABSACOJ_3GABSACOCHAR12 AUFKSender of CO OrderALPHA
J_3GABSAPMJ_3GABSAPMCHAR12 AUFKSender of PM OrderALPHA
J_3GABSWRKJ_3GABSWRKCHAR4 T001WPlant Sender
J_3GABSLAGJ_3GABSLAGCHAR4 T001LStorage Location/Warehouse Sender
J_3GABSEXTJ_3GABSEXTCHAR10 KNA1External Ship-to Party - SenderALPHA
J_3GABSDEBJ_3GABSDEBCHAR10 KNA1Debtor of SenderALPHA
J_3GEMPFAEJ_3GEMPFAECHAR10 KNA1RecipientALPHA
.INCLUDEJ_3GBELEGA General Data Fields for Document Header and Items
J_3GEMPREFJ_3GEMPREFCHAR2 Receiving Reference Type
J_3GEMPPSPJ_3GEMPPSPNUMC8 PRPSReceiving WBS ElementABPSP
J_3GEMPPROJ_3GEMPPRONUMC8 PROJReceiving Project NumberKONPD
J_3GEMPKOSJ_3GEMPKOSCHAR10 CSKSReceiving Cost CenterALPHA
J_3GEMPKOKJ_3GEMPKOKCHAR4 TKA01Receiving Controlling Area
J_3GEMPACOJ_3GEMPACOCHAR12 AUFKCO Order RecipientALPHA
J_3GEMPAPMJ_3GEMPAPMCHAR12 AUFKPM Order RecipientALPHA
J_3GEMPWRKJ_3GEMPWRKCHAR4 T001WReceiving Plant
J_3GEMPLAGJ_3GEMPLAGCHAR4 T001LReceiving Storage Location
J_3GEMPEXTJ_3GEMPEXTCHAR10 KNA1External Ship-To Party - RecipientALPHA
J_3GEMPDEBJ_3GEMPDEBCHAR10 KNA1Debtor of RecipientALPHA
J_3GMITTLEJ_3GMITTLECHAR10
*
Intermediate RecipientALPHA
J_3GMITREFJ_3GMITREFCHAR2 Reference Type - Intermediate Recipient
J_3GMITPSPJ_3GMITPSPNUMC8 PRPSWBS Element - Intermediate RecipientABPSP


J_3GMITPROJ_3GMITPRONUMC8 PROJProject Number - Intermediate RecipientKONPD
J_3GMITKOSJ_3GMITKOSCHAR10 CSKSCost Center - Intermediate RecipientALPHA
J_3GMITKOKJ_3GMITKOKCHAR4 TKA01Controlling Area - Intermediate Recipient
J_3GMITACOJ_3GMITACOCHAR12 AUFKCO Order - Intermediate RecipientALPHA
J_3GMITAPMJ_3GMITAPMCHAR12 AUFKPM Order RecipientALPHA
J_3GMITWRKJ_3GMITWRKCHAR4 T001WPlant - Intermediate Recipient
J_3GMITLAGJ_3GMITLAGCHAR4 T001LStorage Location - Intermediate Recipient
J_3GFREMDPJ_3GFREMDPCHAR1 Indicator for External Employees
PERNRJ_3GPERNRNUMC8
*
Personal Number
NACHNNACHNCHAR25 Last Name
J_3GEMPPERJ_3GEMPPERCHAR10 KNA1Receiving Cost Center for PersonnelALPHA
J_3GBELSTAJ_3GBELSTACHAR1 Internal Document Status
J_3GPIABSJ_3GPIABSCHAR1 Document Flat Rate Indicator (Internal) - Sender
J_3GPEABSJ_3GPEABSCHAR1 Document Flat Rate Indicator (External) - Sender
J_3GPIEMPFJ_3GPIEMPSCHAR1 Document Flat Rate Indicator (Internal) - Recipient
J_3GPEEMPSJ_3GPEEMPSCHAR1 Document Flat Rate Indicator (External) - Recipient
J_3GBETR1J_3GBETR1CURR15(2) Internal Flat Rate - Sender
J_3GBETR2J_3GBETR2CURR15(2) External Flat Rate - Sender
J_3GBETR3J_3GBETR3CURR15(2) Internal Flat Rate - Recipient
J_3GBETR4J_3GBETR4CURR15(2) External Flat Rate - Recipient
J_3GWAERS1J_3GWAERS1CUKY5 TCURCCurrency Flat Rate Amount (Internal) - Sender
J_3GWAERS2J_3GWAERS2CUKY5 TCURCCurrency Flat Rate Amount (External) - Sender
J_3GWAERS3J_3GWAERS3CUKY5 TCURCCurrency Flat Rate Amount (Internal) - Recipient
J_3GWAERS4J_3GWAERS4CUKY5 TCURCCurrency Flat Rate Amount (External) - Recipient
J_3GFAKTABJ_3GFAKTABCHAR1 Billing Indicator - Sender
J_3GFAKTEMJ_3GFAKTEMCHAR1 Billing Indicator - Recipient
EQUNREQUNRCHAR18 EQUIEquipment NumberALPHA
J_3GTPLKZJ_3GTPLKZCHAR5 J_3GT370SCatalog Code
J_3GKATNRCJ_3GKATNRCCHAR30 J_3GKATALNumber in Catalog
LFDNRJ_3GLFDNR4NUMC4 Sequence Number
J_3GDOMLMBJ_3GDOMLMBCHAR1 Pricing Dominancy (Provider/Intermediate Recipient/Debtor)
J_3GDOMMBJ_3GDOMMBCHAR1 Pricing Dominancy (Intermediate Recipient/Debtor)
J_3GBELNRJ_3GBELNRCHAR10 External Document NumberALPHA
J_3GPOSNRJ_3GBELPOSNUMC5
*
Document Item
J_3GGRUNDJ_3GBEWEGCHAR1 J_3GZUABGRInternal Indicator for Transaction Type
J_3GLFDNRJ_3GLFDNR2NUMC2 J_3GZUABGRSequence Number
J_3GLVARTJ_3GLVARTCHAR4 J_3GLEIARTActivity Type
J_3GMENGEJ_3GMENGEQUAN13(3) Quantity
J_3GMEINSMEINAUNIT3 T006Unit of measureCUNIT


J_3GMENGE2J_3GMENGEQUAN13(3) Quantity
J_3GMEINS2MEINAUNIT3 T006Unit of measureCUNIT
J_3GKZLATRJ_3GKZLATRCHAR1 Activity Type Separation
J_3GVBELNEJ_3GVBELNECHAR10 VBUKNumber of External Billing DocumentALPHA
EQUNR2EQUNRCHAR18 EQUIEquipment NumberALPHA
J_3GKZMENGJ_3GKZMENGCHAR1 Item/Multipart Indicator
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
J_3GGENSTAJ_3GGENSTACHAR1 Generation Status
J_3GKZFRISJ_3GKZFRISCHAR1 Usage Period Indicator
J_3GEINENDJ_3GEINENDDATS8 End of Usage Period
J_3GDATLABJ_3GDATLABDATS8 Date of Activity Output
J_3GKZLADIJ_3GKZLADICHAR1 Indicator: Internal Loading Costs
J_3GKZLADEJ_3GKZLADECHAR1 Indicator: External (Un)Loading Costs
J_3GKZBERGJ_3GKZBERGCHAR1 Indicator for Provision Fees
J_3GBESTEMJ_3GBESTEMCHAR10 KNA1Inventory Management - RecipientALPHA
J_3GKZSPILJ_3GKZSPILCHAR1 Indicator: Special Price for Internal Provider of Service
J_3GKZSPELJ_3GKZSPELCHAR1 Indicator: Special Price for External Provider of Service
J_3GKZSPIBJ_3GKZSPIBCHAR1 Indicator: Special Price for Internal Recipient of Service
J_3GKZSPEBJ_3GKZSPEBCHAR1 Indicator: Special Price for External Recipient of Service
J_3GKZLVOIJ_3GKZLVOICHAR1 Indicator: Calculate Internal PBE as TBE
J_3GKZLVOEJ_3GKZLVOECHAR1 Indicator: Calculate external PBE as TBE
J_3GUMVERIJ_3GUMVERICHAR4 J_3GLEIARTRedirection Settlement Type - Internal
J_3GUMVEREJ_3GUMVERECHAR4 J_3GLEIARTRedirection Settlement Type - External
.INCLUDEJ_3GIMPTS Measuring Points Document Entry (Structure)
J_3GIMPT1J_3GIMPT1CHAR12
*
Actual Value of Measuring PointALPHA
J_3GIMPT2J_3GIMPT2CHAR12
*
Calculated Value of Measuring PointALPHA
J_3GMPOBJIMRC_MPOBJCHAR22
*
Object Number for the Measuring Point Object
J_3GMPBEG1J_3GMPBEG1NUMC10 Actual Start of Measuring Point
J_3GMPEND1J_3GMPEND1NUMC10 Actual End of Measuring Point
J_3GCDIFFJ_3GCDIFFNUMC10 Counter Reading Difference
J_3GMDOCM1IMRC_MDOCMCHAR20
*
Measurement DocumentALPHA
J_3GMDOCM2IMRC_MDOCMCHAR20
*
Measurement DocumentALPHA
J_3GIDATEIMRC_IDATEDATS8 Date of the Measurement
J_3GITIMEIMRC_ITIMETIMS6 Time of Measurement
J_3GBELSTEJ_3GBELSTECHAR1 External Document Status
.INCLUDEJ_3GBENUTZ User-Defined Fields
.INCLUDEAFVUI Include structure of the user fields of the operation
SLWIDSLWIDCHAR7 TCN00Key word ID for user-defined fields
USR00USRCHAR20CHAR20 User field with 20 characters

USR01USRCHAR20CHAR20 User field with 20 characters
USR02USRCHAR10CHAR10 User field with 10 characters
USR03USRCHAR10CHAR10 User field with 10 characters
USR04USRQUAN13QUAN13(3) User field for quantity (length 10.3)
USE04USRUNITUNIT3 T006User field: Unit for quantity fieldsCUNIT
USR05USRQUAN13QUAN13(3) User field for quantity (length 10.3)
USE05USRUNITUNIT3 T006User field: Unit for quantity fieldsCUNIT
USR06USRCURR13CURR13(3) User-defined field for values (length 10,3)
USE06USRCUKYCUKY5 TCURCUser field: Unit for value fields
USR07USRCURR13CURR13(3) User-defined field for values (length 10,3)
USE07USRCUKYCUKY5 TCURCUser field: Unit for value fields
USR08USRDATEDATS8 User field for date
USR09USRDATEDATS8 User field for date
USR10USRFLAGCHAR1 User-defined field: Indicator for reports
USR11USRFLAGCHAR1 User-defined field: Indicator for reports
.INCLUDEGJV_DATA_5 JV data: (GJV_DATA_2),jv_oco
.INCLUDEGJV_DATA_2 JV data: (vname,recid,etype),jv_otype,jv_jibcl,jv_jibsa
.INCLUDEGJV_DATA_0 General assignments of application objects
VNAMEJV_NAMECHAR6 T8JVJoint VentureALPHA
RECIDJV_RECINDCHAR2 T8JJRecovery IndicatorALPHA
ETYPEJV_ETYPECHAR3 T8JGEquity typeALPHA
JV_OTYPEJV_OTYPECHAR4 Joint Venture Object TypeALPHA
JV_JIBCLJV_JIBCLCHAR3 T8J6AJIB/JIBE Class
JV_JIBSAJV_JIBSACHAR5 T8J6CJIB/JIBE Subclass A
JV_OCOJV_OR_COCHAR1 JV original cost object
DUMMY_CI_AFVUCHAR1CHAR1 Single-Character Indicator
SPARAMETER1SPARAMETERCHAR4 Scheduling Parameters for External Scheduling
SPARAMETER2SPARAMETERCHAR4 Scheduling Parameters for External Scheduling
SPARAMETER3SPARAMETERCHAR4 Scheduling Parameters for External Scheduling
.APPEND/MRSS/T_APPEND_AFVUI TICM CHANGES
.INCLUDE/MRSS/T_INCLUDE_AFVU TICM CHANGES
/MRSS/ID_PROFILE/MRSS/T_REQU_UPDCHAR1 Requirements Profile Was Changed Manually
/MRSS/PROF_KEY/MRSS/T_RSG_REQUIDCHAR10 Profile KeyALPHA
/MRSS/PROF_GUIDCHAR32CHAR32 Character field, length 32
/MRSS/ACT_TYPE/MRSS/T_ACTIVITY_TYPECHAR1 Process variant
/MRSS/ORDER_PROB/MRSS/T_ORDER_PROBCHAR3 Order probability in percentOPROB
/MRSS/INIT_DONE/MRSS/T_INIT_DONECHAR1 Internal initialization carried out once
/MRSS/DATACHANGE/MRSS/T_USCREENCTL_DATACHANGEDCHAR1 Data was changed in the controls on the user screen
/MRSS/DEM_COUNT/MRSS/T_DEM_COUNTNUMC4 Counter for Demands in Operation
/MRSS/SUPERV_CNT/MRSS/T_RAP_SUPERVISOR_COUNTCHAR2 Number of Site SupervisorsALPHA
/MRSS/RULE_ID/MRSS/T_RSG_TIME_RULE_IDCHAR25 Time Rule Id
/MRSS/SALES_ORGVKORGCHAR4
*
Sales Organization
/MRSS/REFF_RCNT/MRSS/T_REM_EFFORT_RES_COUNTNUMC3 Determination of Remaining Demand: No. of Resources
/MRSS/REFF_E_BEG/MRSS/T_TIMESTAMP_BEGINNUMC14 Time stamp: startTSTLC
/MRSS/REFF_E_END/MRSS/T_TIMESTAMP_ENDNUMC14 Time stamp: endTSTLC
/MRSS/REFF_L_BEG/MRSS/T_TIMESTAMP_BEGINNUMC14 Time stamp: startTSTLC
/MRSS/REFF_L_END/MRSS/T_TIMESTAMP_ENDNUMC14 Time stamp: endTSTLC
/MRSS/RELEVANT/MRSS/T_RELEVANT_FOR_MRSCHAR1 Operation Set as MRS-Relevant
/MRSS/TEAM_PLAN/MRSS/T_RSG_TEAM_PLANNINGCHAR1 Team Planning flag for Demand
/MRSS/SINGL_RES/MRSS/T_RSG_FORCE_SINGLE_RESCHAR1 Indicator for Forcing a Single Resource
/MRSS/TO_BEGDATDATSDATS8 Field of type DATS
/MRSS/TO_BEGTIMTIMSTIMS6 Field of type TIMS
/MRSS/TO_ENDDATDATSDATS8 Field of type DATS
/MRSS/TO_ENDTIMTIMSTIMS6 Field of type TIMS
/MRSS/TO_DURATCHAR10CHAR10 Character Field Length = 10
/MRSS/TO_DUNITMEINSUNIT3
*
Base Unit of MeasureCUNIT
/MRSS/TO_DISTANCHAR19CHAR19 19 Characters
/MRSS/TO_MANUAL/MRSS/T_RSG_BOOLEANCHAR1 Boolean Variable
/MRSS/FR_BEGDATDATSDATS8 Field of type DATS
/MRSS/FR_BEGTIMTIMSTIMS6 Field of type TIMS
/MRSS/FR_ENDDATDATSDATS8 Field of type DATS
/MRSS/FR_ENDTIMTIMSTIMS6 Field of type TIMS
/MRSS/FR_DURATCHAR10CHAR10 Character Field Length = 10
/MRSS/FR_DUNITMEINSUNIT3
*
Base Unit of MeasureCUNIT
/MRSS/FR_DISTANCHAR19CHAR19 19 Characters
/MRSS/FR_MANUAL/MRSS/T_RSG_BOOLEANCHAR1 Boolean Variable
.APPENDAFVUI_OLC AFVUI APPEND for Operation Account Assignment
ILART_OPILACHAR3
*
Maintenance activity type
.APPENDFERC_AFVUI Append structure for Regulatory Reporting
FERC_INDFE_INDCHAR4 FERC_C7Regulatory indicatorALPHA
J_3GVVCOM1J_3GVVCOMCHAR40 Comment
J_3GVVCOM2J_3GVVCOMCHAR40 Comment
J_3GGEWICHTBRGEW_APQUAN15(3) Gross Weight of the Item
J_3GGEWEIGEWEIUNIT3
*
Weight UnitCUNIT
J_3GPAKKENNJ_3GPAKKENNCHAR1 Settlement Package Indicator
CHARGECHARG_DCHAR10 MCH1Batch Number
J_3GPKOKRSKOKRSCHAR4 TKA01Controlling Area
J_3GPKOSTLKOSTLCHAR10 CSKSCost CenterALPHA
J_3GRESTYPJ_3GRESTYPCHAR2 Resource Indicator
J_3GLVART_WLJ_3GLVART_WLCHAR4
*
Activity Type for Redelivery
J_3GBFARTJ_3GBFARTCHAR4
*
Inventory Management Type
/SAPCEM/BDNUM/SAPCEM/BDNUMCHAR10 /SAPCEM/BDKONumber of Requisition NoteALPHA
/SAPCEM/BDPOS/SAPCEM/BDPOSNUMC5 Requisition Note Item
/SAPCEM/FRISTDAT/SAPCEM/FRISTDATDATS8 End of Deadline
J_3GEMP_CHARGECHARG_DCHAR10
*
Batch Number
RSNUMRSNUMNUMC10
*
Number of Reservation/Dependent Requirement
RSPOSRSPOSNUMC4 Item Number of Reservation/Dependent Requirement
J_3GABSNPLNRNPLNRCHAR12 AUFKNetwork Number for Account AssignmentALPHA
J_3GABSVORNRVORNRCHAR4 Operation/Activity NumberNUMCV
J_3GEMPNPLNRNPLNRCHAR12 AUFKNetwork Number for Account AssignmentALPHA
J_3GEMPVORNRVORNRCHAR4 Operation/Activity NumberNUMCV
RUECKCO_RUECKNUMC10 Completion confirmation number for the operation
RMZHLCO_RMZHLNUMC8 Confirmation counter
/SAPCEM/BDENDU/SAPCEM/BDENDUTIMS6 Requirement End: Time
BEDIDBEDIDNUMC12
*
ID of the capacity requirements record
BEDZLCIM_COUNTNUMC8 Internal counter
CANUMCY_COUNTNUMC4
*
Counters for cap. rqmts. records (various caps. + indiv.caps
/SAPCEM/AUFNRAUFNRCHAR12
*
Order NumberALPHA
/SAPCEM/VORNRVORNRCHAR4 Operation/Activity NumberNUMCV
/SAPCEM/UVORNUVORNCHAR4 SuboperationNUMCV



Key field
Non-key field