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

Inner Joins: Add two fields

Former Member
0 Likes
413

Hi

Is is possible to add two fields during a inner join select.

I want to add ( dndabj + dndabp ) and ( dkansw + dknafa ) into one field.


  SELECT a~anln1 a~anln2 a~bukrs a~txt50 a~aktiv a~zugdt a~deakt
         b~kostl
         c~ndjar c~afabe c~schrw
         d~ndabj d~ndabp d~kansw d~knafa d~answl d~nafag d~gjahr
                                                                                INTO TABLE wa_outtab

1 ACCEPTED SOLUTION
Read only

former_member784222
Active Participant
0 Likes
386

Hi,

You cannot do that. You need to populate each field into corresponding internal table field and then do your calculation on the internal table.

Thanks and regards,

S. Chandra Mouli,

Hi,

You cannot do that. You need to populate each field into corresponding internal table field and then do your calculation on the internal table.

Thanks and regards,

S. Chandra Mouli,

1 REPLY 1
Read only

former_member784222
Active Participant
0 Likes
387

Hi,

You cannot do that. You need to populate each field into corresponding internal table field and then do your calculation on the internal table.

Thanks and regards,

S. Chandra Mouli,