topic Re: modify database table(staandard) in Application Development and Automation Discussions

modify database table(staandard)

Former Member — Fri, 09 May 2008 03:56:08 GMT

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.

Re: modify database table(staandard)

former_member156446 — Fri, 09 May 2008 03:59:45 GMT



try to use update or modify from wa_itab...

modify <dbtab> using wa_itab.

Re: modify database table(staandard)

Former Member — Fri, 09 May 2008 04:02:24 GMT

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.