/SAPCEM/SHSM_J_3GBELK

CDS view for search help J_3GBB | view: /SAPCEM/J_3GBB | Extraction: Not supported | Component: Construction Equipment Management
Tables used: J_3GBELK
Column Name Description
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
  • Client
  • Equipment Number
  • /SAPCEM/SHSM_J_3GBELK.MANDT == EQUI.MANDT
  • /SAPCEM/SHSM_J_3GBELK.EQUNR == EQUI.EQUNR
Equity type
  • Client
  • ?
  • ?
  • Equity type
  • Joint venture
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T8JG.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "FDATE"] == T8JG.FDATE
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "BUKRS"] == T8JG.BUKRS
  • /SAPCEM/SHSM_J_3GBELK.ETYPE == T8JG.ETYPE
  • /SAPCEM/SHSM_J_3GBELK.VNAME == T8JG.VNAME
Regulatory indicator
  • Client
  • Regulatory indicator
  • /SAPCEM/SHSM_J_3GBELK.MANDT == FERC_C7.MANDT
  • /SAPCEM/SHSM_J_3GBELK.FERC_IND == FERC_C7.IND
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TINC.MANDT
  • /SAPCEM/SHSM_J_3GBELK.INCO1 == TINC.INCO1
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • ?
  • /SAPCEM/SHSM_J_3GBELK.JV_JIBCL == T8J6A.CLASS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T8J6A.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "BUKRS"] == T8J6A.BUKRS
JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • ?
  • JIB/JIBE Subclass A
  • /SAPCEM/SHSM_J_3GBELK.JV_JIBCL == T8J6C.CLASS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T8J6C.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "BUKRS"] == T8J6C.BUKRS
  • /SAPCEM/SHSM_J_3GBELK.JV_JIBSA == T8J6C.SUBCLASS
Sender of CO Order
  • Client
  • Sender of CO Order
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSACO == AUFK.AUFNR
Sender of PM Order
  • Client
  • Sender of PM Order
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSAPM == AUFK.AUFNR
Debtor of Sender
  • Client
  • Debtor of Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSDEB == KNA1.KUNNR
Sender
  • Client
  • Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSEND == KNA1.KUNNR
External Ship-to Party - Sender
  • External Ship-to Party - Sender
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSEXT == KNA1.KUNNR
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
Controlling Area Sender
  • Client
  • Controlling Area Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TKA01.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSKOK == TKA01.KOKRS
Cost Center Sender
  • Client
  • Controlling Area Sender
  • Cost Center Sender
  • CEM Document Date
  • /SAPCEM/SHSM_J_3GBELK.MANDT == CSKS.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSKOK == CSKS.KOKRS
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSKOS == CSKS.KOSTL
  • /SAPCEM/SHSM_J_3GBELK.J_3GBELDAT == CSKS.DATBI
Storage Location/Warehouse Sender
  • Client
  • Storage Location/Warehouse Sender
  • Plant Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001L.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSLAG == T001L.LGORT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSWRK == T001L.WERKS
Project Number Sender
  • Client
  • Project Number Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == PROJ.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSPRO == PROJ.PSPNR
Plant Sender
  • Client
  • Plant Sender
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001W.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GABSWRK == T001W.WERKS
Document Type
  • Client
  • Document Type
  • /SAPCEM/SHSM_J_3GBELK.MANDT == J_3GBELART.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GBLART == J_3GBELART.J_3GBLART
CO Order Recipient
  • Client
  • CO Order Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPACO == AUFK.AUFNR
PM Order Recipient
  • PM Order Recipient
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPAPM == AUFK.AUFNR
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
Debtor of Recipient
  • Client
  • Debtor of Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPDEB == KNA1.KUNNR
External Ship-To Party - Recipient
  • Client
  • External Ship-To Party - Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPEXT == KNA1.KUNNR
Recipient
  • Client
  • Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPFAE == KNA1.KUNNR
Receiving Controlling Area
  • Receiving Controlling Area
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPKOK == TKA01.KOKRS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TKA01.MANDT
Receiving Cost Center
  • Receiving Controlling Area
  • Client
  • ?
  • Receiving Cost Center
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPKOK == CSKS.KOKRS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == CSKS.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "DATBI"] == CSKS.DATBI
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPKOS == CSKS.KOSTL
Receiving Storage Location
  • Client
  • Receiving Storage Location
  • Receiving Plant
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001L.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPLAG == T001L.LGORT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPWRK == T001L.WERKS
Receiving Cost Center for Personnel
  • Receiving Cost Center for Personnel
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPPER == KNA1.KUNNR
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
Receiving Project Number
  • Client
  • Receiving Project Number
  • /SAPCEM/SHSM_J_3GBELK.MANDT == PROJ.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPPRO == PROJ.PSPNR
Receiving Plant
  • Client
  • Receiving Plant
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001W.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GEMPWRK == T001W.WERKS
Number in Catalog
  • Client
  • Catalog Code
  • Number in Catalog
  • /SAPCEM/SHSM_J_3GBELK.MANDT == J_3GKATAL.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GTPLKZ == J_3GKATAL.J_3GTPLKZ
  • /SAPCEM/SHSM_J_3GBELK.J_3GKATNRC == J_3GKATAL.J_3GKATNRC
CO Order - Intermediate Recipient
  • Client
  • CO Order - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITACO == AUFK.AUFNR
PM Order Recipient
  • Client
  • PM Order Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == AUFK.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITAPM == AUFK.AUFNR
Controlling Area - Intermediate Recipient
  • Client
  • Controlling Area - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TKA01.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITKOK == TKA01.KOKRS
Cost Center - Intermediate Recipient
  • Cost Center - Intermediate Recipient
  • Client
  • ?
  • Controlling Area - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITKOS == CSKS.KOSTL
  • /SAPCEM/SHSM_J_3GBELK.MANDT == CSKS.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "DATBI"] == CSKS.DATBI
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITKOK == CSKS.KOKRS
Storage Location - Intermediate Recipient
  • Client
  • Plant - Intermediate Recipient
  • Storage Location - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001L.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITWRK == T001L.WERKS
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITLAG == T001L.LGORT
Project Number - Intermediate Recipient
  • Client
  • Project Number - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == PROJ.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITPRO == PROJ.PSPNR
Intermediate Recipient
  • Intermediate Recipient
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITTLE == KNA1.KUNNR
  • /SAPCEM/SHSM_J_3GBELK.MANDT == KNA1.MANDT
Plant - Intermediate Recipient
  • Client
  • Plant - Intermediate Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T001W.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GMITWRK == T001W.WERKS
Catalog Code
  • Client
  • Catalog Code
  • /SAPCEM/SHSM_J_3GBELK.MANDT == J_3GT370S.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GTPLKZ == J_3GT370S.J_3GTPLKZ
Currency Flat Rate Amount (Internal) - Sender
  • Currency Flat Rate Amount (Internal) - Sender
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GWAERS1 == TCURC.WAERS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
Currency Flat Rate Amount (External) - Sender
  • Currency Flat Rate Amount (External) - Sender
  • Client
  • /SAPCEM/SHSM_J_3GBELK.J_3GWAERS2 == TCURC.WAERS
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
Currency Flat Rate Amount (Internal) - Recipient
  • Client
  • Currency Flat Rate Amount (Internal) - Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GWAERS3 == TCURC.WAERS
Currency Flat Rate Amount (External) - Recipient
  • Client
  • Currency Flat Rate Amount (External) - Recipient
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
  • /SAPCEM/SHSM_J_3GBELK.J_3GWAERS4 == TCURC.WAERS
Recovery Indicator
  • Client
  • Recovery Indicator
  • ?
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T8JJ.MANDT
  • /SAPCEM/SHSM_J_3GBELK.RECID == T8JJ.RECID
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "BUKRS"] == T8JJ.BUKRS
Key word ID for user-defined fields
  • Client
  • Key word ID for user-defined fields
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCN00.MANDT
  • /SAPCEM/SHSM_J_3GBELK.SLWID == TCN00.SLWID
Division, but Obsolete
  • Client
  • Division, but Obsolete
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TSPA.MANDT
  • /SAPCEM/SHSM_J_3GBELK.SPART == TSPA.SPART
User field: Unit for quantity fields
  • Client
  • User field: Unit for quantity fields
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T006.MANDT
  • /SAPCEM/SHSM_J_3GBELK.USE04 == T006.MSEHI
User field: Unit for quantity fields
  • Client
  • User field: Unit for quantity fields
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T006.MANDT
  • /SAPCEM/SHSM_J_3GBELK.USE05 == T006.MSEHI
User field: Unit for value fields
  • Client
  • User field: Unit for value fields
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
  • /SAPCEM/SHSM_J_3GBELK.USE06 == TCURC.WAERS
User field: Unit for value fields
  • Client
  • User field: Unit for value fields
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TCURC.MANDT
  • /SAPCEM/SHSM_J_3GBELK.USE07 == TCURC.WAERS
Sales Organization, but Obsolete
  • Client
  • Sales Organization, but Obsolete
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TVKO.MANDT
  • /SAPCEM/SHSM_J_3GBELK.VKORG == TVKO.VKORG
Joint venture
  • Client
  • ?
  • Joint venture
  • /SAPCEM/SHSM_J_3GBELK.MANDT == T8JV.MANDT
  • /SAPCEM/SHSM_J_3GBELK.[column in domain "BUKRS"] == T8JV.BUKRS
  • /SAPCEM/SHSM_J_3GBELK.VNAME == T8JV.VNAME
Distribution Channel, but Obsolete
  • Client
  • Distribution Channel, but Obsolete
  • /SAPCEM/SHSM_J_3GBELK.MANDT == TVTW.MANDT
  • /SAPCEM/SHSM_J_3GBELK.VTWEG == TVTW.VTWEG