on 06-10-2010 6:25 PM
Hi Experts
I am able to modify non-key field data or delete row of any Table using SE16N - &SAP_EDIT, but it is not working now. Please let me know if any alternative?
Thanks
Prasad
HI Prasad,
Please do the follow steps hope it defenetly helps you.
1) Go to se11->provide the table name and click on display
2) press the contents button so u will cme to selection screen.
3) Please check the settings->user parameters->select the radiobutton ALV List
4) Provide the selction screen with the record num(key fields).
5) Execute it and double click on the record.
6) type /h in command bar and press enter button.
7) Again press enter button then debug will trigger.
😎 type the variable 'CODE' in debug screen.By default value'SHOW' is assigned.
9) Change this Value to "EDIT" and press enter.
10) press F8. now u r able to edit the non key fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Prasad,
use as the below
GD-EDIT and GD-SAPEDIT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
tyr to use UASE16N AND &SAP_EDIT INSTEAD OF SE16N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use function module SE16N_INTERFACE. Fill in table name and fill the fields I_EDIT and I_SAPEDIT with X, now execute, change tabel entries and save.
If you want you can also limit the amunt of table entries shown by filling a select statement in parameter table IT_SELFIELDS.
This will sometimes still work when &sapedit has been disabled.
It is worth a try
Peter
Hello together,
or modify al little coding in SAP Include LSE16NF10:
*{ INSERT DEVK912885 1
*Modifikation for SAPEDIT switch over RKSE16N_EDIT
data: ld_pos like se16n_edit-pos.
data: ld_sap_edit type se16n_sap_edit.
select max( pos ) from se16n_edit into (ld_pos).
if sy-subrc = 0 and not ld_pos is initial.
select single se16n_sap_edit from se16n_edit
into ld_sap_edit
where pos = ld_pos.
if sy-subrc = 0 and ld_sap_edit <> true.
Message i103(wusl) with 'S' display like 'E'.
CALL FUNCTION 'POPUP_WITH_WARNING'
EXPORTING
TEXTLINE1 = 'Leider hat die SAP die Editierfunktion '
TEXTLINE2 = 'mit dem Support-Package abgeschafft!'
* TEXTLINE3 = 'Editieren von Daten in der SE16N '
TITEL = 'ACHTUNG!' .
exit.
endif.
if sy-subrc = 0 and ld_sap_edit = 'X'.
message i111(wusl).
gd-edit ='X'.
endif.
endif.
*} INSERT
Will working together with Report RKSE16N_EDIT!
Regards
Dietmar Blome
Hi Prasad,
Please try FM SE16N_INTERFACE
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prasad,
&SAP_EDIT wont work in EHP5 , there is a way to achieve this, goto SE16n Transaction , and give GD-SAPEDIT = 'X' in debugging mode .
Regards ,
Ramkumar R .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
After EHP5 this &SAP_EDIT is not available in SE16.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Former Member,
Once you are at step five (i.e you have entered your 2 variables: GD-EDIT / GD-SAPEDIT in debug) you just need to doucle click on each of them and change their value to X.
Click the "change filed content" button (pencil icone) enter X press enter. Do the same with GD-SAPEDIT. Once you have changed both variables press continue (F8) and here you go !
All the best.
Greg.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check this for debugging the table.
<link no longer valid>
http :// www. sapdb.info/sap-hacks-change-database-tables-directly/
Regards
ABG
Message was edited by: Manish Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just found a great trick to maintian the tables if the system is not editable.(this is keeping in mind that you have debug writing access).
Put a breakpoint on the function module - T_SYS_PARAMS - and dynamically set the value of SYSCLIENTEDIT to '1'. This will allow you to do all normal operations. (I did this using normal SE16, so I am guessing that it will work with SE16N)
Thanks,
Aditya
Hi!
I've discovered an alternative method to re-enable all editing funcions on SE16N, Just follow the steps below:
1) Go to SE16N and type the table name you want to deal with
2) Instead of typing &SAP_EDIT in the command window, type /H to activate the debug
3) Hit the F8 key to enter the data browser for the table you typed on step 1)
4) While in debug, type the name of the following two global variables on the right panel: GD-EDIT and GD-SAPEDIT
5) Change the values of BOTH variables to an uppercased X
6) Finally, type F8 to exit from debug
Now you should be in the data browser screen for the table you selected and all editing features you had when &SAP_EDIT was available should be back again!
Enjoy!
Lino's procedure almost works; the following does work (using the classic debugger):
1) Type the table name
2) Instead of typing &SAP_EDIT in the command window, type /H and press enter twice to activate the debugger
3) Enter these two global variables on the right panel: GD-EDIT and GD-SAPEDIT
5) Press Enter to display the current values
6) Change values to an uppercase X for the first variable and click the Pencil icon; repeat for the 2nd variable
6) Finally, press F8 to exit the debugger
7) Enter selection criteria and then press F8.
Now the data browser screen appears with all editing features as old &SAP_EDIT
It was deactivated recently by SAP, see note 1420281.
If this note is not active yet, make sure you enter this code on the initial screen (doesn't work on detail screen)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could be client settings (non-modifiable) or missing authorization.
Should not be used anyway in my opinion except in emergencies. Try "normal" means like SM30 or SE16. If the table is not open for editing, then probably for a good reason.
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You try in SE16 ? It´s a Z* table ?
Best regards,
Leandro Mengue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for which table are you trying to edit the table contents?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
109 | |
15 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.