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

report

Former Member
0 Likes
522

hi all,

Customer name is required in the output, but the field is yet to be defined in the PS table PROJ, when the field u2018KUNNRu2019 is appended.

Pass the WBS element to the Table PROJ & collect the customer code u2018KUNNRu2019.

Pass the customer code u2018KUNNRu2019 to the Table KNA1 & collect the customer description <NAME1>

for this how i can code pl send me immediatly very urgent.

thanks.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
422

Hi,

Please find below queries.....

select *

from proj

into table it_proj

where pspnr = pspnr.

select kunnr name1

from kna1

into table it_kna1

for all entries in it_proj

where kunnr eq it_proj-kunnr.

after fetching data with above sql queries.

u can add customer name in final internal table from it_kna1.

by using read statment in loop.

Thanks & Regards

Gupta..

1 REPLY 1
Read only

Former Member
0 Likes
423

Hi,

Please find below queries.....

select *

from proj

into table it_proj

where pspnr = pspnr.

select kunnr name1

from kna1

into table it_kna1

for all entries in it_proj

where kunnr eq it_proj-kunnr.

after fetching data with above sql queries.

u can add customer name in final internal table from it_kna1.

by using read statment in loop.

Thanks & Regards

Gupta..