C_MatlLdgrPrSalesOrderCostEst

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 C_MatlLdgrPrSalesOrderCostEst.
-- 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: CMVSOCOSTEST

CREATE VIEW C_MatlLdgrPrSalesOrderCostEst AS
SELECT
  ce.CostEstimate AS CostEstimate,
  ce.CostEstimateStatus AS CostEstimateStatus,
  lvcr.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  lvcr.Ledger AS Ledger,
  lvcr.LegalCurrencyRole AS LegalCurrencyRole,
  lvcr.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  lvcr.AccountingValuationSubview AS AccountingValuationSubview,
  lvcr.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  lvcr.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  lvcr.LedgerName AS LedgerName,
  lvcr.AccountingValuationView AS ControllingValuationType,
  lvcr.AccountingValuationViewName AS AccountingValuationViewName,
  ce.CostingVersion AS CostingVersion,
  ce.CostingVariant AS CostingVariant,
  ce.ValuationVariant AS ValuationVariant,
  ce.CostingType AS CostingType,
  ce.Material AS Material,
  ce.ValuationArea AS ValuationArea,
  ce.CompanyCode AS CompanyCode,
  _CompanyCode.ControllingArea AS ControllingArea,
  ce.PlannedPrice AS PlannedPrice,
  ce.FixedPortionOfPlannedPrice AS FixedPortionOfPlannedPrice,
  ce.Currency AS Currency,
  ce.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  ce.BaseUnit AS BaseUnit,
  ce.ValuationQuantityUnit AS ValuationQuantityUnit,
  '' AS ItemIsSelectedForProcessing,
  ce.SalesOrder AS SalesOrder,
  ce.SalesOrderItem AS SalesOrderItem,
  _CompanyCode._ControllingArea AS _ControllingArea
FROM P_Matval_Manage_Cost_Sls_Ord AS ce
INNER JOIN R_MatlLedgerValnCrcyRole AS lvcr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON controllingarea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingValuationTypeText AS _ControllingValuationTypeText ON ControllingValuationType = _ControllingValuationTypeText.ControllingValuationType  -- association [0..*]
LEFT OUTER JOIN I_CostingVariantText AS _CostingVariantText ON CostingVariant = _CostingVariantText.CostingVariant  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;