R_ProcessOrderConfirmationTP
Process Order Confirmation
R_ProcessOrderConfirmationTP is a Transactional CDS View that provides data about "Process Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfirmation) and exposes 96 fields with key fields ConfirmationGroup, ConfirmationCount. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderConfirmation | afru | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_OrderConfirmation | _Extension | $projection.ConfirmationGroup = _Extension.ConfirmationGroup and $projection.ConfirmationCount = _Extension.ConfirmationCount |
| [0..*] | R_ProcOrdConfMatlDocItemTP | _ProcOrdConfMatlDocItm | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Process Order Confirmation | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.sapObjectNodeType.name | ProcessOrderConfirmation | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (96)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConfirmationGroup | I_MfgOrderConfirmation | MfgOrderConfirmationGroup | |
| KEY | ConfirmationCount | I_MfgOrderConfirmation | MfgOrderConfirmation | |
| OrderID | I_MfgOrderConfirmation | ManufacturingOrder | Order | |
| OrderType | I_MfgOrderConfirmation | ManufacturingOrderType | ||
| OrderOperationInternalID | I_MfgOrderConfirmation | OrderOperationInternalID | ||
| ConfirmationText | I_MfgOrderConfirmation | ConfirmationText | ||
| Language | I_MfgOrderConfirmation | Language | Report Text Language | |
| Material | ||||
| OrderPlannedTotalQty | ||||
| ProductionUnit | ||||
| FinalConfirmationType | I_MfgOrderConfirmation | FinalConfirmationType | Final Confirmtn | |
| OpenReservationsIsCleared | I_MfgOrderConfirmation | OpenReservationsIsCleared | ||
| IsReversed | I_MfgOrderConfirmation | IsReversed | Reversed? | |
| IsReversal | I_MfgOrderConfirmation | IsReversal | Reversal doc. | |
| APIConfHasNoGoodsMovements | I_MfgOrderConfirmation | APIConfHasNoGoodsMovements | ||
| OrderConfirmationRecordType | I_MfgOrderConfirmation | OrderConfirmationRecordType | ||
| ConfirmationEntryDate | I_MfgOrderConfirmation | MfgOrderConfirmationEntryDate | ||
| ConfirmationEntryTime | I_MfgOrderConfirmation | MfgOrderConfirmationEntryTime | ||
| EnteredByUser | I_MfgOrderConfirmation | EnteredByUser | ||
| LastChangeDate | I_MfgOrderConfirmation | LastChangeDate | Time Stamp | |
| LastChangedByUser | I_MfgOrderConfirmation | LastChangedByUser | User Name | |
| ConfirmationExternalEntryDate | I_MfgOrderConfirmation | ConfirmationExternalEntryDate | ||
| ConfirmationExternalEntryTime | I_MfgOrderConfirmation | ConfirmationExternalEntryTime | ||
| EnteredByExternalUser | I_MfgOrderConfirmation | EnteredByExternalUser | ||
| ExternalSystemConfirmation | I_MfgOrderConfirmation | ExternalSystemConfirmation | ||
| Plant | I_MfgOrderConfirmation | Plant | Valuation Area | |
| WorkCenterTypeCode | I_MfgOrderConfirmation | WorkCenterTypeCode | Object Type | |
| WorkCenter | ||||
| Personnel | I_MfgOrderConfirmation | Personnel | Personnel No. | |
| TimeRecording | I_MfgOrderConfirmation | TimeRecording | ||
| EmployeeWageType | I_MfgOrderConfirmation | EmployeeWageType | Wage type | |
| EmployeeWageGroup | I_MfgOrderConfirmation | EmployeeWageGroup | Wage Group | |
| BreakDurationUnit | I_MfgOrderConfirmation | BreakDurationUnit | ||
| BreakDurationUnitISOCode | ||||
| BreakDurationUnitSAPCode | ||||
| ConfirmedBreakDuration | I_MfgOrderConfirmation | ConfirmedBreakDuration | ||
| EmployeeSuitability | I_MfgOrderConfirmation | EmployeeSuitability | ||
| NumberOfEmployees | I_MfgOrderConfirmation | NumberOfEmployees | No. employees | |
| PostingDate | I_MfgOrderConfirmation | PostingDate | Posting Date for GR | |
| ConfirmedExecutionStartDate | I_MfgOrderConfirmation | ConfirmedExecutionStartDate | ||
| ConfirmedExecutionStartTime | I_MfgOrderConfirmation | ConfirmedExecutionStartTime | ||
| ConfirmedSetupEndDate | I_MfgOrderConfirmation | ConfirmedSetupEndDate | ||
| ConfirmedSetupEndTime | I_MfgOrderConfirmation | ConfirmedSetupEndTime | ||
| ConfirmedProcessingStartDate | I_MfgOrderConfirmation | ConfirmedProcessingStartDate | ||
| ConfirmedProcessingStartTime | I_MfgOrderConfirmation | ConfirmedProcessingStartTime | ||
| ConfirmedProcessingEndDate | I_MfgOrderConfirmation | ConfirmedProcessingEndDate | ||
| ConfirmedProcessingEndTime | I_MfgOrderConfirmation | ConfirmedProcessingEndTime | ||
| ConfirmedTeardownStartDate | I_MfgOrderConfirmation | ConfirmedTeardownStartDate | ||
| ConfirmedTeardownStartTime | I_MfgOrderConfirmation | ConfirmedTeardownStartTime | ||
| ConfirmedExecutionEndDate | I_MfgOrderConfirmation | ConfirmedExecutionEndDate | ||
| ConfirmedExecutionEndTime | I_MfgOrderConfirmation | ConfirmedExecutionEndTime | ||
| ConfirmationUnit | I_MfgOrderConfirmation | ConfirmationUnit | ||
| ConfirmationUnitISOCode | ||||
| ConfirmationUnitSAPCode | ||||
| ConfirmationYieldQuantity | I_MfgOrderConfirmation | ConfirmationYieldQuantity | ||
| ConfirmationScrapQuantity | I_MfgOrderConfirmation | ConfirmationScrapQuantity | ||
| ConfirmationReworkQuantity | I_MfgOrderConfirmation | ConfirmationReworkQuantity | ||
| VarianceReasonCode | I_MfgOrderConfirmation | VarianceReasonCode | Reason | |
| OpWorkQuantityUnit1 | I_MfgOrderConfirmation | OpWorkQuantityUnit1 | ||
| WorkQuantityUnit1ISOCode | ||||
| WorkQuantityUnit1SAPCode | ||||
| OpConfirmedWorkQuantity1 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity1 | ||
| NoFurtherOpWorkQuantity1IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity1IsExpd | ||
| OpWorkQuantityUnit2 | I_MfgOrderConfirmation | OpWorkQuantityUnit2 | ||
| WorkQuantityUnit2ISOCode | ||||
| WorkQuantityUnit2SAPCode | ||||
| OpConfirmedWorkQuantity2 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity2 | ||
| NoFurtherOpWorkQuantity2IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity2IsExpd | ||
| OpWorkQuantityUnit3 | I_MfgOrderConfirmation | OpWorkQuantityUnit3 | ||
| WorkQuantityUnit3ISOCode | ||||
| WorkQuantityUnit3SAPCode | ||||
| OpConfirmedWorkQuantity3 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity3 | ||
| NoFurtherOpWorkQuantity3IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity3IsExpd | ||
| OpWorkQuantityUnit4 | I_MfgOrderConfirmation | OpWorkQuantityUnit4 | ||
| WorkQuantityUnit4ISOCode | ||||
| WorkQuantityUnit4SAPCode | ||||
| OpConfirmedWorkQuantity4 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity4 | ||
| NoFurtherOpWorkQuantity4IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity4IsExpd | ||
| OpWorkQuantityUnit5 | I_MfgOrderConfirmation | OpWorkQuantityUnit5 | ||
| WorkQuantityUnit5ISOCode | ||||
| WorkQuantityUnit5SAPCode | ||||
| OpConfirmedWorkQuantity5 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity5 | ||
| NoFurtherOpWorkQuantity5IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity5IsExpd | ||
| OpWorkQuantityUnit6 | I_MfgOrderConfirmation | OpWorkQuantityUnit6 | ||
| WorkQuantityUnit6ISOCode | ||||
| WorkQuantityUnit6SAPCode | ||||
| OpConfirmedWorkQuantity6 | I_MfgOrderConfirmation | OpConfirmedWorkQuantity6 | ||
| NoFurtherOpWorkQuantity6IsExpd | I_MfgOrderConfirmation | NoFurtherOpWorkQuantity6IsExpd | ||
| BusinessProcessEntryUnit | I_MfgOrderConfirmation | BusinessProcessEntryUnit | ||
| BusProcessEntrUnitISOCode | ||||
| BusProcessEntryUnitSAPCode | ||||
| BusinessProcessConfirmedQty | I_MfgOrderConfirmation | BusinessProcessConfirmedQty | ||
| NoFurtherBusinessProcQtyIsExpd | I_MfgOrderConfirmation | NoFurtherBusinessProcQtyIsExpd | ||
| ShiftGrouping | I_MfgOrderConfirmation | ShiftGrouping | Shift Grouping | |
| ShiftDefinition | I_MfgOrderConfirmation | ShiftDefinition | ||
| _ProcOrdConfMatlDocItm | _ProcOrdConfMatlDocItm |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view R_ProcessOrderConfirmationTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW R_ProcessOrderConfirmationTP AS
SELECT
afru.MfgOrderConfirmationGroup AS ConfirmationGroup,
afru.MfgOrderConfirmation AS ConfirmationCount,
afru.ManufacturingOrder AS OrderID,
afru.ManufacturingOrderType AS OrderType,
afru.OrderOperationInternalID AS OrderOperationInternalID,
afru.ConfirmationText AS ConfirmationText,
afru.Language AS Language,
afru._MfgOrder.Material AS Material,
afru._MfgOrder.MfgOrderPlannedTotalQty AS OrderPlannedTotalQty,
afru._MfgOrder.ProductionUnit AS ProductionUnit,
afru.FinalConfirmationType AS FinalConfirmationType,
afru.OpenReservationsIsCleared AS OpenReservationsIsCleared,
afru.IsReversed AS IsReversed,
afru.IsReversal AS IsReversal,
afru.APIConfHasNoGoodsMovements AS APIConfHasNoGoodsMovements,
afru.OrderConfirmationRecordType AS OrderConfirmationRecordType,
afru.MfgOrderConfirmationEntryDate AS ConfirmationEntryDate,
afru.MfgOrderConfirmationEntryTime AS ConfirmationEntryTime,
afru.EnteredByUser AS EnteredByUser,
afru.LastChangeDate AS LastChangeDate,
afru.LastChangedByUser AS LastChangedByUser,
afru.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
afru.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
afru.EnteredByExternalUser AS EnteredByExternalUser,
afru.ExternalSystemConfirmation AS ExternalSystemConfirmation,
afru.Plant AS Plant,
afru.WorkCenterTypeCode AS WorkCenterTypeCode,
afru._WorkCenter.WorkCenter AS WorkCenter,
afru.Personnel AS Personnel,
afru.TimeRecording AS TimeRecording,
afru.EmployeeWageType AS EmployeeWageType,
afru.EmployeeWageGroup AS EmployeeWageGroup,
afru.BreakDurationUnit AS BreakDurationUnit,
afru._BreakDurationUnit.UnitOfMeasureISOCode AS BreakDurationUnitISOCode,
afru._BreakDurationUnit.UnitOfMeasureSAPCode AS BreakDurationUnitSAPCode,
afru.ConfirmedBreakDuration AS ConfirmedBreakDuration,
afru.EmployeeSuitability AS EmployeeSuitability,
afru.NumberOfEmployees AS NumberOfEmployees,
afru.PostingDate AS PostingDate,
afru.ConfirmedExecutionStartDate AS ConfirmedExecutionStartDate,
afru.ConfirmedExecutionStartTime AS ConfirmedExecutionStartTime,
afru.ConfirmedSetupEndDate AS ConfirmedSetupEndDate,
afru.ConfirmedSetupEndTime AS ConfirmedSetupEndTime,
afru.ConfirmedProcessingStartDate AS ConfirmedProcessingStartDate,
afru.ConfirmedProcessingStartTime AS ConfirmedProcessingStartTime,
afru.ConfirmedProcessingEndDate AS ConfirmedProcessingEndDate,
afru.ConfirmedProcessingEndTime AS ConfirmedProcessingEndTime,
afru.ConfirmedTeardownStartDate AS ConfirmedTeardownStartDate,
afru.ConfirmedTeardownStartTime AS ConfirmedTeardownStartTime,
afru.ConfirmedExecutionEndDate AS ConfirmedExecutionEndDate,
afru.ConfirmedExecutionEndTime AS ConfirmedExecutionEndTime,
afru.ConfirmationUnit AS ConfirmationUnit,
afru._ConfirmationUnit.UnitOfMeasureISOCode AS ConfirmationUnitISOCode,
afru._ConfirmationUnit.UnitOfMeasureSAPCode AS ConfirmationUnitSAPCode,
afru.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
afru.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
afru.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
afru.VarianceReasonCode AS VarianceReasonCode,
afru.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
afru._WorkQuantityUnit1.UnitOfMeasureISOCode AS WorkQuantityUnit1ISOCode,
afru._WorkQuantityUnit1.UnitOfMeasureSAPCode AS WorkQuantityUnit1SAPCode,
afru.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
afru.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
afru.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
afru._WorkQuantityUnit2.UnitOfMeasureISOCode AS WorkQuantityUnit2ISOCode,
afru._WorkQuantityUnit2.UnitOfMeasureSAPCode AS WorkQuantityUnit2SAPCode,
afru.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
afru.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
afru.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
afru._WorkQuantityUnit3.UnitOfMeasureISOCode AS WorkQuantityUnit3ISOCode,
afru._WorkQuantityUnit3.UnitOfMeasureSAPCode AS WorkQuantityUnit3SAPCode,
afru.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
afru.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
afru.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
afru._WorkQuantityUnit4.UnitOfMeasureISOCode AS WorkQuantityUnit4ISOCode,
afru._WorkQuantityUnit4.UnitOfMeasureSAPCode AS WorkQuantityUnit4SAPCode,
afru.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
afru.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
afru.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
afru._WorkQuantityUnit5.UnitOfMeasureISOCode AS WorkQuantityUnit5ISOCode,
afru._WorkQuantityUnit5.UnitOfMeasureSAPCode AS WorkQuantityUnit5SAPCode,
afru.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
afru.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
afru.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
afru._WorkQuantityUnit6.UnitOfMeasureISOCode AS WorkQuantityUnit6ISOCode,
afru._WorkQuantityUnit6.UnitOfMeasureSAPCode AS WorkQuantityUnit6SAPCode,
afru.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
afru.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
afru.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
afru._BusinessProcessUnit.UnitOfMeasureISOCode AS BusProcessEntrUnitISOCode,
afru._BusinessProcessUnit.UnitOfMeasureSAPCode AS BusProcessEntryUnitSAPCode,
afru.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
afru.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
afru.ShiftGrouping AS ShiftGrouping,
afru.ShiftDefinition AS ShiftDefinition
FROM I_MfgOrderConfirmation AS afru
LEFT OUTER JOIN E_OrderConfirmation AS _Extension ON ConfirmationGroup = _Extension.ConfirmationGroup AND ConfirmationCount = _Extension.ConfirmationCount -- association [1..1]
LEFT OUTER JOIN R_ProcOrdConfMatlDocItemTP AS _ProcOrdConfMatlDocItm ON /* condition not available in parsed metadata */ -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA