Skip to Content
0
Jun 22, 2023 at 09:05 AM

CDS View or API for Asset dispaly vaultion report (Public Cloud 3SL )

219 Views Last edit Jun 23, 2023 at 03:10 AM 3 rev

Hello All ,

We have new requirement from customer on Asset report which contain details like Asset number , deprecation start date , use life , and need planned deprecation month wise till the useful life of particular asset .

Asset ID

Company Code

Cost Center

Capitalized Amount

Depreciation Start date

Depreciation End Date

Fiscal Year

Fiscal Period

Depreciation Amount

Currency

Net Value

We didn’t find any report in standard SAP , hence we want to develop new extension for the same .

To create a new report, we need APIs or whitelisted CDS views.

We couldn’t find any Asset -Depreciation Balance fields like Depreciation Status and OrdinaryDeprAmtInDspCrcy in any Asset related whitelisted CDS views or in Asset related APIs.

We have checked in below whitelisted CDS views.

Asset related whitelisted CDS views

I_ObjectAssetType

I_AssetClass

I_FixedAssetStdVH

I_FixedAsset

I_ObjectAssetCategory

I_ObjectAssetTypeText

I_ParkedOplAcctgDocAssetItem

I_FixedAssetForLedger

I_FixedAssetGroup

I_AssetClassText

I_AssetKeyFigure

I_MasterFixedAsset

I_AssetAcctDetermination

I_AssetBalanceCube

I_ObjectAssetCategory

I_ObjectAssetTypeText

I_ObjectAssetData

I_BPGerAstRglnRstrcdAstQta

I_AssetTransactionTypeText

I_AssetEvaluationKeyText

I_FixedAssetGroupText

I_FixedAssetUsageObject

I_AssetHistorySheetCube

I_AssetAcctDeterminationText

I_ProfitCenterToFixedAsset

I_AssetKeyFigureSet

I_AssetValuationForLedger

I_RU_AssetDepreciationGroup

I_RU_AssetOKOF

I_AssetTransactionTypeText

I_AgreementAssetCalcData

I_ObjectAssetVerificationFrqcy

I_BPGerAstRglnRstrcdAstQtaText

I_SecuritiesAccountAssetType

I_AssetAgreementLinkData

I_ObjectAssetLiquidationType

I_ObjectAssetValuationFrqcy

I_ObjectAssetDocument

I_ObjectAssetCategoryText

I_Group2AssetEvaluationKey

I_Group3AssetEvaluationKey

I_Group4AssetEvaluationKey

I_FixedAssetAssgmt

I_FixedAssetCountryData

I_CompanyCodeAsset

I_AssetBalancesKeyFigureSetVH

I_AssetRedesignSwitchStatus

I_AssetKeyFigureSetText

I_Group1AssetEvaluationKey

I_RU_AssetDepreciationGroupT

I_RU_AssetOKOFText

I_Group5AssetEvaluationKey

I_ObjAssetVerificationFrqcyTxt

I_FinAssetsMgntProductType

I_ObjectAssetPartner

I_ObjectAssetValuationFrqcyTxt

I_ObjAssetLiquidationTypeText

I_ShortenedFiscalYear

I_FixedAssetUsageObjectPeriod

I_Group4AssetEvaluationKeyText

I_Group3AssetEvaluationKeyText

I_Group1AssetEvaluationKeyText

I_Group2AssetEvaluationKeyText

I_AssetHistSheetKeyFigureSetVH

I_FixedAssetUsageObjectTotal

I_Group5AssetEvaluationKeyText

I_FinAssetsMgntProductTypeT

I_AssetSortedKeyFigureSetSpec

Can you please check and support us to get the right API or CDS views which can provide these details.

Kindly let me know if you need any further information or clarification .

Thanks & Regards

Suhas