I_PRODNMODBOOVERSBOMASSGMT

CDS View

Bill of Operation Version BOM Assignment

I_PRODNMODBOOVERSBOMASSGMT is a CDS View in S/4HANA. Bill of Operation Version BOM Assignment. It contains 5 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 5 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdnModOperationActivity view_entity inner COMPOSITE Production Model Operation Activity
I_ProductionModel view_entity inner COMPOSITE Production Model Header
I_ProductionModelOperation view_entity inner COMPOSITE Production Model Operation
P_ProductionModelComponent view_entity inner COMPOSITE Prodn Model Sales Order Component

Fields (5)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsVersion BillOfOperationsVersion 4
BillOfMaterialVersion BillOfMaterialVersion 2
BillOfOperationsVersionStatus BillOfOperationsVersionStatus 1
BOMVersionStatus BOMVersionStatus 1
IsLatestBOOVersion IsLatestBOOVersion 1 
@EndUserText.label: 'Bill of Operation Version BOM Assignment'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MASTER
}

define view entity I_ProdnModBOOVersBOMAssgmt
  as select from    plvk as BillOfOperationsVersion
    inner join      plmb as BooVersionBOMAssgmt on  BooVersionBOMAssgmt.plnty = BillOfOperationsVersion.plnty
                                                and BooVersionBOMAssgmt.plnnr = BillOfOperationsVersion.plnnr
                                                and BooVersionBOMAssgmt.plnal = BillOfOperationsVersion.plnal
                                                and BooVersionBOMAssgmt.versn = BillOfOperationsVersion.versn
    left outer to one join stko as BOMHeader    on  BOMHeader.stlty     = BooVersionBOMAssgmt.stlty
                                                and BOMHeader.stlnr     = BooVersionBOMAssgmt.stlnr
                                                and BOMHeader.stlal     = BooVersionBOMAssgmt.stlal
                                                and BOMHeader.bom_versn = BooVersionBOMAssgmt.bom_versn
                                                and BOMHeader.lkenz     = ''
{
  key BillOfOperationsVersion.plnty      as BillOfOperationsType,
  key BillOfOperationsVersion.plnnr      as BillOfOperationsGroup,
  key BillOfOperationsVersion.plnal      as BillOfOperationsVariant,
  key BillOfOperationsVersion.versn      as BillOfOperationsVersion,
  key BooVersionBOMAssgmt.zuonr          as ProdnRtgVersBOMInternalID,
      BooVersionBOMAssgmt.matnr          as Material,
      BooVersionBOMAssgmt.werks          as Plant,
      BooVersionBOMAssgmt.stlty          as BillOfMaterialCategory,
      BooVersionBOMAssgmt.stlan          as BillOfMaterialVariantUsage,
      cast( BooVersionBOMAssgmt.stlnr  as cs_stlnr ) as BillOfMaterial,
      BooVersionBOMAssgmt.stlal          as BillOfMaterialVariant,
      BooVersionBOMAssgmt.bom_versn      as BillOfMaterialVersion,
      BillOfOperationsVersion.status     as BillOfOperationsVersionStatus,
      @Semantics.booleanIndicator: true
      BillOfOperationsVersion.last_versn as IsLatestBOOVersion,
      BOMHeader.versnst                  as BOMVersionStatus,
      BOMHeader.stlst                    as BillOfMaterialStatus
}

Learn More