topic Re: USR04 Table in Application Development and Automation Discussions

USR04 Table

Former Member — Wed, 19 Jan 2011 12:02:57 GMT

Dear All Experts,

I need to read table USR04 with select statement and want some validation against field PROFS. But due to data type LCHR and lenght of 3750, I am unable to fetch records.

How to over come from this problem?

Regards,

Shaligram

Re: USR04 Table

Former Member — Wed, 19 Jan 2011 12:14:28 GMT

Hi,

Can you please explain the logic how are you going to fetch the values from this data base table.

1. Why cant you use the keys in this table?

With Regards,

Sumodh.P

Re: USR04 Table

Former Member — Wed, 19 Jan 2011 12:15:32 GMT

I am going to fetch records by comparing BNAME = SY-UNAME.

Re: USR04 Table

Former Member — Wed, 19 Jan 2011 12:19:58 GMT

Hi,

if you retrieve the data by using the BNAME you will only get one Record.

Then can you please tell me whats the validation what you want in PROFS field.

With Regards,

Sumodh.P

Re: USR04 Table

former_member201275 — Wed, 19 Jan 2011 12:37:34 GMT

Here are 2 programs which use this field. If you are doing something similair maybe you can cut and paste from here. If not then please provide more detail.

http://wiki.sdn.sap.com/wiki/display/Snippets/Compositeprofiles,SingleProfiles,Objects+Program

http://wiki.sdn.sap.com/wiki/display/Snippets/UserListOfTheSystem

Regards,

Warren.

Re: USR04 Table

Former Member — Thu, 20 Jan 2011 07:10:49 GMT

Check second link which Gemini Twin given in this link u check following code


  ASSIGN U4-PROFS+X(12) TO <A>.
      IF <A> EQ '            '.
        EXIT.

Re: USR04 Table

Former Member — Fri, 06 Jul 2012 12:27:13 GMT

Hello Shaligram,

Can you please copy paste the code which u used for your requirement as the links provided in this blog do not exist anymore.

Quick response would be highly appreciated.

BR,

Nisha