topic Re: report in Application Development and Automation Discussions

report

Former Member — Wed, 23 Apr 2008 07:53:56 GMT

hi guys,

can any one advice me the tables that i will need for my report.

my report fields needed is:

PO No.

Inovice No.

Invoice amount

Payment No.

Payment amount.

i were unable to find the payment details table for the invoice. what field that i need to link for?

thanks

Re: report

Former Member — Wed, 23 Apr 2008 07:58:41 GMT

Hi,

LFA1 for vendor details

EKKO, EKPO, EKBE, EKET for PO details

RBKP, RSEG for Vendor Invoice details

Regards,

Raj.

Re: report

Former Member — Wed, 23 Apr 2008 07:59:32 GMT

check these tables :

REGUP

RSEG

RBKP

PAYR

Reward if useful.

Dara.

Re: report

Former Member — Wed, 23 Apr 2008 08:22:27 GMT

hi thanks.

but what is the field to link them up together?

under PO, i have used table EKBE --> RBKP to get the invoice receipt details. however, i were unable to match it to BSEG, BSIK to retrieve the payment details.

how?

thanks

Re: report

Former Member — Wed, 23 Apr 2008 10:23:24 GMT

Hi,

You may link the table BSEG and BSIK with the fields

BSIK-BUKRS = BSEG-BUKRS

BSIK-BELNR = BSEG-BELNR

BSIK-GJAHR = BSEG-GJAHR

In BSEG table use KOART as "K".

BSEG table contains data for Customers, Vendors and GL.

By choosing field KOART you may select any of the data for example:

KOART K is for Vendors,

D is for Customers,

S is for G/L.

For your requirement you need table BSIK which is for vendors(Clearing Items).

So you may proceed with KOART type "K" in BSEG filed.

Get back in case you have any questions.

Reward points if helpful.