on 2023 May 12 1:42 PM
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.
Request clarification before answering.
Hello Sona,
to be honest, I don't know the answer, but I would assume the following:
Since the key figures are named like HIST_COUNT_INVOICES and COUNT_INVOICES, I think you can use the field I_OperationalAcctgDocItem.BillingDocument as the aggregation dimension, to count the invoice numbers.
Just give it a try, and let us know the outcome 🙂
Have a nice weekend,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).Soňa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.