P_ActlCostgRunRsltBegInvtryDta

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_ActlCostgRunRsltBegInvtryDta.
-- 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_CostingRunType : ckml_run_type, P_FiscalPeriod : fins_fiscalperiod, P_FiscalYear : fis_gjahr_no_conv

CREATE VIEW P_ActlCostgRunRsltBegInvtryDta AS
SELECT
  MLDocExtract.CostEstimate AS CostEstimate,
  MLDocExtract.CurrencyRole AS CurrencyRole,
  MLDocExtract.Ledger AS Ledger,
  MatlLedgerHeaderData.Material AS Material,
  MatlLedgerHeaderData.ValuationArea AS ValuationArea,
  MatlLedgerHeaderData.InventoryValuationType AS InventoryValuationType,
  MatlLedgerHeaderData.SalesOrder AS SalesOrder,
  MatlLedgerHeaderData.SalesOrderItem AS SalesOrderItem,
  MatlLedgerHeaderData.InventorySpecialStockType AS InventorySpecialStockType,
  MatlLedgerHeaderData._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MatlLedgerHeaderData.Supplier AS Supplier,
  cast ( 'AB' as ckml_categ preserving type ) AS MaterialLedgerCategory,
  cast ( ' ' as ck_ptyp_bvalt preserving type ) AS ProcessCategory,
  cast ( 'X' as ml4h_xabr preserving type ) AS MatlLdgrDocIsCostingRelevant,
  cast ( '000000000000' as ckml_alprocnr preserving type ) AS ProcurementAlternative,
  cast ( '000000000000' as ckml_f_procnr preserving type ) AS ProductionProcess,
  cast ( ' ' as mmim_movement_type preserving type ) AS MovementType,
  cast ( ' ' as saknr preserving type ) AS GLAccount,
  MLDocExtract.FiscalYearPeriod AS FiscalYearPeriod,
  MatlLedgerHeaderData.PriceDeterminationControl AS PriceDeterminationControl,
  sum(MLDocExtract.TotalVltdStockQuantity) AS TotalVltdStockQuantity,
  MLDocExtract.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum(MLDocExtract.InvtryTransacAmtInDisplayCrcy) AS InvtryTransacAmtInDisplayCrcy,
  cast ( 0 as ml4h_prd ) AS PriceDiffAmtInDisplayCrcy,
  cast ( 0 as ml4h_kdm ) AS ExchRateDiffAmtInDspCurrency,
  MLDocExtract.Currency as Currency AS CostEstimateasCostEstimate,
  MatlLedgerDocument.Currency AS Currency
FROM P_MatLedgerCostingRunPerPeriod AS PerPeriod
INNER JOIN P_MaterialLedgerCostingRun AS CostingRun ON /* join condition not captured in parsed metadata */
INNER JOIN P_MatlLedgerDocumentExtract AS MLDocExtract ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaterialLedgerHeaderData AS MatlLedgerHeaderData ON /* join condition not captured in parsed metadata */
INNER JOIN P_InvtryLdgrMatlLedgerDocument AS MatlLedgerDocument ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MatLedgerCostingRunPerPeriod
;