P_InventoryLedger

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_InventoryLedger.
-- 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_FromFiscalYearPeriod : fml_fyearperiod_from, P_ToFiscalYearPeriod : fml_fyearperiod_to

CREATE VIEW P_InventoryLedger AS
SELECT
  $parameters.P_FromFiscalYearPeriod AS FromFiscalYearPeriod,
  $parameters.P_ToFiscalYearPeriod AS ToFiscalYearPeriod,
  PriceDeterminationControl,
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  InventorySpecialStockTypeName,
  Supplier,
  WBSElementExternalID,
  CurrencyRole,
  Ledger,
  cast( MaterialLedgerCategory as fml_material_ledger_category preserving type ) AS MaterialLedgerCategory,
  cast( MaterialLedgerCategoryText as fml_matl_ledger_category_text preserving type ) AS MaterialLedgerCategoryText,
  cast( ProcessCategory as fml_process_category preserving type ) AS ProcessCategory,
  cast( ProcessCategoryName as fml_process_category_text preserving type ) AS ProcessCategoryName,
  cast( TotalVltdStockQuantity as ml4h_quantity preserving type ) AS TotalVltdStockQuantity,
  ValuationQuantityUnit,
  cast( 0 as fml_inventory_value ) AS InventoryAmtInDspCrcy,
  cast( InvtryTransacAmtInDisplayCrcy as fml_preliminary_value preserving type ) AS InvtryTransacAmtInDisplayCrcy,
  cast( PriceDiffAmtInDisplayCrcy as ml4h_prd preserving type ) AS PriceDiffAmtInDisplayCrcy,
  cast(ExchRateDiffAmtInDspCurrency as ml4h_kdm preserving type ) AS ExchRateDiffAmtInDspCurrency,
  Currency,
  CompanyCode,
  ControllingArea AS P_FromFiscalYearPeriod,
  ControllingArea
FROM P_InventoryLedgerProcess
-- UNION ALL with additional select branch(es): P_BeginningAndEndingInventory
;