I_ProductionOrder

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser', '_MRPController', '_ProductionSupervisor']
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Production Order'
// CDS view for linkage between SOT "Production Order" and VDM

// Not for general usage, not for consumption, not for C1-release! 

// Please use DDLS I_ManufacturingOrder for all other purposes.


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity I_ProductionOrder
  as select from I_ManufacturingOrder as head

  -- to child: Items
  association [1..*] to I_ManufacturingOrderItem      as _ProductionOrderItem          on  $projection.ProductionOrder = _ProductionOrderItem.ManufacturingOrder
  -- to child: Sequences
  association [1..*] to I_ManufacturingOrderSequence  as _ProductionOrderSequence      on  $projection.ProductionOrder = _ProductionOrderSequence.ManufacturingOrder
  -- to child: Operations
  association [1..*] to I_ManufacturingOrderOperation as _ProductionOrderOperation     on  $projection.OrderInternalID = _ProductionOrderOperation.MfgOrderInternalID
  -- to child: Components
  association [0..*] to I_ManufacturingOrderComponent as _ProductionOrderComponent     on  $projection.Reservation = _ProductionOrderComponent.Reservation
  -- to child: PRTs
  association [0..*] to I_MfgOrderOperationPRT        as _ProductionOrderProdnRsceTool on  $projection.OrderInternalID = _ProductionOrderProdnRsceTool.MfgOrderInternalID
  -- to child: Document Links
  association [0..*] to I_MfgOrderDocumentLink        as _ProductionOrderDocumentLink  on  $projection.ProductionOrder = _ProductionOrderDocumentLink.ManufacturingOrder

{
      // Key

  key head.ManufacturingOrder,
  
      @ObjectModel.text.element: ['OrderDescription']
      cast(head.ManufacturingOrder as co_aufnr preserving type)         as ProductionOrder,

      // Text

      @Semantics.text: true
      cast(head. ManufacturingOrderText as pph_auftext preserving type) as OrderDescription,
      head.ManufacturingOrderHasLongText                                as OrderHasLongText,
      head.LongTextLanguageCode                                         as LongTextLanguageCode,

      // Attributes

      head.IsMarkedForDeletion,
      head.IsCompletelyDelivered,

      // Admin data

      @Semantics.systemDate.createdAt: true
      head.CreationDate,
      @Semantics.systemTime.createdAt: true
      head.CreationTime,
      @Semantics.user.createdBy: true
      head.CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      head.LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      head.LastChangeTime,
      @Semantics.user.lastChangedBy: true
      head.LastChangedByUser,

      // Header Material data

      head.Product,
      head.StorageLocation,
      head.Batch,

      // Asssignments

      head.ManufacturingOrderType                                as OrderType,
      cast(head.MfgOrderInternalID as pph_aufpl preserving type) as OrderInternalID,
      head.ReferenceOrder,
      head.LeadingOrder,
      head.SuperiorOrder,
      head.Currency,
      head.ProductionPlant,
      head.PlanningPlant,
      head.MRPController,
      head.ProductionSupervisor,
      head.ProductionSchedulingProfile,
      head.ResponsiblePlannerGroup,
      head.ProductionVersion,
      head.SalesOrder,
      head.SalesOrderItem,
      head.WBSElementInternalID_2 as WBSElementInternalID,
      head.Reservation,
      head.SettlementReservation,
      head.PlannedOrder,
      head.CapacityRequirement,
      head.InspectionLot,
      head.ChangeNumber,

      // Assignments BOO

      head.BillOfOperationsMaterial,
      head.BillOfOperationsType,
      head.BillOfOperationsGroup,
      head.BillOfOperationsVariant,
      head.BOOInternalVersionCounter,
      head.BillOfOperationsApplication,
      head.BillOfOperationsUsage,
      head.BillOfOperationsVersion,
      head.BOOExplosionDate,

      // Assignments BOM

      head.BillOfMaterialCategory,
      head.BillOfMaterialInternalID,
      head.BillOfMaterialVariant,
      head.BillOfMaterialVariantUsage,
      head.BillOfMaterialVersion,
      head.BOMExplosionDate,

      // Assignments FI/CO

      head.BusinessArea,
      head.CompanyCode,
      head.ControllingArea,
      head.ProfitCenter,
      head.CostCenter,
      head.CostElement,
      head.CostingSheet,
      head.GLAccount,
      head.ProductCostCollector,
      head.ActualCostsCostingVariant,
      head.PlannedCostsCostingVariant,
      head.ControllingObjectClass,
      head.FunctionalArea,
      head.EventBasedPostingMethod,

      // Dates and Times

      head.MfgOrderPlannedStartDate       as PlannedStartDate,
      head.MfgOrderPlannedStartTime       as PlannedStartTime,
      head.MfgOrderPlannedEndDate         as PlannedEndDate,
      head.MfgOrderPlannedEndTime         as PlannedEndTime,
      head.MfgOrderPlannedReleaseDate     as PlannedReleaseDate,
      head.MfgOrderScheduledStartDate     as ScheduledBasicStartDate,
      head.MfgOrderScheduledStartTime     as ScheduledBasicStartTime,
      head.MfgOrderScheduledEndDate       as ScheduledBasicEndDate,
      head.MfgOrderScheduledEndTime       as ScheduledBasicEndTime,
      head.MfgOrderScheduledReleaseDate   as ScheduledReleaseDate,
      head.MfgOrderActualStartDate        as ActualStartDate,
      head.MfgOrderActualStartTime        as ActualStartTime,
      head.MfgOrderActualEndDate          as ActualEndDate,
      head.MfgOrderActualReleaseDate      as ActualReleasedDate,
      head.MfgOrderConfirmedEndDate       as ConfirmedEndDate,
      head.MfgOrderConfirmedEndTime       as ConfirmedEndTime,
      head.MfgOrderActualCompletionDate   as TechnicalCompletionDate,
      head.MfgOrderItemActualDeliveryDate as ActualDeliveryDate, 

      // Quantities and UoM

      head.ProductionUnit,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.MfgOrderPlannedTotalQty    as OrderPlannedTotalQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.MfgOrderPlannedScrapQty    as OrderPlannedScrapQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.MfgOrderConfirmedYieldQty  as OrderConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.MfgOrderConfirmedScrapQty  as OrderConfirmedScrapQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.MfgOrderConfirmedReworkQty as OrderConfirmedReworkQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.ExpectedDeviationQuantity,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      head.ActualDeliveredQuantity,

      -- for DCLS purposes only
      @Consumption.hidden: true
      head.ManufacturingOrderCategory as OrderCategory,

      // Associations

      _ProductionOrderItem,
      _ProductionOrderSequence,
      _ProductionOrderOperation,
      _ProductionOrderComponent,
      _ProductionOrderProdnRsceTool,
      _ProductionOrderDocumentLink,
      head._CreatedByUser,
      head._LastChangedByUser,
      head._LongTextLanguage,
      head._ProductionUnit,
      head._Currency,
      head._OrderInternalID,
      head._BillOfOperationsMaterial,
      head._BillOfOperationsType,
      head._Reservation,
      head._SettlementReservation,
      head._ProductionPlant,
      head._PlanningPlant,
      head._Product,
      head._StorageLocation,
      head._MRPController,
      head._ProductionSupervisor,
      head._ProductionSchedulingProfile,
      head._ResponsiblePlannerGroup,
      head._CapacityRequirement,
      head._ChangeNumber  

}
where head.ManufacturingOrderCategory = '10';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSTYPE",
"I_CAPACITYREQUIREMENT",
"I_CHANGEMASTER",
"I_CURRENCY",
"I_LANGUAGE",
"I_MANUFACTURINGORDERCOMPONENT",
"I_MANUFACTURINGORDERITEM",
"I_MANUFACTURINGORDEROPERATION",
"I_MANUFACTURINGORDERSEQUENCE",
"I_MFGORDERDOCUMENTLINK",
"I_MFGORDEROPERATIONPRT",
"I_MRPCONTROLLER",
"I_ORDERINTERNALID",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTIONSCHEDULINGPROFILE",
"I_PRODUCTIONSUPERVISOR",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESPONSIBLEPLANNERGROUP",
"I_STORAGELOCATION",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_MANUFACTURINGORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/