USR04 Table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member201275]

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.

[Former Member]

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.

[Former Member]

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