Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravindra
Contributor II
Contributor II

Error while fetching data from SAP BW Report

I am trying to fetch data from SAP BW report using SAPConnector BEXquery.

But I am unable to fetch the data, it throws below error message:

Custom read failed
SELECT [ZICPPAN_Q001]
DIMENSIONS (
[AUART],
[AUFNR],
[AUTYP],
[BLDAT],
[BOMCAT],
[BUDAT],
[BUKRS],
[BWART],
[CALWEEK],
[CHARG],
[CQUARTER],
[KDAUF],
[LGORT],
[MANDT],
[MATKL],
[MATNR],
[MBLNR],
[MJAHR],
[MONTH],
[PRCTR],
[QUARTER],
[WERKS],
[ZEILE],
[ZMATKL],
[ZMATNR],
[ZMATNR1],
[ZMTART],
[ZZGRADE],
[ZZKGPERMC],
[ZZL2ID],
[ZZLENGTHC],
[ZZSECTION],
[ZZSIZE],
[ZZSTD],
[0CALDAY],
[0CALMONTH],
)
MEASURES (
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
UNITS (
[CURRENCY001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
[UNIT001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
VARIABLES (
[NAME=ZCOMP_CODE11, SIGN=I, OPTION=EQ, LOW=6000],
[NAME=ZCALMONTH, SIGN=I, OPTION=BT, LOW=201811, HIGH=201901],
)
FROM [ZICPPAN]

Below is the Script:

CUSTOM CONNECT TO "Provider=QvBexConnector.exe;servertype=0;ASHOST=000.00.00.00;CLIENT=00;SYSNR=00;Timeout=3600;SNC_MODE=false;SNC_QOP=9;XUserId=EDfcZIRJJaSKVJVISSbB;XPassword=YaISQIRNJbaAUYIGTZaB;";
[ZICPPAN_Q001]:
LOAD
[AUART] as [Document Type],
[AUFNR] as [Order Number],
[AUTYP] as [Order category],
[BLDAT] as [Document Date],
[BOMCAT] as [BoM Category],
[BUDAT] as [Posting Date],
[BUKRS] as [Company Code],
[BWART] as [Movement Type],
[CALWEEK] as [Calendar Week],
[CHARG] as [Batch Number],
[CQUARTER] as [Quarter],
[KDAUF] as [Sales Order Number],
[LGORT] as [Storage Location],
[MANDT] as [Client],
[MATKL] as [Material Group],
[MATNR] as [Material],
[MBLNR] as [Material Document],
[MJAHR] as [Material Document Year],
[MONTH] as [CALMONTH],
[PRCTR] as [Profit Centre],
[QUARTER] as [Calendar Quarter],
[WERKS] as [Plant],
[ZEILE] as [Material Document Item],
[ZMATKL] as [Material Group],
[ZMATNR] as [Planned Material],
[ZMATNR1] as [Prime/Non-Prime],
[ZMTART] as [Material type],
[ZZGRADE] as [Grade],
[ZZKGPERMC] as [KgPerMeter],
[ZZL2ID] as [Level II ID],
[ZZLENGTHC] as [Length],
[ZZSECTION] as [Section],
[ZZSIZE] as [Size],
[ZZSTD] as [Standard],
[0CALDAY] as [Calendar day],
[0CALMONTH] as [Calendar year/month],
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL] as [Consumption Quantity],
[CURRENCY001] as [CURRENCY001 Consumption Quantity],
[UNIT001] as [UNIT001 Consumption Quantity];
// Uncomment appropriate lines and move the semicolon
// to load TEXT data for the dimensions that are known
// to include text:
// [AUART__TEXT] as [Document Type TEXT],
// [AUFNR__TEXT] as [Order Number TEXT],
// [AUTYP__TEXT] as [Order category TEXT],
// [BLDAT__TEXT] as [Document Date TEXT],
// [BOMCAT__TEXT] as [BoM Category TEXT],
// [BUDAT__TEXT] as [Posting Date TEXT],
// [BUKRS__TEXT] as [Company Code TEXT],
// [BWART__TEXT] as [Movement Type TEXT],
// [CALWEEK__TEXT] as [Calendar Week TEXT],
// [CHARG__TEXT] as [Batch Number TEXT],
// [CQUARTER__TEXT] as [Quarter TEXT],
// [KDAUF__TEXT] as [Sales Order Number TEXT],
// [LGORT__TEXT] as [Storage Location TEXT],
// [MANDT__TEXT] as [Client TEXT],
// [MATKL__TEXT] as [Material Group TEXT],
// [MATNR__TEXT] as [Material TEXT],
// [MBLNR__TEXT] as [Material Document TEXT],
// [MJAHR__TEXT] as [Material Document Year TEXT],
// [MONTH__TEXT] as [CALMONTH TEXT],
// [PRCTR__TEXT] as [Profit Centre TEXT],
// [QUARTER__TEXT] as [Calendar Quarter TEXT],
// [WERKS__TEXT] as [Plant TEXT],
// [ZEILE__TEXT] as [Material Document Item TEXT],
// [ZMATKL__TEXT] as [Material Group TEXT],
// [ZMATNR__TEXT] as [Planned Material TEXT],
// [ZMATNR1__TEXT] as [Prime/Non-Prime TEXT],
// [ZMTART__TEXT] as [Material type TEXT],
// [ZZGRADE__TEXT] as [Grade TEXT],
// [ZZKGPERMC__TEXT] as [KgPerMeter TEXT],
// [ZZL2ID__TEXT] as [Level II ID TEXT],
// [ZZLENGTHC__TEXT] as [Length TEXT],
// [ZZSECTION__TEXT] as [Section TEXT],
// [ZZSIZE__TEXT] as [Size TEXT],
// [ZZSTD__TEXT] as [Standard TEXT],
// [0CALDAY__TEXT] as [Calendar day TEXT],
// [0CALMONTH__TEXT] as [Calendar year/month TEXT];

SELECT [ZICPPAN_Q001]
DIMENSIONS (
[AUART],
[AUFNR],
[AUTYP],
[BLDAT],
[BOMCAT],
[BUDAT],
[BUKRS],
[BWART],
[CALWEEK],
[CHARG],
[CQUARTER],
[KDAUF],
[LGORT],
[MANDT],
[MATKL],
[MATNR],
[MBLNR],
[MJAHR],
[MONTH],
[PRCTR],
[QUARTER],
[WERKS],
[ZEILE],
[ZMATKL],
[ZMATNR],
[ZMATNR1],
[ZMTART],
[ZZGRADE],
[ZZKGPERMC],
[ZZL2ID],
[ZZLENGTHC],
[ZZSECTION],
[ZZSIZE],
[ZZSTD],
[0CALDAY],
[0CALMONTH],
)
MEASURES (
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
UNITS (
[CURRENCY001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
[UNIT001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
VARIABLES (
[NAME=ZCOMP_CODE11, SIGN=I, OPTION=EQ, LOW=6000],
[NAME=ZCALMONTH, SIGN=I, OPTION=BT, LOW=201812, HIGH=201901],
)
PARAMS (FORMAT=Y)
FROM [ZICPPAN];
STORE * FROM [ZICPPAN_Q001] INTO ZICPPAN_Q001.qvd;
DROP TABLE [ZICPPAN_Q001];

Please advise to resolve.

Thanks in advance.

Labels (1)
0 Replies