Some fields are not getting updated using export--to database statement

[chand1260]

Hi All,

I have a table zvariant.In that there are fields called mandt,z_var,projid,RELID,SRTF2,CLUSTR,CLUSTD and I am using the statement

EXPORT variant = variant

TO DATABASE zvariant(va)

FROM wa_variant

CLIENT sy-mandt

ID wa_variant-z_var.

for to save the values in the database table.From this statement, all fields are getting updated except the projid field.I have tried to update the projid field using UPDATE statement but it is still not updating.

and when I give ID value with project name then the projid saves and z_var is not updating.

could you people please let me know where I am doin the mistake??

[Former Member]

Hi,

Try this

DATA: wa TYPE zvariant. 

wa-mandt     = sy-mandt. 
wa-z_var     = 'test'. 
wa-projid      = 'test'.  
wa-relid        = 'test'. 
wa-srtf2       = 'test'. 
wa-clustr      = 'test'. 
wa-clustd     = ''test'.  

INSERT zvariant CLIENT SPECIFIED FROM wa. 

--

Raul Natu