J_3GBELP

Document Data - Item Data | #itemdata | Component: Construction Equipment Management
Column Name Description
MANDT FK Client
J_3GBELNRI FK Document Number
J_3GPOSNRI Document Item
J_3GUPOSNR Sub-Item Number
Column Name Description
💲 Currency Flat Rate Amount (Internal) - Sender (J_3GWAERS1):
J_3GBETR1 Internal Flat Rate - Sender
💲 Currency Flat Rate Amount (External) - Sender (J_3GWAERS2):
J_3GBETR2 External Flat Rate - Sender
💲 Currency Flat Rate Amount (Internal) - Recipient (J_3GWAERS3):
J_3GBETR3 Internal Flat Rate - Recipient
💲 Currency Flat Rate Amount (External) - Recipient (J_3GWAERS4):
J_3GBETR4 External Flat Rate - Recipient
💲 User field: Unit for value fields (USE06):
USR06 User-defined field for values (length 10,3)
💲 User field: Unit for value fields (USE07):
USR07 User-defined field for values (length 10,3)
Column Name Description
📏 Unit of measure (J_3GMEINS):
J_3GMENGE Quantity
📏 Unit of measure (J_3GMEINS2):
J_3GMENGE2 Quantity
📏 User field: Unit for quantity fields (USE04):
USR04 User field for quantity (length 10.3)
📏 User field: Unit for quantity fields (USE05):
USR05 User field for quantity (length 10.3)
📏 Weight Unit (J_3GGEWEI):
J_3GGEWICHT Gross Weight of the Item
Column Name Description
ERZET Entry time
ERDAT Date on which the record was created
AEZET Time last change was made
AEDTM Last Changed On
J_3GEINEND End of Usage Period
J_3GDATLAB Date of Activity Output
J_3GIDATE Date of the Measurement
J_3GITIME Time of Measurement
USR08 User field for date
USR09 User field for date
/SAPCEM/FRISTDAT End of Deadline
/SAPCEM/BDENDU Requirement End: Time
Column Name Description
J_3GABSREF Reference Type Sender Show values
J_3GEMPREF Receiving Reference Type Show values
J_3GMITREF Reference Type - Intermediate Recipient Show values
J_3GFREMDP Indicator for External Employees Show values
J_3GBELSTA Internal Document Status Show values
J_3GPIABS Document Flat Rate Indicator (Internal) - Sender Show values
J_3GPEABS Document Flat Rate Indicator (External) - Sender Show values
J_3GPIEMPF Document Flat Rate Indicator (Internal) - Recipient Show values
J_3GPEEMPS Document Flat Rate Indicator (External) - Recipient Show values
J_3GFAKTAB Billing Indicator - Sender Show values
J_3GFAKTEM Billing Indicator - Recipient Show values
J_3GDOMLMB Pricing Dominancy (Provider/Intermediate Recipient/Debtor) Show values
J_3GDOMMB Pricing Dominancy (Intermediate Recipient/Debtor) Show values
J_3GKZLATR Activity Type Separation Show values
J_3GKZMENG Item/Multipart Indicator Show values
J_3GGENSTA Generation Status Show values
J_3GKZFRIS Usage Period Indicator Show values
J_3GKZLADI Indicator: Internal Loading Costs Show values
J_3GKZLADE Indicator: External (Un)Loading Costs Show values
J_3GKZBERG Indicator for Provision Fees Show values
J_3GKZSPIL Indicator: Special Price for Internal Provider of Service Show values
J_3GKZSPEL Indicator: Special Price for External Provider of Service Show values
J_3GKZSPIB Indicator: Special Price for Internal Recipient of Service Show values
J_3GKZSPEB Indicator: Special Price for External Recipient of Service Show values
J_3GKZLVOI Indicator: Calculate Internal PBE as TBE Show values
J_3GKZLVOE Indicator: Calculate external PBE as TBE Show values
J_3GBELSTE External Document Status Show values
USR10 User-defined field: Indicator for reports Show values
USR11 User-defined field: Indicator for reports Show values
JV_OCO JV original cost object Show values
J_3GPAKKENN Settlement Package Indicator Show values
J_3GRESTYP Resource Indicator Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
UNAME Name of Person Who Changed Object USNAM
J_3GMITTLE Intermediate Recipient KUNNR
NACHN Last Name NACHN
LFDNR Sequence Number NUMC4
J_3GBELNR External Document Number J_3GBELNR
J_3GPOSNR Document Item J_3GPOSNR
J_3GVBELNE Number of External Billing Document VBELN
J_3GIMPT1 Actual Value of Measuring Point IMRC_POINT
J_3GIMPT2 Calculated Value of Measuring Point IMRC_POINT
J_3GMPOBJ Object Number for the Measuring Point Object J_OBJNR
J_3GMPBEG1 Actual Start of Measuring Point NUM10
J_3GMPEND1 Actual End of Measuring Point NUMC10
J_3GCDIFF Counter Reading Difference NUMC10
J_3GMDOCM1 Measurement Document IMRC_MDOCM
J_3GMDOCM2 Measurement Document IMRC_MDOCM
USR00 User field with 20 characters USRCHAR20
USR01 User field with 20 characters USRCHAR20
USR02 User Field with 10 Characters USRCHAR10
USR03 User Field with 10 Characters USRCHAR10
JV_OTYPE Joint Venture Object Type JV_OTYPE
DUMMY_AFVU_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
SPARAMETER1 Scheduling Parameters for External Scheduling
SPARAMETER2 Scheduling Parameters for External Scheduling
SPARAMETER3 Scheduling Parameters for External Scheduling
ILART_OP Maintenance activity type ILART
J_3GVVCOM1 Comment CHAR40
J_3GVVCOM2 Comment CHAR40
J_3GLVART_WL Activity Type for Redelivery J_3GLVART
J_3GBFART Inventory Management Type J_3GBFART
/SAPCEM/BDPOS Requisition Note Item /SAPCEM/BDPOS
J_3GEMP_CHARGE Batch Number CHARG
RSNUM Number of reservation/dependent requirements RSNUM
RSPOS Item Number of Reservation / Dependent Requirements RSPOS
J_3GABSVORNR Operation/Activity Number VORNR
J_3GEMPVORNR Operation/Activity Number VORNR
RUECK Completion confirmation number for the operation CO_RUECK
RMZHL Confirmation counter CIM_COUNT
BEDID ID of the Capacity Requirements Record BEDID
BEDZL Internal counter CIM_COUNT
CANUM Counters for cap. rqmts. records (various caps. + indiv.caps CY_COUNT
/SAPCEM/AUFNR Order Number AUFNR
/SAPCEM/VORNR Operation/Activity Number VORNR
/SAPCEM/UVORN Suboperation VORNR
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • J_3GBELP.MATNR == MCH1.MATNR
  • J_3GBELP.MANDT == MCH1.MANDT
  • J_3GBELP.CHARGE == MCH1.CHARG
Equipment Number
  • Equipment Number
  • Client
  • J_3GBELP.EQUNR == EQUI.EQUNR
  • J_3GBELP.MANDT == EQUI.MANDT
Equipment Number
  • Equipment Number
  • Client
  • J_3GBELP.EQUNR2 == EQUI.EQUNR
  • J_3GBELP.MANDT == EQUI.MANDT
Equity type
  • Joint venture
  • ?
  • ?
  • Equity type
  • J_3GBELP.MANDT == T8JG.MANDT
  • J_3GBELP.VNAME == T8JG.VNAME
  • J_3GBELP.[column in domain "FDATE"] == T8JG.FDATE
  • J_3GBELP.[column in domain "BUKRS"] == T8JG.BUKRS
  • J_3GBELP.ETYPE == T8JG.ETYPE
Regulatory indicator
  • Regulatory indicator
  • Client
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • ?
  • J_3GBELP.JV_JIBCL == T8J6A.CLASS
  • J_3GBELP.MANDT == T8J6A.MANDT
  • J_3GBELP.[column in domain "BUKRS"] == T8J6A.BUKRS
JIB/JIBE Subclass A
  • ?
  • JIB/JIBE Subclass A
  • JIB/JIBE Class
  • J_3GBELP.MANDT == T8J6C.MANDT
  • J_3GBELP.[column in domain "BUKRS"] == T8J6C.BUKRS
  • J_3GBELP.JV_JIBSA == T8J6C.SUBCLASS
  • J_3GBELP.JV_JIBCL == T8J6C.CLASS
Sender of CO Order
  • Sender of CO Order
  • Client
  • J_3GBELP.J_3GABSACO == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Sender of PM Order
  • Sender of PM Order
  • Client
  • J_3GBELP.J_3GABSAPM == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Debtor of Sender
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GABSDEB == KNA1.KUNNR
Sender
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GABSEND == KNA1.KUNNR
External Ship-to Party - Sender
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GABSEXT == KNA1.KUNNR
Controlling Area Sender
  • J_3GBELP.MANDT == TKA01.MANDT
  • J_3GBELP.J_3GABSKOK == TKA01.KOKRS
Cost Center Sender
  • ?
  • Cost Center Sender
  • Controlling Area Sender
  • J_3GBELP.MANDT == CSKS.MANDT
  • J_3GBELP.[column in domain "DATBI"] == CSKS.DATBI
  • J_3GBELP.J_3GABSKOS == CSKS.KOSTL
  • J_3GBELP.J_3GABSKOK == CSKS.KOKRS
Storage Location/Warehouse Sender
  • Storage Location/Warehouse Sender
  • Client
  • Plant Sender
  • J_3GBELP.J_3GABSLAG == T001L.LGORT
  • J_3GBELP.MANDT == T001L.MANDT
  • J_3GBELP.J_3GABSWRK == T001L.WERKS
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • J_3GBELP.J_3GABSNPLNR == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Project Number Sender
  • J_3GBELP.MANDT == PROJ.MANDT
  • J_3GBELP.J_3GABSPRO == PROJ.PSPNR
Plant Sender
  • J_3GBELP.MANDT == T001W.MANDT
  • J_3GBELP.J_3GABSWRK == T001W.WERKS
Inventory Management - Recipient
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GBESTEM == KNA1.KUNNR
CO Order Recipient
  • CO Order Recipient
  • Client
  • J_3GBELP.J_3GEMPACO == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
PM Order Recipient
  • PM Order Recipient
  • Client
  • J_3GBELP.J_3GEMPAPM == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Debtor of Recipient
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GEMPDEB == KNA1.KUNNR
External Ship-To Party - Recipient
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GEMPEXT == KNA1.KUNNR
Recipient
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GEMPFAE == KNA1.KUNNR
Receiving Controlling Area
  • J_3GBELP.MANDT == TKA01.MANDT
  • J_3GBELP.J_3GEMPKOK == TKA01.KOKRS
Receiving Cost Center
  • ?
  • Receiving Cost Center
  • Receiving Controlling Area
  • J_3GBELP.MANDT == CSKS.MANDT
  • J_3GBELP.[column in domain "DATBI"] == CSKS.DATBI
  • J_3GBELP.J_3GEMPKOS == CSKS.KOSTL
  • J_3GBELP.J_3GEMPKOK == CSKS.KOKRS
Receiving Storage Location
  • Receiving Storage Location
  • Client
  • Receiving Plant
  • J_3GBELP.J_3GEMPLAG == T001L.LGORT
  • J_3GBELP.MANDT == T001L.MANDT
  • J_3GBELP.J_3GEMPWRK == T001L.WERKS
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • J_3GBELP.J_3GEMPNPLNR == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Receiving Cost Center for Personnel
  • J_3GBELP.MANDT == KNA1.MANDT
  • J_3GBELP.J_3GEMPPER == KNA1.KUNNR
Receiving Project Number
  • J_3GBELP.MANDT == PROJ.MANDT
  • J_3GBELP.J_3GEMPPRO == PROJ.PSPNR
Receiving Plant
  • J_3GBELP.MANDT == T001W.MANDT
  • J_3GBELP.J_3GEMPWRK == T001W.WERKS
Internal Indicator for Transaction Type
  • Internal Indicator for Transaction Type
  • Client
  • Sequence Number
Number in Catalog
  • Number in Catalog
  • Client
  • Catalog Code
Sequence Number
  • Internal Indicator for Transaction Type
  • Client
  • Sequence Number
Activity Type
  • Activity Type
  • Client
Unit of measure
  • J_3GBELP.MANDT == T006.MANDT
  • J_3GBELP.J_3GMEINS == T006.MSEHI
Unit of measure
  • J_3GBELP.MANDT == T006.MANDT
  • J_3GBELP.J_3GMEINS2 == T006.MSEHI
CO Order - Intermediate Recipient
  • CO Order - Intermediate Recipient
  • Client
  • J_3GBELP.J_3GMITACO == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
PM Order Recipient
  • PM Order Recipient
  • Client
  • J_3GBELP.J_3GMITAPM == AUFK.AUFNR
  • J_3GBELP.MANDT == AUFK.MANDT
Controlling Area - Intermediate Recipient
  • J_3GBELP.MANDT == TKA01.MANDT
  • J_3GBELP.J_3GMITKOK == TKA01.KOKRS
Cost Center - Intermediate Recipient
  • ?
  • Cost Center - Intermediate Recipient
  • Controlling Area - Intermediate Recipient
  • J_3GBELP.MANDT == CSKS.MANDT
  • J_3GBELP.[column in domain "DATBI"] == CSKS.DATBI
  • J_3GBELP.J_3GMITKOS == CSKS.KOSTL
  • J_3GBELP.J_3GMITKOK == CSKS.KOKRS
Storage Location - Intermediate Recipient
  • Storage Location - Intermediate Recipient
  • Client
  • Plant - Intermediate Recipient
  • J_3GBELP.J_3GMITLAG == T001L.LGORT
  • J_3GBELP.MANDT == T001L.MANDT
  • J_3GBELP.J_3GMITWRK == T001L.WERKS
Project Number - Intermediate Recipient
  • J_3GBELP.MANDT == PROJ.MANDT
  • J_3GBELP.J_3GMITPRO == PROJ.PSPNR
Plant - Intermediate Recipient
  • J_3GBELP.MANDT == T001W.MANDT
  • J_3GBELP.J_3GMITWRK == T001W.WERKS
Controlling Area
  • J_3GBELP.MANDT == TKA01.MANDT
  • J_3GBELP.J_3GPKOKRS == TKA01.KOKRS
Cost Center
  • Date on which the record was created
  • Cost Center
  • Controlling Area
  • J_3GBELP.MANDT == CSKS.MANDT
  • J_3GBELP.ERDAT == CSKS.DATBI
  • J_3GBELP.J_3GPKOSTL == CSKS.KOSTL
  • J_3GBELP.J_3GPKOKRS == CSKS.KOKRS
Catalog Code
Redirection Settlement Type - External
  • Redirection Settlement Type - External
  • Client
Redirection Settlement Type - Internal
  • Redirection Settlement Type - Internal
  • Client
Currency Flat Rate Amount (Internal) - Sender
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.J_3GWAERS1 == TCURC.WAERS
Currency Flat Rate Amount (External) - Sender
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.J_3GWAERS2 == TCURC.WAERS
Currency Flat Rate Amount (Internal) - Recipient
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.J_3GWAERS3 == TCURC.WAERS
Currency Flat Rate Amount (External) - Recipient
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.J_3GWAERS4 == TCURC.WAERS
Client J_3GBELP.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_3GBELP.MATNR == MARA.MATNR
  • J_3GBELP.MANDT == MARA.MANDT
Recovery Indicator
  • ?
  • Recovery Indicator
  • J_3GBELP.MANDT == T8JJ.MANDT
  • J_3GBELP.[column in domain "BUKRS"] == T8JJ.BUKRS
  • J_3GBELP.RECID == T8JJ.RECID
Key word ID for user-defined fields
  • J_3GBELP.MANDT == TCN00.MANDT
  • J_3GBELP.SLWID == TCN00.SLWID
User field: Unit for quantity fields
  • J_3GBELP.MANDT == T006.MANDT
  • J_3GBELP.USE04 == T006.MSEHI
User field: Unit for quantity fields
  • J_3GBELP.MANDT == T006.MANDT
  • J_3GBELP.USE05 == T006.MSEHI
User field: Unit for value fields
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.USE06 == TCURC.WAERS
User field: Unit for value fields
  • J_3GBELP.MANDT == TCURC.MANDT
  • J_3GBELP.USE07 == TCURC.WAERS
Joint venture
  • ?
  • Joint venture
  • Client
  • J_3GBELP.[column in domain "BUKRS"] == T8JV.BUKRS
  • J_3GBELP.VNAME == T8JV.VNAME
  • J_3GBELP.MANDT == T8JV.MANDT