I_FixedAssetCompanyCodeLedger

DDL: I_FIXEDASSETCOMPANYCODELEDGER Type: view_entity BASIC Package: FINS_FAA_CFG_CMP

Fixed Asset Company Code Ledger

I_FixedAssetCompanyCodeLedger is a Basic CDS View that provides data about "Fixed Asset Company Code Ledger" in SAP S/4HANA. It reads from 1 data source (faat_cmp_ledger) and exposes 5 fields with key fields CompanyCode, Ledger. Part of development package FINS_FAA_CFG_CMP.

Data Sources (1)

SourceAliasJoin Type
faat_cmp_ledger faat_cmp_ledger from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fixed Asset Company Code Ledger view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code
KEY Ledger ledger
AssetAcctgLastOpenFiscalYear
FixedAssetLedgerPlanningHrzn plan_horizon
_FiscalYearVariant _FiscalYearVariant
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fixed Asset Company Code Ledger'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_FixedAssetCompanyCodeLedger as select from faat_cmp_ledger
//association[0..1] to I_FiscalYearVariantText  as _Text on  $projection.FiscalYearVariant = _Text.FiscalYearVariant

//                                                       and _Text.Language = $session.system_language

association[0..1] to I_FiscalYearForLedger    as _FiscalYearVariant on  $projection.CompanyCode = _FiscalYearVariant.CompanyCode
                                                                    and $projection.Ledger      = _FiscalYearVariant.Ledger
                                                                    and $projection.AssetAcctgLastOpenFiscalYear = _FiscalYearVariant.FiscalYear
{
  //key mandt as Mandt,

  key comp_code as CompanyCode,
  key ledger as Ledger,
  cast (current_fisc_year as faa_max_open_fisc_year preserving type) as AssetAcctgLastOpenFiscalYear,
  plan_horizon as FixedAssetLedgerPlanningHrzn,

 _FiscalYearVariant
}