J_3GBELK

Document File - Header Data | #header | Component: Construction Equipment Management
Column Name Description
MANDT FK Client
J_3GBELNRI Document 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
📏 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 (GEWEI):
GSGEW Total Weight
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_3GBELDAT CEM Document Date
USR08 User field for date
USR09 User field for date
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_3GBLTYP CEM Document Category Show values
J_3GBEWEG Internal Indicator for Transaction Type 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
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
UNAME Name of Person Who Changed Object USNAM
NACHN Last Name NACHN
LFDNR Sequence Number NUMC4
J_3GBELNR External Document Number J_3GBELNR
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_3GABS_BUKRS Company Code BUKRS
J_3GABS_GSBER Business Area GSBER
MBLNR Number of Material Document BELNR
MJAHR Material Document Year GJAHR
J_3GEMP_BUKRS Company Code BUKRS
J_3GEMP_GSBER Business Area GSBER
J_3GABSNPLNR Network Number for Account Assignment AUFNR
J_3GABSVORNR Operation/Activity Number VORNR
J_3GEMPNPLNR Network Number for Account Assignment AUFNR
J_3GEMPVORNR Operation/Activity Number VORNR
Master Data Relations Join Conditions
Equipment Number
  • Equipment Number
  • Client
  • J_3GBELK.EQUNR == EQUI.EQUNR
  • J_3GBELK.MANDT == EQUI.MANDT
Equity type
  • Joint venture
  • ?
  • ?
  • Equity type
  • J_3GBELK.MANDT == T8JG.MANDT
  • J_3GBELK.VNAME == T8JG.VNAME
  • J_3GBELK.[column in domain "FDATE"] == T8JG.FDATE
  • J_3GBELK.[column in domain "BUKRS"] == T8JG.BUKRS
  • J_3GBELK.ETYPE == T8JG.ETYPE
Regulatory indicator
  • Regulatory indicator
  • Client
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • J_3GBELK.INCO1 == TINC.INCO1
  • J_3GBELK.MANDT == TINC.MANDT
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • ?
  • J_3GBELK.JV_JIBCL == T8J6A.CLASS
  • J_3GBELK.MANDT == T8J6A.MANDT
  • J_3GBELK.[column in domain "BUKRS"] == T8J6A.BUKRS
JIB/JIBE Subclass A
  • ?
  • JIB/JIBE Subclass A
  • JIB/JIBE Class
  • J_3GBELK.MANDT == T8J6C.MANDT
  • J_3GBELK.[column in domain "BUKRS"] == T8J6C.BUKRS
  • J_3GBELK.JV_JIBSA == T8J6C.SUBCLASS
  • J_3GBELK.JV_JIBCL == T8J6C.CLASS
Sender of CO Order
  • Sender of CO Order
  • Client
  • J_3GBELK.J_3GABSACO == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
Sender of PM Order
  • Sender of PM Order
  • Client
  • J_3GBELK.J_3GABSAPM == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
Debtor of Sender
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GABSDEB == KNA1.KUNNR
Sender
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GABSEND == KNA1.KUNNR
External Ship-to Party - Sender
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GABSEXT == KNA1.KUNNR
Controlling Area Sender
  • J_3GBELK.MANDT == TKA01.MANDT
  • J_3GBELK.J_3GABSKOK == TKA01.KOKRS
Cost Center Sender
  • CEM Document Date
  • Cost Center Sender
  • Controlling Area Sender
  • J_3GBELK.MANDT == CSKS.MANDT
  • J_3GBELK.J_3GBELDAT == CSKS.DATBI
  • J_3GBELK.J_3GABSKOS == CSKS.KOSTL
  • J_3GBELK.J_3GABSKOK == CSKS.KOKRS
Storage Location/Warehouse Sender
  • Storage Location/Warehouse Sender
  • Client
  • Plant Sender
  • J_3GBELK.J_3GABSLAG == T001L.LGORT
  • J_3GBELK.MANDT == T001L.MANDT
  • J_3GBELK.J_3GABSWRK == T001L.WERKS
Project Number Sender
  • J_3GBELK.MANDT == PROJ.MANDT
  • J_3GBELK.J_3GABSPRO == PROJ.PSPNR
Plant Sender
  • J_3GBELK.MANDT == T001W.MANDT
  • J_3GBELK.J_3GABSWRK == T001W.WERKS
Document Type
CO Order Recipient
  • CO Order Recipient
  • Client
  • J_3GBELK.J_3GEMPACO == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
PM Order Recipient
  • PM Order Recipient
  • Client
  • J_3GBELK.J_3GEMPAPM == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
Debtor of Recipient
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GEMPDEB == KNA1.KUNNR
External Ship-To Party - Recipient
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GEMPEXT == KNA1.KUNNR
Recipient
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GEMPFAE == KNA1.KUNNR
Receiving Controlling Area
  • J_3GBELK.MANDT == TKA01.MANDT
  • J_3GBELK.J_3GEMPKOK == TKA01.KOKRS
Receiving Cost Center
  • ?
  • Receiving Cost Center
  • Receiving Controlling Area
  • J_3GBELK.MANDT == CSKS.MANDT
  • J_3GBELK.[column in domain "DATBI"] == CSKS.DATBI
  • J_3GBELK.J_3GEMPKOS == CSKS.KOSTL
  • J_3GBELK.J_3GEMPKOK == CSKS.KOKRS
Receiving Storage Location
  • Receiving Storage Location
  • Client
  • Receiving Plant
  • J_3GBELK.J_3GEMPLAG == T001L.LGORT
  • J_3GBELK.MANDT == T001L.MANDT
  • J_3GBELK.J_3GEMPWRK == T001L.WERKS
Receiving Cost Center for Personnel
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GEMPPER == KNA1.KUNNR
Receiving Project Number
  • J_3GBELK.MANDT == PROJ.MANDT
  • J_3GBELK.J_3GEMPPRO == PROJ.PSPNR
Receiving Plant
  • J_3GBELK.MANDT == T001W.MANDT
  • J_3GBELK.J_3GEMPWRK == T001W.WERKS
Number in Catalog
  • Number in Catalog
  • Client
  • Catalog Code
CO Order - Intermediate Recipient
  • CO Order - Intermediate Recipient
  • Client
  • J_3GBELK.J_3GMITACO == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
PM Order Recipient
  • PM Order Recipient
  • Client
  • J_3GBELK.J_3GMITAPM == AUFK.AUFNR
  • J_3GBELK.MANDT == AUFK.MANDT
Controlling Area - Intermediate Recipient
  • J_3GBELK.MANDT == TKA01.MANDT
  • J_3GBELK.J_3GMITKOK == TKA01.KOKRS
Cost Center - Intermediate Recipient
  • ?
  • Cost Center - Intermediate Recipient
  • Controlling Area - Intermediate Recipient
  • J_3GBELK.MANDT == CSKS.MANDT
  • J_3GBELK.[column in domain "DATBI"] == CSKS.DATBI
  • J_3GBELK.J_3GMITKOS == CSKS.KOSTL
  • J_3GBELK.J_3GMITKOK == CSKS.KOKRS
Storage Location - Intermediate Recipient
  • Storage Location - Intermediate Recipient
  • Client
  • Plant - Intermediate Recipient
  • J_3GBELK.J_3GMITLAG == T001L.LGORT
  • J_3GBELK.MANDT == T001L.MANDT
  • J_3GBELK.J_3GMITWRK == T001L.WERKS
Project Number - Intermediate Recipient
  • J_3GBELK.MANDT == PROJ.MANDT
  • J_3GBELK.J_3GMITPRO == PROJ.PSPNR
Intermediate Recipient
  • J_3GBELK.MANDT == KNA1.MANDT
  • J_3GBELK.J_3GMITTLE == KNA1.KUNNR
Plant - Intermediate Recipient
  • J_3GBELK.MANDT == T001W.MANDT
  • J_3GBELK.J_3GMITWRK == T001W.WERKS
Catalog Code
Currency Flat Rate Amount (Internal) - Sender
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.J_3GWAERS1 == TCURC.WAERS
Currency Flat Rate Amount (External) - Sender
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.J_3GWAERS2 == TCURC.WAERS
Currency Flat Rate Amount (Internal) - Recipient
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.J_3GWAERS3 == TCURC.WAERS
Currency Flat Rate Amount (External) - Recipient
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.J_3GWAERS4 == TCURC.WAERS
Client J_3GBELK.MANDT == T000.MANDT
Recovery Indicator
  • ?
  • Recovery Indicator
  • J_3GBELK.MANDT == T8JJ.MANDT
  • J_3GBELK.[column in domain "BUKRS"] == T8JJ.BUKRS
  • J_3GBELK.RECID == T8JJ.RECID
Key word ID for user-defined fields
  • J_3GBELK.MANDT == TCN00.MANDT
  • J_3GBELK.SLWID == TCN00.SLWID
Division, but Obsolete
  • J_3GBELK.MANDT == TSPA.MANDT
  • J_3GBELK.SPART == TSPA.SPART
User field: Unit for quantity fields
  • J_3GBELK.MANDT == T006.MANDT
  • J_3GBELK.USE04 == T006.MSEHI
User field: Unit for quantity fields
  • J_3GBELK.MANDT == T006.MANDT
  • J_3GBELK.USE05 == T006.MSEHI
User field: Unit for value fields
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.USE06 == TCURC.WAERS
User field: Unit for value fields
  • J_3GBELK.MANDT == TCURC.MANDT
  • J_3GBELK.USE07 == TCURC.WAERS
Sales Organization, but Obsolete
  • J_3GBELK.MANDT == TVKO.MANDT
  • J_3GBELK.VKORG == TVKO.VKORG
Joint venture
  • ?
  • Joint venture
  • Client
  • J_3GBELK.[column in domain "BUKRS"] == T8JV.BUKRS
  • J_3GBELK.VNAME == T8JV.VNAME
  • J_3GBELK.MANDT == T8JV.MANDT
Distribution Channel, but Obsolete
  • Distribution Channel, but Obsolete
  • Client
  • J_3GBELK.VTWEG == TVTW.VTWEG
  • J_3GBELK.MANDT == TVTW.MANDT