C_MatlValnManageCostEst

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_MatlValnManageCostEst.
-- 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: CMVMCOSTEST

CREATE VIEW C_MatlValnManageCostEst AS
SELECT
  CostEstimate,
  CostingStatus,
  ce.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  lvcr.Ledger AS Ledger,
  lvcr.LegalCurrencyRole AS LegalCurrencyRole,
  lvcr.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  cast( lvcr.CurrencyRole as fins_ext_curtype preserving type ) AS CurrencyRole,
  lvcr.CurrencyRoleName AS CurrencyRoleName,
  lvcr.AccountingValuationSubview AS AccountingValuationSubview,
  lvcr.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  lvcr.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  lvcr.LedgerName AS LedgerName,
  lvcr.AccountingValuationView AS ControllingValuationType,
  lvcr.AccountingValuationViewName AS AccountingValuationViewName,
  CostingVersion,
  CostingVariant,
  CostEstimateValidityStartDate,
  ValuationArea,
  ce.CompanyCode AS CompanyCode,
  _CompanyCode.ControllingArea AS ControllingArea,
  ValuationVariant,
  CostingType,
  CostEstimateMarkingDate,
  CostEstimateMarkingUser,
  CostEstimateReleaseDate,
  CostEstimateReleaseUser,
  PlannedPrice,
  FixedPortionOfPlannedPrice,
  ce.Currency AS Currency,
  MaterialPriceUnitQty,
  BaseUnit,
  ValuationQuantityUnit,
  '' AS ItemIsSelectedForProcessing,
  ce.Material AS Material,
  _CompanyCode._ControllingArea AS _ControllingArea
FROM P_Matval_Manage_Cost 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]
;