table join
Hi guru's,
can any body tell me how to join the rbkp, bkpf and bseg tables pls.
Thanks & Best Regards,
Rakhi.
Jayasri P 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.