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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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