topic modify statement in Application Development and Automation Discussions

modify statement

Former Member — Wed, 12 Nov 2008 06:30:16 GMT

Hi ,

i want to put ernam field from one internam table to final internal table ernam please guide

loop at tbl_output.

data: v_ernam like ekbe-ernam.

select ernam from ekbe

into v_ernam

where

elikz eq 'X' and

ebeln eq tbl_output-ebeln

and

ebelp eq tbl_output-ebelp.

modify grnam transporting v_ernam .

endloop.

Re: modify statement

Former Member — Wed, 12 Nov 2008 06:37:30 GMT

tbl_output contains all the ebeln, ebelp.

tbl_ernam table to contain all ernam.

so write a select query as follws.

select ernam from ekbe into tbl_ernam

for all entries in tbl_output

where elikz = 'X'

and ebeln eq tbl_output-ebeln

and ebelp eq tbl_output-ebelp.

Select in a loop reduces performance

Use both the internal tables and modify as per ur requirement.

Regards,

SAPient

Re: modify statement

Former Member — Wed, 12 Nov 2008 07:01:04 GMT

loop at tbl_output.

data: v_ernam like ekbe-ernam.

select ernam from ekbe

into v_ernam

where

elikz eq 'X' and

ebeln eq tbl_output-ebeln

and

ebelp eq tbl_output-ebelp.

tbl_output-grnam = v_ernam.

modify tbl_output transporting grnam

where ebeln eq tbl_output-ebeln

and ebelp eq tbl_output-ebelp.

endloop.

Re: modify statement

Former Member — Wed, 12 Nov 2008 07:03:44 GMT

Hi,

yuo can use follwoing syntax :

modify table transporting field1 field2 where field1 = condition1.

thanks.