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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

extracting directly from SAP and not from cubes

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.

1 Reply
amien
Specialist
Specialist
Author

/UP