08-12-2021 2:58 PM - edited 02-04-2024 1:26 AM
Dear Community,
is it possible to add the field "Reference" from the app "Supplier Invoices List" to the embedded analysis "Projects - Actuals"? We need a link between the ext. reference no. ("Reference" from app "Supplier Invoices List") and the field "Reference document" from app "Projects - Actuals"
InfoProvider Technical Name2CIFIDOCJRNLCUBEThanks and best regards,
Bianca
Hi,
Unfortunately, there is no way to populate 'Reference' field from Supplier Invoice into the P&L app. I think a similar thread was also discussed in the past with On premise or with ECC system in the past. (https://answers.sap.com/questions/448253/acdoca-awref-reference-doc-field-in-fb03-screen.html)
There is no way we could join Reference( Invoice no from source system) to ReferenceDocument as its system generated.
The app P&L is not extensible by itself, but what could be possible is to create an app itself by building Custom Analytical Query associating I_ActualPlanJournalEntryItem(primary)OR I_GlAccountLineItemCube(primary) and I_SupplierInvoiceAPI with Reference document and Supplier Invoice being the join condition and then filter ReferenceDocumentType by RMRP and then choose the fields you need from both the view(Outer Join)
Hope this helps!
Thank you!
Amith Nair
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
9 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.