Data Extraction issue from SAP

[arvind_patil]

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]

Any Help regarding above issue

Thanks,

Arvind Patil

[Anil_Babu_Samineni]

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

[arvind_patil]

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