Skip to Content
0

Document Numbers from RBKP (Invoice Header) not found in RSEG (Invoice Items)

Apr 26 at 04:15 AM

18

avatar image
Former Member

I am trying to develop a test for 3-way-match all the way from AP items to POs / Deliveries using a bunch of tables from SAP, but I'm having problems ensring completness of the downloads.

In particular , I noticed that there are a number of Document No.'s for the year 2018 in the Table RBKP that are missing in the table RSEG. the RSEG table will contain the Document No for prior years, but not for the current year.

How is this possible? I need the RSEG table to get the Purch. Doc. Number, with which I can then acces EKBE, EKPO and EKKO tables. But I need to make sure that no items are lost on the way.

Any suggestions are highly appreciated

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Samson Wang
May 01 at 08:24 AM
1

Hi Tyro,


While posting an invoice with reference to PO, it should not have different fiscal years updated in the header (RBKP) and item levels (RSEG).
For the mentioned situation, it seems that the invoice was directly posted to G/L account or Material account without reference PO, so that
there was no any record generated in RSEG table, but the table RBCO or RBMA should be updated in such of case.

Therefore, you can use MIR4 to display this invoice and check if there is any line items entered in the "PO reference" Tab.
if no any line items exists there, there is no RSEG entry generated. If necessary you may need to check the entries in RBKP, RBCO and RBMA.

Hope this could be of help.

Share
10 |10000 characters needed characters left characters exceeded