1 Reply Latest reply: Oct 14, 2014 2:32 AM by Purvisha Sitrambalam RSS

    Aliasing Select Statement

    Purvisha Sitrambalam

      Hi friends,

       

      I have connected to QvSAPDSOConnector. I am trying to pull an infoObject from a particular DSO and rename it into a business specific format. I am trying to alias the fields in the select statement. But an error is thrown

       

      Type: 'E', Message: 'InfoObject AS in the list of available InfoObjects does not exist in DS'

       

      The code  I am using is

       

       

      [ZCR_OCOM]:

      Load *;

      SQL Select

      0CRM_ACGUID AS ABC

      from ZCR_OCOM;

      Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;

      Drop table [ZCR_OCOM];

       

      please help me with this.