reading cluster PCL1

[Former Member]

Hi Experts ,

I am trying to read data from the cluster PCL1.

Can anyone tell me the code to be used .

Thanks in advance.

Devika.

[Former Member]

Hi Experts ,

I am trying to read data from the cluster PCL1.

Can anyone tell me the code to be used .

Thanks in advance.

Devika.

[Former Member]

hi check this..

regards,

venkat

[Former Member]

Hi,

SELECT * FROM PCL   WHERE RELID EQ v_RELID
             AND SRTFD EQ v_SRTFD
             ORDER BY PRIMARY KEY
             into table i_pcl1.

[Former Member]

U can directly read from PCL1 ..

First build the sortfield ...

LOOP AT SPERNR.

REFRESH SRTFD.

SRTFD-SIGN = 'I'.

SRTFD-OPTION = 'BT'.

SRTFD-LOW = ' '.

SRTFD-HIGH

= 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ'.

IF SPERNR-OPTION = 'BT'.

SRTFD-LOW(8) = SPERNR-LOW.

SRTFD-HIGH(8) = SPERNR-LOW.

APPEND SRTFD.

ELSEIF SPERNR-OPTION = 'EQ'.

SRTFD-LOW(8) = SPERNR-LOW.

SRTFD-HIGH(8) = SPERNR-LOW.

ENDIF.

SELECT * FROM PCL1 APPENDING TABLE ICL1

WHERE SRTFD >= SRTFD-LOW

AND SRTFD <= SRTFD-HIGH .

ENDLOOP.

[Former Member]

Hi all,

I have to read USER (user-defined Fields in Travel Request) table of PCL1 cluster for 'TE' (Travel Request). i have used following code

IMPORT USER TO T_USER

FROM DATABASE PCL1(TE)

ID TE_KEY.

TE_KEY is populated correctly and this code is fetching me the data too..but the problem is if i change value in any of the fields in USER table then this code fetches all the previous values also while all i want is current latest entry of this field.. So am i missing any additions in SYNTEX..or what is the why to fetch only latest entry of filed in table USER for cluster PCL1.

thanks in advance...