topic Re: Scrip Error (Field not found) SAP Table in QlikView

Scrip Error (Field not found) SAP Table

tiklabaq — Mon, 26 Jan 2026 21:26:37 GMT

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');

Re: Scrip Error (Field not found) SAP Table

Peter_Cammaert — Wed, 19 Apr 2017 07:33:12 GMT

Most probably a problem with your connection or permissions.

Are you able to load any other table, for example a simple one like KNA1?

How did you check in SAP anyway? The ScriptBuilder has no live connection to SAP. And asking SAP for table details doesn't mean anything with respect to them being available to your SAP Connector account...

Re: Scrip Error (Field not found) SAP Table

Peter_Cammaert — Wed, 19 Apr 2017 07:34:14 GMT

Does it work when you remove the WHERE clause?

Re: Scrip Error (Field not found) SAP Table

Peter_Cammaert — Wed, 19 Apr 2017 07:43:00 GMT

Also, there is a quote missing after the C43100 value...

Re: Scrip Error (Field not found) SAP Table

tiklabaq — Wed, 19 Apr 2017 07:53:00 GMT

Oh my God. For over a day, I have been desperate for this problem, and it is so simple. Many many thanks

Re: Scrip Error (Field not found) SAP Table

Peter_Cammaert — Wed, 19 Apr 2017 08:31:00 GMT

Oh wow... didn't think we would have found it so quickly. Problems with SAP connections aren't usually that easy to diagnose. Well, sorry for the lost day but maybe a tip may be useful for future diagnoses:

The QlikView Script Editor isn't usually very strong in analysing SQL statements, let alone in checking OpenSQL However, in this case it was able to detect and mark a bracket balancing problem. I checked again and again but the parentheses were ok. And then I found the missing quote which turns the better half of the WHERE clause into one long string...

Sometimes the markers aren't obvious, but they're there allright Always check for red wiggly lines or parentheses that go red without an apparent cause.

Good luck,

Peter

Re: Scrip Error (Field not found) SAP Table

tiklabaq — Wed, 19 Apr 2017 12:18:35 GMT

Thank you very much Peter.