Reg tables

[Former Member]

Hi which table i have to refer inoder to get the details of vendor number,invoice date,Po, invoice number and idoc?

[Former Member]

Hi Hema,

Vendor details are available in LFA1, J_1IMOVEND table..

Rest tables are Rseg,RBKP..

Edited by: Ullas U on Apr 3, 2008 1:41 PM

[Former Member]

Try vbrk,vbrp table.....and edidc,edidd table for idocs..

reward if helpfull...

[Former Member]

I have the vendor id now how to get the details of invoice date,invoice number,PO ,idoc date for the related vendor.How to code?Any idea?

[Former Member]

use select statement to fetch data.....

otherwise do u have fields with u ,then send it to me..

Edited by: Lokesh rao on Apr 2, 2008 2:37 PM

[Former Member]

I couldnt find the correct fields thats the major problem where am stuck up

[Former Member]

hi Hema,

check out this tables u'll find the fields u required

EKBE, RBKP, RSEG

VBFK Invoicing header

VBFP Invoicing detail

VBRP Billing Document: Item Data

VBRK Billing Document: Header Data

EDIDC & EDIDS for <b>IDocs </b>

VBLNR - Document Number of the Payment Document in the table <b> REGUH </b>

VBLNR - Document Number of the Payment Document in the table <b>REGUP </b>

Reward Points if it helpful

Thanks&Regards,

Lokesh

[Former Member]

sorry this is not my correct scenario.i have the vendor no now by using the vendor no i have to fetch the details of the PO,invoice number,invoice date,idoc number,idoc date and status.

[Former Member]

Hi Hema,

Vendor details are available in LFA1, J_1IMOVEND table..

Rest tables are Rseg,RBKP..

Edited by: Ullas U on Apr 3, 2008 1:41 PM