Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

modify database table(staandard)

Go to solution
Former Member

‎05-09-2008 4:56 AM

0 Kudos

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.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎05-09-2008 5:02 AM

0 Kudos

hi,

do this way ..make sure you provide all the key fields to it ...

data : it_gb01 like bb01 occurs 0 with header line.


it_GB01-BOOLCLASS = '009'.
it_GB01-CLASSTYPE = 'S'.
it_GB01-BCLTAB = 'BSEG'.
it_GB01-BCLFIELD = 'GSBER'.
it_GB01-BEXCLUDE = '='.
append it_GB01
clear   it_GB01.

modify GB01 FROM TABLE it_GB01.

2 REPLIES 2

Go to solution
former_member156446
Active Contributor

‎05-09-2008 4:59 AM

0 Kudos 


try to use update or modify from wa_itab...

modify <dbtab> using wa_itab.

Go to solution
Former Member

‎05-09-2008 5:02 AM

0 Kudos

hi,

do this way ..make sure you provide all the key fields to it ...

data : it_gb01 like bb01 occurs 0 with header line.


it_GB01-BOOLCLASS = '009'.
it_GB01-CLASSTYPE = 'S'.
it_GB01-BCLTAB = 'BSEG'.
it_GB01-BCLFIELD = 'GSBER'.
it_GB01-BEXCLUDE = '='.
append it_GB01
clear   it_GB01.

modify GB01 FROM TABLE it_GB01.