topic Re: select statement problem in fm in Application Development and Automation Discussions

select statement problem in fm

Former Member — Wed, 16 Apr 2008 22:20:55 GMT

HI,

I have a custom tabel with fields vbeln primary, erdat, erzet, ernam.

i have a function module which import parameter is SENDER type SIBFLPORB.

the values to sender come from workflow.

code in fm is:

data itab like zsab_test occurs 0 with header line.

select vbeln erdat erzet ernam from vbak into corresponding fields of table itab where vbeln = sender-instid.

modify zsab_test from itab.

but the data is not inserted in zsab_test table.

but in ITAB the record is there..

help me pls...

Regards

Giri

Re: select statement problem in fm

former_member156446 — Wed, 16 Apr 2008 22:27:49 GMT

hi Giri

you are using modify.. its means that if the same pair of primary keys exist before.. it will modify it..

you might be needed to use update or insert statments.

Re: select statement problem in fm

Former Member — Wed, 16 Apr 2008 22:45:01 GMT

Hello

I believe that you need a small change to the modify statement.

modify zsab_test from itab. " This will try to update zsab_test from the header line of itab which is initial

should be

modify zsab_test from table itab. " This will use the contents of the body of itab to update zsab_test.

Hope this helps.

Regards

Greg Kern