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

    Aliasing Select Statement

      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




      Load *;

      SQL Select


      from ZCR_OCOM;

      Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;

      Drop table [ZCR_OCOM];


      please help me with this.