data from TVKO and VBAK table

[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 seperate select statementsif so how to get the combined data between those selection

please give me some guidance

I really appreciate your anticipation

[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 seperate select statementsif so how to get the combined data between those selection

please give me some guidance

I really appreciate your anticipation

[Former Member]

select ... from vbak into table <tabnam> where vkorg = s_vkorg and

spart = s_spart.

I hope this code would help you..

have a check with it..

reply back.

Regards,

praveen