Missing ID column in CDS (business content)

[Sona]

Hello,

I want to install the business content package "SAP Finance Accounts Receivable – Invoice Payment Forecasting". I have done everything according to the documentation starting with CDS view: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/42093f14b43c485fbe3adbbe81eff6c8/9d654f7844ac4d8b8a7fd...

but the query (and CDS) does not contain a column "ID" as can be seen in the link. Therefore I have a problem doing the calculations because they require ID column, please see here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/42093f14b43c485fbe3adbbe81eff6c8/8bb14e798e544efebe85a...

Where is the problem? Should I consider some other column as "ID" - and if yes, which one? Or the problem is that this specific business content is only a template with last update in 2019?

Thank you in advance.

[Sona]

Hi Martin,

thank you for your feedback. I had to eventually create an ID by myself and I did it by concatenating four columns (after some consulting with FI colleague).
However, I couldn´t use just the I_OperationalAcctgDocItem.BillingDocument as the aggregation dimension because there are no unique values.
Appreciate your help 🙂

Soňa