P_RealTimeOrderCost

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_RealTimeOrderCost.
-- 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: PRTORDERCOST
-- Parameters: P_Ledger : fins_ledger

CREATE VIEW P_RealTimeOrderCost AS
SELECT
  OrderAndItem.ObjectInternalID AS ControllingObject,
  OrderAndItem.OrderInternalID AS OrderInternalID,
  OrderAndItem.OrderID AS OrderID,
  OrderAndItem.OrderItem AS OrderItem,
  case OrderAndItem.OrderItem when '0000' then ltrim(OrderAndItem.OrderID, '0') else concat(ltrim(OrderAndItem.OrderID, '0'), concat('/', ltrim(OrderAndItem.OrderItem, '0'))) end as InternalOrderText AS OrderItem0endasInternalOrderText,
  OrderAndItem.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  OrderAndItem.IsMarkedForDeletion AS IsMarkedForDeletion,
  OrderAndItem.Plant AS Plant,
  OrderAndItem.CompanyCode AS CompanyCode,
  OrderDescription,
  cast(Material as fco_rtwip_product preserving type) AS Product,
  OrderAndItem.OrderSettlementTriggerType AS OrderSettlementTriggerType,
  OrderAndItem.ValuationType AS ValuationType,
  OrderAndItem.OrderType AS OrderType,
  OrderAndItem.OrderCategory AS OrderCategory,
  OrderAndItem.ProfitCenter AS ProfitCenter,
  cast(:P_Ledger as fins_ledger) AS Ledger,
  OrderAndItem.ControllingArea AS ControllingArea,
  StorageLocation,
  ProductionVersion,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  OrderAndItem.SalesOrder AS SalesOrder,
  OrderAndItem.SalesOrderItem AS SalesOrderItem,
  cast(OrderAndItem.WBSElementInternalID as fco_ebpr_wbs_element_int_id preserving type ) AS WBSElementInternalID,
  Currency.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(coalesce( AmountInCompanyCodeCurrency, 0 ) as fis_actlcost_in_cccrcy) AS ActlCostInCoCodeCrcy,
  cast(BaseUnit as fis_meinh) AS ProductionUnit,
  cast(coalesce( ActualOutputQuantity, 0 ) as fis_actual_output_quantity) AS ActualOutputQuantity,
  cast(coalesce( PlanOutputQuantity, 0 ) as fis_plan_output_quantity) AS PlanOutputQuantity,
  cast(OrderKeyStatus.ControllingObjectStatus as fco_current_order_status ) AS ControllingObjectStatus,
  cast(OrderKeyStatus.StatusCode as fco_current_order_key_status) AS OrderKeyStatus
FROM P_RealTmeWrkInProcOrdHdAndItem AS OrderAndItem
INNER JOIN I_LedgerCompanyCodeCrcyRoleVH AS Currency ON /* join condition not captured in parsed metadata */
INNER JOIN P_CoEvtBsdOrderKeyStatus AS OrderKeyStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostingVariantText AS _ActlCostsCostingVariantText ON ActualCostsCostingVariant = _ActlCostsCostingVariantText.CostingVariant  -- association [0..*]
LEFT OUTER JOIN I_CostingVariantText AS _PlndCostsCostingVariantText ON PlannedCostsCostingVariant = _PlndCostsCostingVariantText.CostingVariant  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;