topic Re: Values not fetched in Application Development and Automation Discussions

Values not fetched

Former Member — Thu, 31 Jul 2014 09:08:47 GMT

Hi,

When i given the task value in selection screen the description of the task need to be taken from the table hrs100

this is my code

IF NOT s_task[] is INITIAL.

SELECT stext

FROM hrs1000

INTO TABLE lt_hrs1000

WHERE otype = lv_type AND

objid = lv_ojid and

langu = 'E'.

ENDIF.

but values not fetched

Re: Values not fetched

sivaganesh_krishnan — Thu, 31 Jul 2014 10:36:03 GMT

Hi,

before coding , please check the table for values.

Regards,

Sivaganesh

Re: Values not fetched

former_member201275 — Thu, 31 Jul 2014 13:18:02 GMT

Have you tried using 'EN' as suggested in the same question you have onw asked twice? i.e. LANGU = 'EN'.

Or try leaving the LANGU out of the SELECT statement and see if you get anything.

Do you have an abap person there that can help you quickly because this is very basic stuff i'm sure they can quickly solve for you?

Re: Values not fetched

Former Member — Thu, 31 Jul 2014 13:35:40 GMT

Hi,

look at the table -what entries are in it?

try to select without where-statement. add 1 where-statement by another to figure out what line causing the error. sometimes leading 0 or SPACE in the ID field can be the issue.

go to transacion SE16 and enter your conditions. if you find something you should find something via programm too. If not - watch the data convertions to internal format.

regards

Stefan Seeburger

Re: Values not fetched

bernat_loscos — Thu, 31 Jul 2014 14:02:29 GMT

Hi,

You can try to use system variable for language: sy-langu.

WHERE otype = lv_type AND

objid = lv_ojid and

langu = sy-langu.

Regards.