P_EBOrderHdrItmProdnCost2v2

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

CREATE VIEW P_EBOrderHdrItmProdnCost2v2 AS
SELECT
  OrderID,
  OrderItem,
  OrderInternalID,
  ObjectInternalID,
  OrderType,
  OrderCategory,
  ExternalOrder,
  OrderDescription,
  Plant,
  CompanyCode,
  BaseUnit,
  RatioUnit,
  Ledger,
  ControllingArea,
  BusinessArea,
  ProfitCenter,
  ResponsibleCostCenter,
  WBSElementInternalID,
  ProductionVersion,
  ValuationType,
  SalesOrder,
  SalesOrderItem,
  Material,
  MRPPlant,
  StorageLocation,
  ProductionUnit,
  IsMarkedForDeletion,
  MfgOrderHasMultipleItems,
  CombnOrdCombinationIdentifier,
  CombinedOrder,
  SuperiorOrder,
  MfgOrderIsPartOfCollvOrder,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  PlannedReleaseDate,
  PlannedCompletionDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  TechnicalCompletionDate,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualDeliveryDate,
  ActualReleasedDate,
  ControllingObjectStatus,
  OrderKeyStatus,
  DisplayCurrency,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate,
  cast(CreditActlCostInDspCrcy as fis_cr_actlcost_in_dspcrcy) AS CreditActlCostInDspCrcy,
  cast(DebitActlCostInDspCrcy as fis_dr_actlcost_in_dspcrcy) AS DebitActlCostInDspCrcy,
  cast(CreditActlCostInDspCrcy + DebitActlCostInDspCrcy as fis_actlcost_in_dspcrcy ) AS ActlCostInDspCrcy,
  cast(CrdtActlFxdCostInDspCrcy as fis_cr_actlfxdcost_in_dspcrcy) AS CrdtActlFxdCostInDspCrcy,
  cast(DebitActlFixedCostInDspCrcy as fis_dr_actlfxdcost_in_dspcrcy) AS DebitActlFxdCostInDspCrcy,
  cast(CrdtActlFxdCostInDspCrcy + DebitActlFixedCostInDspCrcy as fis_actlfixedcost_in_dspcrcy) AS ActlFixedCostInDspCrcy,
  cast(DebitActlCostInDspCrcy - DebitActlFixedCostInDspCrcy as fis_dr_actlvarblcost_indspcrcy) AS DebitActlVarblCostInDspCrcy,
  cast(CreditActlCostInDspCrcy - CrdtActlFxdCostInDspCrcy as fis_cr_actlvarblcost_indspcrcy) AS CrdtActlVarblCostIndDspCrcy,
  cast(CreditPlanCostInDspCrcy as fis_cr_plancost_in_dspcrcy) AS CreditPlanCostInDspCrcy,
  cast(DebitPlanCostInDspCrcy as fis_dr_plancost_in_dspcrcy) AS DebitPlanCostInDspCrcy,
  cast(CreditPlanFxdCostInDspCrcy as fis_cr_plnfxdcost_in_dspcrcy) AS CrdtPlnFxdCostInDspCrcy,
  cast(DebitPlanFxdCostInDspCrcy as fis_dr_plnfxdcost_in_dspcrcy) AS DebitPlnFxdCostInDspCrcy,
  cast(DebitPlanCostInDspCrcy - DebitPlanFxdCostInDspCrcy as fis_dr_plnvarblcost_in_dspcrcy) AS DebitPlnVarblCostInDspCrcy,
  cast(CreditPlanCostInDspCrcy - CreditPlanFxdCostInDspCrcy as fis_cr_plnvarblcost_in_dspcrcy) AS CrdtPlnVarblCostInDspCrcy,
  cast(DebitPlanCostInDspCrcy + CreditPlanCostInDspCrcy as fis_plancost_in_dspcrcy) AS PlanCostInDspCrcy,
  cast(DebitPlanFxdCostInDspCrcy + CreditPlanFxdCostInDspCrcy as fis_planfixedcost_in_dspcrcy) AS PlanFixedCostInDspCrcy,
  cast(CrdtTargetCostInDspCrcy as fis_cr_tgtcost_in_dspcrcy) AS CrdtTargetCostInDspCrcy,
  cast(DebitTargetCostInDspCrcy as fis_dr_tgtcost_in_dspcrcy) AS DebitTargetCostInDspCrcy,
  cast((CrdtTargetCostInDspCrcy + DebitTargetCostInDspCrcy) as fis_tgtcost_in_dspcrcy) AS TargetCostInDspCrcy,
  cast((CreditActlCostInDspCrcy + DebitActlCostInDspCrcy) as fis_actlctrlcost_in_dspcrcy) AS ActlCtrlCostInDspCrcy,
  cast(WIPCostInDspCrcy as fis_wipcost_in_dspcrcy) AS WIPCostInDspCrcy,
  cast(UnrlzdCostRsrvAmtInDspCrcy as fis_abgruekfk) AS UnrlzdCostRsrvAmtInDspCrcy,
  cast((WIPCostInDspCrcy + UnrlzdCostRsrvAmtInDspCrcy) as fco_eb_totalwipamt_in_dspcrcy) AS TotalWIPAmountInDspCrcy,
  cast(CostVarianceInDspCrcy as fco_eb_totalvarcamt_in_dspcrcy) AS CostVarianceInDspCrcy,
  InptPrVarcAmtInDspCrcy,
  InptQtyVarcAmtInDspCrcy,
  RsceUsgeVarcAmtInDspCrcy,
  OutpPrVarcAmtInDspCrcy,
  LotSizeVarcAmtInDspCrcy,
  RmngVarcAmtInDspCrcy,
  cast((DebitActlCostInDspCrcy - DebitPlanCostInDspCrcy) as fis_dractlplndiffcostindspcrcy) AS DebitActlPlnDiffCostInDspCrcy,
  cast((DebitActlCostInDspCrcy - DebitTargetCostInDspCrcy) as fis_dractltgtdiffcostindspcrcy) AS DebitActlTgtDiffCostInDspCrcy,
  cast(PlanOutputQuantity as fis_plan_output_quantity) AS PlanOutputQuantity,
  cast(ActualOutputQuantity as fis_actual_output_quantity) AS ActualOutputQuantity,
  cast((ActualOutputQuantity - PlanOutputQuantity) as fis_actlplandiffoutputquantity) AS ActlPlanDiffOutputQuantity
FROM P_EBOrderHdrItmProdnCost1v2
;