Mismatch value between SAP and QlikView

[marcohadiyanto]

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.

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

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

Any one know why this is happening?

I'm using SAP Connector 6.0

Thanks

Marco

[mats_olin · Accepted solution]

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

[marcohadiyanto]

Thanks for your suggestion, after we adding this script.

[ZCOMPANY__TEXT] as [Company Code TEXT],

The data already loaded.

Thanks