urgent!! users parameters

[Former Member]

Do you know where can i get values of USER's ID parameters?

like USPARAM-PARTEXT???? Which TABLE can i select it from???

[Former Member]

do u mean user id??

SELECT persnumber addrnumber

INTO (w_persnumber, w_addrnumber) UP TO 1 ROWS

FROM usr21 WHERE bname EQ sy-uname.

ENDSELECT.

IF sy-subrc EQ 0.

SELECT smtp_addr FROM adr6

INTO w_adr6

UP TO 1 ROWS

WHERE addrnumber = w_addrnumber

AND persnumber = w_persnumber.

ENDSELECT.

IF sy-subrc <> 0.

MESSAGE i015 WITH text-082.

ENDIF.

ENDIF.

[Former Member]

TPARA

[Former Member]

BUT DOES IT depend on user's name? sy-uname????

[Former Member]

what if different users have the same ID parameters but different PARTEXT??

[Former Member]

Then try with table USR05

[Former Member]

THERES NO PARTEXT IN USR05...

i have check it already..

[Former Member]

do u mean user id??

SELECT persnumber addrnumber

INTO (w_persnumber, w_addrnumber) UP TO 1 ROWS

FROM usr21 WHERE bname EQ sy-uname.

ENDSELECT.

IF sy-subrc EQ 0.

SELECT smtp_addr FROM adr6

INTO w_adr6

UP TO 1 ROWS

WHERE addrnumber = w_addrnumber

AND persnumber = w_persnumber.

ENDSELECT.

IF sy-subrc <> 0.

MESSAGE i015 WITH text-082.

ENDIF.

ENDIF.

[Former Member]

NOT ADDRESS!!!

LOOK... I NEED USPARAM-PARTEXT

[Former Member]

check foll tables...

TPARA

TPARAT

TSOPT

also look into follwing tables

<b>RFCGO</b> RFC stub generation - generation of user parameters

<b>TCGUEENNA</b> EHS: Obsolete! Lang-dependent label for user exit parameters

<b>TCGUEPA</b> EHS: Allocation user exist function module to parameter

[Former Member]

Hi Julia,

The PARTEXT field availabe with TPARA table only....

The PARID and value will be available with USR05 table.

If you want both please write the SELECT QUERY WITH JOIN CONDITION

OF CREATE A VIEW WITH THESE TWO TABLES.

[Former Member]

How can i JOIN THEM if TPARA is consists of only memory and its not connected to the users name...it will be impossible to get the right value of partext .

[Former Member]

DATA: BEGIN OF ITAB1,

BNAME TYPE USR05-BNAME,

PARID TYPE USR05-PARID,

PARVA TYPE USR05-PARVA,

PARTEXT TYPE TPARA-PARTEXT,

END OF ITAB1.

DATA: ITAB LIKE TABLE OF ITAB1.

DATA: WA TYPE ITAB.

SELECT c_{BNAME C}PARID C_{PARVA D}PARTEXT INTO TABLE ITAB FROM USR05 AS C INNER JOIN TPARA AS D ON C_{PARID = D}PARAMID.

LOOP AT ITAB INTO ITAB1.

WRITE:/ ITAB1-BNAME, ITAB1-PARTEXT.

ENDLOOP.

Message was edited by:

Muthurajan Ramkumar

[Former Member]

THIS IS WRONG!!!!! i know how to write CODES...

Im telling u.

what if different USERS have the same ID parameters BUT different PARTEXT???

OR what???

[Former Member]

maybe not TPARA BUT TPARAT???

[Former Member]

Same Parameter ID will not have different text...may be it can have the same text in different languages (like as told by you TPARAT)...

Then use that table TPARAT also in the join conditions..

[Former Member]

THANK U .

I GOT IT