‎2008 Jan 03 8:40 AM
I need to pick tha datafrom bsad and bsik and
i need to dispaly data at atime
‎2008 Jan 03 8:47 AM
hi,
use the inner join
for BELNR,GJAHR,BUZEI this field and select data as per your requirement.
e.g.
select required fields into it_tab from bisk as b inner join bsad as a on bbelnr = abelnr and bgjahr = agjahr and bbuzei = abuzei.
Regards,
Arpit
‎2008 Jan 03 8:46 AM
Vasanth,
try this with inner joins or
use for all entries .
this will do
Regards,
Talwinder
‎2008 Jan 03 8:47 AM
hi,
use the inner join
for BELNR,GJAHR,BUZEI this field and select data as per your requirement.
e.g.
select required fields into it_tab from bisk as b inner join bsad as a on bbelnr = abelnr and bgjahr = agjahr and bbuzei = abuzei.
Regards,
Arpit
‎2008 Jan 03 8:50 AM
hi
select required fields into it_tab from bisk as b inner join bsad as a on bbukrs = abukrs.