Hello,
We have a need for our accounting operations manager to review a list of the fixed assets created over a specific period of time with the entry details prior to us settling value to them (Cost Center, Asset Class, Depreciation Keys, Useful Life, etc.). I know that this information cannot be generated in list form out of the Manage Fixed Assets app, but there are CDS tables which have the information like I_FixedAssets available which have the fields required. Since these assets don't have balances/values at this point they're just master records they do not appear in the asset balances or asset history reports (and tables).
What is the best way to get at this information and generate it in a query or app for a user to consume and filter or at a minimum have it somewhere where it can be exported to an excel file to do those activities?
I've connected oData API's to excel in the past, but I don't believe there are any api's available for S/4HC related to fixed assets. I've setup custom cds tables and custom analytical queries in the past too, but if the cds table has no measure (which the list above will not) you cannot create an analytical query and associate a tile for users. The preview for custom cds tables also doesn't have excel export functionality at this point. There has gotta be a way to setup this info for a user to consume it and filter it within SAP.
Thanks for the help,
Ryan