topic Re: Reg tables in Application Development and Automation Discussions

Reg tables

Former Member — Wed, 02 Apr 2008 11:42:31 GMT

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

Re: Reg tables

Former Member — Wed, 02 Apr 2008 12:05:33 GMT

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

reward if helpfull...

Re: Reg tables

Former Member — Wed, 02 Apr 2008 12:13:11 GMT

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?

Re: Reg tables

Former Member — Wed, 02 Apr 2008 12:22:47 GMT

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 IDocs

VBLNR - Document Number of the Payment Document in the table REGUH

VBLNR - Document Number of the Payment Document in the table REGUP

Reward Points if it helpful

Thanks&Regards,

Lokesh

Re: Reg tables

Former Member — Wed, 02 Apr 2008 12:34:25 GMT

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.

Re: Reg tables

Former Member — Wed, 02 Apr 2008 12:37:47 GMT

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

Re: Reg tables

Former Member — Wed, 02 Apr 2008 14:10:15 GMT

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

Re: Reg tables

Former Member — Thu, 03 Apr 2008 11:40:21 GMT

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