I_AssetLedgerTP

DDL: I_ASSETLEDGERTP SQL: IASSETLDGRTP Type: view TRANSACTIONAL

Asset Ledger

I_AssetLedgerTP is a Transactional CDS View that provides data about "Asset Ledger" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetForLedger) and exposes 16 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetForLedger AssetLedger from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IASSETLDGRTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Asset Ledger view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence FAAV_MD_LD view
ObjectModel.writeDraftPersistence FAAD_MD_LD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetForLedger CompanyCode
KEY MasterFixedAsset I_FixedAssetForLedger MasterFixedAsset
KEY FixedAsset I_FixedAssetForLedger FixedAsset
KEY Ledger I_FixedAssetForLedger Ledger
AssetCapitalizationDate I_FixedAssetForLedger AssetCapitalizationDate
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate
AcquisitionValueDate I_FixedAssetForLedger AcquisitionValueDate
FirstAcquisitionFiscalYear I_FixedAssetForLedger FirstAcquisitionFiscalYear
FirstAcquisitionFiscalPeriod I_FixedAssetForLedger FirstAcquisitionFiscalPeriod
LastRevaluationDate I_FixedAssetForLedger LastRevaluationDate
_AssetTP _AssetTP
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_Ledger _Ledger
_AssetValuationForLedger _AssetValuationForLedger 
@AbapCatalog.sqlViewName: 'IASSETLDGRTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Asset Ledger'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence: 'FAAV_MD_LD',
    writeDraftPersistence:  'FAAD_MD_LD',
    semanticKey: ['Ledger', 'CompanyCode','MasterFixedAsset','FixedAsset'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
}

define view I_AssetLedgerTP
  as select from I_FixedAssetForLedger as AssetLedger

  association [1..1] to I_AssetTP as _AssetTP on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                              and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                              and $projection.FixedAsset       = _AssetTP.FixedAsset

{
        // Keys

  key   AssetLedger.CompanyCode,

  key   AssetLedger.MasterFixedAsset,

  key   AssetLedger.FixedAsset,

        @ObjectModel.readOnly: true
  key   AssetLedger.Ledger,

        //        @ObjectModel:{ mandatory:true, readOnly: true}

        //        //@ObjectModel.editableFieldFor: 'Ledger'

        //        AssetLedger.Ledger                                                as LedgerForEdit,


        // Fields

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.AssetCapitalizationDate,

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.AssetDeactivationDate,

        //@ObjectModel:{ mandatory:false, readOnly:true, enabled:true}

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.AcquisitionValueDate,

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.FirstAcquisitionFiscalYear,

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.FirstAcquisitionFiscalPeriod,


        //@ObjectModel.readOnly: true

        @ObjectModel:{ mandatory:'EXTERNAL_CALCULATION', readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
        AssetLedger.LastRevaluationDate,

        //@ObjectModel.readOnly: true

        //@Semantics.quantity.unitOfMeasure: 'BaseUnit'

        //AssetLedger.Quantity,

        //cast ('0'as abap.quan( 23,3 ) ) as Quantity,





        // Associations

        @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
        _AssetTP,

        //_Quantity,


        //_AssetTP._UnitOfMeasure,


        _CompanyCode,
        _MasterFixedAsset,
        _FixedAsset,
        _Ledger,
        _AssetValuationForLedger


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSETFORLEDGER"
],
"ASSOCIATED":
[
"I_ASSETTP",
"I_ASSETVALUATIONFORLEDGER",
"I_COMPANYCODE",
"I_FIXEDASSET",
"I_LEDGER",
"I_MASTERFIXEDASSET"
],
"BASE":
[
"I_FIXEDASSETFORLEDGER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More