P_JITOutBOMData

DDL: P_JITOUTBOMDATA SQL: PJITBOMDATA Type: view TRANSACTIONAL

Bill of material data

P_JITOutBOMData is a Transactional CDS View that provides data about "Bill of material data" in SAP S/4HANA. It reads from 3 data sources (I_JITControlCycle, I_MaterialBOMLink, stpo) and exposes 15 fields with key fields BillOfMaterial, Material, Plant, JITControlCycle, BillOfMaterialComponent.

3 data source(s) 15 fields

Data Sources (3)

SourceAliasJoin Type
I_JITControlCycle _JITControlCycle inner
I_MaterialBOMLink _mast from
stpo _stpo inner

Annotations (13)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PJITBOMDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Bill of material data view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_MaterialBOMLink BillOfMaterial
KEY Material I_MaterialBOMLink Material
KEY Plant I_MaterialBOMLink Plant
KEY JITControlCycle I_JITControlCycle JITControlCycle
KEY BillOfMaterialComponent stpo idnrk
KEY ProdOrderIssueLocation stpo lgort
KEY BillOfMaterialVariant I_MaterialBOMLink BillOfMaterialVariant
KEY BillOfMaterialVariantUsage I_MaterialBOMLink BillOfMaterialVariantUsage
KEY BillOfMaterialItemNumber stpo posnr
ProductionSupplyArea I_JITControlCycle ProductionSupplyArea
QuantityUnit I_JITControlCycle QuantityUnit
JITControlCycleCategory I_JITControlCycle JITControlCycleCategory
JITCtrlCycLifeCycSts I_JITControlCycle JITCtrlCycLifeCycSts
BillOfMaterialItemUnit stpo meins
BillOfMaterialItemQuantity stpo menge 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PJITBOMDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType:#TRANSACTIONAL
@EndUserText.label: 'Bill of material data'
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_JITOutBOMData as select from I_MaterialBOMLink as _mast 
                       inner join  stpo as _stpo on  _stpo.stlty = 'M'
                                              and _stpo.stlnr = _mast.BillOfMaterial
        inner join I_JITControlCycle as _JITControlCycle on _JITControlCycle.Material = _mast.Material and
                                                              _JITControlCycle.Plant    = _mast.Plant and
                                                              _JITControlCycle.ProductionSupplyArea = _stpo.prvbe 
            {


  key  _mast.BillOfMaterial,
  key  _mast.Material,
  key  _mast.Plant,
  key  _JITControlCycle.JITControlCycle,
  key _stpo.idnrk  as BillOfMaterialComponent,
  key _stpo.lgort  as ProdOrderIssueLocation,
  key  _mast.BillOfMaterialVariant,
  key  _mast.BillOfMaterialVariantUsage,
  key _stpo.posnr                         as BillOfMaterialItemNumber,
    _JITControlCycle.ProductionSupplyArea, 
     _JITControlCycle.QuantityUnit,
     _JITControlCycle.JITControlCycleCategory,
      _JITControlCycle.JITCtrlCycLifeCycSts,
      @Semantics.unitOfMeasure: true
     _stpo.meins                         as BillOfMaterialItemUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
     _stpo.menge                         as BillOfMaterialItemQuantity
 

   
}

where _mast.BillOfMaterialVariantUsage = 'J'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JITCONTROLCYCLE",
"I_MATERIALBOMLINK",
"STPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More