I_EstimatedCostCostingRun

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 I_EstimatedCostCostingRun.
-- 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.

CREATE VIEW I_EstimatedCostCostingRun AS
SELECT
  kalaid AS EstimatedCostCostingRun,
  kaladat AS EstimatedCostCostingRunDate,
  tvers AS CostingVersion,
  cast(kala.kalabez as fpc_costing_run_description preserving type) AS EstimatedCostCostingRunDesc,
  kala.klvaf AS CostingVariant,
  kala.kokrs AS ControllingArea,
  kala.bukrs AS CompanyCode,
  kala.uebid AS CostEstimateTransferControl,
  kala.erfnm AS CreatedByUser,
  kala.cpudt AS CreationDate,
  kala.mgtyp AS QuantityStructureType,
  kala.aldat AS QuantityStructureDate,
  kala.kalka AS CostingType,
  kala.bwdat AS MaterialValuationDate,
  kala.bidat AS CostEstimateValidityEndDate,
  kala.kadat AS CostEstimateValidityStartDate,
  kala.freq AS EstdCostCostgRunRcrrcFrqcy,
  kala.rec_step AS EstdCostCostgRunStoppingStep,
  kala.rec_date AS EstdCostCostgRunRcrrcDate,
  kala.rec_time AS EstdCostCostgRunRcrrcTime,
  _CostingVariant.ValuationVariant AS ValuationVariant,
  _CostingType._Ledger AS _Ledger,
  _CostingType._LedgerText AS _LedgerText,
  _CostingVariant.CostEstimateReferenceVariant AS CostEstimateReferenceVariant,
  _CostingType.ControllingValuationType AS ControllingValuationType,
  _CostingType.Ledger AS Ledger
FROM kala
LEFT OUTER JOIN I_CostingVersion AS _CostingVersion ON CostingVersion = _CostingVersion.CostingVersion AND CostingType = _CostingVersion.CostingType AND valuationvariant = _CostingVersion.ValuationVariant  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _CostingVariant ON _CostingVariant.CostingVariant = CostingVariant  -- association [0..1]
LEFT OUTER JOIN I_CostingType AS _CostingType ON _CostingType.CostingType = CostingType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostEstimateTransferControl AS _TransferControl ON CostEstimateTransferControl = _TransferControl.CostEstimateTransferControl  -- association [0..1]
LEFT OUTER JOIN I_QuantityStructureType AS _QuantityStructureType ON QuantityStructureType = _QuantityStructureType.QuantityStructureType  -- association [0..1]
LEFT OUTER JOIN I_CostingValuationVariant AS _CostingValuationVariant ON valuationvariant = _CostingValuationVariant.ValuationVariant  -- association [0..1]
LEFT OUTER JOIN I_EstdCostRunRcrrcFrqcy AS _EstdCostRunRcrrcFrqcy ON EstdCostCostgRunRcrrcFrqcy = _EstdCostRunRcrrcFrqcy.EstdCostCostgRunRcrrcFrqcy  -- association [0..1]
LEFT OUTER JOIN I_EstdCostRunStopStep AS _EstdCostRunStopStep ON EstdCostCostgRunStoppingStep = _EstdCostRunStopStep.EstdCostCostgRunStoppingStep  -- association [0..1]
LEFT OUTER JOIN I_ControllingValuationType AS _ControllingValuationType ON controllingvaluationtype = _ControllingValuationType.ControllingValuationType  -- association [0..1]
LEFT OUTER JOIN I_CostEstimateReferenceVariant AS _CostEstimateReferenceVariant ON _CostingVariant.CostEstimateReferenceVariant = _CostEstimateReferenceVariant.CostEstimateReferenceVariant  -- association [0..1]
;