Need Join ideas

[Former Member]

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 ).

[ThomasZloch]

Also include AGR_HIERT-SPRAS in the ON- or WHERE-conditions (probably selecting SY-LANGU) to avoid duplicates due to possible multiple translations.

> report = 'APPION'22

Is this a typo?

Thomas

[Former Member]

Hi,

One suggestion.

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 agr_hier~report IN ('_APPATION' , 'APPION22u2019 ).

Regards,

Jisha.

[Former Member]

Hi,

1. don't used INTO CORRESPONDING FIELDS OF TABLE it_h.

2. FROM agr_hier as 'TABLE NAME'

3. INNER JOIN agr_hiert as 'TABLE NAME'

Regards:

Mahesh

[Former Member]

hi

use the following code:

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 as agr_hier

INNER JOIN agr_hiert as 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 ).

one more thing u can try u can cut the code in two selection

1- for innerjoin of two tables

2- for where condion on it_h and ct_agr_user