<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Some fields are not getting updated using export--to database statement in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/some-fields-are-not-getting-updated-using-export-to-database-statement/m-p/7785673#M1585902</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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 &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;  EXPORT  variant =  variant&lt;/P&gt;&lt;P&gt;    TO DATABASE        zvariant(va)&lt;/P&gt;&lt;P&gt;             FROM      wa_variant&lt;/P&gt;&lt;P&gt;             CLIENT    sy-mandt&lt;/P&gt;&lt;P&gt;             ID        wa_variant-z_var.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and when I give ID value with project name then the  projid saves and z_var is not updating.&lt;/P&gt;&lt;P&gt;could you people please let me know where I am doin the mistake??&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 28 Mar 2011 10:41:32 GMT</pubDate>
    <dc:creator>chand1260</dc:creator>
    <dc:date>2011-03-28T10:41:32Z</dc:date>
    <item>
      <title>Some fields are not getting updated using export--to database statement</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/some-fields-are-not-getting-updated-using-export-to-database-statement/m-p/7785673#M1585902</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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 &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;  EXPORT  variant =  variant&lt;/P&gt;&lt;P&gt;    TO DATABASE        zvariant(va)&lt;/P&gt;&lt;P&gt;             FROM      wa_variant&lt;/P&gt;&lt;P&gt;             CLIENT    sy-mandt&lt;/P&gt;&lt;P&gt;             ID        wa_variant-z_var.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and when I give ID value with project name then the  projid saves and z_var is not updating.&lt;/P&gt;&lt;P&gt;could you people please let me know where I am doin the mistake??&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 28 Mar 2011 10:41:32 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/some-fields-are-not-getting-updated-using-export-to-database-statement/m-p/7785673#M1585902</guid>
      <dc:creator>chand1260</dc:creator>
      <dc:date>2011-03-28T10:41:32Z</dc:date>
    </item>
    <item>
      <title>Re: Some fields are not getting updated using export--to database statement</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/some-fields-are-not-getting-updated-using-export-to-database-statement/m-p/7785674#M1585903</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Try this&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;
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. 

&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;--&lt;/P&gt;&lt;P&gt;Raul Natu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 29 Mar 2011 10:01:57 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/some-fields-are-not-getting-updated-using-export-to-database-statement/m-p/7785674#M1585903</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2011-03-29T10:01:57Z</dc:date>
    </item>
  </channel>
</rss>

