R_FixedAssetLedgerTP

DDL: R_FIXEDASSETLEDGERTP Type: view_entity TRANSACTIONAL Package: FINS_FAA_MD_RAP_BO

Fixed Asset Ledger

R_FixedAssetLedgerTP is a Transactional CDS View that provides data about "Fixed Asset Ledger" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetForLedger) and exposes 15 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger. Part of development package FINS_FAA_MD_RAP_BO.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetForLedger I_FixedAssetForLedger from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fixed Asset Ledger view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER 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
_FixedAsset _FixedAsset
_Ledger _Ledger
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_AssetValuationForLedger _AssetValuationForLedger 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fixed Asset Ledger'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','Ledger'],
  usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
 }

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&' ]

define view entity R_FixedAssetLedgerTP
  as select from I_FixedAssetForLedger

  association to parent R_FixedAssetTP as _FixedAsset on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                      and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                      and $projection.FixedAsset       = _FixedAsset.FixedAsset

{
        // Keys

  key   CompanyCode,

  key   MasterFixedAsset,

  key   FixedAsset,

  key   Ledger,

        AssetCapitalizationDate,

        AssetDeactivationDate,

        AcquisitionValueDate,

        FirstAcquisitionFiscalYear,

        FirstAcquisitionFiscalPeriod,

        LastRevaluationDate,

        /* Associations */
        _FixedAsset,

        _Ledger,
        _CompanyCode,
        _MasterFixedAsset,
        _AssetValuationForLedger
}

Learn More