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

NORAML REPORT

Former Member
0 Likes
491

I need to pick tha datafrom bsad and bsik and

i need to dispaly data at atime

1 ACCEPTED SOLUTION
Read only

arpit_shah
Contributor
0 Likes
473

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

3 REPLIES 3
Read only

Former Member
0 Likes
473

Vasanth,

try this with inner joins or

use for all entries .

this will do

Regards,

Talwinder

Read only

arpit_shah
Contributor
0 Likes
474

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

Read only

Former Member
0 Likes
473

hi

select required fields into it_tab from bisk as b inner join bsad as a on bbukrs = abukrs.