I_FixedAssetForLedger

DDL: I_FIXEDASSETFORLEDGER Type: view COMPOSITE

Fixed Asset for Ledger

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

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
P_FixedAssetForLedger P_FixedAssetForLedger 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 #COMPOSITE 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 CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
AssetCapitalizationDate AssetCapitalizationDate
AssetDeactivationDate AssetDeactivationDate
AcquisitionValueDate AcquisitionValueDate
FirstAcquisitionFiscalYear FirstAcquisitionFiscalYear
FirstAcquisitionFiscalPeriod FirstAcquisitionFiscalPeriod
LastRevaluationDate LastRevaluationDate
_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: #COMPOSITE
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MASTER,
                modelingPattern: #NONE,
                supportedCapabilities: [#SQL_DATA_SOURCE]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_FixedAssetForLedger
  as select from P_FixedAssetForLedger

  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 CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
  key FixedAsset,
      @ObjectModel.foreignKey.association: '_Ledger'
  key Ledger,

      AssetCapitalizationDate,
      AssetDeactivationDate,
      AcquisitionValueDate,
      FirstAcquisitionFiscalYear,
      FirstAcquisitionFiscalPeriod,
      LastRevaluationDate,

      /* Associations */
      _CompanyCode,
      _MasterFixedAsset,
      _FixedAsset,
      _Ledger,
      _AssetValuationForLedger
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FIXEDASSETFORLEDGER"
],
"ASSOCIATED":
[
"I_ASSETVALUATIONFORLEDGER",
"I_COMPANYCODE",
"I_FIXEDASSET",
"I_LEDGER",
"I_MASTERFIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More