I_DepreciationArea

DDL: I_DEPRECIATIONAREA Type: view COMPOSITE
31 Fields 1 Data Sources 7 Associations

Depreciation Area

I_DepreciationArea (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_DepreciationArea is a Composite CDS View (Dimension) that provides data about "Depreciation Area" in SAP S/4HANA. It reads from 1 data source (I_DepreciationAreaForLedger) and exposes 31 fields with key fields CompanyCode, Ledger, AssetDepreciationArea. It has 7 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-AA-IS
CapabilitiesAnalytical Dimension
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DepreciationAreaForLedger I_DepreciationAreaForLedger from

Associations (7)

CardinalityTargetAliasCondition
[1] I_ChartOfDepreciation _ChartOfDepreciation $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
[0..1] I_LedgerGroup _LedgerGroup $projection.LedgerGroup = _LedgerGroup.LedgerGroup
[0..1] I_RealDepreciationArea _RealDepreciationArea1 $projection.ChartOfDepreciation = _RealDepreciationArea1.ChartOfDepreciation and $projection.AssetRealDepreciationArea1 = _RealDepreciationArea1.AssetRealDepreciationArea
[0..1] I_RealDepreciationArea _RealDepreciationArea2 $projection.ChartOfDepreciation = _RealDepreciationArea2.ChartOfDepreciation and $projection.AssetRealDepreciationArea2 = _RealDepreciationArea2.AssetRealDepreciationArea
[0..1] I_RealDepreciationArea _RealDepreciationArea3 $projection.ChartOfDepreciation = _RealDepreciationArea3.ChartOfDepreciation and $projection.AssetRealDepreciationArea3 = _RealDepreciationArea3.AssetRealDepreciationArea
[0..1] I_RealDepreciationArea _RealDepreciationArea4 $projection.ChartOfDepreciation = _RealDepreciationArea4.ChartOfDepreciation and $projection.AssetRealDepreciationArea4 = _RealDepreciationArea4.AssetRealDepreciationArea
[0..1] I_AccountingPrinciple _AccountingPrinciple $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IDEPRAREA view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
EndUserText.label Depreciation Area view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey AssetDepreciationArea view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger in General Ledger Accounting
KEY AssetDepreciationArea AssetDepreciationArea Depreciation Area Real or Derived
ChartOfDepreciation ChartOfDepreciation Chart of Depreciaton for Asset Valuation
AssetRealDepreciationArea1 AssetRealDepreciationArea1 Real depreciation area
AssetRealDepreciationArea2 AssetRealDepreciationArea2 Real depreciation area
AssetRealDepreciationArea3 AssetRealDepreciationArea3 Real depreciation area
AssetRealDepreciationArea4 AssetRealDepreciationArea4 Real depreciation area
AccountingPrinciple AccountingPrinciple Accounting Principle
AssetGLPostingMethod AssetGLPostingMethod Post to G/L Account
DerivedDeprAreaValCalcFactor1 DerivedDeprAreaValCalcFactor1 Proportion of Real Depreciation Area in Derived Dep.Area
DerivedDeprAreaValCalcFactor2 DerivedDeprAreaValCalcFactor2 Proportion of Real Depreciation Area in Derived Dep.Area
DerivedDeprAreaValCalcFactor3 DerivedDeprAreaValCalcFactor3 Proportion of Real Depreciation Area in Derived Dep.Area
DerivedDeprAreaValCalcFactor4 DerivedDeprAreaValCalcFactor4 Proportion of Real Depreciation Area in Derived Dep.Area
DerivedDeprAreaValCalcSign1 DerivedDeprAreaValCalcSign1 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area
DerivedDeprAreaValCalcSign2 DerivedDeprAreaValCalcSign2 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area
DerivedDeprAreaValCalcSign3 DerivedDeprAreaValCalcSign3 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area
DerivedDeprAreaValCalcSign4 DerivedDeprAreaValCalcSign4 +/- Sgn of Real Dep. Area in Screen Layout Rule of Der. Area
AcquisitionValueCalcSign AcquisitionValueCalcSign +/- Sign for Acquisition Value
LedgerGroup LedgerGroup Target Ledger Group
IsRealDepreciationArea IsRealDepreciationArea Indicator: Store Real Depreciation Area
_CompanyCode _CompanyCode
_Ledger _Ledger
_ChartOfDepreciation _ChartOfDepreciation
_LedgerGroup _LedgerGroup
_RealDepreciationArea1 _RealDepreciationArea1
_RealDepreciationArea2 _RealDepreciationArea2
_RealDepreciationArea3 _RealDepreciationArea3
_RealDepreciationArea4 _RealDepreciationArea4
_AccountingPrinciple _AccountingPrinciple
_Text _Text

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_DepreciationArea.
-- 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_DepreciationArea AS
SELECT
  CompanyCode,
  Ledger,
  AssetDepreciationArea,
  ChartOfDepreciation,
  AssetRealDepreciationArea1,
  AssetRealDepreciationArea2,
  AssetRealDepreciationArea3,
  AssetRealDepreciationArea4,
  AccountingPrinciple,
  AssetGLPostingMethod,
  DerivedDeprAreaValCalcFactor1,
  DerivedDeprAreaValCalcFactor2,
  DerivedDeprAreaValCalcFactor3,
  DerivedDeprAreaValCalcFactor4,
  DerivedDeprAreaValCalcSign1,
  DerivedDeprAreaValCalcSign2,
  DerivedDeprAreaValCalcSign3,
  DerivedDeprAreaValCalcSign4,
  AcquisitionValueCalcSign,
  LedgerGroup,
  IsRealDepreciationArea
FROM I_DepreciationAreaForLedger
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
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]
;

Learn More