Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Best approach for import SAP data into Qlik View. Hi

Best approach for import SAP data into Qlik View.


Hi All


Below is the my existing sales order table from syspro accounting software :-


@314:343T as [desc],

@314:343T as [desc_key],

@43:48T as [inv],

@65:78T as [iDSE],

@50:60T as [date],

@107:120T as [quantity],

@121:133T as [cost],

@1:10T as [cust_id],

@1:10T as [CUST_ID],

@207:240T as [PRO_CLASS],

@97:100T as [pro_cls],

@150:166T as [PRODUCT_CODE],

@241:243T as [sign],

@299:306T as [gROUP],

@307:312T as [grouping],

@61:64T as [oDSE],

@83:86T as [sub_seg],

@79:82T as [sEG],

@344:354T as [date_sales],

@355:361T as [DO_NO],


Now I using above approach to import data to my Qlik View software. Since now I am using SAP software , can some one share it there a better approach and why ?


Paul Yeo

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

It seems like your "syspro" accounting software is making data available in headerless fixed-format files. The technique you use in your example is only to be used if there really is no other method to extract data from an application. If you don't mind, I would even put it like this: any other method to obtain data from an application is better than this one.

SAP is a gigantic ERP-package that runs on either a relational database or on HANA. Every table in SAP has a name, and every field (column) has a name as well. So you can omit the positioning stuff (i.e. @nnn:mmmT ) from your LOAD statements, as a simple

CUSTOM CONNECT TO ...; // If you use the SAP Connector

ODBC CONNECT TO ...; // If you connect straight to the underlying RDBMS

VBAK:

SQL SELECT * FROM VBAK;

DISCONNECT;

may already load all Sales Order headers from your SAP database. And the fields will have the names they have in SAP.

Hope this help,

Peter

View solution in original post

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

It seems like your "syspro" accounting software is making data available in headerless fixed-format files. The technique you use in your example is only to be used if there really is no other method to extract data from an application. If you don't mind, I would even put it like this: any other method to obtain data from an application is better than this one.

SAP is a gigantic ERP-package that runs on either a relational database or on HANA. Every table in SAP has a name, and every field (column) has a name as well. So you can omit the positioning stuff (i.e. @nnn:mmmT ) from your LOAD statements, as a simple

CUSTOM CONNECT TO ...; // If you use the SAP Connector

ODBC CONNECT TO ...; // If you connect straight to the underlying RDBMS

VBAK:

SQL SELECT * FROM VBAK;

DISCONNECT;

may already load all Sales Order headers from your SAP database. And the fields will have the names they have in SAP.

Hope this help,

Peter

paulyeo11
Master
Master
Author

Hi Peter

Thank you very much for your reply. . I think your approach is very good.

I can imagine the benefit are :-

I don’t need to count the columns numbering

I can reload and get update updated any time I like

I can load all the field into QV.

It is correct ?

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>