Duplicate Payment Report - AP

[#1]

hi

i want to run report based on Duplicate Payment . which table contains this information? this report should return different and/ or the same vendors with the same invoice numbers, and/or identical payment amounts with different invoices and the same vendor -

any table contain this information?

[Former Member]

TO,

kudlabwguy,

In Enterprise Data Warehousing, Data comes from ERP tables , so you can confirm the duplicates Payment Data from EPR Table(BSIK-Check Status, PAYRQ-Payment Request....etc ).

I think you will get idea.

Devendra Meshram

Osaka

[Former Member]

hi

is there any data source carries this information into BW? or do i have to create any generic data source?

BSIK carries vendor information and how do i know if duplicate payment or duplicate invoice generated?

[Former Member]

Standard Extractor 0FI_AP_4 brings data from BSIK and BSAK.

you should be able to query data from InfoProviders based on this data source.

You might be able to use standard DSO 0FIAP_O03 for this.

If you have two or more clearing documents with the same invoice number, you might have some partial payments or duplicate payments.

You might want to involve your busienss users to find out the exact criteria to identify duplicate payments. It will be lot easier to meet the requirements if you try to understand the functional requirements from the business and then locate the fields that are needed for this purpose and try to come up with the correct logic for this.

Good Luck.

MP.

[Former Member]

hi

Here is the logic needed for this report.

1 different and/ or the same vendors with the same invoice numbers,

2 identical payment amounts with different invoices and the same vendor

How to display only this in bex? or do i need to feed this to separate ods ?

[Former Member]

Hi,

One of the options would be to create an infoset on top of vendor and invoice number infoobjects. Do the joins as appropriate.

Thanks