topic SQL query joins in Application Development and Automation Discussions

SQL query joins

amysh95 — Wed, 20 Feb 2019 07:01:55 GMT

Hey,

I am having trouble to get field data from structure.

select single * into @data(wa_vbap2)
from vbap as v
left outer join vbfa as x
on v~vbeln = x~vbelv
left outer join vbfa as y
on x~vbeln = y~vbelv and x~vbtyp_v = 'G'
where y~vbeln = @vbeln and y~vbtyp_v = 'C'.

this is my query and in debugging mode i have this.

i want to fetch fields from V. how can i do this?

zproj_name = wa_vbap2-zproj_name. (giving error)

thanks.

Re: SQL query joins

s1252 — Wed, 20 Feb 2019 07:46:14 GMT

You can try specifying only fields from V like below

select single v~* into @data(wa_vbap2)
 from vbap as v
 left outer join vbfa as x
 on v~vbeln = x~vbelv
 left outer join vbfa as y
 on x~vbeln = y~vbelv and x~vbtyp_v = 'G'
 where y~vbeln = @vbeln and y~vbtyp_v = 'C'.

Re: SQL query joins

DoanManhQuynh — Wed, 20 Feb 2019 08:48:37 GMT

because you dont specific field name ( select * from a join ) then fields of each table will save in corresponding nested structure of return structure. you can access field like below:

zproj_name = wa_vbap2-v-zproj_name.(i suppose zproj_name is under vbap which you define alias as V in query, if not you have to change it)

Re: SQL query joins

amysh95 — Wed, 20 Feb 2019 09:14:55 GMT

i am using @data(wa_vbap2) it will create itselft.

after executing query i am getting the data but don't know how to display or pass that data into another field.

anyway Thank you all, I resolve my issue. i checked that structure filed in debugging and got my answer.

now i am using like this.

zproj_name = wa_vbap2-v-zproj_name