I_AssetValuationForLedger

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_AssetValuationForLedger.
-- 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_AssetValuationForLedger AS
SELECT
  I_AssetTimeBasedValuation.CompanyCode AS CompanyCode,
  I_AssetTimeBasedValuation.MasterFixedAsset AS MasterFixedAsset,
  I_AssetTimeBasedValuation.FixedAsset AS FixedAsset,
  I_AssetTimeBasedValuation.Ledger AS Ledger,
  cast(I_AssetTimeBasedValuation.AssetDepreciationArea as afabe_d) AS AssetRealDepreciationArea,
  I_AssetTimeBasedValuation.ValidityEndDate AS ValidityEndDate,
  I_AssetTimeBasedValuation.ValidityStartDate AS ValidityStartDate,
  I_AssetValuation.DepreciationStartDate AS DepreciationStartDate,
  I_AssetValuation.SpecialDeprStartDate AS SpecialDeprStartDate,
  cast(I_AssetValuation.DeprKeyChangeoverYear as fis_umjar) AS DeprKeyChangeoverYear,
  I_AssetValuation.DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  I_AssetTimeBasedValuation.DepreciationKey AS DepreciationKey,
  cast('' as faa_invsl) AS InvestmentSupportMeasure,
  cast(I_AssetTimeBasedValuation.PlannedUsefulLifeInPeriods as fis_ndper) AS PlannedUsefulLifeInPeriods,
  cast(I_AssetTimeBasedValuation.PlannedUsefulLifeInYears as fis_ndjar) AS PlannedUsefulLifeInYears,
  cast('0000' as fis_vyear) AS VintageYear,
  cast('000' as fis_vmnth) AS VintageMonth,
  cast('000' as fis_ndurp) AS OriglAstUsefulLifeInPerds,
  cast('000' as ndurj) AS OriglAstUsefulLifeInYears,
  I_AssetValuation.ReplacementValueIndexSers AS ReplacementValueIndexSers,
  cast(I_AssetValuation.RplcmtValueAgingIndexSers as fis_alind) AS RplcmtValueAgingIndexSers,
  I_AssetTimeBasedValuation.AcqnProdnCostScrapPercent AS AcqnProdnCostScrapPercent,
  I_AssetTimeBasedValuation.VariableDeprPercent AS VariableDeprPercent,
  I_AssetTimeBasedValuation.ShiftOperationFactor AS ShiftOperationFactor,
  I_AssetTimeBasedValuation.IsShutDown AS IsShutDown,
  I_AssetTimeBasedValuation.DeprCalcBaseValuePercent AS DeprCalcBaseValuePercent,
  I_AssetValuation.LastRetirementValueDate AS LastRetirementValueDate,
  I_AssetValuation.DepreciationAreaType AS DepreciationAreaType,
  I_AssetTimeBasedValuation.ScrapAmountInCoCodeCrcy AS ScrapAmountInCoCodeCrcy,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  I_AssetValuation.AssetOpgReadinessDate AS AssetOpgReadinessDate,
  I_AssetTimeBasedValuation.FixedAssetUsageObject AS FixedAssetUsageObject,
  I_AssetTimeBasedValuation.AssetRevaluationIndex AS AssetRevaluationIndex
FROM I_AssetTimeBasedValuation
INNER JOIN I_AssetValuation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [1..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetRealDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_ReplacementValueIndexSers AS _ReplacementValueIndexSers ON ReplacementValueIndexSers = _ReplacementValueIndexSers.ReplacementValueIndexSers  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetUsageObject AS _FixedAssetUsageObject ON CompanyCode = _FixedAssetUsageObject.CompanyCode AND FixedAssetUsageObject = _FixedAssetUsageObject.FixedAssetUsageObject  -- association [0..1]
LEFT OUTER JOIN I_AssetRevaluationIndex AS _AssetRevaluationIndex ON AssetRevaluationIndex = _AssetRevaluationIndex.AssetRevaluationIndex  -- association [0..1]
LEFT OUTER JOIN I_AssetValuationScrapAmount AS _ScrapAmount ON CompanyCode = _ScrapAmount.CompanyCode AND MasterFixedAsset = _ScrapAmount.MasterFixedAsset AND FixedAsset = _ScrapAmount.FixedAsset AND Ledger = _ScrapAmount.Ledger AND AssetRealDepreciationArea = _ScrapAmount.AssetRealDepreciationArea AND ValidityEndDate = _ScrapAmount.ValidityEndDate  -- association [1..1]
;