SQVI Supplier Invoice and EKKO/EKPO

[lynnette1]

I would like to build a SQVI where I can enter a beginning date and end date based on Invoice Date that will return the following: PO Line Item, Material, Short Text, PO, Invoice Ref Number.

What tables do I need and what should I link together in the tables?

Report will be one of many that show compliance to policies such as; invoice prior to PO.

I know how to grab the fields within the SQVI, just unsure of the relationship builder.

I have attached what I thought would work, but it did not produce the right information.

[lynnette1]

Thank you Bg Andreas

I was able to create a SQVI based on your recommendations.

[Lakshmipathi]

If your requirement is addressed, please close the discussion by accepting the Right Answer

[akaserer · Accepted solution]

Hi Lynnette

To link logistic invoices I would use the following tables:

Invoices: RBKP + RSEG (or RBKP + RBDRSEG for background processed invoices)

and join position table with EKPO.

From RBKP you take:

beginning date and end date - BLDAT

Invoice Ref Number - XBLNR

...

Bg Andreas