change a field value in the database table

[Former Member]

Hi,

GB01 is the database table.

GB01-BOOLCLASS = 009

GB01-CLASSTYPE = S

GB01-BCLTAB = BSEG.

GB01-BCLFIELD = GSBER.

Upon input of above details, will get table Record as

BOOLCLASS 9

CLASSTYPE S

BCLTAB BSEG

BCLFIELD GSBER

BEXCLUDE X

In the record, the field GB01-BEXCLUDE has the value “X” in it. It should be replaced by value “=.”

Changes should be made ONLY for this record. Other Records should not be touched.

How can we do this. Help me in doing this.

Thanks,

Ramya.

[Former Member]

Hi Ramya,

Follow these steps :

1. Goto the table GB01 -> Display its contents.

2. Double click the record which you want to edit.

3. Type /h (where you type transaction code) to go to debugging mode for that record.(Press enter twice to goto debugging mode)

4. Click on Field CODE and give it value EDIT and then click on the PENCIL icon besides it.

5. Now click on SAVE.

6. Switch off the Debugging mode now.

7. Now you can see your selected record in EDITABLE mode.

8. Do the EDIT part and SAVE.

Reward with points if helpful.

Regards

Hemant Khemani

[Former Member]

Hi hemant,

i dont have the authorization to edit the contents is there any other way.

[Former Member]

Hi Ramya,

Please follow the steps which I have suggested it won't ask for Authorization if you go in Debugging mode for that record and then EDIT.

Reward with Points if helpful.

Regards

Hemant Khemani

[Former Member]

hi hemant,

i followed the procedure which u mentioned when i give code its giving only SHOW not EDIT user command and the table is standard table not a ztable.

any other way to do?

[Former Member]

Hi Ramya,

Yes it will give the value of the field CODE as SHOW initially but you delete that value and give it a value EDIT (in CAPS) and then click on the PENCIL icon besides it.

Then click on SAVE.

Switch off the debugging mode from the MENU.

Then EDIT your record and SAVE.

Yes i know it is a standard table and not a Ztable.

Please follow the steps.

Reward with Points if helpful.

Regards

Hemant Khemani

[Former Member]

Hi hemant,

just clarify this doubt i followed the steps its going into edit mode. Now will it allow me enter the value of the field from F4 help because i need to change the value from 'X' to '=' when i am trying to do this its giving an error message

"ENTER A VALID VALUE".

[Former Member]

Hi Ramya,

It will allow you to take value from F4 help.

It is giving you an Error because the value ' = ' is not maintained for that particular field BEXCLUDE.

You can check this by going into the Domain XFELD for that field BEXCLUDE. On the value range tab it has two values either 'X' (Yes) or ' ' (No). So thats why you can't give ' = ' there.You can only give 'X' or ' '. (Please check)

Please Reward each helpful answers with Points.

Regards

Hemant Khemani

Edited by: Hemant Khemani on May 9, 2008 10:51 AM

[prasanth_kasturi]

hi ramya

write a simple prog in se38 and use modify statement

or use dialog programming.

read the recors into a work area ,

modify as you need

and use update or modify statements

check the value you want to enter is in the f4 help aor not.

if its not there you cant enter the value.

if you still want the value populate the check table from where you are having f4 help

revert if prob

prasanth