P_RealTimeJntProdnOrderHeader

DDL: P_REALTIMEJNTPRODNORDERHEADER Type: view_entity COMPOSITE
17 Fields 2 Data Sources

Real time joint production order header

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

Data Sources (2)

SourceAliasJoin Type
R_EventBasedDistrPostingRule postingRule from
I_ProductCostCtrlgOrder productCostCtrlOrder inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real time joint production order header 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 I_ProductCostCtrlgOrder ObjectInternalID Object number
OrderID I_ProductCostCtrlgOrder 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
StatusCodeI0045thenI0002endasStatusCode

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_RealTimeJntProdnOrderHeader.
-- 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 P_RealTimeJntProdnOrderHeader AS
SELECT
  productCostCtrlOrder.ObjectInternalID AS ControllingObject,
  productCostCtrlOrder.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,
  case when ( productCostCtrlOrder.TechnicalCompletionDate is initial or _Status.StatusCode = 'I0045') then 'I0002' end as StatusCode AS StatusCodeI0045thenI0002endasStatusCode
FROM R_EventBasedDistrPostingRule AS postingRule
INNER JOIN I_ProductCostCtrlgOrder AS productCostCtrlOrder ON /* join condition not captured in parsed metadata */
;

Learn More