Inner Join Syntax review

[Former Member]

Hi All,

I want to select the external material text from twewt table , for the corresponding material in mara , so I wrote a join statement like this -

Select singlep~ewbez  into gv_extmatdesc from (twewt as p INNER JOIN  mara as c  on C~matnr = rm_matnr)

Join is working fine and giving me output but I like to know this is the proper syntax or not

[Former Member]

Hi John,

In your selection query do you have any where clause ?

I can see that you r fetching single record with field EWBEZ ? What is where clause condition for this query ? Since you r fetching single field from TWEWT table why inner join is required ?

Can you paste the full selection query ?

Thanks & Regards,

Arun

[Former Member]

Hi Aruna,

I  have  only material number value.

so I have to write like I have to fetch twewt-ewbez  for  mara-extwg  when mara-matnr = my_matnr

..

How Can I achieve this?

[Former Member]

Hi John,

Can you paste full inner join selection query ?

Thanks & Regards,

Arun

[Former Member]

the same as  in the first post

[Former Member]

I have done it aruna , thanks