Skip to Content
0
Former Member
Sep 05, 2006 at 03:41 PM

Modify Database table

38 Views

Hi all

i have a int .table(T_ZVXX) that has a status field .

my code is

select *

from ZVXX (ZVXX has matnr,inv.no. is key field)

into t_zvxx

where status is null.

now i have certain proceesing after thati m doing like that

concatenate 'Screen'

T_ZVXX-matnr

'Business Area'

'100'

T_ZVXX-maktx

into T_OUTPUT-line.

Append t_output

clear t_output

concatenate 'Message'

T_ZVXX-vbeln

sy-datum

'500'

T_ZVXX-matnr

into T_OUTPUT-line.

Download T_OUTPUT to a unix file.

***Main problem is i have to update a table(set the Staus to X initialy it was null )for the records which is downloaded successfully.

How can modify the Data base table ZVXX for the successfully downloaded record.

since it is concatenation i can not detect the key fields bcoz i have different conditions for concatenate(i.e sequence of Concatenate changes always)

Thanks

Saurabh Tiwari