I_DepreciationAreaWithLedger

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_DepreciationAreaWithLedger.
-- 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_DepreciationAreaWithLedger AS
SELECT
  ChartOfDepreciation,
  AssetDepreciationArea,
  AssetRealDepreciationArea1,
  AssetRealDepreciationArea2,
  AssetRealDepreciationArea3,
  AssetRealDepreciationArea4,
  AccountingPrinciple,
  AssetGLPostingMethod,
  DerivedDeprAreaValCalcFactor1,
  DerivedDeprAreaValCalcFactor2,
  DerivedDeprAreaValCalcFactor3,
  DerivedDeprAreaValCalcFactor4,
  DerivedDeprAreaValCalcSign1,
  DerivedDeprAreaValCalcSign2,
  DerivedDeprAreaValCalcSign3,
  DerivedDeprAreaValCalcSign4,
  I_AssetDepreciationArea.LedgerGroup AS LedgerGroup,
  IsRealDepreciationArea,
  case when I_LedgerGroupAssignment.LedgerGroup is not null then I_LedgerGroupAssignment.Ledger else '' end as RepresentativeLedger AS LedgerelseendasRepresentativeLedger
FROM I_AssetDepreciationArea
LEFT OUTER JOIN I_LedgerGroupAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Ledger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [1]
LEFT OUTER JOIN I_AssetDepreciationAreaText AS _Text ON ChartOfDepreciation = _Text.ChartOfDepreciation AND AssetDepreciationArea = _Text.AssetDepreciationArea  -- association [0..*]
LEFT OUTER JOIN I_RealDepreciationArea AS _RealDepreciationArea1 ON ChartOfDepreciation = _RealDepreciationArea1.ChartOfDepreciation AND AssetRealDepreciationArea1 = _RealDepreciationArea1.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_RealDepreciationArea AS _RealDepreciationArea2 ON ChartOfDepreciation = _RealDepreciationArea2.ChartOfDepreciation AND AssetRealDepreciationArea2 = _RealDepreciationArea2.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_RealDepreciationArea AS _RealDepreciationArea3 ON ChartOfDepreciation = _RealDepreciationArea3.ChartOfDepreciation AND AssetRealDepreciationArea3 = _RealDepreciationArea3.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_RealDepreciationArea AS _RealDepreciationArea4 ON ChartOfDepreciation = _RealDepreciationArea4.ChartOfDepreciation AND AssetRealDepreciationArea4 = _RealDepreciationArea4.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
;