P_RealTimeJointProductionOrder

DDL: P_REALTIMEJOINTPRODUCTIONORDER Type: view_entity COMPOSITE
17 Fields 3 Data Sources

Real time joint production order

P_RealTimeJointProductionOrder is a Composite CDS View that provides data about "Real time joint production order" in SAP S/4HANA. It reads from 3 data sources (I_ProductCostCtrlgOrderItem, R_EventBasedDistrPostingRule, I_ProductCostCtrlgOrder) and exposes 17 fields with key field ControllingObject.

Data Sources (3)

SourceAliasJoin Type
I_ProductCostCtrlgOrderItem orderItem inner
R_EventBasedDistrPostingRule postingRule from
I_ProductCostCtrlgOrder productCostCtrlOrder inner

Parameters (1)

NameTypeDefault
P_FiscalPeriodEndDate budat

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real time joint production order view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject R_EventBasedDistrPostingRule ControllingObject Object number
OrderID R_EventBasedDistrPostingRule OrderID Order ID
OrderDescription I_ProductCostCtrlgOrder OrderDescription
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
EventBasedProcessingKey I_ProductCostCtrlgOrder EventBasedProcessingKey Event-Based Proc Key
OrderSettlementTriggerType I_ProductCostCtrlgOrder OrderSettlementTriggerType
ActualReleasedDate I_ProductCostCtrlgOrder ActualReleasedDate
TechCompDate I_ProductCostCtrlgOrder TechnicalCompletionDate
MfgOrderHasMultipleItems I_ProductCostCtrlgOrder MfgOrderHasMultipleItems
PartnerControllingObjectType R_EventBasedDistrPostingRule PartnerControllingObjectType Receiver Type
IsFixedPriceCoProduct I_ProductCostCtrlgOrderItem IsFixedPriceCoProduct Fixed-Price Co-Prod.

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_RealTimeJointProductionOrder.
-- 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.
-- Parameters: P_FiscalPeriodEndDate : budat

CREATE VIEW P_RealTimeJointProductionOrder AS
SELECT
  postingRule.ControllingObject AS ControllingObject,
  postingRule.OrderID AS OrderID,
  productCostCtrlOrder.OrderDescription AS OrderDescription,
  productCostCtrlOrder.OrderType AS OrderType,
  productCostCtrlOrder.OrderCategory AS OrderCategory,
  productCostCtrlOrder.ControllingArea AS ControllingArea,
  productCostCtrlOrder.CompanyCode AS CompanyCode,
  productCostCtrlOrder.Plant AS Plant,
  productCostCtrlOrder.ProfitCenter AS ProfitCenter,
  productCostCtrlOrder.ResultAnalysisInternalID AS ResultsAnalysisKey,
  productCostCtrlOrder.EventBasedProcessingKey AS EventBasedProcessingKey,
  productCostCtrlOrder.OrderSettlementTriggerType AS OrderSettlementTriggerType,
  productCostCtrlOrder.ActualReleasedDate AS ActualReleasedDate,
  productCostCtrlOrder.TechnicalCompletionDate AS TechCompDate,
  productCostCtrlOrder.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  postingRule.PartnerControllingObjectType AS PartnerControllingObjectType,
  orderItem.IsFixedPriceCoProduct AS IsFixedPriceCoProduct
FROM R_EventBasedDistrPostingRule AS postingRule
INNER JOIN I_ProductCostCtrlgOrderItem AS orderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductCostCtrlgOrder AS productCostCtrlOrder ON /* join condition not captured in parsed metadata */
;

Learn More