on 08-05-2009 6:39 AM
Dear Experts,
Please guide me, How to get the link between payment document and Miro document , any table or report?
Regards
Chandu
Solved my self
Regards
chandu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use can try through Purchase Order History table EKBE and BSIK, BSAK tables also.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.