R_ProcessOrderComponentTP
Process Order Component - TP
R_ProcessOrderComponentTP is a Transactional CDS View that provides data about "Process Order Component - TP" in SAP S/4HANA. It reads from 2 data sources (I_ManufacturingOrderComponent, I_OrderOperationBasic) and exposes 127 fields with key fields Reservation, ReservationItem, ReservationRecordType. It has 3 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ManufacturingOrderComponent | Component | from |
| I_OrderOperationBasic | Operation | inner |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_ProcessOrderPhaseTP | _Phase | _Phase.ProcessOrder = $projection.ProcessOrder and _Phase.OrderPhaseInternalID = $projection.OrderPhaseInternalID |
| [0..1] | R_ProcessOrderOperationTP | _Operation | _Operation.ProcessOrder = $projection.ProcessOrder and _Operation.OrderOperationInternalID = $projection.OrderOperationInternalID |
| [1..1] | E_ProcessOrderComponent | _Extension | $projection.Reservation = _Extension.Reservation and $projection.ReservationItem = _Extension.ReservationItem and $projection.ReservationRecordType = _Extension.ReservationRecordType |
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 | #MIXED | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| EndUserText.label | Process Order Component - TP | view |
Fields (127)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Reservation | I_ManufacturingOrderComponent | Reservation | Reservation |
| KEY | ReservationItem | I_ManufacturingOrderComponent | ReservationItem | Reservation Item |
| KEY | ReservationRecordType | I_ManufacturingOrderComponent | ReservationRecordType | Record type |
| MaterialGroup | ||||
| Material | ||||
| Plant | ||||
| ProcessOrder | ||||
| ProcessOrderPhase | ||||
| ProcessOrderOperation | ||||
| OrderInternalID | I_ManufacturingOrderComponent | OrderInternalID | Plan No.f.Oper. | |
| OrderPhaseInternalID | ||||
| OrderOperationInternalID | ||||
| MatlCompRequirementDate | I_ManufacturingOrderComponent | MatlCompRequirementDate | Reqmts date | |
| MatlCompRequirementTime | I_ManufacturingOrderComponent | MatlCompRequirementTime | ||
| LatestRequirementDate | I_ManufacturingOrderComponent | LatestRequirementDate | Latest Requirement Date | |
| ReservationItemCreationCode | I_ManufacturingOrderComponent | ReservationItemCreationCode | Reserv. status | |
| ReservationIsFinallyIssued | I_ManufacturingOrderComponent | ReservationIsFinallyIssued | Res Final Issue | |
| MatlCompIsMarkedForDeletion | I_ManufacturingOrderComponent | MatlCompIsMarkedForDeletion | ||
| MaterialComponentIsMissing | I_ManufacturingOrderComponent | MaterialComponentIsMissing | ||
| IsBulkMaterialComponent | I_ManufacturingOrderComponent | IsBulkMaterialComponent | Bulk material | |
| MatlCompIsMarkedForBackflush | I_ManufacturingOrderComponent | MatlCompIsMarkedForBackflush | Backflush | |
| MatlCompIsTextItem | I_ManufacturingOrderComponent | MatlCompIsTextItem | ||
| MaterialPlanningRelevance | I_ManufacturingOrderComponent | MaterialPlanningRelevance | ||
| MatlCompIsConfigurable | I_ManufacturingOrderComponent | MatlCompIsConfigurable | ||
| MaterialCompCostingRelevancy | I_ManufacturingOrderComponent | MaterialCompCostingRelevancy | CostingRelevncy | |
| MaterialComponentIsClassified | I_ManufacturingOrderComponent | MaterialComponentIsClassified | ||
| MaterialCompIsIntraMaterial | I_ManufacturingOrderComponent | MaterialCompIsIntraMaterial | ||
| MaterialIsDirectlyProduced | I_ManufacturingOrderComponent | MaterialIsDirectlyProduced | ||
| MaterialIsDirectlyProcured | I_ManufacturingOrderComponent | MaterialIsDirectlyProcured | ||
| LongTextLanguage | I_ManufacturingOrderComponent | LongTextLanguage | Long Text Lang | |
| MaterialComponentHasLongText | I_ManufacturingOrderComponent | MaterialComponentHasLongText | ||
| RequirementType | I_ManufacturingOrderComponent | RequirementType | RequirementType | |
| SalesOrder | I_ManufacturingOrderComponent | SalesOrder | SD Document | |
| SalesOrderItem | I_ManufacturingOrderComponent | SalesOrderItem | Sales Order Item | |
| WBSElementInternalID | I_ManufacturingOrderComponent | WBSElementInternalID | WBS Internal ID | |
| ProductConfiguration | I_ManufacturingOrderComponent | ProductConfiguration | ||
| ChangeNumber | I_ManufacturingOrderComponent | ChangeNumber | Change Number | |
| EffectivityParameterVariant | I_ManufacturingOrderComponent | EffectivityParameterVariant | ||
| MatlCompFreeDefinedAttribute | I_ManufacturingOrderComponent | MatlCompFreeDefinedAttribute | Sort String | |
| BillOfMaterialCategory | I_ManufacturingOrderComponent | BillOfMaterialCategory | BOM category | |
| BillOfMaterialInternalID | I_ManufacturingOrderComponent | BillOfMaterialInternalID | ||
| BillOfMaterialVariant | I_ManufacturingOrderComponent | BillOfMaterialVariant | AlternativeBOM | |
| BillOfMaterialItemNodeNumber | I_ManufacturingOrderComponent | BillOfMaterialItemNodeNumber | Item node | |
| BillOfMaterialVersion | I_ManufacturingOrderComponent | BillOfMaterialVersion | BOM Version | |
| BOMItemInternalChangeCount | I_ManufacturingOrderComponent | BOMItemInternalChangeCount | Counter | |
| InheritedBOMItemNode | I_ManufacturingOrderComponent | InheritedBOMItemNode | ||
| BillOfMaterialItemCategory | I_ManufacturingOrderComponent | BillOfMaterialItemCategory | Item Category | |
| BillOfMaterialItemNumber | I_ManufacturingOrderComponent | BillOfMaterialItemNumber | Item | |
| MaterialComponentText | I_ManufacturingOrderComponent | MaterialComponentText | ||
| MaterialComponentSecondText | I_ManufacturingOrderComponent | MaterialComponentSecondText | ||
| BOMExplosionDateID | I_ManufacturingOrderComponent | BOMExplosionDateID | ||
| PurchasingInfoRecord | I_ManufacturingOrderComponent | PurchasingInfoRecord | Info Record | |
| PurchasingGroup | I_ManufacturingOrderComponent | PurchasingGroup | Purchasing Group | |
| PurchaseRequisition | I_ManufacturingOrderComponent | PurchaseRequisition | Requisition | |
| PurchaseRequisitionItem | I_ManufacturingOrderComponent | PurchaseRequisitionItem | Requisn. item | |
| PurchaseOrder | I_ManufacturingOrderComponent | PurchaseOrder | Purchasing Document | |
| PurchaseOrderItem | I_ManufacturingOrderComponent | PurchaseOrderItem | Purchasing Document Item | |
| Supplier | I_ManufacturingOrderComponent | Supplier | Supplier | |
| DeliveryDurationInDays | I_ManufacturingOrderComponent | DeliveryDurationInDays | Del time (days) | |
| MaterialGoodsReceiptDuration | I_ManufacturingOrderComponent | MaterialGoodsReceiptDuration | GR proc. time | |
| ExternalProcessingPrice | ||||
| NumberOfPriceUnits | I_ManufacturingOrderComponent | NumberOfOperationPriceUnits | Price Unit | |
| GoodsMovementIsAllowed | I_ManufacturingOrderComponent | GoodsMovementIsAllowed | Mvt Allowed | |
| StorageLocation | I_ManufacturingOrderComponent | StorageLocation | StorageLocation | |
| Batch | ||||
| BatchSplitType | I_ManufacturingOrderComponent | BatchSplitType | ||
| DebitCreditCode | I_ManufacturingOrderComponent | DebitCreditCode | Single-Character Flag | |
| GoodsMovementType | I_ManufacturingOrderComponent | GoodsMovementType | Movement Type | |
| InventorySpecialStockType | I_ManufacturingOrderComponent | InventorySpecialStockType | Special Stock Type | |
| InventorySpecialStockValnType | I_ManufacturingOrderComponent | InventorySpecialStockValnType | Valuation | |
| ConsumptionPosting | I_ManufacturingOrderComponent | ConsumptionPosting | Consumption Posting | |
| SupplyArea | I_ManufacturingOrderComponent | SupplyArea | Supply Area | |
| GoodsRecipientName | I_ManufacturingOrderComponent | GoodsRecipientName | Recipient Name | |
| UnloadingPointName | I_ManufacturingOrderComponent | UnloadingPointName | Unloading Point Name | |
| StockSegment | I_ManufacturingOrderComponent | StockSegment | Stock Segment | |
| RequirementSegment | I_ManufacturingOrderComponent | RequirementSegment | Req. Segment | |
| BusinessArea | I_ManufacturingOrderComponent | BusinessArea | Business Area | |
| GLAccount | I_ManufacturingOrderComponent | GLAccount | General Ledger | |
| FunctionalArea | I_ManufacturingOrderComponent | FunctionalArea | Sendr Fctl Area | |
| AccountAssignmentCategory | I_ManufacturingOrderComponent | AccountAssignmentCategory | Acct Assgmt Cat | |
| MaterialCompIsVariableSized | I_ManufacturingOrderComponent | MaterialCompIsVariableSized | Var-Sized Item | |
| VariableSizeItemUnit | I_ManufacturingOrderComponent | VariableSizeItemUnit | VSI unit | |
| VariableSizeItemQuantity | I_ManufacturingOrderComponent | VariableSizeItemQuantity | VSI Quantity | |
| VariableSizeComponentUnit | I_ManufacturingOrderComponent | VariableSizeComponentUnit | VSI UoM | |
| VariableSizeComponentQuantity | I_ManufacturingOrderComponent | VariableSizeComponentQuantity | VSI Quantity | |
| VariableSizeDimensionUnit | I_ManufacturingOrderComponent | VariableSizeDimensionUnit | Size unit | |
| VariableSizeDimension1 | I_ManufacturingOrderComponent | VariableSizeDimension1 | Size 1 | |
| VariableSizeDimension2 | I_ManufacturingOrderComponent | VariableSizeDimension2 | Size 2 | |
| VariableSizeDimension3 | I_ManufacturingOrderComponent | VariableSizeDimension3 | Size 3 | |
| VariableSizeCompFormulaKey | I_ManufacturingOrderComponent | VariableSizeCompFormulaKey | VSI Formula | |
| DiscontinuationGroup | I_ManufacturingOrderComponent | DiscontinuationGroup | Discont. group | |
| MatlCompDiscontinuationType | I_ManufacturingOrderComponent | MatlCompDiscontinuationType | ||
| MatlCompIsFollowUpMaterial | I_ManufacturingOrderComponent | MatlCompIsFollowUpMaterial | ||
| FollowUpGroup | I_ManufacturingOrderComponent | FollowUpGroup | Follow-up group | |
| FollowUpMaterial | I_ManufacturingOrderComponent | FollowUpMaterial | ||
| FollowUpMaterialIsActive | I_ManufacturingOrderComponent | FollowUpMaterialIsActive | ||
| MaterialCompIsAlternativeItem | I_ManufacturingOrderComponent | MaterialCompIsAlternativeItem | ||
| AlternativeItemGroup | I_ManufacturingOrderComponent | AlternativeItemGroup | AltItemGroup | |
| AlternativeItemStrategy | I_ManufacturingOrderComponent | AlternativeItemStrategy | Strategy | |
| AlternativeItemPriority | I_ManufacturingOrderComponent | AlternativeItemPriority | Priority | |
| UsageProbabilityPercent | I_ManufacturingOrderComponent | UsageProbabilityPercent | Usage Prob. | |
| MaterialComponentIsPhantomItem | I_ManufacturingOrderComponent | MaterialComponentIsPhantomItem | Phantom Item | |
| OrderPathValue | I_ManufacturingOrderComponent | OrderPathValue | Order path | |
| OrderLevelValue | I_ManufacturingOrderComponent | OrderLevelValue | Order level | |
| MaterialProvisionType | I_ManufacturingOrderComponent | MaterialProvisionType | Material Provision Type | |
| MatlComponentSparePartType | I_ManufacturingOrderComponent | MatlComponentSparePartType | Spare Part ID | |
| LeadTimeOffset | I_ManufacturingOrderComponent | LeadTimeOffset | Lead-tm offset | |
| PhaseLeadTimeOffsetUnit | ||||
| PhaseLeadTimeOffset | ||||
| QuantityIsFixed | I_ManufacturingOrderComponent | QuantityIsFixed | Qty. is fixed | |
| IsNetScrap | I_ManufacturingOrderComponent | IsNetScrap | Net Indicator | |
| ComponentScrapInPercent | I_ManufacturingOrderComponent | ComponentScrapInPercent | Component Scrap | |
| PhaseScrapPercent | ||||
| MaterialQtyToBaseQtyNmrtr | I_ManufacturingOrderComponent | MaterialQtyToBaseQtyNmrtr | Numerator | |
| MaterialQtyToBaseQtyDnmntr | I_ManufacturingOrderComponent | MaterialQtyToBaseQtyDnmntr | Denominator | |
| BaseUnit | I_ManufacturingOrderComponent | BaseUnit | Unit of Measure | |
| RequiredQuantity | I_ManufacturingOrderComponent | RequiredQuantity | Requirement qty | |
| WithdrawnQuantity | I_ManufacturingOrderComponent | WithdrawnQuantity | Withdrawn Quantity | |
| ConfirmedAvailableQuantity | I_ManufacturingOrderComponent | ConfirmedAvailableQuantity | Available Quantity | |
| MaterialCompOriginalQuantity | I_ManufacturingOrderComponent | MaterialCompOriginalQuantity | ||
| EntryUnit | I_ManufacturingOrderComponent | EntryUnit | Unit of Entry | |
| GoodsMovementEntryQty | I_ManufacturingOrderComponent | GoodsMovementEntryQty | ||
| Currency | I_ManufacturingOrderComponent | Currency | Valuation Crcy | |
| WithdrawnQuantityAmount | I_ManufacturingOrderComponent | WithdrawnQuantityAmount | ||
| _Order | _Order | |||
| _Phase | _Phase | |||
| _Operation | _Operation |
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_ProcessOrderComponentTP.
-- 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_ProcessOrderComponentTP AS
SELECT
Component.Reservation AS Reservation,
Component.ReservationItem AS ReservationItem,
Component.ReservationRecordType AS ReservationRecordType,
cast(Component.MaterialGroup as matkl preserving type ) AS MaterialGroup,
cast(Component.Material as matnr preserving type ) AS Material,
cast(Component.Plant as werks_d preserving type ) AS Plant,
cast(Component.ManufacturingOrder as co_bord preserving type) AS ProcessOrder,
case Operation.MfgOrderOperationIsPhase when 'X' then Component.ManufacturingOrderOperation else ' ' end AS ProcessOrderPhase,
case Operation.MfgOrderOperationIsPhase when ' ' then Component.ManufacturingOrderOperation else ' ' end AS ProcessOrderOperation,
Component.OrderInternalID AS OrderInternalID,
case Operation.MfgOrderOperationIsPhase when 'X' then Component.OrderOperationInternalID else null end AS OrderPhaseInternalID,
case Operation.MfgOrderOperationIsPhase when ' ' then Component.OrderOperationInternalID else null end AS OrderOperationInternalID,
Component.MatlCompRequirementDate AS MatlCompRequirementDate,
Component.MatlCompRequirementTime AS MatlCompRequirementTime,
Component.LatestRequirementDate AS LatestRequirementDate,
Component.ReservationItemCreationCode AS ReservationItemCreationCode,
Component.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
Component.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
Component.MaterialComponentIsMissing AS MaterialComponentIsMissing,
Component.IsBulkMaterialComponent AS IsBulkMaterialComponent,
Component.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
Component.MatlCompIsTextItem AS MatlCompIsTextItem,
Component.MaterialPlanningRelevance AS MaterialPlanningRelevance,
Component.MatlCompIsConfigurable AS MatlCompIsConfigurable,
Component.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
Component.MaterialComponentIsClassified AS MaterialComponentIsClassified,
Component.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
Component.MaterialIsDirectlyProduced AS MaterialIsDirectlyProduced,
Component.MaterialIsDirectlyProcured AS MaterialIsDirectlyProcured,
Component.LongTextLanguage AS LongTextLanguage,
Component.MaterialComponentHasLongText AS MaterialComponentHasLongText,
Component.RequirementType AS RequirementType,
Component.SalesOrder AS SalesOrder,
Component.SalesOrderItem AS SalesOrderItem,
Component.WBSElementInternalID AS WBSElementInternalID,
Component.ProductConfiguration AS ProductConfiguration,
Component.ChangeNumber AS ChangeNumber,
Component.EffectivityParameterVariant AS EffectivityParameterVariant,
Component.MatlCompFreeDefinedAttribute AS MatlCompFreeDefinedAttribute,
Component.BillOfMaterialCategory AS BillOfMaterialCategory,
Component.BillOfMaterialInternalID AS BillOfMaterialInternalID,
Component.BillOfMaterialVariant AS BillOfMaterialVariant,
Component.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
Component.BillOfMaterialVersion AS BillOfMaterialVersion,
Component.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
Component.InheritedBOMItemNode AS InheritedBOMItemNode,
Component.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
Component.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
Component.MaterialComponentText AS MaterialComponentText,
Component.MaterialComponentSecondText AS MaterialComponentSecondText,
Component.BOMExplosionDateID AS BOMExplosionDateID,
Component.PurchasingInfoRecord AS PurchasingInfoRecord,
Component.PurchasingGroup AS PurchasingGroup,
Component.PurchaseRequisition AS PurchaseRequisition,
Component.PurchaseRequisitionItem AS PurchaseRequisitionItem,
Component.PurchaseOrder AS PurchaseOrder,
Component.PurchaseOrderItem AS PurchaseOrderItem,
Component.Supplier AS Supplier,
Component.DeliveryDurationInDays AS DeliveryDurationInDays,
Component.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
Component.NumberOfOperationPriceUnits AS NumberOfPriceUnits,
Component.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
Component.StorageLocation AS StorageLocation,
cast(Component.Batch as charg_d preserving type) AS Batch,
Component.BatchSplitType AS BatchSplitType,
Component.DebitCreditCode AS DebitCreditCode,
Component.GoodsMovementType AS GoodsMovementType,
Component.InventorySpecialStockType AS InventorySpecialStockType,
Component.InventorySpecialStockValnType AS InventorySpecialStockValnType,
Component.ConsumptionPosting AS ConsumptionPosting,
Component.SupplyArea AS SupplyArea,
Component.GoodsRecipientName AS GoodsRecipientName,
Component.UnloadingPointName AS UnloadingPointName,
Component.StockSegment AS StockSegment,
Component.RequirementSegment AS RequirementSegment,
Component.BusinessArea AS BusinessArea,
Component.GLAccount AS GLAccount,
Component.FunctionalArea AS FunctionalArea,
Component.AccountAssignmentCategory AS AccountAssignmentCategory,
Component.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
Component.VariableSizeItemUnit AS VariableSizeItemUnit,
Component.VariableSizeItemQuantity AS VariableSizeItemQuantity,
Component.VariableSizeComponentUnit AS VariableSizeComponentUnit,
Component.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
Component.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
Component.VariableSizeDimension1 AS VariableSizeDimension1,
Component.VariableSizeDimension2 AS VariableSizeDimension2,
Component.VariableSizeDimension3 AS VariableSizeDimension3,
Component.VariableSizeCompFormulaKey AS VariableSizeCompFormulaKey,
Component.DiscontinuationGroup AS DiscontinuationGroup,
Component.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
Component.MatlCompIsFollowUpMaterial AS MatlCompIsFollowUpMaterial,
Component.FollowUpGroup AS FollowUpGroup,
Component.FollowUpMaterial AS FollowUpMaterial,
Component.FollowUpMaterialIsActive AS FollowUpMaterialIsActive,
Component.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
Component.AlternativeItemGroup AS AlternativeItemGroup,
Component.AlternativeItemStrategy AS AlternativeItemStrategy,
Component.AlternativeItemPriority AS AlternativeItemPriority,
Component.UsageProbabilityPercent AS UsageProbabilityPercent,
Component.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
Component.OrderPathValue AS OrderPathValue,
Component.OrderLevelValue AS OrderLevelValue,
Component.MaterialProvisionType AS MaterialProvisionType,
Component.MatlComponentSparePartType AS MatlComponentSparePartType,
Component.LeadTimeOffset AS LeadTimeOffset,
case Operation.MfgOrderOperationIsPhase when 'X' then Component.OperationLeadTimeOffsetUnit else null end AS PhaseLeadTimeOffsetUnit,
case Operation.MfgOrderOperationIsPhase when 'X' then Component.OperationLeadTimeOffset else null end AS PhaseLeadTimeOffset,
Component.QuantityIsFixed AS QuantityIsFixed,
Component.IsNetScrap AS IsNetScrap,
Component.ComponentScrapInPercent AS ComponentScrapInPercent,
case Operation.MfgOrderOperationIsPhase when 'X' then Component.OperationScrapInPercent else null end AS PhaseScrapPercent,
Component.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
Component.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
Component.BaseUnit AS BaseUnit,
Component.RequiredQuantity AS RequiredQuantity,
Component.WithdrawnQuantity AS WithdrawnQuantity,
Component.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
Component.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
Component.EntryUnit AS EntryUnit,
Component.GoodsMovementEntryQty AS GoodsMovementEntryQty,
Component.Currency AS Currency,
Component.WithdrawnQuantityAmount AS WithdrawnQuantityAmount
FROM I_ManufacturingOrderComponent AS Component
INNER JOIN I_OrderOperationBasic AS Operation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProcessOrderPhaseTP AS _Phase ON _Phase.ProcessOrder = ProcessOrder AND _Phase.OrderPhaseInternalID = OrderPhaseInternalID -- association [0..1]
LEFT OUTER JOIN R_ProcessOrderOperationTP AS _Operation ON _Operation.ProcessOrder = ProcessOrder AND _Operation.OrderOperationInternalID = OrderOperationInternalID -- association [0..1]
LEFT OUTER JOIN E_ProcessOrderComponent AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND ReservationRecordType = _Extension.ReservationRecordType -- association [1..1]
;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