topic Re: Modifying entry in a table using report program in Application Development and Automation Discussions

Modifying entry in a table using report program

Former Member — Tue, 04 Dec 2007 11:40:39 GMT

Hi this is my requirement

In table GB01, remove a possibly existing entry with GB01-BOOLCLASS = 015, GB01-CLASSTYPE = S., GB01-BCLTAB = BSEG and GB01-BCLFIELD = *. Instead insert an entry with the following parameters:

GB01-BOOLCLASS = '015'

GB01-CLASSTYPE = 'S'

GB01-BCLTAB = 'BSEG'

GB01-BCLFIELD = 'VBUND'

GB01-BEXCLUDE = ''

Please provide the coding

Thanks in advance.

Re: Modifying entry in a table using report program

Former Member — Tue, 04 Dec 2007 11:43:44 GMT

Hi,

Data wa_gb01 type gb01.
wa_GB01-BOOLCLASS = '015' 
wa_GB01-CLASSTYPE = 'S' 
wa_gb01-BCLTAB = 'BSEG' 
wa_GB01-BCLFIELD = 'VBUND' 
wa_GB01-BEXCLUDE = ''
Modify GB01 from wa_gb01.

Regards,

Satish

Re: Modifying entry in a table using report program

Former Member — Tue, 04 Dec 2007 11:47:38 GMT

please give me clear coding

Re: Modifying entry in a table using report program

Former Member — Tue, 04 Dec 2007 11:47:57 GMT

update table GB01 set : BOOLCLASS = '015'

CLASSTYPE = 'S'

BCLTAB = 'BSEG'

BCLFIELD = 'VBUND'

BEXCLUDE = ''''

where BOOLCLASS = 015 and CLASSTYPE = 'S' and BCLTAB = 'BSEG' and BCLFIELD = '*' .

hope this helps.

Re: Modifying entry in a table using report program

Former Member — Tue, 04 Dec 2007 11:50:13 GMT

You can maintain the entires in this table using transaction OKOR, there is no need to write a program.

Regards,

Nick