Get the data from TVKO n VBAK tables

[Former Member]

hello experts,

My selection screen is designed as...

select-options: s_wadat for vkdfs-fkdata no extension,

s_vkorg for tvko-vkorg,

s_spart for vbak-spart,

s_burks for tvko-bukrs.

Based on the selection screen i have to retrieve the data for VKORG and SPART.

for different values of the selection screen.... and with out any values in the any of fields of selection screen....

can anyone guide me what is best select statement to write...

Please guide me is it better to put the joining condition.. if so how

or better to write the separate select statement if so how to get the combined data between those selection

please give me some guidance

I really appreciate your anticipation

[Former Member]

hi Nitesha,

here im giving the code.

select tvko~vkorg

tvko~bukrs

vbak~spart

vkdfs~fkdat

into table <itab>

from tvko join vbak

on tvko_{vkorg eq vbak}vkorg

join vkdfs on

vkdfs_{vkorg eq tvko}vkorg

where vkdfs~fkdat in s_wadat and

tvko~vkorg in s_vkorg and

tvko~bukrs in s_bukrs and

vbak~spart in s_spart.

Rewards points if useful.

regards.,

Chandra