cancel
Showing results for 
Search instead for 
Did you mean: 

MIRO and Payment document link

Former Member
0 Kudos

Dear Experts,

Please guide me, How to get the link between payment document and Miro document , any table or report?

Regards

Chandu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Solved my self

Regards

chandu

Former Member
0 Kudos

The information is not stored in a single table.

You could use the following logic

a. Take the list of payment documents from BSAS using the outgoing payment GL account(s).

b. Get the corresponding invoice accounting documents (check using document type to ensure they belong to Invoice verification) from BSAK where AUGBL (clearing document) and AUGDT (clearing date) equals the document numbers obtained in a above.

c. Get the invoice line item details from table RSEG.Alternatively you could also get the invoice numbers from BKPF-AWKEY.

This can be achieved using an ABAP query or writing an ABAP code.

Note that this does not consider partial payments. For partial payments you have to use table BSIS too in step a and compare BSIK too in step B using XREF (reference) or ZUONR (assignment) as the comparison criteria.

Former Member
0 Kudos

Hi,

Use can try through Purchase Order History table EKBE and BSIK, BSAK tables also.

Former Member
0 Kudos

Thanks for your reply

i need all document in one in one table is it possible

for ex: PO no; MIGO, MIRO, Payment

Regards

chandu