Skip to Content
0
Former Member
Dec 11, 2008 at 08:08 AM

Need Join ideas

43 Views

HI

i write this join ,there is a better way to write it?

Regards

SELECT agr_hier~agr_name agr_hier~object_id agr_hier~parent_id agr_hier~sort_order
           agr_hier~menu_level  agr_hier~menu_level agr_hier~report agr_hiert~text
      INTO CORRESPONDING FIELDS OF TABLE it_h
      FROM ( ( agr_hier
      INNER JOIN agr_hiert
      ON agr_hier~agr_name = agr_hiert~agr_name
      AND agr_hier~object_id = agr_hiert~object_id ) )
      FOR ALL ENTRIES IN ct_agr_user
      WHERE agr_hier~agr_name = ct_agr_user-agr_name
      AND ( report = '_APPATION' OR report = 'APPION'22 ).