R_ProductionOrderOpComponentTP

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.modelingPattern: #TRANSACTIONAL_PROJECTED_ENTITY
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Production Order Component - TP'


//

//      ************************  DO NOT USE  ************************

//      *            This RAP BO is for testing purpose only         *

//      **************************************************************


define view entity R_ProductionOrderOpComponentTP
  as select from I_ManufacturingOrderComponent as Component

  // BO relation

  association        to parent R_ProductionOrderTP    as _ProductionOrder           on  $projection.ProductionOrder = _ProductionOrder.ProductionOrder

// extension association

  association [1..1] to E_ProductionOrderComponent    as _Extension          on  $projection.Reservation           = _Extension.Reservation
                                                                             and $projection.ReservationItem       = _Extension.ReservationItem
                                                                             and $projection.ReservationRecordType = _Extension.ReservationRecordType

{
      // Key

  key Component.Reservation,
  key Component.ReservationItem,
  key Component.ReservationRecordType,

      //Material data

      cast(Component.MaterialGroup as matkl preserving type )                      as MaterialGroup,
      cast(Component.Material as matnr preserving type )                           as Material,
      Component.Plant,

      // Order and Operation data

      cast(Component.ManufacturingOrder as vdm_manufacturingorder preserving type) as ProductionOrder,

      Component.ManufacturingOrderSequence                                         as ProductionOrderSequence,

      Component.MfgOrderSequenceCategory                                           as SequenceCategory,

      cast ( Component.ManufacturingOrderOperation as vdm_vornr preserving type )  as ProductionOrderOperation,

      Component.OrderInternalID                                                    as OrderInternalID,
      Component.OrderOperationInternalID,

      // Date and Time

      @Semantics.businessDate.at: true
      Component.MatlCompRequirementDate,
      Component.MatlCompRequirementTime,
      Component.LatestRequirementDate,

      // Attributes

      Component.ReservationItemCreationCode,
      Component.ReservationIsFinallyIssued,
      @Semantics.booleanIndicator
      Component.MatlCompIsMarkedForDeletion,
      Component.MaterialComponentIsMissing,
      Component.IsBulkMaterialComponent,
      Component.MatlCompIsMarkedForBackflush,
      Component.MaterialCompIsAlternativeItem,
      Component.MatlCompIsTextItem,
      Component.MaterialProvisionType,
      Component.MaterialPlanningRelevance,
      Component.MatlCompDiscontinuationType,
      Component.MatlCompIsConfigurable,
      Component.MaterialCompCostingRelevancy,
      Component.MaterialComponentIsClassified,
      Component.MaterialCompIsIntraMaterial,
      Component.UsageProbabilityPercent,
      Component.MaterialIsDirectlyProduced,
      Component.MaterialIsDirectlyProcured,

      // Long Text

      Component.LongTextLanguage,
      Component.MaterialComponentHasLongText,

      // Assignments

      Component.RequirementType,
      Component.SalesOrder,
      Component.SalesOrderItem,
      cast ( Component.WBSElementInternalID as ps_s4_pspnr preserving type )       as WBSElementInternalID,
      Component.ProductConfiguration,
      Component.ChangeNumber,
      Component.EffectivityParameterVariant,
      Component.MatlCompFreeDefinedAttribute                                       as MatlCompFreeDefinedAttribute,

      // Assignments BOM

      Component.BillOfMaterialCategory,
      Component.BillOfMaterialInternalID                                           as BillOfMaterialInternalID,
      Component.BillOfMaterialVariant,
      Component.BillOfMaterialItemNodeNumber,
      Component.BillOfMaterialVersion,
      Component.BOMItemInternalChangeCount,
      Component.InheritedBOMItemNode,
      Component.BillOfMaterialItemCategory,
      Component.BillOfMaterialItemNumber                                           as BillOfMaterialItemNumber,
      @Semantics.text: true
      Component.MaterialComponentText,
      @Semantics.text: true
      Component.MaterialComponentSecondText,
      Component.BOMExplosionDateID,

      // Assignments Purchasing

      Component.PurchasingInfoRecord,
      Component.PurchasingGroup,
      --    @ObjectModel.foreignKey.association: '_PurchaseRequisition'
      Component.PurchaseRequisition,
      --    @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
      Component.PurchaseRequisitionItem,
      --    @ObjectModel.foreignKey.association: '_PurchaseOrder'
      Component.PurchaseOrder,
      --    @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
      Component.PurchaseOrderItem,
      @ObjectModel.foreignKey.association: '_Supplier'
      Component.Supplier,
      Component.DeliveryDurationInDays,
      Component.MaterialGoodsReceiptDuration,
      -- Price
      @Semantics.amount.currencyCode: 'Currency'
      Component.ExternalProcessingPrice,
      Component.NumberOfOperationPriceUnits,

      // Goods Movement data

      Component.GoodsMovementIsAllowed,
      Component.StorageLocation,
      cast(Component.Batch as charg_d preserving type )                            as Batch,
      Component.BatchSplitType,
      Component.DebitCreditCode,
      Component.GoodsMovementType,
      Component.InventorySpecialStockType,
      Component.InventorySpecialStockValnType,
      Component.ConsumptionPosting,
      Component.SupplyArea,
      @Semantics.text: true
      Component.GoodsRecipientName,
      @Semantics.text: true
      Component.UnloadingPointName,
      Component.StockSegment,
      Component.RequirementSegment,

      // Assignments WM   - old WM should not be used any longer

      //      @ObjectModel.foreignKey.association: '_Warehouse'

      //      Component.Warehouse,

      //      Component.StorageType,

      //      Component.StorageBin,


      // Assignments FI/CO

      Component.BusinessArea,
      //      @ObjectModel.foreignKey.association: '_CompanyCode'

      //      CompanyCode,

      //      @ObjectModel.foreignKey.association: '_GLAccount'

      Component.GLAccount,
      Component.FunctionalArea,
      //      @ObjectModel.foreignKey.association: '_ControllingArea'

      //      ControllingArea,

      Component.AccountAssignmentCategory,
      //      Component.CommitmentItemShortID,           // not needed

      //      Component.FundsCenter,                     // not needed


      // Variable-size comp. data

      Component.MaterialCompIsVariableSized,
      Component.VariableSizeItemUnit,
      //      cast(case Component.MaterialCompIsVariableSized

      //        when 'X' then tcs03.roame

      //        else ' '

      //      end as vdm_roame)                                                           as VariableSizeItemUnit,

      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      Component.VariableSizeItemQuantity                                           as VariableSizeItemQuantity,

      Component.VariableSizeComponentUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      Component.VariableSizeComponentQuantity,
      Component.VariableSizeDimensionUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      Component.VariableSizeDimension1,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      Component.VariableSizeDimension2,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      Component.VariableSizeDimension3,
      Component.VariableSizeCompFormulaKey,

      // Phantom assembly

      Component.MaterialComponentIsPhantomItem,
      Component.OrderPathValue,
      Component.OrderLevelValue,

      // Lead-Time offset

      Component.LeadTimeOffset,
      Component.OperationLeadTimeOffsetUnit,
      Component.OperationLeadTimeOffset,

      // Quantities and UoM

      Component.QuantityIsFixed,
      Component.IsNetScrap,
      Component.ComponentScrapInPercent,
      Component.OperationScrapInPercent,
      Component.MaterialQtyToBaseQtyNmrtr,
      Component.MaterialQtyToBaseQtyDnmntr,
      Component.BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Component.RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Component.WithdrawnQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Component.ConfirmedAvailableQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Component.MaterialCompOriginalQuantity,

      Component.EntryUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      Component.GoodsMovementEntryQty,

      // Amount and Currency

      Component.Currency,
      @Semantics.amount.currencyCode: 'Currency'
      Component.WithdrawnQuantityAmount,

      // Associations

      _Supplier,
      _SupplierCompanyByPlant,

      _ProductionOrder
}
where
  Component.ManufacturingOrderCategory = '10'; //production order


//      resb.kzkup =  ''    //no co-products

//  and resb.postp <> 'D'   //no documents

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDERCOMPONENT"
],
"ASSOCIATED":
[
"I_SUPPLIER",
"I_SUPPLIERCOMPANYBYPLANT",
"R_PRODUCTIONORDERTP"
],
"BASE":
[
"I_MANUFACTURINGORDERCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/