P_RTPC_REM_Order

DDL: P_RTPC_REM_ORDER SQL: PRTPCREMORD Type: view COMPOSITE
14 Fields 1 Data Sources

P_RTPC_REM_Order is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ProductCostCtrlgOrder) and exposes 14 fields with key field OrderID.

Data Sources (1)

SourceAliasJoin Type
I_ProductCostCtrlgOrder _Order from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRTPCREMORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.representativeKey OrderID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_ProductCostCtrlgOrder OrderID Order ID
OrderDescription I_ProductCostCtrlgOrder OrderDescription
ControllingObject I_ProductCostCtrlgOrder ObjectInternalID Object number
OrderType I_ProductCostCtrlgOrder OrderType Order Type
OrderCategory I_ProductCostCtrlgOrder OrderCategory Order Category
ControllingArea I_ProductCostCtrlgOrder ControllingArea Controlling Area
CompanyCode I_ProductCostCtrlgOrder CompanyCode Receiver Company Code
Plant I_ProductCostCtrlgOrder Plant Valuation Area
ProfitCenter I_ProductCostCtrlgOrder ProfitCenter Profit Center
ResultsAnalysisKey I_ProductCostCtrlgOrder ResultAnalysisInternalID Results Analysis Key
OrderSettlementTriggerType I_ProductCostCtrlgOrder OrderSettlementTriggerType
TechCompDate I_ProductCostCtrlgOrder TechnicalCompletionDate
Material _LeadingOrderItem Material Vehicle Model
ProductionVersion _LeadingOrderItem ProductionVersion Version ID

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 P_RTPC_REM_Order.
-- 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.
-- SQL view name: PRTPCREMORD

CREATE VIEW P_RTPC_REM_Order AS
SELECT
  _Order.OrderID AS OrderID,
  _Order.OrderDescription AS OrderDescription,
  _Order.ObjectInternalID AS ControllingObject,
  _Order.OrderType AS OrderType,
  _Order.OrderCategory AS OrderCategory,
  _Order.ControllingArea AS ControllingArea,
  _Order.CompanyCode AS CompanyCode,
  _Order.Plant AS Plant,
  _Order.ProfitCenter AS ProfitCenter,
  _Order.ResultAnalysisInternalID AS ResultsAnalysisKey,
  _Order.OrderSettlementTriggerType AS OrderSettlementTriggerType,
  _Order.TechnicalCompletionDate AS TechCompDate,
  _LeadingOrderItem.Material AS Material,
  _LeadingOrderItem.ProductionVersion AS ProductionVersion
FROM I_ProductCostCtrlgOrder AS _Order
;

Learn More