Skip to Content
author's profile photo Former Member
Former Member

Purchasing and AP to get Total Spend in BI 7.0

Hi all,

We have a requirement at my client location were we need to provide BW reports on purchasing documents: PO, GR, and INV (with & without a related PO).

We have used 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL

For all Purchasing data (PO's and their GR and IR) we have used 2LIS_02_HDR, 2LIS_02_ITM, & 2LIS_02_SCL and also added a lot of fields from EKKO/EKPO via the standard interface (LBWE)

For non-PO we have used 0FI_AP_4 & we are able to identify the non-PO data by document type.

Now the challenge is how do I combine PO & Non PO in order to report Total Spend by Vendor which contains purchasing documents, PO Value (this is from purchasing data) & Non PO Value (this is from AP). I main challenge over here is LIS structure uses 0VENDOR (LIFNR) & 0INV_PTY (LIFRE) , but the AP uses 0CREDITOR (LIFNR).

I would like to know if anyone has come across similar requirement or if there is any other method to deliver PO, GR & INV values (with and without a related PO)

Thanks for the help in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2012 at 06:04 AM

    any comments please

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2012 at 06:42 AM

    Hi Pria,

    Inorder to report on PO and non-PO, you need to identify a common key which can be used to link the two areas.

    1. Identify a key field by noting all the primary keys of either tables used to populate the two scenarios.

    2. Create a Multiprovider on top of the PO Cube and non-PO cube, where you can allocate the Identifications for each field required in your report.

    3. you may select the respective info provider in the identification to provide the relevant data, but beware you need to have a common field across two cubes which can be used to pull data from the two cubes. for instance, you may have Material number in common across the two cubes, which can be identified in the multiprovider to pull across both the cubes.

    Once this is done, you may build you report based on Vendor and the identified common key field

    Let me know, if this helps!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.