Data Extraction issue from SAP - Qlik Community

arvind_patil · ‎2017-09-25

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

arvind_patil · ‎2017-09-25

Any Help regarding above issue

Thanks,

Arvind Patil

Anil_Babu_Samineni · ‎2017-09-25

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

arvind_patil · ‎2017-09-26

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