Inner Joins: Add two fields

[Former Member]

Hi

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

I want to add ( d_{ndabj + d}ndabp ) and ( d_{kansw + d}knafa ) 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

[Former Member]

Hi

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

I want to add ( d_{ndabj + d}ndabp ) and ( d_{kansw + d}knafa ) 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

[former_member784222]

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,