SELECT STATEMENT

[Former Member]

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.

[Former Member]

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

[vinod_vemuru2]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Guy's,

Thank you very much your valuable replies.

Thanks and Regards,

Bhavani.