Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

table join

Hi guru's,

can any body tell me how to join the rbkp, bkpf and bseg tables pls.

Thanks & Best Regards,

Rakhi.

Former Member
Former Member replied

data : begin of it_rbkp occurs 0.

include structure rbkp.

data : awkey like bkpf-awkey,

end of it_rbkp.

data : begin of it_bkpf occurs 0.

include structure bkpf.

data : end of it_bkpf.

select * from rbkp into corresponding fields of table it_rbkp

where belnr in belnr and gjahr in gjahr.

loop at it_rbkp.

concatenate it_rbkp-belnr it_rbkp-gjahr into it_rbkp-awkey.

modify it_rbkp transporting awkey.

endloop.

select * from bkpf into corresponding fields of table it_bkpf

for all entries in it_rbkp where awkey = it_rbkp-awkey.

I have tried in this manner. it worked for me.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question