report

[Former Member]

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

[Former Member]

Hi,

LFA1 for vendor details

EKKO, EKPO, EKBE, EKET for PO details

RBKP, RSEG for Vendor Invoice details

Regards,

Raj.

[Former Member]

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

[Former Member]

check these tables :

REGUP

RSEG

RBKP

PAYR

Reward if useful.

Dara.

[Former Member]

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.