topic R3 Data Loading issue in to Qlikview? in QlikView

R3 Data Loading issue in to Qlikview?

Fri, 05 Aug 2011 09:24:12 GMT

hi,

when i am trying to pulling data from R3 into qlikview,i can able to load first table script data,but 2nd table script data not loading....qlikview hanging

some times generating dev_rfc.trc log file on desktop?

pls let me know any wht is the cause.

note: installed qlickview connector for sap and tested....working fine.

Rgds

R3 Data Loading issue in to Qlikview?

suniljain — Sun, 07 Aug 2011 06:34:49 GMT

can i know which table you are extracting ?.

R3 Data Loading issue in to Qlikview?

disqr_rm — Mon, 08 Aug 2011 02:16:40 GMT

Nothing wrong with your code. The tables you are loading aren't big enough to cause problems.

You may want to just load all values and see how it works:

T001L: // Division Codes

SQL Select * from T001L;

TSPAT: // Sales Division Codes

SQL Select * from TSPAT WHERE SPRAS = 'EN';

Otherwise, I recommend double checking what versions on R/3 (BASIS) you have and which transports you have imported for SAP Connector. You may have imported wrong one. If so, please check installation manual to identify correct transports.

You mentioned about dev_rfc.trc file being generated. Open that file in notebook and it will show you the communication problem your systems may be having. Also check SM37 for terminated jobs, SM21 for sys log and ST22 for system dumps. Post trace file here for further recommendations.

Rakesh

R3 Data Loading issue in to Qlikview?

suniljain — Wed, 10 Aug 2011 07:49:05 GMT

Tables you are extracting is not big one.

I will suggest you retransport the SAP Connector Transport according to SAP Basis version.