Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

table entry

Former Member
0 Likes
959

hi all,

i need to create one entry into USR05 table?can any one tell me how to do?i don't hav authorization to creat the entries.any other way to create the entries?

points will be rewarded.

thank u

sunny

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
807

Hi Sunny..

If no authorization its illegal

You can create entry from program as mentioned in thread.

If you have display table entries authorization (from SE11 or SE16) and you have debug replace access then you can create entry as below. Follow these steps..

Display all entiries from USR05 table

Select any one entry by marking checkbox.

Now do /h in command window to start debugging

click on display icon (spectacles)

It will go in debug mode.

Press F7.

Now you can see code like:


refresh exclude_tab.
if code = 'SHOW'.
  set titlebar 'TAB' with name 'anzeigen'(100
elseif code = 'EDIT'.
  set titlebar 'TAB' with name 'ändern'(101).
elseif code = 'INSR'.
  set titlebar 'TAB' with name 'einfügen'(102
elseif code = 'ANVO'.
  set titlebar 'TAB' with name 'einfügen'(102
elseif code = 'DELE'.
  set titlebar 'TAB' with name 'löschen'(103)

check variable code and it will have value 'SHOW'.

Change that value to 'INSR'.. This must be in CAPS.

Now F8.

This will open fields for creating new entry.

Add your entry and press save. Refresh your table entry and you will your entry added.

Use with Caution

reward if useful..

thnx.

Ags.

3 REPLIES 3
Read only

Former Member
0 Likes
807

do you have authrization to SU01 Transaction if so

enter SU01 Transaction -> enter your user id -> click on change button

here see parameters tab -> enter WRK (Parameter ID) 1000 ( Parameter value )

save it.

now see the data in USR05 Table.

Thanks

Seshu

Read only

Former Member
0 Likes
807

Hi Sunny,

we can enter data by using tcode or by creating a report program.as you said you dont have authorizations use the following code.if you have authorizations to SU01 use it.

data:begin of itab occurs 0,

MANDT type MANDT,

BNAME type XUBNAME,

PARID type MEMORYID,

PARVA type XUVALUE,

end of itab.

itab-MANDT = 1000.

itab-BNAME = 'CHAITUKN'.

itab-PARID = 'SCL'.

itab-PARVA = 'X'.

append itab.

insert USR05 from itab.

if sy-subrc <> 0.

write: / 'failure'.

else.

write: / 'success'.

endif.

reward points if helpful.

Read only

Former Member
0 Likes
808

Hi Sunny..

If no authorization its illegal

You can create entry from program as mentioned in thread.

If you have display table entries authorization (from SE11 or SE16) and you have debug replace access then you can create entry as below. Follow these steps..

Display all entiries from USR05 table

Select any one entry by marking checkbox.

Now do /h in command window to start debugging

click on display icon (spectacles)

It will go in debug mode.

Press F7.

Now you can see code like:


refresh exclude_tab.
if code = 'SHOW'.
  set titlebar 'TAB' with name 'anzeigen'(100
elseif code = 'EDIT'.
  set titlebar 'TAB' with name 'ändern'(101).
elseif code = 'INSR'.
  set titlebar 'TAB' with name 'einfügen'(102
elseif code = 'ANVO'.
  set titlebar 'TAB' with name 'einfügen'(102
elseif code = 'DELE'.
  set titlebar 'TAB' with name 'löschen'(103)

check variable code and it will have value 'SHOW'.

Change that value to 'INSR'.. This must be in CAPS.

Now F8.

This will open fields for creating new entry.

Add your entry and press save. Refresh your table entry and you will your entry added.

Use with Caution

reward if useful..

thnx.

Ags.