I_FixedAssetForLedger

DDL: I_FIXEDASSETFORLEDGER Type: view BASIC Package: FINS_FIS_AA_MD

Fixed Asset for Ledger

I_FixedAssetForLedger is a Basic CDS View that provides data about "Fixed Asset for Ledger" in SAP S/4HANA. It reads from 1 data source (faat_md_ld) and exposes 15 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger. It has 5 associations to related views. Part of development package FINS_FIS_AA_MD.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
faat_md_ld faat_md_ld from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_MasterFixedAsset _MasterFixedAsset $projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
[1..1] I_FixedAsset _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[0..*] I_AssetValuationForLedger _AssetValuationForLedger $projection.CompanyCode = _AssetValuationForLedger.CompanyCode and $projection.MasterFixedAsset = _AssetValuationForLedger.MasterFixedAsset and $projection.FixedAsset = _AssetValuationForLedger.FixedAsset and $projection.Ledger = _AssetValuationForLedger.Ledger

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFIASSETFORLDGR view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fixed Asset for Ledger view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code
KEY MasterFixedAsset asset_no
KEY FixedAsset asset_subno
KEY Ledger ledger
AssetCapitalizationDate capitalization_date
AssetDeactivationDate deactivation_date
AcquisitionValueDate acquisition_date
FirstAcquisitionFiscalYear acquisition_year
FirstAcquisitionFiscalPeriod acquisition_period
LastRevaluationDate last_reval_date
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_Ledger _Ledger
_AssetValuationForLedger _AssetValuationForLedger 
@AbapCatalog: {sqlViewName: 'IFIASSETFORLDGR', preserveKey: true}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fixed Asset for Ledger'
@VDM.viewType: #BASIC
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MASTER,
                modelingPattern: #NONE,
                supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_FixedAssetForLedger
  as select from faat_md_ld

  association [1..1] to I_CompanyCode             as _CompanyCode             on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_MasterFixedAsset        as _MasterFixedAsset        on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                              and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [1..1] to I_FixedAsset              as _FixedAsset              on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                              and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                              and $projection.FixedAsset       = _FixedAsset.FixedAsset
  association [1..1] to I_Ledger                  as _Ledger                  on  $projection.Ledger = _Ledger.Ledger
  association [0..*] to I_AssetValuationForLedger as _AssetValuationForLedger on  $projection.CompanyCode      = _AssetValuationForLedger.CompanyCode
                                                                              and $projection.MasterFixedAsset = _AssetValuationForLedger.MasterFixedAsset
                                                                              and $projection.FixedAsset       = _AssetValuationForLedger.FixedAsset
                                                                              and $projection.Ledger           = _AssetValuationForLedger.Ledger
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key comp_code           as CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key asset_no            as MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
  key asset_subno         as FixedAsset,
      @ObjectModel.foreignKey.association: '_Ledger'
  key ledger              as Ledger,

      capitalization_date as AssetCapitalizationDate,
      deactivation_date   as AssetDeactivationDate,
      acquisition_date    as AcquisitionValueDate,
      acquisition_year    as FirstAcquisitionFiscalYear,
      acquisition_period  as FirstAcquisitionFiscalPeriod,
      last_reval_date     as LastRevaluationDate,

      /* Associations */
      _CompanyCode,
      _MasterFixedAsset,
      _FixedAsset,
      _Ledger,
      _AssetValuationForLedger
}

Learn More