grn invoice table

[Former Member]

hi

can any one tell me a single table in which i can get both

grn number as well as invoice no .

Regards

Rakesh singh

[Former Member]

Hi ,

Go thorugh the RSEG table ,

Invoice number - BELNR

GR NUMBER - LFBNR

Regards,

Madhu.

[Former Member]

thanks for reply

I am useing that only but the problem is that

for the park invoice GR NUMBER RSEG-LFBNR is blank

Regards,

Rakesh

[Former Member]

Hi RAKESH KUMAR SINGH,

U are not getting the Ref Doc No value for all the Accounting Doc no or for some specific Accounting doc nos...

Check it up ...

If the doc is not created using any other document no as a ref doc no then it won't show in the table...

If the doc is created using any other document no as a ref doc no then ONLY it WILL show in the table...

Check it out by specifying LFBNR NE INITIAL

Refer below tables..

BKPF,

BSIK,

RBKP,

RSEG,

BSEG.

If u r not getting both in single table then u can make a join of the table or use for all entries and fulfill ur req..

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7