topic Re: table in Application Development and Automation Discussions

table

Former Member — Wed, 18 Jul 2007 12:32:15 GMT

HELLO FRIENDS

As we assign mandt field for adding default client of the system logon

MANDT MANDT CLNT 3 0 Client

i want a field

creby like system user logon automatically enter in that if we create enteries in database

Hope this is possible reply How?

With Best Regards

Ruby

Re: table

Former Member — Wed, 18 Jul 2007 12:36:12 GMT

Hi Ruby,

You can use sy-uname to get the user name but it will not be populated automatically in the DB. You have to manually insert it in the table you required.

Regards,

Atish

Re: table

Former Member — Wed, 18 Jul 2007 13:23:20 GMT

Dear ruby,

you can use a field with a data element as SYUNAME and give default value as SY-UNAME and the check table as USR02.

This field should also be a key field.

You can also add the Value Table as USR01.

This should solve your problem.

Thanks

Venugopal

Reward accordingly

Re: table

Former Member — Wed, 18 Jul 2007 13:59:46 GMT

Hi Ruby,

SYST is the table that holds the system variable fields.In it there will be a field called SYUNAME i think...Tht will retrieve the name of the user...

See u want to pin it in every record when u r entering the value ,right..

U can design a program to add this field...But it will only add to every record when u run this program..

Program will first retrieve all the values checking the condition tht this username field is null...Then u want to update every field by giving the username..

REWARD IF USEFUL