EKKO+ RSEG : Report times out

[Former Member]

Hi

What would be the most effetive way to check whether an purchase order has been invoice receipt(IR) and what the invoice document number is?

The report times out because i don't use the year and invoice document number when reading rseg. The link to rseg from ekpo or ekko is the purchase document number.

If i use rseg as a starting point you will not know in which year the purchase order has been (IR).

[Former Member · Accepted solution]

you better read the purchase order history table:EKBE.

Pass the purchase order number and its item.

Pass BEWTP eq 'Q', you will get the generated invoice document number.

later you can query RSEG with the document numbers found.

[Former Member · Accepted solution]

PO based doc will store in RBKP RSEG

Non Po based doc will store in BKPF BSEG.

[Former Member · Accepted solution]

Sharath

What does BEWTP = 'R' mean?

Q= IR-L

R= IR

[former_member181962 · Accepted solution]

bewtp = r means "RE"(Invoice receipt)

Regards,

Ravi

[Former Member · Accepted solution]

Meaning Invoice Return i presume?

[Former Member]

Hi,

It is definitely not a invoice return, but it is called GROSS INVOICE RECIEPT.

[Former Member]

Check this table rbkp.