topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Wed, 23 Apr 2008 13:24:30 GMT

Hi Guy's,

Please help me i wrote select statement using HRP1000. it displaying an error message " HRP1000 is not define in ABAP-Dictionary as a table, projection view .

My doubts is using this infotype it is not possible to wire the select statement.

Thanks and Regards,

Bhavani.

Re: SELECT STATEMENT

Former Member — Wed, 23 Apr 2008 13:28:52 GMT

My selects Work fine. I treied this on ECC5.0 and 4.7

*----------------------------------- Department Long Text
  SELECT SINGLE short stext  FROM hrp1000 INTO (lv_short , wa-dept_name ) WHERE
                              otype EQ 'O'          AND
                              objid EQ p0001-orgeh  AND
                              langu EQ sy-langu     AND
                              plvar EQ'01'          AND
                              begda LE sy-datum     AND
                              endda GE sy-datum.

Amandeep

Re: SELECT STATEMENT

vinod_vemuru2 — Wed, 23 Apr 2008 13:32:03 GMT

Hi Bhavani,

How u have written ur select query? There must be some thing wrong with syntax. I tried like this and is working fine.

DATA: i_data TYPE STANDARD TABLE OF hrp1000.

SELECT * FROM hrp1000 INTO TABLE i_data UP TO 1 ROWS.

Post ur query so that we can correct it.

Thanks,

Vinod.

Re: SELECT STATEMENT

Former Member — Wed, 23 Apr 2008 13:35:11 GMT

Hi Dear,

Use following ...

DATA: it1 TYPE STANDARD TABLE OF hrp1000.

SELECT * FROM hrp1000 INTO TABLE it1

where (your condition)

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 11:16 AM

Re: SELECT STATEMENT

Former Member — Wed, 23 Apr 2008 15:24:10 GMT

hi check this...

tables: hrp1000 .

data: itab type p1000 occurs 0 with header line .

select PLVAR BEGDA endda OBJID from hrp1000 into corresponding fields of

table itab .

if sy-subrc = 0.

loop at itab.

write:/ itab-plvar, itab-begda,itab-endda.

endloop.

endif.

regards,

venkat

Re: SELECT STATEMENT

Former Member — Thu, 24 Apr 2008 09:18:47 GMT

Hi Guy's,

Thank you very much your valuable replies.

Thanks and Regards,

Bhavani.