Inner join

hi,

try this,

SELECT P_{AGR_NAME P}LANGU P_{PROFILE P}PTEXT

INTO TABLE T_AGR_PROF

FROM AGR_PROF AS P

INNER JOIN

UST12 AS U

ON <b>U_{auth = P}PROFILE</b>

WHERE U_{OBJCT in S_OBJCT AND U}FIELD in S_FIELD AND U~VON in S_VON.

And we can compare 2 fields with diff length but here in inner join we have to write only the tables field name.

We can not write like U~auth(10) as u have written in your coding.

thanks

Dharmshta

hi,

u cant explicitly give length for a field of table as it takes automatically and compares according to that.

SELECT P_{AGR_NAME P}LANGU P_{PROFILE P}PTEXT

INTO TABLE T_AGR_PROF

FROM AGR_PROF AS P

INNER JOIN

UST12 AS U

ON U_{auth = P}PROFILE

WHERE U_{OBJCT in S_OBJCT AND U}FIELD in S_FIELD AND U~VON in S_VON.

if helpful reward some points.

with regards,

Suresh Aluri.

If that is your requirement, try this.

SELECT P~AGR_NAME P~LANGU P~PROFILE P~PTEXT U~AUTH
INTO TABLE T_AGR_PROF
FROM AGR_PROF AS P
INNER JOIN
UST12 AS U
ON U~auth(10) = P~PROFILE
WHERE U~OBJCT in S_OBJCT AND U~FIELD in S_FIELD AND U~VON in S_VON.

Then concatenate the field auth (10 chars), before filtering the data in your internal table.

data: lv_auth(10) type c.

loop at T_AGR_PROF.
  lv_auth = T_AGR_PROF-auth+0(10).
  
  if lv_auth NE t_agr_prof-profile.
    delete t_agr_prof.
  endif.

  clear t_agr_prof.
endloop.

HI,

DATA : BEGIN OF ITAB1 OCCURS 0,

AUTH. LIKE UST12-AUTH.,

END OF ITAB1.

DATA : BEGIN OF ITAB2 OCCURS 0,

AGR LIKE T_AGR_PROF-AGR,

LANGU LIKE T_AGR_PROF-LANGU,

NAME LIKE T_AGR_PROF-NAME,

PROFILE LIKE T_AGR_PROF-PROFILE,

PTEXT LIKE T_AGR_PROF-PTEXT,

END OF ITAB1.

SELECT PROFILE INTO TABLE ITAB1 FROM UST12.

LOOP AT ITAB1.

CONCATENATE ITAB1-AUTH.(10) INTO ITAB1-AUTH.

MODIFY ITAB1.

ENDLOOP.

SELECT AGR LANGU NAME PROFILE PTEXT INTO TABLE ITAB2 FROM T_AGR_PROF.

LOOP AT ITAB2.

CONCATENATE ITAB2-PROFILE(10) INTO ITAB2-PROFILE.

MODIFY ITAB2.

ENDLOOP.

LOOP AT ITAB2.

READ ITAB1 WITH KEY AUTH = ITAB2-PROFILE.

IF SY-SUBRC = 0 .

" APPEND IT NOW ALL TO OTHER INTERNAL TABLE OR WRITE HERE

ENDIF.

ENDLOOP.

I THINK IT WILL BE USEFUL ....

NOTE: I DINT CHECK FOR SYNTAX PLS CHECK IT...

REGARD,

KARTHIK

write like this.

data : begin of IT_UST12 OCCURS 0,

u_auth like UST12-u_auth,

u_auth1(10) type C,

end of IT_UST12.

select u_auth from UST12 into table IT_UST12

WHERE OBJCT in S_OBJCT AND FIELD in S_FIELD AND VON in S_VON.

loop at it_ust12.

it_ust12-u_auth1 = it_ust12-u_auth+0(10).

modify it_ust12.

endloop.

sort IT_UST12 by u_auth1 u_auth.

if not IT_UST12 is initial.

SELECT AGR_NAME LANGU PROFILE PTEXT

INTO TABLE T_AGR_PROF

FROM AGR_PROF for all entries in IT_UST12

WHERE profile = IT_UST12-u_auth1.

endif.

reward if useful.

Amit Singla