I_RealDepreciationAreaByCoCode

DDL: I_REALDEPRECIATIONAREABYCOCODE Type: view BASIC Package: FINS_FIS_AA_MD
8 Fields 1 Data Sources 2 Associations

Real Depreciation Areas of Company Code

I_RealDepreciationAreaByCoCode is a Basic CDS View (Dimension) that provides data about "Real Depreciation Areas of Company Code" in SAP S/4HANA. It reads from 1 data source (t093b) and exposes 8 fields with key fields CompanyCode, AssetRealDepreciationArea. It has 2 associations to related views. Part of development package FINS_FIS_AA_MD.

Data Sources (1)

SourceAliasJoin Type
t093b t093b from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFIREALDPRARCO view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
EndUserText.label Real Depreciation Areas of Company Code view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey AssetRealDepreciationArea view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AssetRealDepreciationArea afabe Deprec. Area
Currency waers Transaction Currency
AssetAcctgLastClosedFiscalYear abgja Closed FYear
FinancialStatementVariant versn_011 FS Version
FiscalYearVariant periv FYear Variant
_CompanyCode _CompanyCode
_Currency _Currency

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_RealDepreciationAreaByCoCode.
-- 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_RealDepreciationAreaByCoCode AS
SELECT
  bukrs AS CompanyCode,
  afabe AS AssetRealDepreciationArea,
  waers AS Currency,
  abgja AS AssetAcctgLastClosedFiscalYear,
  versn_011 AS FinancialStatementVariant,
  periv AS FiscalYearVariant
FROM t093b
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;

Learn More