I_CoCodeLedgerDeprArea

DDL: I_COCODELEDGERDEPRAREA Type: view BASIC

Company code dependent settings for Depreciation Area

I_CoCodeLedgerDeprArea is a Basic CDS View that provides data about "Company code dependent settings for Depreciation Area" in SAP S/4HANA. It reads from 1 data source (faat_cmp_da) and exposes 7 fields with key fields CompanyCode, Ledger, AssetDepreciationArea. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
faat_cmp_da faat_cmp_da from

Associations (3)

CardinalityTargetAliasCondition
[1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[1] I_DepreciationAreaForLedger _AssetDepreciationArea $projection.CompanyCode = _AssetDepreciationArea.CompanyCode and $projection.Ledger = _AssetDepreciationArea.Ledger and $projection.AssetDepreciationArea = _AssetDepreciationArea.AssetDepreciationArea

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETCCODEDA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Company code dependent settings for Depreciation Area view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code
KEY Ledger ledger
KEY AssetDepreciationArea depr_area
AssetAcctgLastClosedFiscalYear closed_fisc_year
_CompanyCode _CompanyCode
_Ledger _Ledger
_AssetDepreciationArea _AssetDepreciationArea 
@AbapCatalog: {sqlViewName: 'IFASSETCCODEDA', compiler.compareFilter: true, preserveKey: true}
@EndUserText.label: 'Company code dependent settings for Depreciation Area'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #C,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_CoCodeLedgerDeprArea
  as select from faat_cmp_da

  association [1] to I_CompanyCode               as _CompanyCode           on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1] to I_Ledger                    as _Ledger                on  $projection.Ledger = _Ledger.Ledger
  association [1] to I_DepreciationAreaForLedger as _AssetDepreciationArea on  $projection.CompanyCode           = _AssetDepreciationArea.CompanyCode
                                                                           and $projection.Ledger                = _AssetDepreciationArea.Ledger
                                                                           and $projection.AssetDepreciationArea = _AssetDepreciationArea.AssetDepreciationArea
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key comp_code        as CompanyCode,
      @ObjectModel.foreignKey.association: '_Ledger'
  key ledger           as Ledger,
      @ObjectModel.foreignKey.association: '_AssetDepreciationArea'
  key depr_area        as AssetDepreciationArea,

      closed_fisc_year as AssetAcctgLastClosedFiscalYear,

      _CompanyCode,
      _Ledger,
      _AssetDepreciationArea
}

Learn More