I_MfgOrderActlPlanTgtLdgrCost

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 I_MfgOrderActlPlanTgtLdgrCost.
-- 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: IFIORDAPTLCOST
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_Ledger : fins_ledger, P_CurrencyRole : fac_crcyrole, P_TargetCostVariant : fis_awvrs

CREATE VIEW I_MfgOrderActlPlanTgtLdgrCost AS
SELECT
  lookupEntity: 'I_FiscalCalendarDate' AS lookupEntityI_FiscalCalendarDate,
  resultElement: 'FiscalYearPeriod' AS resultElementFiscalYearPeriod,
  derivation: { lookupEntity: 'I_Ledger', resultElement: 'Ledger', binding: [ { targetElement: 'IsLeadingLedger', type: #CONSTANT, value: 'X' AS P_FromFiscalYearPeriod,
  P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod AS P_ToFiscalYearPeriod,
  P_Ledger : $parameters.P_Ledger AS P_Ledger,
  P_CurrencyRole : $parameters.P_CurrencyRole AS P_CurrencyRole,
  OrderItem,
  WorkCenterInternalID,
  OrderOperation,
  GLAccount,
  PartnerCostCtrActivityType,
  PartnerCostCenter,
  Plant,
  Product,
  UnitOfMeasure,
  CurPlanProjSlsOrdValnStrategy,
  cast( :P_Ledger as fins_ledger ) AS Ledger,
  ControllingArea,
  CompanyCode,
  ProducedProduct,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  ChartOfAccounts,
  OrderType,
  OrderCategory,
  DisplayCurrency,
  cast(CreditActlCostInDisplayCrcy as fis_cr_actlcost_in_dspcrcy) AS CreditActlCostInDspCrcy,
  cast(DebitActlCostInDisplayCrcy as fis_dr_actlcost_in_dspcrcy) AS DebitActlCostInDspCrcy,
  cast(CrdtActlFixedCostInDspCrcy as fis_cr_actlfxdcost_in_dspcrcy) AS CrdtActlFxdCostInDspCrcy,
  cast(DebitActlFixedCostInDspCrcy as fis_dr_actlfxdcost_in_dspcrcy) AS DebitActlFxdCostInDspCrcy,
  cast(ActualQtyInCostSourceUnit as fis_actlqty_in_costsrceunit) AS ActualQtyInCostSourceUnit,
  cast(CreditPlanCostInDisplayCrcy as fis_cr_plancost_in_dspcrcy) AS CreditPlanCostInDspCrcy,
  cast(DebitPlanCostInDisplayCrcy as fis_dr_plancost_in_dspcrcy) AS DebitPlanCostInDspCrcy,
  cast(CrdtPlanFixedCostInDspCrcy as fis_cr_plnfxdcost_in_dspcrcy) AS CrdtPlnFxdCostInDspCrcy,
  cast(DebitPlanFixedCostInDspCrcy as fis_dr_plnfxdcost_in_dspcrcy) AS DebitPlnFxdCostInDspCrcy,
  cast(PlanQtyInCostSourceUnit as fis_planqty_in_costsrceunit) AS PlanQtyInCostSourceUnit,
  cast(CreditTgtCostInDisplayCrcy as fis_cr_tgtcost_in_dspcrcy) AS CrdtTargetCostInDspCrcy,
  cast(DebitTgtCostInDisplayCrcy as fis_dr_tgtcost_in_dspcrcy) AS DebitTargetCostInDspCrcy,
  cast(TargetQtyInCostSourceUnit as fis_tgtqty_in_costsrceunit) AS TargetQtyInCostSourceUnit
FROM P_MfgOrderActlPlanTgtCostV2
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ProducedProduct ON ProducedProduct = _ProducedProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON OrderID = _OrderItem.OrderID AND OrderItem = _OrderItem.OrderItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON UnitOfMeasure = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _PartnerCostCtrActivityType ON ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;