Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
mpbtejada
Contributor III
Contributor III

Extracting from SAP Table KNA1

Hi,

We recently upgraded from SAP Connector 5.4 to the latest 6.5.

Main change was the treatment of fields that accept both numeric and string entries.

We changed the connection string parameter MixedMode to TRUE and this made the transition for most of our built extractors bearable.

Except for 1 so far. Extracting from SAP table KNA1.

For some reason under MixedMode TRUE, customer code (KUNNR) P434 and 434 is treated as the same.

I tried changing MixedMode to FALSE and this separated the values.

Can anyone please give clarification?

Thanks.

10 Replies
trm
Employee
Employee

1. Yes I believe they are, haven't checked for all possible data types though.

2. I haven't tried this out myself so no good answer there, needs experimenting...

3. One thing you could try is to test an application named EasyQlik QViewer, it's not a Qlik product but I've found it convenient for looking at QVD files and what different metadata is assigned on different levels. You can see the unknown flag in the XML Type metadata field.

But I don't think using MixedMode=true is a bad thing, if you have fields with mixed content it makes a lot of sense using it (and utilizing Qlik's 'intelligence'). But it can be too 'broad', i.e what you saw in detecting values as money. So if you want better control and know for example that there's only text or numeric values you could use MixedMode=false and trying Num#() function on the values and falling back on text.

4. Yes but probably hard to cover for all different probing that Qlik does (i.e numeric, money, dates, times, etc.) so depending on your situation.

// Thomas Örnmarker