Relation between tables

[Former Member]

Hi,

Can anyone please give me the relation between the tables BKPF, BSAD, REGUH, REGUP, PAYR.

I have prepared internal tables of these tables and have some data in all them.

Now I need to read these tables and populate them into a final internal table. I am confused which table should I loop and which to read in the loop.

Please give some advice.

Thanks in advance.

[Former Member]

Hi,

Can anyone please give me the relation between the tables BKPF, BSAD, REGUH, REGUP, PAYR.

I have prepared internal tables of these tables and have some data in all them.

Now I need to read these tables and populate them into a final internal table. I am confused which table should I loop and which to read in the loop.

Please give some advice.

Thanks in advance.

[MusAbaper]

Can you give me ur mail because i have a document who contain a relation between SAP tables.

Thanks

Mustapha

[Former Member]

My ID is <REMOVED BY MODERATOR>

Thanks for the reply

Edited by: Alvaro Tejada Galindo on Jun 9, 2008 6:36 PM

[Former Member]

I am not sure about your requirement but i guess you are reading custom cleared items and their payment details.

You may try this:

BKPF to BSAD - To read customer cleared items by passing BUKRS, GJAHR and BELNR if you have.

REGUP - To read processed items by passing KUNNR, BUKRS, BELNR GJAHR from above

REGUH - To read payment data by passing LAUFD LAUFI from above.

Hope this helps.

Thanks,

SKJ

[Former Member]

So should I loop at BKPF and read from the other tables you mentioned?

[Former Member]

Yes