P_ActlCostgRunRsltEnhcdWthTxt

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_ActlCostgRunRsltEnhcdWthTxt.
-- 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_ActlCostgRunRsltEnhcdWthTxt AS
SELECT
  CostEstimate,
  CurrencyRole,
  Ledger,
  cast( MaterialLedgerCategory as fml_material_ledger_category preserving type ) AS MaterialLedgerCategory,
  cast( ProcessCategory as fml_process_category preserving type ) AS ProcessCategory,
  MatlLdgrDocIsCostingRelevant,
  ProcurementAlternative,
  ProductionProcess,
  MovementType,
  GLAccount,
  PriceDeterminationControl,
  ValuationArea,
  Material,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  WBSElementExternalID,
  Supplier,
  ValuationQuantityUnit,
  Currency,
  _InvtrySpclStkTypeTxt.InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  cast( _MatlLdgrCatTxt .MaterialLedgerCategoryText as fml_matl_ledger_category_text preserving type ) AS MaterialLedgerCategoryText,
  cast( _MatlLdgrProcCatTxt .ProcessCategoryName as fml_process_category_text preserving type ) AS ProcessCategoryName,
  GoodsMovementTypeName,
  _GLText.GLAccountName AS GLAccountName,
  CompanyCode,
  ControllingArea,
  _LdgrValnCrcyRole.AccountingValuationView AS ControllingValuationType
FROM P_ActualCostingRunResultEnhcd
LEFT OUTER JOIN I_InventorySpecialStockTypeT AS _InvtrySpclStkTypeTxt ON InventorySpecialStockType = _InvtrySpclStkTypeTxt.InventorySpecialStockType AND _InvtrySpclStkTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerCategoryTxt AS _MatlLdgrCatTxt ON MaterialLedgerCategory = _MatlLdgrCatTxt.MaterialLedgerCategory AND _MatlLdgrCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_MLProcessCategoryText AS _MatlLdgrProcCatTxt ON ProcessCategory = _MatlLdgrProcCatTxt.ProcessCategory AND _MatlLdgrProcCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_MatlLedgerValnCrcyRole AS _LdgrValnCrcyRole ON CurrencyRole = _LdgrValnCrcyRole.CurrencyRole AND Ledger = _LdgrValnCrcyRole.Ledger AND CompanyCode = _LdgrValnCrcyRole.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLText ON CompanyCode = _GLText.CompanyCode AND GLAccount = _GLText.GLAccount AND _GLText.Language = $session.system_language  -- association [0..1]
;