6 Replies Latest reply: Apr 19, 2017 8:18 AM by Ibrahim Aslan RSS

    Scrip Error (Field not found) SAP Table

    Ibrahim Aslan

      Hi Guys,

       

      I have a Problem with loading The SAP Table "COVP". When I check in SAP all fields exists, as soon as I want to load the specific fields of this table via QlikView, the error comes, "Field not found", for all fields of this table.


      What can I do?


       

      [COVP]:

      Load

         [WERKS] as [WERKS.COVP],

         [MATNR] as [MATNR.COVP],

         [GJAHR] as [GJAHR.COVP],

         [KOKRS] as [KOKRS.COVP],

         [OBJNR] as [OBJNR.COVP],

         [WTGBTR] as [WTGBTR.COVP],

         [KSTAR] as [KSTAR.COVP],

         [USPOB] as [USPOB.COVP],

         [MEGBTR] as [MEGBTR.COVP],

         [BUDAT] as [BUDAT.COVP],

         [PERIO] as [PERIO.COVP],

         [WRTTP] as [WRTTP.COVP],

         [PAROB] as [PAROB.COVP];

      SQL Select GJAHR WERKS MATNR BUDAT KOKRS OBJNR KSTAR WRTTP PERIO USPOB WTGBTR MEGBTR PAROB  from COVP

      where KOKRS = 'XXXX' and (((KSTAR = 'C43100 or KSTAR ='C43200') and WERKS = 'XXXX') or KSTAR = 'C49200');