R_ProcessOrderOperationTP
Process Order Operation - TP
R_ProcessOrderOperationTP is a Transactional CDS View that provides data about "Process Order Operation - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderOperation) and exposes 130 fields with key fields OrderInternalID, OrderOperationInternalID. It has 5 associations to related views. Part of development package PP_PROCESSORDER_RAP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ManufacturingOrderOperation | Operation | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_ProcessOrderComponentTP | _Component | _Component.ProcessOrder = $projection.ProcessOrder and _Component.OrderOperationInternalID = $projection.OrderOperationInternalID |
| [0..*] | R_ProcessOrderPhaseCapacityTP | _PhaseCapacity | _PhaseCapacity.OrderInternalID = $projection.OrderInternalID and _PhaseCapacity.SuperiorOperationIntIDOfPhase = $projection.OrderOperationInternalID |
| [1..1] | E_ProcessOrderOperation | _Extension | _Extension.OrderInternalID = $projection.OrderInternalID and _Extension.OrderOperationInternalID = $projection.OrderOperationInternalID |
| [0..*] | R_ProcessOrderPhaseTP | _Phase | |
| [0..*] | R_ProcOrdOperationCapacityTP | _OperationCapacity | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| EndUserText.label | Process Order Operation - TP | view |
Fields (130)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderInternalID | MfgOrderInternalID | ||
| KEY | OrderOperationInternalID | OrderOperationInternalID | ||
| ProcessOrder | ||||
| ProcessOrderSequence | ||||
| ProcessOrderOperation | ||||
| OperationText | ||||
| OperationStandardTextCode | OperationStandardTextCode | |||
| OperationHasLongText | OperationHasLongText | |||
| LongTextLanguage | Language | |||
| OperationIsToBeDeleted | OperationIsToBeDeleted | |||
| Plant | Plant | |||
| ProductionResource | ||||
| ProductionResourceInternalID | WorkCenterInternalID | |||
| OperationControlProfile | OperationControlProfile | |||
| FactoryCalendar | FactoryCalendar | |||
| ConfirmationGroup | OperationConfirmation | |||
| NumberOfOperationConfirmations | NumberOfOperationConfirmations | |||
| NumberOfCapacities | NumberOfCapacities | |||
| ChangeNumber | ChangeNumber | |||
| ObjectInternalID | ObjectInternalID | |||
| Reservation | _Order | Reservation | ||
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | |||
| CostElement | ||||
| EmployeeSuitability | EmployeeSuitability | |||
| EmployeeWageType | EmployeeWageType | |||
| EmployeeWageGroup | EmployeeWageGroup | |||
| NumberOfEmployees | NumberOfEmployees | |||
| NumberOfTimeTickets | NumberOfTimeTickets | |||
| OperationSetupGroupCategory | OperationSetupGroupCategory | |||
| OperationSetupGroup | OperationSetupGroup | |||
| OperationSetupType | OperationSetupType | |||
| BillOfOperationsType | BillOfOperationsType | |||
| MasterRecipeGroup | BillOfOperationsGroup | |||
| MasterRecipe | BillOfOperationsVariant | |||
| MasterRecipeOperationIntID | BOOOperationInternalID | |||
| ExtProcgOperationHasSubcontrg | ExtProcgOperationHasSubcontrg | |||
| PurchasingOrganization | PurchasingOrganization | |||
| PurchasingGroup | PurchasingGroup | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| PurchaseOrder | PurchaseOrder | |||
| PurchaseOrderItem | PurchaseOrderItem | |||
| PurchasingInfoRecord | PurchasingInfoRecord | |||
| PurgInfoRecdDataIsFixed | PurgInfoRecdDataIsFixed | |||
| PurchasingInfoRecordCategory | PurchasingInfoRecordCategory | |||
| Supplier | Supplier | |||
| GoodsRecipientName | GoodsRecipientName | |||
| UnloadingPointName | UnloadingPointName | |||
| MaterialGroup | MaterialGroup | |||
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | |||
| OpExternalProcessingPrice | OpExternalProcessingPrice | |||
| NumberOfOperationPriceUnits | NumberOfOperationPriceUnits | |||
| CompanyCode | CompanyCode | |||
| BusinessArea | BusinessArea | |||
| ProfitCenter | ProfitCenter | |||
| RequestingCostCenter | RequestingCostCenter | |||
| CostingVariant | CostingVariant | |||
| CostingSheet | CostingSheet | |||
| FunctionalArea | FunctionalArea | |||
| ErlstSchedldExecStrtDte | OpErlstSchedldExecStrtDte | |||
| ErlstSchedldExecStrtTime | OpErlstSchedldExecStrtTme | |||
| ErlstSchedldExecEndDte | OpErlstSchedldExecEndDte | |||
| ErlstSchedldExecEndTime | OpErlstSchedldExecEndTme | |||
| LtstSchedldExecStrtDte | OpLtstSchedldExecStrtDte | |||
| LtstSchedldExecStrtTime | OpLtstSchedldExecStrtTme | |||
| LtstSchedldExecEndDte | OpLtstSchedldExecEndDte | |||
| LtstSchedldExecEndTime | OpLtstSchedldExecEndTme | |||
| ActualExecutionStartDate | OpActualExecutionStartDate | |||
| ActualExecutionStartTime | OpActualExecutionStartTime | |||
| ActualProcessingStartDate | OpActualProcessingStartDate | |||
| ActualProcessingStartTime | OpActualProcessingStartTime | |||
| ActualProcessingEndDate | OpActualProcessingEndDate | |||
| ActualProcessingEndTime | OpActualProcessingEndTime | |||
| ActualExecutionEndDate | OpActualExecutionEndDate | |||
| ActualExecutionEndTime | OpActualExecutionEndTime | |||
| StandardWorkQuantity1 | WorkCenterStandardWorkQty1 | |||
| CostCtrActivityType1 | CostCtrActivityType1 | |||
| StandardWorkQuantityUnit2 | WorkCenterStandardWorkQtyUnit2 | |||
| StandardWorkQuantity2 | WorkCenterStandardWorkQty2 | |||
| CostCtrActivityType2 | CostCtrActivityType2 | |||
| StandardWorkQuantityUnit3 | WorkCenterStandardWorkQtyUnit3 | |||
| StandardWorkQuantity3 | WorkCenterStandardWorkQty3 | |||
| CostCtrActivityType3 | CostCtrActivityType3 | |||
| StandardWorkQuantityUnit4 | WorkCenterStandardWorkQtyUnit4 | |||
| StandardWorkQuantity4 | WorkCenterStandardWorkQty4 | |||
| CostCtrActivityType4 | CostCtrActivityType4 | |||
| StandardWorkQuantityUnit5 | WorkCenterStandardWorkQtyUnit5 | |||
| StandardWorkQuantity5 | WorkCenterStandardWorkQty5 | |||
| CostCtrActivityType5 | CostCtrActivityType5 | |||
| StandardWorkQuantityUnit6 | WorkCenterStandardWorkQtyUnit6 | |||
| StandardWorkQuantity6 | WorkCenterStandardWorkQty6 | |||
| CostCtrActivityType6 | CostCtrActivityType6 | |||
| OperationUnit | OperationUnit | |||
| OpQtyToBaseQtyDnmntr | OpQtyToBaseQtyDnmntr | |||
| OpQtyToBaseQtyNmrtr | OpQtyToBaseQtyNmrtr | |||
| OperationReferenceQuantity | OperationReferenceQuantity | |||
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | |||
| OpPlannedScrapQuantity | OpPlannedScrapQuantity | |||
| OpTotalConfirmedScrapQty | OpTotalConfirmedScrapQty | |||
| WorkQuantityUnit1 | OpWorkQuantityUnit1 | |||
| ConfirmedWorkQuantity1 | OpConfirmedWorkQuantity1 | |||
| NoFurtherWorkQuantity1IsExpd | NoFurtherOpWorkQuantity1IsExpd | |||
| WorkQuantityUnit2 | OpWorkQuantityUnit2 | |||
| ConfirmedWorkQuantity2 | OpConfirmedWorkQuantity2 | |||
| NoFurtherWorkQuantity2IsExpd | NoFurtherOpWorkQuantity2IsExpd | |||
| WorkQuantityUnit3 | OpWorkQuantityUnit3 | |||
| ConfirmedWorkQuantity3 | OpConfirmedWorkQuantity3 | |||
| NoFurtherWorkQuantity3IsExpd | NoFurtherOpWorkQuantity3IsExpd | |||
| WorkQuantityUnit4 | OpWorkQuantityUnit4 | |||
| ConfirmedWorkQuantity4 | OpConfirmedWorkQuantity4 | |||
| NoFurtherWorkQuantity4IsExpd | NoFurtherOpWorkQuantity4IsExpd | |||
| WorkQuantityUnit5 | OpWorkQuantityUnit5 | |||
| ConfirmedWorkQuantity5 | OpConfirmedWorkQuantity5 | |||
| NoFurtherWorkQuantity5IsExpd | NoFurtherOpWorkQuantity5IsExpd | |||
| WorkQuantityUnit6 | OpWorkQuantityUnit6 | |||
| ConfirmedWorkQuantity6 | OpConfirmedWorkQuantity6 | |||
| NoFurtherWorkQuantity6IsExpd | NoFurtherOpWorkQuantity6IsExpd | |||
| BusinessProcess | ||||
| BusinessProcessEntryUnit | BusinessProcessEntryUnit | |||
| BusinessProcessConfirmedQty | BusinessProcessConfirmedQty | |||
| NoFurtherBusinessProcQtyIsExpd | NoFurtherBusinessProcQtyIsExpd | |||
| BusinessProcRemainingQtyUnit | BusinessProcRemainingQtyUnit | |||
| BusinessProcessRemainingQty | BusinessProcessRemainingQty | |||
| _Phase | _Phase | |||
| _OperationCapacity | _OperationCapacity | |||
| _Order | _Order | |||
| _Component | _Component | |||
| _PhaseCapacity | _PhaseCapacity | |||
| _Supplier | _Supplier | |||
| _SupplierCompanyByPlant | _SupplierCompanyByPlant |
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Process Order Operation - TP'
// ************************ DO NOT USE ************************
// * This RAP BO is for testing purpose only *
// **************************************************************
define view entity R_ProcessOrderOperationTP
as select from I_ManufacturingOrderOperation as Operation
association to parent R_ProcessOrderTP as _Order on _Order.ProcessOrder = $projection.ProcessOrder
// BO relation
composition [0..*] of R_ProcessOrderPhaseTP as _Phase
composition [0..*] of R_ProcOrdOperationCapacityTP as _OperationCapacity
association [0..*] to R_ProcessOrderComponentTP as _Component on _Component.ProcessOrder = $projection.ProcessOrder
and _Component.OrderOperationInternalID = $projection.OrderOperationInternalID
association [0..*] to R_ProcessOrderPhaseCapacityTP as _PhaseCapacity on _PhaseCapacity.OrderInternalID = $projection.OrderInternalID
and _PhaseCapacity.SuperiorOperationIntIDOfPhase = $projection.OrderOperationInternalID
// Extension
association [1..1] to E_ProcessOrderOperation as _Extension on _Extension.OrderInternalID = $projection.OrderInternalID
and _Extension.OrderOperationInternalID = $projection.OrderOperationInternalID
{
// Technical Key
key MfgOrderInternalID as OrderInternalID,
key OrderOperationInternalID,
// Semantic Key
cast(ManufacturingOrder as co_bord preserving type) as ProcessOrder,
@Consumption.hidden: true
cast(ManufacturingOrderSequence as plnfolge preserving type) as ProcessOrderSequence,
cast(ManufacturingOrderOperation_2 as vdm_vornr preserving type) as ProcessOrderOperation,
// cast(ManufacturingOrdSubOperation_2 as vdm_uvorn preserving type) as SecondaryResource,
// Text
cast(MfgOrderOperationText as ltxa1 preserving type) as OperationText,
OperationStandardTextCode,
OperationHasLongText,
Language as LongTextLanguage,
// Attributes
OperationIsToBeDeleted, // not changeable - deprecate/remove in subsequent version
// OperationImportance, // not relevant for PP orders - only for PS
// Assignments
Plant,
cast(_WorkCenter.WorkCenter as cr_resourc preserving type) as ProductionResource,
@Consumption.hidden: true
WorkCenterInternalID as ProductionResourceInternalID,
// @Consumption.hidden: true
// WorkCenterTypeCode_2 as ProductionResourceType,
OperationControlProfile,
FactoryCalendar,
OperationConfirmation as ConfirmationGroup,
NumberOfOperationConfirmations,
NumberOfCapacities,
// CapacityRequirement,
// CapacityRequirementItem,
ChangeNumber,
ObjectInternalID,
_Order.Reservation as Reservation,
NumberOfConfirmationSlips,
cast(CostElement as kstar preserving type) as CostElement,
EmployeeSuitability, // not changeable - deprecate/remove in subsequent version
EmployeeWageType, // not changeable - deprecate/remove in subsequent version
EmployeeWageGroup, // not changeable - deprecate/remove in subsequent version
NumberOfEmployees, // not changeable - deprecate/remove in subsequent version
NumberOfTimeTickets,
OperationSetupGroupCategory,
OperationSetupGroup,
OperationSetupType,
// OperationSplitIsRequired,
// MaximumNumberOfSplits,
// Assignment Master Recipe
@Consumption.hidden: true
BillOfOperationsType,
BillOfOperationsGroup as MasterRecipeGroup,
BillOfOperationsVariant as MasterRecipe,
// @Consumption.hidden: true
// BillOfOperationsSequence,
BOOOperationInternalID as MasterRecipeOperationIntID,
// External processing
@Semantics.booleanIndicator
ExtProcgOperationHasSubcontrg,
PurchasingOrganization,
PurchasingGroup,
PurchaseRequisition,
PurchaseRequisitionItem,
PurchaseOrder, // not changeable - deprecate/remove in subsequent version
PurchaseOrderItem, // not changeable - deprecate/remove in subsequent version
PurchasingInfoRecord, // only for phase - readonly
PurgInfoRecdDataIsFixed,
PurchasingInfoRecordCategory,
Supplier,
GoodsRecipientName,
UnloadingPointName,
MaterialGroup,
OpExternalProcessingCurrency,
@Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
OpExternalProcessingPrice,
NumberOfOperationPriceUnits,
// Assignments CO
CompanyCode,
BusinessArea,
// ControllingArea,
ProfitCenter,
RequestingCostCenter,
CostingVariant,
CostingSheet,
FunctionalArea,
// Dates and times
OpErlstSchedldExecStrtDte as ErlstSchedldExecStrtDte,
OpErlstSchedldExecStrtTme as ErlstSchedldExecStrtTime,
OpErlstSchedldExecEndDte as ErlstSchedldExecEndDte,
OpErlstSchedldExecEndTme as ErlstSchedldExecEndTime,
OpLtstSchedldExecStrtDte as LtstSchedldExecStrtDte,
OpLtstSchedldExecStrtTme as LtstSchedldExecStrtTime,
OpLtstSchedldExecEndDte as LtstSchedldExecEndDte,
OpLtstSchedldExecEndTme as LtstSchedldExecEndTime,
OpActualExecutionStartDate as ActualExecutionStartDate,
OpActualExecutionStartTime as ActualExecutionStartTime,
OpActualProcessingStartDate as ActualProcessingStartDate,
OpActualProcessingStartTime as ActualProcessingStartTime,
OpActualProcessingEndDate as ActualProcessingEndDate,
OpActualProcessingEndTime as ActualProcessingEndTime,
OpActualExecutionEndDate as ActualExecutionEndDate,
OpActualExecutionEndTime as ActualExecutionEndTime,
// BreakDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'BreakDurationUnit'
// PlannedBreakDuration,
// @Semantics.quantity.unitOfMeasure: 'BreakDurationUnit'
// ConfirmedBreakDuration,
// OverlapMinimumDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'
// OverlapMinimumDuration,
// MaximumWaitDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'
// MaximumWaitDuration,
// MinimumWaitDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'
// MinimumWaitDuration,
// StandardMoveDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'
// StandardMoveDuration,
// StandardQueueDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'
// StandardQueueDuration,
// MinimumQueueDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
// MinimumQueueDuration,
// MinimumMoveDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
// MinimumMoveDuration,
// @Semantics.quantity.unitOfMeasure: 'OperationStandardDurationUnit'
// OperationStandardDuration,
// OperationStandardDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'MinimumDurationUnit'
// MinimumDuration,
// MinimumDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'ScheduledMoveDurationUnit'
// ScheduledMoveDuration,
// ScheduledMoveDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'ScheduledQueueDurationUnit'
// ScheduledQueueDuration,
// ScheduledQueueDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'ScheduledWaitDurationUnit'
// ScheduledWaitDuration,
// ScheduledWaitDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'OpPlannedSetupDurnUnit'
// OpPlannedSetupDurn,
// OpPlannedSetupDurnUnit,
// @Semantics.quantity.unitOfMeasure: 'OpPlannedProcessingDurnUnit'
// OpPlannedProcessingDurn,
// OpPlannedProcessingDurnUnit,
// @Semantics.quantity.unitOfMeasure: 'OpPlannedTeardownDurnUnit'
// OpPlannedTeardownDurn,
// OpPlannedTeardownDurnUnit,
// StartDateOffsetReferenceCode,
// StartDateOffsetDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
// StartDateOffsetDuration,
// EndDateOffsetReferenceCode,
// EndDateOffsetDurationUnit,
// @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
// EndDateOffsetDuration,
-- Standard Values and activities / required on PI operation level? --
WorkCenterStandardWorkQtyUnit1 as StandardWorkQuantityUnit1,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1' //'WorkCenterStandardWorkQtyUnit1'
WorkCenterStandardWorkQty1 as StandardWorkQuantity1,
CostCtrActivityType1,
WorkCenterStandardWorkQtyUnit2 as StandardWorkQuantityUnit2,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2' //'WorkCenterStandardWorkQtyUnit2'
WorkCenterStandardWorkQty2 as StandardWorkQuantity2,
CostCtrActivityType2,
WorkCenterStandardWorkQtyUnit3 as StandardWorkQuantityUnit3,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3' //'WorkCenterStandardWorkQtyUnit3'
WorkCenterStandardWorkQty3 as StandardWorkQuantity3,
CostCtrActivityType3,
WorkCenterStandardWorkQtyUnit4 as StandardWorkQuantityUnit4,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4' //'WorkCenterStandardWorkQtyUnit4'
WorkCenterStandardWorkQty4 as StandardWorkQuantity4,
CostCtrActivityType4,
WorkCenterStandardWorkQtyUnit5 as StandardWorkQuantityUnit5,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5' //'WorkCenterStandardWorkQtyUnit5'
WorkCenterStandardWorkQty5 as StandardWorkQuantity5,
CostCtrActivityType5,
WorkCenterStandardWorkQtyUnit6 as StandardWorkQuantityUnit6,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6' //'WorkCenterStandardWorkQtyUnit6'
WorkCenterStandardWorkQty6 as StandardWorkQuantity6,
CostCtrActivityType6,
// Quantities and UoM
OperationUnit,
OpQtyToBaseQtyDnmntr,
OpQtyToBaseQtyNmrtr,
// phase scrap only per MQC
// OperationScrapPercent,
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
OperationReferenceQuantity,
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
OpPlannedTotalQuantity,
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
OpPlannedScrapQuantity,
-- Confirmed Work Quantities --
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
OpTotalConfirmedYieldQty,
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
OpTotalConfirmedScrapQty,
OpWorkQuantityUnit1 as WorkQuantityUnit1,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit1' //'OpWorkQuantityUnit1'
OpConfirmedWorkQuantity1 as ConfirmedWorkQuantity1,
NoFurtherOpWorkQuantity1IsExpd as NoFurtherWorkQuantity1IsExpd,
OpWorkQuantityUnit2 as WorkQuantityUnit2,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit2' //'OpWorkQuantityUnit2'
OpConfirmedWorkQuantity2 as ConfirmedWorkQuantity2,
NoFurtherOpWorkQuantity2IsExpd as NoFurtherWorkQuantity2IsExpd,
OpWorkQuantityUnit3 as WorkQuantityUnit3,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit3' //'OpWorkQuantityUnit3'
OpConfirmedWorkQuantity3 as ConfirmedWorkQuantity3,
NoFurtherOpWorkQuantity3IsExpd as NoFurtherWorkQuantity3IsExpd,
OpWorkQuantityUnit4 as WorkQuantityUnit4,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit4' //'OpWorkQuantityUnit4'
OpConfirmedWorkQuantity4 as ConfirmedWorkQuantity4,
NoFurtherOpWorkQuantity4IsExpd as NoFurtherWorkQuantity4IsExpd,
OpWorkQuantityUnit5 as WorkQuantityUnit5,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit5' //'OpWorkQuantityUnit5'
OpConfirmedWorkQuantity5 as ConfirmedWorkQuantity5,
NoFurtherOpWorkQuantity5IsExpd as NoFurtherWorkQuantity5IsExpd,
OpWorkQuantityUnit6 as WorkQuantityUnit6,
@Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit6' //'OpWorkQuantityUnit6'
OpConfirmedWorkQuantity6 as ConfirmedWorkQuantity6,
NoFurtherOpWorkQuantity6IsExpd as NoFurtherWorkQuantity6IsExpd,
// Business process
cast(BusinessProcess as co_prznr preserving type) as BusinessProcess,
BusinessProcessEntryUnit,
@Semantics.quantity.unitOfMeasure: 'BusinessProcessEntryUnit'
BusinessProcessConfirmedQty,
NoFurtherBusinessProcQtyIsExpd,
BusinessProcRemainingQtyUnit,
@Semantics.quantity.unitOfMeasure: 'BusinessProcRemainingQtyUnit'
BusinessProcessRemainingQty,
// relations
_Phase, // composition
_OperationCapacity, // composition
_Order, // to-parent association
_Component,
_PhaseCapacity,
@Consumption.hidden: true
_Supplier, // for DCLS
@Consumption.hidden: true
_SupplierCompanyByPlant // for DCLS
}
where
ManufacturingOrderCategory = '40'
and MfgOrderOperationIsPhase is initial // no phases
and ManufacturingOrdSubOperation_2 is initial // no secondary resources
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA