extracting directly from SAP and not from cubes

amien — Wed, 15 Jun 2011 09:36:03 GMT

I want to extract a few dimensions from SAP, but not from the cube, but directly from SAP.

i use the QvSAPConnector.dll connector. I connect to SAP and the CUSTOM CONNECT TO is created. Connection is succesful

Now the script builder is started. I select what i need and choose to create script.

i copy/past the script to the Qlikview application, but the SELECT statement gives me a script error:

[/TT5/CHTBPERS]: // Human Resources

Load

[MANDT] as [Client_MANDT],

[TPORGE] as [CH Organizational Unit_TPORGE],

[TPPERS] as [Employee_TPPERS],

[TPNNAME] as [Last Name_TPNNAME],

[TPVNAME] as [First name_TPVNAME];

SQL Select MANDT TPORGE TPPERS TPNNAME TPVNAME from /TT5/CHTBPERS

;

i dont see why QV is giving this error.

amien — Mon, 20 Jun 2011 12:58:42 GMT

/UP

topic extracting directly from SAP and not from cubes in QlikView