Inner Joins: Add two fields

Former Member — Mon, 11 Jun 2007 07:30:06 GMT

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

Re: Inner Joins: Add two fields

former_member784222 — Mon, 11 Jun 2007 07:45:11 GMT

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,

topic Inner Joins: Add two fields in Application Development and Automation Discussions

Inner Joins: Add two fields

Re: Inner Joins: Add two fields