topic Re: urgent!! users parameters in Application Development and Automation Discussions

urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:29:37 GMT

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

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

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:30:24 GMT

TPARA

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:32:14 GMT

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

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:33:30 GMT

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

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:34:24 GMT

Then try with table USR05

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:36:21 GMT

THERES NO PARTEXT IN USR05...

i have check it already..

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:36:24 GMT

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.

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:37:17 GMT

NOT ADDRESS!!!

LOOK... I NEED USPARAM-PARTEXT

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:41:22 GMT

check foll tables...

TPARA

TPARAT

TSOPT

also look into follwing tables

RFCGO RFC stub generation - generation of user parameters

TCGUEENNA EHS: Obsolete! Lang-dependent label for user exit parameters

TCGUEPA EHS: Allocation user exist function module to parameter

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:47:28 GMT

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.

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:51:00 GMT

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 .

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 09:53:57 GMT

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

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 10:11:56 GMT

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???

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 10:12:39 GMT

maybe not TPARA BUT TPARAT???

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 10:16:01 GMT

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..

Re: urgent!! users parameters

Former Member — Fri, 19 Oct 2007 10:20:33 GMT

THANK U .

I GOT IT