topic Re: table entry in Application Development and Automation Discussions

table entry

Former Member — Tue, 20 May 2008 14:04:49 GMT

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

Re: table entry

Former Member — Tue, 20 May 2008 14:09:17 GMT

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

Re: table entry

Former Member — Tue, 20 May 2008 14:15:32 GMT

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.

Re: table entry

Former Member — Tue, 20 May 2008 20:53:00 GMT

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.