topic Re: grn invoice table in Application Development and Automation Discussions

grn invoice table

Former Member — Mon, 08 Sep 2008 05:29:27 GMT

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 — Mon, 08 Sep 2008 05:55:16 GMT

Hi ,

Go thorugh the RSEG table ,

Invoice number - BELNR

GR NUMBER - LFBNR

Regards,

Madhu.

Former Member — Mon, 08 Sep 2008 06:04:23 GMT

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 — Mon, 08 Sep 2008 08:07:27 GMT

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