I_SubcontractingComponent

@AbapCatalog.sqlViewName: 'IPPSUBCONTRCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'ReservationItem'
@ObjectModel.semanticKey: ['Reservation', 'ReservationItem']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Subcontracting Component'
// corresponds to data base view MDSB


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_SubcontractingComponent
  as select from resb as mdsb
    left outer to one join tcs03 as tcs03 on tcs03.agb29 = '29'

  association [0..1] to I_ReservationDocumentHeader    as _Reservation                   on  $projection.Reservation = _Reservation .Reservation
  association [1..1] to I_ReservationDocumentItem      as _ReservationItem               on  $projection.Reservation     = _ReservationItem.Reservation
                                                                                         and $projection.ReservationItem = _ReservationItem.ReservationItem
                                                                                         and $projection.RecordType      = _ReservationItem.RecordType
  association [0..1] to I_ReservationDocRecordType     as _ReservationRecordType         on  $projection.RecordType = _ReservationRecordType.RecordType                                                                                  
  association [1..1] to I_MaterialGroup                as _MaterialGroup                 on  $projection.MaterialGroup = _MaterialGroup.MaterialGroup
  association [1..1] to I_Material                     as _Material                      on  $projection.Material = _Material.Material
  association [1..1] to I_Product                      as _Product                       on  $projection.Material = _Product.Product
  association [1..*] to I_ProductUnitsOfMeasure        as _ProductUnitsOfMeasure         on  $projection.Material = _ProductUnitsOfMeasure.Product
  association [1..1] to I_ProductPlantBasic            as _ProductPlant                  on  $projection.Material = _ProductPlant.Product
                                                                                         and $projection.Plant    = _ProductPlant.Plant
  association [0..1] to I_ProductSupplyPlanning        as _ProductSupplyPlanning         on  $projection.Material = _ProductSupplyPlanning.Product
                                                                                         and $projection.Plant    = _ProductSupplyPlanning.Plant
  association [0..1] to I_ProductStorageLocationBasic  as _ProductStorageLocation        on  $projection.Material        = _ProductStorageLocation.Product
                                                                                         and $projection.Plant           = _ProductStorageLocation.Plant
                                                                                         and $projection.StorageLocation = _ProductStorageLocation.StorageLocation                                                                                     
  association [1..1] to I_Plant                        as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_SalesOrder                   as _SalesOrder                    on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [0..1] to I_SalesOrderItem               as _SalesOrderItem                on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                                                         and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
  association [0..1] to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1] to I_EnterpriseProjectElement     as _EnterpriseProjectElement      on  $projection.WBSElementInternalID = _EnterpriseProjectElement.WBSElementInternalID  
  association [0..1] to I_StorageLocation              as _StorageLocation               on  $projection.Plant           = _StorageLocation.Plant
                                                                                         and $projection.StorageLocation = _StorageLocation.StorageLocation
  association [0..1] to I_Batch                        as _Batch                         on  $projection.Material = _Batch.Material
                                                                                         and $projection.Plant    = _Batch.Plant
                                                                                         and $projection.Batch    = _Batch.Batch  
  association [0..1] to I_ProductionSupplyArea         as _ProductionSupplyArea          on  $projection.Plant                = _ProductionSupplyArea.Plant
                                                                                         and $projection.ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea
  association [0..1] to I_DebitCreditCode              as _DebitCreditCode               on  $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
  association [0..1] to I_GoodsMovementType            as _GoodsMovementType             on  $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
  association [0..1] to I_InventorySpecialStockType    as _InventorySpecialStockType     on  $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
  association [0..1] to I_InvtrySpecialStockValnType   as _InventorySpecialStockValnType on  $projection.InventorySpecialStockValnType = _InventorySpecialStockValnType.InventorySpecialStockValnType
  association [0..1] to I_ConsumptionPosting           as _ConsumptionPosting            on  $projection.ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting
  association [0..1] to I_AccountAssignmentCategory    as _AccountAssignmentCategory     on  $projection.AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory
  association [0..1] to I_FunctionalArea               as _FunctionalArea                on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  association [0..1] to I_BusinessArea                 as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..*] to I_GLAccount                    as _GLAccount                     on  $projection.GLAccount   = _GLAccount.GLAccount
  association [0..1] to I_PlannedOrder                 as _PlannedOrder                  on  $projection.PlannedOrder = _PlannedOrder.PlannedOrder
  association [0..1] to I_LogisticsOrder               as _Order                         on  $projection.OrderID = _Order.OrderID
  association [0..1] to I_PurchasingGroup              as _PurchasingGroup               on  $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
  association [0..1] to I_PurchasingInfoRecordApi01    as _PurchasingInfoRecord          on  $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord
  association [0..1] to I_PurchasingDocument           as _PurchasingDocument            on  $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
  association [0..1] to I_PurchasingDocumentItem       as _PurchasingDocumentItem        on  $projection.PurchasingDocument     = _PurchasingDocumentItem.PurchasingDocument
                                                                                         and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
  association [0..1] to I_PurchaseRequisitionItemAPI01 as _PurchaseRequisitionItem       on  $projection.PurchaseRequisition     = _PurchaseRequisitionItem.PurchaseRequisition
                                                                                         and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem
  association [0..1] to I_Supplier                     as _Supplier                      on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_ChangeMaster                 as _ChangeNumber                  on  $projection.ChangeNumber = _ChangeNumber.ChangeNumber
  association [0..1] to I_BOMExplosionDate             as _BOMExplosion                  on  $projection.BOMExplosionDateID = _BOMExplosion.BOMExplosionDateID
  association [0..1] to I_MatlCompDiscontinuationType  as _MatlCompDiscontinuationType   on  $projection.MatlCompDiscontinuationType = _MatlCompDiscontinuationType.MatlCompDiscontinuationType
  association [0..1] to I_MatlCompProvisionType        as _ProvisionType                 on  $projection.MaterialProvisionType = _ProvisionType.MaterialProvisionType
  association [0..1] to I_MatlCompSparePartType        as _SparePartType                 on  $projection.MatlComponentSparePartType = _SparePartType.MatlComponentSparePartType
  association [0..1] to I_Product                      as _FollowUpMaterial              on  $projection.FollowUpMaterial = _FollowUpMaterial.Product
  association [0..1] to I_Material                     as _Assembly                      on  $projection.Assembly = _Assembly.Material
  association [0..1] to I_Language                     as _Language                      on  $projection.LongTextLanguageCode = _Language.Language
  association [0..1] to I_UnitOfMeasure                as _VariableSizeCompUnit          on  $projection.VariableSizeComponentUnit = _VariableSizeCompUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _VariableSizeItemUnit          on  $projection.VariableSizeItemUnit = _VariableSizeItemUnit.UnitOfMeasure 
  association [0..1] to I_UnitOfMeasure                as _VariableSize1To3Unit          on  $projection.UnitOfMeasureForSize1To3  = _VariableSize1To3Unit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _LeadTimeOffsetUnit            on  $projection.OperationLeadTimeOffsetUnit = _LeadTimeOffsetUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure                as _BaseUnit                      on  $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _EntryUnit                     on  $projection.EntryUnit = _EntryUnit.UnitOfMeasure

{
      // Key

      @ObjectModel.foreignKey.association: '_Reservation'
  key mdsb.rsnum                                    as Reservation,
      @ObjectModel.text.element: ['BOMItemDescription']
  key cast(mdsb.rspos as pph_rspos preserving type) as ReservationItem,
      @ObjectModel.foreignKey.association: '_ReservationRecordType'
  key cast(mdsb.rsart as pph_rsart preserving type) as RecordType,

      //Material data

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      mdsb.matkl                                    as MaterialGroup,
      @ObjectModel.foreignKey.association: '_Material'
      mdsb.matnr                                    as Material,
      @ObjectModel.foreignKey.association: '_Plant'
      mdsb.werks                                    as Plant,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      cast(mdsb.lgort as pph_lgort preserving type) as StorageLocation,
      @ObjectModel.foreignKey.association: '_Batch'      
      mdsb.charg                                    as Batch,
      @ObjectModel.foreignKey.association: '_ProductionSupplyArea'
      cast(mdsb.prvbe as pph_prvbe preserving type) as ProductionSupplyArea,
      mdsb.sgt_scat                                 as StockSegment,
      mdsb.sgt_rcat                                 as RequirementSegment,

      // Date and Time

      @Semantics.businessDate.at: true
      cast(mdsb.bdter as pph_bdter preserving type) as RequirementDate,
      cast(mdsb.bdztp as pph_bdztp preserving type) as RequirementTime,
      cast(mdsb.sbter as pph_sbter preserving type) as LatestRequirementDate,

      // Attributes

      @Semantics.booleanIndicator:true
      mdsb.kzear                                    as ReservationIsFinallyIssued,
      @Semantics.booleanIndicator: true
      cast(mdsb.xloek as pph_xloek preserving type) as MatlCompIsMarkedForDeletion,
      @Semantics.booleanIndicator:true
      mdsb.xfehl                                    as MaterialComponentIsMissing,
      @Semantics.booleanIndicator:true
      mdsb.schgt                                    as IsBulkMaterialComponent,
      @Semantics.booleanIndicator:true
      mdsb.txtps                                    as MatlCompIsTextItem,
      @Semantics.booleanIndicator:true
      mdsb.kfpos                                    as MatlCompIsConfigurable,
      @Semantics.booleanIndicator:true
      mdsb.clakz                                    as MaterialComponentIsClassified,
      @Semantics.booleanIndicator:true
      mdsb.inpos                                    as MaterialCompIsIntraMaterial,
      
      // Assignments Order

      @ObjectModel.foreignKey.association: '_PlannedOrder'
      mdsb.plnum                                    as PlannedOrder,
      @ObjectModel.foreignKey.association: '_Order'
      mdsb.aufnr                                    as OrderID,
      cast(mdsb.aufpl as pph_aufpl preserving type) as OrderInternalID,
      cast(mdsb.aplzl as operationinternalid preserving type) as OrderOperationInternalID, 
      
      // Assignments Purchasing

      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      cast(mdsb.ekgrp as pph_ekgrp preserving type) as PurchasingGroup,
      cast(mdsb.infnr as pph_infnr preserving type) as PurchasingInfoRecord,
      cast(mdsb.banfn as co_banfn  preserving type) as PurchaseRequisition,
      cast(mdsb.bnfpo as co_bnfpo  preserving type) as PurchaseRequisitionItem,
      cast(mdsb.ebeln as pph_ebeln preserving type) as PurchasingDocument,
      cast(mdsb.ebelp as pph_ebelp preserving type) as PurchasingDocumentItem,
      mdsb.ebele as ScheduleLine,
      @ObjectModel.foreignKey.association: '_Supplier'
      mdsb.lifnr as Supplier,

      // Assignments BOM

      cast(mdsb.stlty as pph_stlty preserving type) as BillOfMaterialCategory,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'BillOfMaterialInternalID_2'
      mdsb.stlnr                                    as BillOfMaterialInternalID,
      cast(mdsb.stlnr as pph_stnum preserving type) as BillOfMaterialInternalID_2,
      mdsb.stlal                                    as BillOfMaterialVariant,
      mdsb.bom_versn                                as BillOfMaterialVersion,
      cast(mdsb.stlkn as pph_stlkn preserving type) as BOMItem,
      mdsb.stpoz                                    as BOMItemInternalChangeCount,
      mdsb.stvkn                                    as InheritedBOMItemNode,
      cast(mdsb.postp as pph_postp preserving type) as BOMItemCategory,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'BillOfMaterialItemNumber_2'
      mdsb.posnr                                    as BillOfMaterialItemNumber,
      @ObjectModel.text.element: ['BOMItemDescription']
      cast(mdsb.posnr as vdm_sposn preserving type) as BillOfMaterialItemNumber_2,
      @Semantics.text: true
      mdsb.potx1                                    as BOMItemDescription,
      @Semantics.text: true
      mdsb.potx2                                    as BOMItemText2,
      @ObjectModel.foreignKey.association: '_BOMExplosion'
      cast(mdsb.sernr as pph_sernr preserving type) as BOMExplosionDateID,

      // Assignments others

      @ObjectModel.foreignKey.association: '_SalesOrder'
      cast(mdsb.kdauf as co_kdauf preserving type)                  as SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
      cast(mdsb.kdpos as co_kdpos preserving type)                  as SalesOrderItem,
      @ObjectModel.foreignKey.association: '_WBSElementBasicData'
      cast(mdsb.pspel as ps_s4_pspnr preserving type)               as WBSElementInternalID,

      // Goods Movement data

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      cast(mdsb.shkzg as pph_shkzg preserving type)                 as DebitCreditCode,
      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      mdsb.bwart                                                    as GoodsMovementType,
      @ObjectModel.foreignKey.association: '_InventorySpecialStockType'
      cast(mdsb.sobkz as inventoryspecialstocktype preserving type) as InventorySpecialStockType,
      @ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
      cast(mdsb.kzbws as pph_kzbws preserving type)                 as InventorySpecialStockValnType,
      @ObjectModel.foreignKey.association: '_ConsumptionPosting'
      cast(mdsb.kzvbr as pph_kzvbr preserving type)                 as ConsumptionPosting,
      @ObjectModel.foreignKey.association: '_AccountAssignmentCategory'
      cast(mdsb.knttp as pph_knttp preserving type)                 as AccountAssignmentCategory,

      // Assignments FI/CO

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'MaterialCompCostingRelevancy'
      mdsb.sanka                                       as MaterialCompIsCostRelevant,
      mdsb.sanka                                       as MaterialCompCostingRelevancy,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      mdsb.gsber                                       as BusinessArea,
--    @ObjectModel.foreignKey.association: '_GLAccount'
      mdsb.saknr                                       as GLAccount,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      mdsb.fkber                                       as FunctionalArea,

      // Assignments others

      @ObjectModel.foreignKey.association: '_Language'
      mdsb.ltxsp                                       as LongTextLanguageCode,
      @ObjectModel.foreignKey.association: '_ChangeNumber'
      mdsb.aennr                                       as ChangeNumber,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'MaterialRevisionLevel_2' 
      mdsb.revlv                                       as MaterialRevisionLevel,
      cast(mdsb.revlv as vdm_qm_revlv preserving type) as MaterialRevisionLevel_2,
      mdsb.verti                                       as QuantityDistributionKey,
      mdsb.techs                                       as EffectivityParameterVariant,
      mdsb.cuobj                                       as ProductConfiguration,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'MatlCompFreeDefinedAttribute'      
      mdsb.sortf                                       as SortField,
      mdsb.sortf                                       as MatlCompFreeDefinedAttribute,

      // Variable-sized data

      @Semantics.booleanIndicator:true
      mdsb.rohps                                    as MaterialCompIsVariableSized,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'VariableSizeItemQuantity'
      cast(mdsb.roanz as pph_roanz preserving type) as NumberOfVariableSizeComponents,
      @ObjectModel.foreignKey.association: '_VariableSizeItemUnit'
      @Semantics.unitOfMeasure: true
      cast(case mdsb.rohps
        when 'X' then tcs03.roame
      end as vdm_roame)                             as VariableSizeItemUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      @Aggregation.default: #SUM
      cast(mdsb.roanz as pph_roanz preserving type) as VariableSizeItemQuantity,
      @ObjectModel.foreignKey.association: '_VariableSizeCompUnit'
      @Semantics.unitOfMeasure: true      
      cast(mdsb.rokme as pph_rokme preserving type) as VariableSizeComponentUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      @Aggregation.default: #SUM
      cast(mdsb.romen as pph_romen preserving type) as VariableSizeComponentQuantity,
      @ObjectModel.foreignKey.association: '_VariableSize1To3Unit'
      @Semantics.unitOfMeasure: true
      mdsb.romei                                    as UnitOfMeasureForSize1To3,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      @Aggregation.default: #SUM
      mdsb.roms1                                    as Size1,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      @Aggregation.default: #SUM
      mdsb.roms2                                    as Size2,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      @Aggregation.default: #SUM
      mdsb.roms3                                    as Size3,
      mdsb.rform                                    as FormulaKey,

      // Alternative item data

      mdsb.alpos                                    as MaterialCompIsAlternativeItem,
      cast(mdsb.alpgr as pph_alpgr preserving type) as AlternativeItemGroup,
      cast(mdsb.alpst as pph_alpst preserving type) as AlternativeItemStrategy,
      cast(mdsb.alprf as pph_alprf preserving type) as AlternativeItemPriority,
      mdsb.ewahr                                    as UsageProbabilityPercent,

      // Discontinuation

      cast(mdsb.nfeag as pph_nfeag preserving type) as DiscontinuationGroup,
      @ObjectModel.foreignKey.association: '_MatlCompDiscontinuationType'
      mdsb.kzaus                                    as MatlCompDiscontinuationType,
      @Semantics.booleanIndicator:true
      cast(mdsb.nfpkz as pph_kznfp preserving type) as MatlCompIsFollowUpMaterial,
      cast(mdsb.nfgrp as pph_nfgrp preserving type) as FollowUpGroup,
      @ObjectModel.foreignKey.association: '_FollowUpMaterial'
      cast(mdsb.nomat as pph_nomat preserving type) as FollowUpMaterial,
      @Semantics.booleanIndicator:true
      cast(mdsb.nafkz as pph_nafkz preserving type) as FollowUpMaterialIsActive,

      // Phantom assembly

      @Semantics.booleanIndicator:true
      cast(mdsb.dumps as pph_dumps preserving type) as MaterialComponentIsPhantomItem,
      mdsb.aufwg                                    as OrderPathValue,
      mdsb.aufst                                    as OrderLevelValue,
      @ObjectModel.foreignKey.association: '_Assembly'
      mdsb.baugr                                    as Assembly,
      mdsb.bauwg                                    as AssemblyOrderPathValue,
      mdsb.baust                                    as AssemblyOrderLevelValue,

      // Material provision

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'MaterialProvisionType'
      mdsb.beikz                                    as IsMaterialProvision,
      @ObjectModel.foreignKey.association: '_ProvisionType'
      cast(mdsb.beikz as vdm_beikz preserving type) as MaterialProvisionType,

      // Spare parts

      @Semantics.booleanIndicator:true
      cast(case 
        when mdsb.erskz <> '' then 'X'
      end as vdm_kzers preserving type)             as MaterialComponentIsSparePart,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'MatlComponentSparePartType'
      mdsb.erskz                                    as SparePartFltrType,
      @ObjectModel.foreignKey.association: '_SparePartType'
      cast(mdsb.erskz as vdm_erskz preserving type) as MatlComponentSparePartType,

      // Lead-Time offset

      cast(mdsb.nlfzt as pph_nlfzt preserving type) as LeadTimeOffset,
      @ObjectModel.foreignKey.association: '_LeadTimeOffsetUnit'
      @Semantics.unitOfMeasure: true
      cast(mdsb.nlfmv as pph_nlfmv preserving type) as OperationLeadTimeOffsetUnit,
      cast(mdsb.nlfzv as pph_nlfzv preserving type) as OperationLeadTimeOffset,

      // Quantities and UoM

      @Semantics.booleanIndicator:true
      mdsb.fmeng                                    as QuantityIsFixed,
      mdsb.ausch                                    as ComponentScrapInPercent,
      mdsb.avoau                                    as OperationScrapInPercent,
      mdsb.netau                                    as IsNetScrap,
      mdsb.umrez                                    as MaterialQtyToBaseQtyNmrtr,
      mdsb.umren                                    as MaterialQtyToBaseQtyDnmntr,
      @ObjectModel.foreignKey.association: '_BaseUnit'
      @Semantics.unitOfMeasure: true
      mdsb.meins                                    as BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      mdsb.bdmng                                    as RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      cast(mdsb.enmng as pph_enmng preserving type) as WithdrawnQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      cast(mdsb.nomng as pph_nomng preserving type) as MaterialCompOriginalQuantity,      
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM     
      mdsb.esmng                                    as MaterialComponentUsageQuantity,

      @ObjectModel.foreignKey.association: '_EntryUnit'
      @Semantics.unitOfMeasure: true
      mdsb.erfme                                    as EntryUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      @Aggregation.default: #SUM
      cast(mdsb.erfmg as pph_erfmg preserving type) as QuantityInEntryUnit,

      // Associations

      _Reservation,
      _ReservationItem,
      _ReservationRecordType,
      _MaterialGroup,
      _Material,
      _Product,
      _ProductUnitsOfMeasure,
      _ProductPlant,
      _ProductStorageLocation,
      _ProductSupplyPlanning,
      _Plant,
      _SalesOrder,
      _SalesOrderItem,
      _WBSElementBasicData,
      _EnterpriseProjectElement,
      _StorageLocation,
      _Batch,
      _ProductionSupplyArea,
      _DebitCreditCode,
      _GoodsMovementType,
      _InventorySpecialStockType,
      _InventorySpecialStockValnType,
      _ConsumptionPosting,
      _AccountAssignmentCategory,
      _BusinessArea,
      _GLAccount,
      _FunctionalArea,
      _PlannedOrder,
      _Order,
      _PurchasingGroup,
      _PurchasingInfoRecord,
      _PurchasingDocument,
      _PurchasingDocumentItem,
      _PurchaseRequisitionItem,
      _Supplier,
      _ChangeNumber,
      _BOMExplosion,
      _Assembly,
      _VariableSizeCompUnit,
      _VariableSizeItemUnit,
      _VariableSize1To3Unit,
      _FollowUpMaterial,
      _MatlCompDiscontinuationType,
      _ProvisionType,
      _SparePartType,
      _LeadTimeOffsetUnit,
      _Language,
      _BaseUnit,
      _EntryUnit  
}
where mdsb.bdart = 'BB';  //Subcontracting