Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
chooco_co
Partner
Partner

Mismatch value between SAP and QlikView

Hi All,

I'm trying to load data using BEx Connector.

Picture below my setting on BEx Designer, i want to load Company Code shown as Key and Text.

Email 1.jpg

Picture below shown the result on SAP, Company Code contain Company Code and Company Description.

Email 3.jpg

When i'm loading this into QlikView, It only show Company Code.

Email 2.jpg

Any one know why this is happening?

I'm using SAP Connector 6.0

Thanks

Marco

1 Solution

Accepted Solutions
mats_olin
Employee
Employee

Do you get the 0COMP_CODE__TEXT fiels if loading the data without the LOAD statement in the script (conmment the hole LOAD statement so that the script starts with SELECT.. )?

/Mats

View solution in original post

2 Replies
mats_olin
Employee
Employee

Do you get the 0COMP_CODE__TEXT fiels if loading the data without the LOAD statement in the script (conmment the hole LOAD statement so that the script starts with SELECT.. )?

/Mats

View solution in original post

chooco_co
Partner
Partner

Thanks for your suggestion, after we adding this script.

[ZCOMPANY__TEXT] as [Company Code TEXT],

The data already loaded.

Thanks