P_EBOrderHdrItmProdnCost1v2

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_EBOrderHdrItmProdnCost1v2.
-- 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: PEBORDHAIPC1V2
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_CurrencyRole : fis_curtp

CREATE VIEW P_EBOrderHdrItmProdnCost1v2 AS
SELECT
  EvtBsdOrderAndItem.OrderID AS OrderID,
  EvtBsdOrderAndItem.OrderItem AS OrderItem,
  EvtBsdOrderAndItem.OrderInternalID AS OrderInternalID,
  EvtBsdOrderAndItem.ObjectInternalID AS ObjectInternalID,
  EvtBsdOrderAndItem.OrderType AS OrderType,
  EvtBsdOrderAndItem.OrderCategory AS OrderCategory,
  EvtBsdOrderAndItem.ExternalOrder AS ExternalOrder,
  EvtBsdOrderAndItem.OrderDescription AS OrderDescription,
  EvtBsdOrderAndItem.Plant AS Plant,
  EvtBsdOrderAndItem.CompanyCode AS CompanyCode,
  cast(EvtBsdOrderAndItem.BaseUnit as fis_meinh) AS BaseUnit,
  cast('%' as msehi) AS RatioUnit,
  EvtBsdOrderAndItem.CombnOrdCombinationIdentifier AS CombnOrdCombinationIdentifier,
  EvtBsdOrderAndItem.CombinedOrder AS CombinedOrder,
  EvtBsdOrderAndItem.SuperiorOrder AS SuperiorOrder,
  EvtBsdOrderAndItem.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  :P_Ledger AS Ledger,
  EvtBsdOrderAndItem.ControllingArea AS ControllingArea,
  EvtBsdOrderAndItem.BusinessArea AS BusinessArea,
  EvtBsdOrderAndItem.ProfitCenter AS ProfitCenter,
  EvtBsdOrderAndItem.ResponsibleCostCenter AS ResponsibleCostCenter,
  EvtBsdOrderAndItem.WBSElementInternalID AS WBSElementInternalID,
  EvtBsdOrderAndItem.ProductionVersion AS ProductionVersion,
  EvtBsdOrderAndItem.SalesOrder AS SalesOrder,
  EvtBsdOrderAndItem.SalesOrderItem AS SalesOrderItem,
  EvtBsdOrderAndItem.Material AS Material,
  EvtBsdOrderAndItem.MRPPlant AS MRPPlant,
  EvtBsdOrderAndItem.StorageLocation AS StorageLocation,
  EvtBsdOrderAndItem.ProductionUnit AS ProductionUnit,
  EvtBsdOrderAndItem.ValuationType AS ValuationType,
  EvtBsdOrderAndItem.IsMarkedForDeletion AS IsMarkedForDeletion,
  EvtBsdOrderAndItem.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  EvtBsdOrderAndItem.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  EvtBsdOrderAndItem.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  EvtBsdOrderAndItem.PlannedReleaseDate AS PlannedReleaseDate,
  EvtBsdOrderAndItem.PlannedCompletionDate AS PlannedCompletionDate,
  EvtBsdOrderAndItem.CreatedByUser AS CreatedByUser,
  EvtBsdOrderAndItem.CreationDate AS CreationDate,
  EvtBsdOrderAndItem.LastChangedByUser AS LastChangedByUser,
  EvtBsdOrderAndItem.LastChangeDate AS LastChangeDate,
  EvtBsdOrderAndItem.TechnicalCompletionDate AS TechnicalCompletionDate,
  EvtBsdOrderAndItem.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  EvtBsdOrderAndItem.ScheduledReleaseDate AS ScheduledReleaseDate,
  EvtBsdOrderAndItem.ActualStartDate AS ActualStartDate,
  EvtBsdOrderAndItem.ConfirmedEndDate AS ConfirmedEndDate,
  EvtBsdOrderAndItem.ActualDeliveryDate AS ActualDeliveryDate,
  EvtBsdOrderAndItem.ActualReleasedDate AS ActualReleasedDate,
  cast(_OrderKeyStatus.StatusCode as fco_current_order_key_status) AS OrderKeyStatus,
  _LdgrCompCodeCrcy.Currency AS DisplayCurrency,
  coalesce(_OrderPlanCost.CreditPlanCostInDspCrcy, 0) AS CreditPlanCostInDspCrcy,
  coalesce(_OrderPlanCost.DebitPlanCostInDspCrcy, 0) AS DebitPlanCostInDspCrcy,
  coalesce(_OrderPlanCost.CreditPlanFxdCostInDspCrcy, 0) AS CreditPlanFxdCostInDspCrcy,
  coalesce(_OrderPlanCost.DebitPlanFxdCostInDspCrcy, 0) AS DebitPlanFxdCostInDspCrcy,
  coalesce(_OrderActualCost.CreditActlCostInDspCrcy, 0) AS CreditActlCostInDspCrcy,
  coalesce(_OrderActualCost.DebitActlCostInDspCrcy, 0) AS DebitActlCostInDspCrcy,
  coalesce(_OrderActualCost.CrdtActlFxdCostInDspCrcy, 0) AS CrdtActlFxdCostInDspCrcy,
  coalesce(_OrderActualCost.DebitActlFixedCostInDspCrcy, 0) AS DebitActlFixedCostInDspCrcy,
  coalesce(_OrderWIPCost.WIPCostInDspCrcy, 0) AS WIPCostInDspCrcy,
  coalesce(_OrderWIPCost.UnrlzdCostRsrvAmtInDspCrcy, 0) AS UnrlzdCostRsrvAmtInDspCrcy,
  coalesce(_OrderVarianceCost.AmountInDisplayCurrency, 0) AS CostVarianceInDspCrcy,
  coalesce(_OrderSplitVarianceCost.InptPrVarcAmtInDspCrcy, 0) AS InptPrVarcAmtInDspCrcy,
  coalesce(_OrderSplitVarianceCost.InptQtyVarcAmtInDspCrcy, 0) AS InptQtyVarcAmtInDspCrcy,
  coalesce(_OrderSplitVarianceCost.RsceUsgeVarcAmtInDspCrcy, 0) AS RsceUsgeVarcAmtInDspCrcy,
  coalesce(_OrderSplitVarianceCost.OutpPrVarcAmtInDspCrcy, 0) AS OutpPrVarcAmtInDspCrcy,
  coalesce(_OrderSplitVarianceCost.LotSizeVarcAmtInDspCrcy, 0) AS LotSizeVarcAmtInDspCrcy,
  coalesce(_OrderSplitVarianceCost.RmngVarcAmtInDspCrcy, 0) AS RmngVarcAmtInDspCrcy,
  coalesce(_OrderPlanCost.PlanOutputQuantity, 0) AS PlanOutputQuantity,
  coalesce(_OrderActualCost.ActualOutputQuantity, 0) AS ActualOutputQuantity
FROM P_RealTmeWrkInProcOrdHdAndItem AS EvtBsdOrderAndItem
INNER JOIN P_EvtBsdOrderMinCompletelyDLV AS _OrderStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRolesVH AS _LdgrCompCodeCrcy ON /* join condition not captured in parsed metadata */
;