I_DepreciationAreaForLedger

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_DepreciationAreaForLedger.
-- 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_DepreciationAreaForLedger AS
SELECT
  CompanyCode,
  Ledger,
  AssetDepreciationArea,
  AssetValuationView,
  FiscalYearVariant,
  ValidityStartFiscalYear,
  ValidityEndFiscalYear,
  cast('' as afapl) AS ChartOfDepreciation,
  cast('00' as afabe_d) AS AssetRealDepreciationArea1,
  cast('00' as afabe_d) AS AssetRealDepreciationArea2,
  cast('00' as afabe_d) AS AssetRealDepreciationArea3,
  cast('00' as afabe_d) AS AssetRealDepreciationArea4,
  cast('' as accounting_principle) AS AccountingPrinciple,
  cast('' as buhbkt) AS AssetGLPostingMethod,
  cast('0' as anteil) AS DerivedDeprAreaValCalcFactor1,
  cast('0' as anteil) AS DerivedDeprAreaValCalcFactor2,
  cast('0' as anteil) AS DerivedDeprAreaValCalcFactor3,
  cast('0' as anteil) AS DerivedDeprAreaValCalcFactor4,
  cast('' as abvorz) AS DerivedDeprAreaValCalcSign1,
  cast('' as abvorz) AS DerivedDeprAreaValCalcSign2,
  cast('' as abvorz) AS DerivedDeprAreaValCalcSign3,
  cast('' as abvorz) AS DerivedDeprAreaValCalcSign4,
  cast('' as vzansw) AS AcquisitionValueCalcSign,
  cast('' as fagl_target_ldgrp) AS LedgerGroup,
  IsRealDepreciationArea,
  IsRepresentativeLedger
FROM P_DepreciationAreaForLedger
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_AssetValuationView AS _AssetValuationView ON AssetValuationView = _AssetValuationView.AssetValuationView  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_DeprAreaForLedgerText AS _Text ON CompanyCode = _Text.CompanyCode AND Ledger = _Text.Ledger AND AssetDepreciationArea = _Text.AssetDepreciationArea  -- association [0..*]
;