Is there a Report or CDS View that can give details of list of Journal Entries billed as part of specific billing document/invoice

[Former Member]

Is there a Report or CDS View that can give details of list of Journal Entries billed as part of specific billing document/invoice

[Amith_Nair · Accepted solution]

Hi Roshini,

I am not sure if you already found a solution to your problem statement, but, I assume you must have already explored the cube that is based on the Journal Entry Item CDS view- I_JournalEntryItemCube

This view is based on the database table ACDOCA

Further more, we have another view I_ActualPlanJournalEntryItemCube(based on the database table ACDOCA and ACDOCP), which provide access to plan data (FinancialPlanningEntryItem CDS view) in addition to most important business entities, such as G/L account, company code, cost center or profit center. The CDS view also contains all balance carry forward postings.

The CDS view also contains all balance carry forward postings. We also have an app based out of this view, which is called P&L- Plan/ Actuals App

These views certainly hold the attributes that you’re looking for.

Let me know if this make sense to your effort.

Thank you! Amith Nair

[arvshar2 · Accepted solution]

Thanks, Amith. I check view I_ActualPlanJournalEntryItemCube but could not find, though I see view I_ActualPlanJournalEntryItem. How to find I_ActualPlanJournalEntryItemCube view.

[Former Member]

Hi Jeroen,

Thank you for the response.

Actually I am looking for a Report/App/CDS View which can give following.

Example: Posted say supplier invoice say for 100 USD . Later did billing of the same. Then I need to basically report out in detail the costs which was billed i.e.

Expense P&L G/L account

Journal Entry Number

Journal Entry Type

Journal Entry Created By

Journal Posting Date

Transaction Reference Number that's fed in Supplier Invoice Header

WBSE

Personnel Number

Amount Billed in Global Currency

Regards

Rohini Pillai

[Jeroen_Zijderveld]

Hi Rohini,

In the app 'Manage Journal Entries' the billing document number is available in the field 'Reference'. You can add this field to the filter and find the journal entries for a certain billing document. Only thing is that the field uses leading zeros, so a billing document can be found like '0090000001' .

hope this helps,

Jeroen