Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Relation between tables

Former Member
0 Likes
1,103

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.

5 REPLIES 5
Read only

MusAbaper
Active Participant
0 Likes
752

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

Thanks

Mustapha

Read only

Former Member
0 Likes
752

My ID is <REMOVED BY MODERATOR>

Thanks for the reply

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

Read only

Former Member
0 Likes
752

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

Read only

0 Likes
752

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

Read only

0 Likes
752

Yes