topic Re: Relation between tables in Application Development and Automation Discussions

Relation between tables

Former Member — Mon, 09 Jun 2008 14:54:18 GMT

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 — Mon, 09 Jun 2008 15:03:59 GMT

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

Thanks

Mustapha

Former Member — Mon, 09 Jun 2008 15:11:04 GMT

My ID is <REMOVED BY MODERATOR>

Thanks for the reply

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

Former Member — Mon, 09 Jun 2008 15:35:07 GMT

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 — Mon, 09 Jun 2008 15:43:21 GMT

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

Former Member — Wed, 18 Jun 2008 14:00:55 GMT

Yes