P_MATLBILLOFMATERIALITEMDEX

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
define view entity P_MATLBILLOFMATERIALITEMDEX as select from stas as stas
    inner join   stpo as stpo on  stas.stlty = stpo.stlty
                              and stas.stlnr = stpo.stlnr
                              and stas.stlkn = stpo.stlkn
                              and stas.lkenz = ' '
{
  key stas.stlty                                     as BillOfMaterialCategory,
  key cast(stas.stlnr as cs_stlnr preserving type )  as BillOfMaterial,
  key stas.stlal                                     as BillOfMaterialVariant,
  key stas.stlkn                                     as BillOfMaterialItemNodeNumber,
  key stas.stasz                                     as BOMInstceInternalChangeNumber,
      stpo.stpoz                                     as BOMItemInternalChangeCount,
      stpo.guidx                                     as BillOfMaterialItemUUID,
      stas.stvkn                                     as InheritedNodeNumberForBOMItem,
      stpo.stvkn_versn                               as InheritedNodeNumberVersionBOM,
      stas.bom_versn                                 as BillOfMaterialVersion,
      @Semantics.businessDate.from: true
      stpo.datuv                                     as ValidityStartDate,
      stpo.aennr                                     as EngineeringChangeDocument,
      stpo.ecn_to                                    as ChgToEngineeringChgDocument,
      @Semantics.businessDate.to: true
      cast( stpo.valid_to as datub preserving type ) as ValidityEndDate,
      stpo.andat                                     as BOMItemRecordCreationDate,
      stpo.annam                                     as BOMItemCreatedByUser,
      stpo.aedat                                     as BOMItemLastChangeDate,
      stpo.aenam                                     as BOMItemLastChangedByUser,
      stpo.idnrk                                     as BillOfMaterialComponent,
      stpo.postp                                     as BillOfMaterialItemCategory,
      cast(stpo.posnr as char4  preserving type )    as BillOfMaterialItemNumber,
      stpo.meins                                     as BillOfMaterialItemUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.menge                                     as BillOfMaterialItemQuantity,
      stpo.upskz                                     as IsSubItem,
      stpo.sortf                                     as BOMItemSorter,
      stpo.fmeng                                     as BOMItemHasFixedQuantity,
      stpo.ekgrp                                     as PurchasingGroup,
      stpo.waers                                     as Currency,
      @Semantics.amount.currencyCode : 'Currency'
      stpo.preis                                     as MaterialComponentPrice,
      case when
      ( stpo.itmid is null or stpo.itmid = '')
       then stpo.stvkn
       else
      stpo.itmid
      end                                            as IdentifierBOMItem,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.peinh                                     as MaterialPriceUnitQty,
      stpo.ausch                                     as ComponentScrapInPercent,
      stpo.avoau                                     as OperationScrapInPercent,
      stpo.netau                                     as IsNetScrap,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.romen                                     as QuantityVariableSizeItem,
      stpo.rform                                     as FormulaKey,
      stpo.potx1                                     as BOMItemDescription,
      stpo.potx2                                     as BOMItemText2,
      stpo.ltxsp                                     as LongTextLanguage,
      stpo.matkl                                     as MaterialGroup,
      stpo.dokar                                     as DocumentType,
      stpo.doknr                                     as DocNumber,
      stpo.dokvr                                     as DocumentVersion,
      stpo.doktl                                     as DocumentPart,
      stpo.class                                     as ClassNumber,
      stpo.klart                                     as ClassType,
      stpo.potpr                                     as ResultingItemCategory,
      stpo.knobj                                     as DependencyObjectNumber,
      stpo.objty                                     as BillOfMaterialObjectType,
      stpo.kzclb                                     as IsClassificationRelevant,
      stpo.schgt                                     as IsBulkMaterial,
      @Semantics.booleanIndicator:true
      stpo.erskz                                     as BOMItemIsSparePart,
      @Semantics.booleanIndicator:true
      stpo.rvrel                                     as BOMItemIsSalesRelevant,
      stpo.sanfe                                     as IsProductionRelevant,
      stpo.sanin                                     as BOMItemIsPlantMaintRelevant,
      @Semantics.booleanIndicator:true
      stpo.sanka                                     as BOMItemIsCostingRelevant,
      stpo.sanko                                     as IsEngineeringRelevant,
      stpo.itsob                                     as SpecialProcurementType,
      stpo.rekrs                                     as IsBOMRecursiveAllowed,
      stpo.nlfzv                                     as OperationLeadTimeOffset,
      stpo.nlfmv                                     as OpsLeadTimeOffsetUnit,
      @Semantics.booleanIndicator:true
      stpo.beikz                                     as IsMaterialProvision,
      stpo.rekri                                     as BOMIsRecursive,
      stpo.cadpo                                     as DocumentIsCreatedByCAD,
      stpo.verti                                     as DistrKeyCompConsumption,
      stpo.lifzt                                     as DeliveryDurationInDays,
      stpo.sakto                                     as CostElement,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.roms1                                     as Size1,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.roms2                                     as Size2,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      stpo.roms3                                     as Size3,
      stpo.romei                                     as UnitOfMeasureForSize1To3,
      stpo.webaz                                     as GoodsReceiptDuration,
      stpo.ekorg                                     as PurchasingOrganization,
      stpo.clobk                                     as RequiredComponent,
      stpo.clmul                                     as MultipleSelectionAllowed,
      stpo.lgort                                     as ProdOrderIssueLocation,
      stpo.kzkup                                     as MaterialIsCoProduct,
      stpo.dspst                                     as ExplosionType,
      stpo.nfgrp                                     as FollowUpGroup,
      stpo.nfeag                                     as DiscontinuationGroup,
      stpo.cview                                     as ReinsurContrOrgUnit,
      @Semantics.booleanIndicator:true
      stpo.awakz                                     as IsConfigurableBOM,
      stpo.rfpnt                                     as ReferencePoint,
      stpo.nlfzt                                     as LeadTimeOffset,
      stpo.sfwind                                    as IsSoftwareComponent,
      stpo.prvbe                                     as ProductionSupplyArea,
      stpo.lkenz                                     as IsDeleted,
      stpo.alekz                                     as IsALE,
      stpo.alpgr                                     as AlternativeItemGroup,
      stpo.alprf                                     as AlternativeItemPriority,
      stpo.alpst                                     as AlternativeItemStrategy,
      stpo.ewahr                                     as UsageProbabilityPercent,
      stpo.stkkz                                     as IsPMAssemblyRelevant,
      stpo.lastchangedatetime                        as LastChangeDateTime,
      stpo.kstty                                     as OrigSalesOrderBOMItmCategory,
      stpo.kstkn                                     as OrigSalesOrderBOMItmNodeNumber,
      stpo.kstpz                                     as OrigSalesOrderBOMItmNumber,
      cast(stpo.preliminary_material as matnr  preserving type ) as PreliminaryMaterial

}
where stas.stlty = 'M'