topic Re: Data Extraction issue from SAP in QlikView

Data Extraction issue from SAP

arvind_patil — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am Fetching data from SAP . The SAP Connector is 5.802211. When I fetch a huge data Maximum data Is correct but in some fields i Get Exclamatory marks Before some fields and last digit Missing in that .

Please suggest me what Can I do to resolve this

Thanks,

Arvind Patil

Re: Data Extraction issue from SAP

arvind_patil — Tue, 26 Sep 2017 03:46:59 GMT

Any Help regarding above issue

Thanks,

Arvind Patil

Re: Data Extraction issue from SAP

Anil_Babu_Samineni — Tue, 26 Sep 2017 03:52:05 GMT

Not sure about that. What if you used Num() in qlikview.. Can you show the variant from SAP values how looks like..

Re: Data Extraction issue from SAP

arvind_patil — Tue, 26 Sep 2017 07:45:56 GMT

Sorry !

But I am new in SAP Do You mean script how I fetch Data.

select SAPREPORT (REPORT (ABC), VARIANT (CBD), ROWS_PER_RECORD (1), FIELD_START_POSITIONS (1, 10, 11, 46, 47, 71, 72, 77, 78, 93, 94, 108, 109, 113, 114, 130, 131, 171, 172, 186, 187, 208, 209, 220, 221, 248, 249, 262, 263, 276, 277, 288, 289,302,303,312,313,325,326,343,344,360,361,396,397,408,409,429,430,445,446,466,467,480,481,511,512,525,526,542,543,557,558,569,570,589,590,604,605,624,625,633,634,639,640,653,654,663,664,692,693,709,710,730,731,744,745,757,758,793,794,804,805,815,816,826), SKIP (T (1), T (2), T (3), T (4)), HEADER (T (5)));

Thanks

Arvind patil