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 128 fields with key fields OrderInternalID, OrderOperationInternalID. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ManufacturingOrderOperation | Operation | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_ProcessOrderComponentTP | _Component | _Component.ProcessOrder = $projection.ProcessOrder and _Component.OrderOperationInternalID = $projection.OrderOperationInternalID |
| [1..1] | E_ProcessOrderOperation | _Extension | _Extension.OrderInternalID = $projection.OrderInternalID and _Extension.OrderOperationInternalID = $projection.OrderOperationInternalID |
| [0..*] | R_ProcessOrderPhaseTP | _Phase | |
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 (128)
| 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 | ||||
| EmployeeWageType | EmployeeWageType | |||
| EmployeeWageGroup | EmployeeWageGroup | |||
| EmployeeSuitability | EmployeeSuitability | |||
| NumberOfTimeTickets | NumberOfTimeTickets | |||
| NumberOfEmployees | NumberOfEmployees | |||
| 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 | |||
| _Order | _Order | |||
| _Component | _Component | |||
| _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
association [0..*] to R_ProcessOrderComponentTP as _Component on _Component.ProcessOrder = $projection.ProcessOrder
and _Component.OrderOperationInternalID = $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,
// 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,
EmployeeWageType,
EmployeeWageGroup,
EmployeeSuitability,
NumberOfTimeTickets,
NumberOfEmployees,
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,
PurchaseOrderItem,
PurchasingInfoRecord,
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,
// OpErlstSchedldProcgStrtDte, //
// OpErlstSchedldProcgStrtTme,
// OpErlstSchedldTrdwnStrtDte,
// OpErlstSchedldTrdwnStrtTme,
OpErlstSchedldExecEndDte as ErlstSchedldExecEndDte,
OpErlstSchedldExecEndTme as ErlstSchedldExecEndTime,
OpLtstSchedldExecStrtDte as LtstSchedldExecStrtDte,
OpLtstSchedldExecStrtTme as LtstSchedldExecStrtTime,
// OpLtstSchedldProcgStrtDte,
// OpLtstSchedldProcgStrtTme,
// OpLtstSchedldTrdwnStrtDte,
// OpLtstSchedldTrdwnStrtTme,
OpLtstSchedldExecEndDte as LtstSchedldExecEndDte,
OpLtstSchedldExecEndTme as LtstSchedldExecEndTime,
// SchedldFcstdEarliestStartDate,
// SchedldFcstdEarliestStartTime,
// SchedldFcstdEarliestEndDate,
// SchedldFcstdEarliestEndTime,
// LatestSchedldFcstdStartDate,
// SchedldFcstdLatestStartTime,
// LatestSchedldFcstdEndDate,
// SchedldFcstdLatestEndTime,
// OperationConfirmedStartDate,
// OperationConfirmedEndDate,
OpActualExecutionStartDate as ActualExecutionStartDate,
OpActualExecutionStartTime as ActualExecutionStartTime,
// OpActualSetupEndDate,
// OpActualSetupEndTime,
OpActualProcessingStartDate as ActualProcessingStartDate,
OpActualProcessingStartTime as ActualProcessingStartTime,
OpActualProcessingEndDate as ActualProcessingEndDate,
OpActualProcessingEndTime as ActualProcessingEndTime,
// OpActualTeardownStartDate,
// OpActualTeardownStartTme,
OpActualExecutionEndDate as ActualExecutionEndDate,
OpActualExecutionEndTime as ActualExecutionEndTime,
// ActualForecastEndDate,
// ActualForecastEndTime,
// EarliestScheduledWaitStartDate,
// EarliestScheduledWaitStartTime,
// EarliestScheduledWaitEndDate,
// EarliestScheduledWaitEndTime,
// LatestScheduledWaitStartDate,
// LatestScheduledWaitStartTime,
// LatestScheduledWaitEndDate,
// LatestScheduledWaitEndTime,
// 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
_Order, // to-parent association
_Component,
@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