Skip to Content
0
Aug 21, 2015 at 08:07 PM

Issue With Select Query

22 Views

Hi Experts

I have issue with my below select query statement. Through there are multiple entries in the Database table for the below selection. But the program is not fetching any entries.

But when the same condition is being passed at table level, Values are being fetched successfully. Kindly try the same program in your Sandbox and let me know how this works.

TABLES: /sapdmc/lsoatt,/sapdmc/lsocod.

TYPES: BEGIN OF ty_tab,

project TYPE /sapdmc/ls_project,

subproj TYPE /sapdmc/ls_project,

object TYPE /sapdmc/ls_project,

posnr TYPE /sapdmc/ls_posnr,

trgstr TYPE /sapdmc/ls_trgstr,

trgfld TYPE /sapdmc/ls_trgfld,

counter TYPE /sapdmc/ls_counter,

line TYPE /sapdmc/ls_line,

uname TYPE uname,

datum TYPE datum,

END OF ty_tab.

PARAMETERS: p_proj TYPE /SAPDMC/LS_PROJECT,

p_subp type /SAPDMC/LS_PROJECT,

p_obj type /SAPDMC/LS_PROJECT.

data: lt_tab2 TYPE STANDARD TABLE OF ty_tab.

SELECT

project

subproj

object

posnr

trgstr

trgfld

counter

line

uname

datum FROM /sapdmc/lsocod INTO TABLE lt_tab2

WHERE project EQ p_proj AND

subproj EQ p_subp AND

object EQ p_obj.

if sy-subrc eq 0.

endif.