P_RealTimeNormalMfgOrder

DDL: P_REALTIMENORMALMFGORDER Type: view_entity COMPOSITE Package: ODATA_EBW_ORDER_INSPECTOR
17 Fields 2 Data Sources

Real time normal manufacturing order

P_RealTimeNormalMfgOrder is a Composite CDS View that provides data about "Real time normal manufacturing order" in SAP S/4HANA. It reads from 2 data sources (R_EventBasedDistrPostingRule, I_ProductCostCtrlgOrder) and exposes 17 fields with key field ControllingObject. Part of development package ODATA_EBW_ORDER_INSPECTOR.

Data Sources (2)

SourceAliasJoin Type
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 normal manufacturing 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 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
IsFixedPriceCoProduct leadingOrderItem IsFixedPriceCoProduct

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_RealTimeNormalMfgOrder.
-- 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_RealTimeNormalMfgOrder 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,
  leadingOrderItem.IsFixedPriceCoProduct AS IsFixedPriceCoProduct
FROM R_EventBasedDistrPostingRule AS postingRule
INNER JOIN I_ProductCostCtrlgOrder AS productCostCtrlOrder ON /* join condition not captured in parsed metadata */
;

Learn More