Hi,
While working with qlik sense sap BEX connector. I am getting below error
1: When I removed the preceding load statement
Started loading data
Connected
ZUBO_ZFIGL_M10_Q0003 << ZFIGL_M10
The following error occurred:
Structure "LT_GENTAB" contains no fields fields. 4 LT_GENTAB
The error occurred here:
[ZUBO_ZFIGL_M10_Q0003]:
SELECT [ZUBO_ZFIGL_M10_Q0003]
DIMENSIONS (
[0COMP_CODE],
[0COSTCENTER],
[0GL_ACCOUNT],
[0GL_ACCOUNT__0CS_ITEM],
[0PROFIT_CTR],
[0VERSION],
[0VTYPE],
[ZCOMMENT1],
[0FISCPER],
[0CURRENCY],
)
MEASURES (
[F2ATB1FXM3MR4NXWOQ0W259G4],
[F2ATB1FXM3MR4NXWOQ0WDIDCK],
[F2ATB1FXM3MR4NXWOQ0WOKXZO],
[F2ATB1FXM3MR4NXWOQ0WZEQL0],
[F2ATB1FXM3MR4NXWOQ0XAAADW],
[F2ATB1FXM3MR4NXWOQ0XL42Z8],
)
UNITS (
)
VARIABLES (
[NAME=ZU_FSPER, SIGN=I, OPTION=EQ, LOW=V32017003],
)
FROM [ZFIGL_M10]
Data has not been loaded. Please correct the error and try loading again.
2: with Preceding Load I am getting below error
Started loading data
Connected
The following error occurred:
Field '0COMP_CODE' not found
The error occurred here:
?
Data has not been loaded. Please correct the error and try loading again.
Query:
[ZUBO_ZFIGL_M10_Q0003]:
LOAD
[0COMP_CODE] as [Company code],
[0COSTCENTER] as [Cost Center],
[0GL_ACCOUNT] as [G/L Account],
[0GL_ACCOUNT__0CS_ITEM] as [FS-ITEM],
[0PROFIT_CTR] as [Profit Center],
[0VERSION] as [Version],
[0VTYPE] as [Value Type for Reporting],
[ZCOMMENT1] as [ZCOMMENT1],
[0FISCPER] as [Fiscal year / period],
[0CURRENCY] as [Currency key],
[F2ATB1FXM3MR4NXWOQ0W259G4] as [&ZT_YEAR&],
[F2ATB1FXM3MR4NXWOQ0WDIDCK] as [&ZT_YEAR&_1],
[F2ATB1FXM3MR4NXWOQ0WOKXZO] as [&ZT_YEAR&_2],
[F2ATB1FXM3MR4NXWOQ0WZEQL0] as [&ZT_YEAR&_3],
[F2ATB1FXM3MR4NXWOQ0XAAADW] as [&ZT_YEAR&_4],
[F2ATB1FXM3MR4NXWOQ0XL42Z8] as [&ZT_YEAR&_5],
[CURRENCY001] as [CURRENCY001 &ZT_YEAR&],
[UNIT001] as [UNIT001 &ZT_YEAR&],
[CURRENCY002] as [CURRENCY002 &ZT_YEAR&],
[UNIT002] as [UNIT002 &ZT_YEAR&],
[CURRENCY003] as [CURRENCY003 &ZT_YEAR&],
[UNIT003] as [UNIT003 &ZT_YEAR&],
[CURRENCY004] as [CURRENCY004 &ZT_YEAR&],
[UNIT004] as [UNIT004 &ZT_YEAR&],
[CURRENCY005] as [CURRENCY005 &ZT_YEAR&],
[UNIT005] as [UNIT005 &ZT_YEAR&],
[CURRENCY006] as [CURRENCY006 &ZT_YEAR&],
[UNIT006] as [UNIT006 &ZT_YEAR&],
[0COMP_CODE__TEXT] as [Company code TEXT],
[0COSTCENTER__TEXT] as [Cost Center TEXT],
[0GL_ACCOUNT__TEXT] as [G/L Account TEXT],
[0GL_ACCOUNT__0CS_ITEM__TEXT] as [FS-ITEM TEXT],
[0PROFIT_CTR__TEXT] as [Profit Center TEXT],
[0VERSION__TEXT] as [Version TEXT],
[0VTYPE__TEXT] as [Value Type for Reporting TEXT],
[ZCOMMENT1__TEXT] as [ZCOMMENT1 TEXT],
[0FISCPER__TEXT] as [Fiscal year / period TEXT],
[0CURRENCY__TEXT] as [Currency key TEXT];
SELECT [ZUBO_ZFIGL_M10_Q0003]
DIMENSIONS (
[0COMP_CODE], //Company code
[0COSTCENTER], //Cost Center
[0GL_ACCOUNT], //G/L Account
[0GL_ACCOUNT__0CS_ITEM], //FS-ITEM
[0PROFIT_CTR], //Profit Center
[0VERSION], //Version
[0VTYPE], //Value Type for Reporting
[ZCOMMENT1], //ZCOMMENT1
[0FISCPER], //Fiscal year / period
[0CURRENCY], //Currency key
)
MEASURES (
[F2ATB1FXM3MR4NXWOQ0W259G4], //&ZT_YEAR&
[F2ATB1FXM3MR4NXWOQ0WDIDCK], //&ZT_YEAR&_1
[F2ATB1FXM3MR4NXWOQ0WOKXZO], //&ZT_YEAR&_2
[F2ATB1FXM3MR4NXWOQ0WZEQL0], //&ZT_YEAR&_3
[F2ATB1FXM3MR4NXWOQ0XAAADW], //&ZT_YEAR&_4
[F2ATB1FXM3MR4NXWOQ0XL42Z8], //&ZT_YEAR&_5
)
UNITS (
[CURRENCY001.F2ATB1FXM3MR4NXWOQ0W259G4], //CURRENCY001 &ZT_YEAR&
[UNIT001.F2ATB1FXM3MR4NXWOQ0W259G4], //UNIT001 &ZT_YEAR&
[CURRENCY002.F2ATB1FXM3MR4NXWOQ0WDIDCK], //CURRENCY002 &ZT_YEAR&
[UNIT002.F2ATB1FXM3MR4NXWOQ0WDIDCK], //UNIT002 &ZT_YEAR&
[CURRENCY003.F2ATB1FXM3MR4NXWOQ0WOKXZO], //CURRENCY003 &ZT_YEAR&
[UNIT003.F2ATB1FXM3MR4NXWOQ0WOKXZO], //UNIT003 &ZT_YEAR&
[CURRENCY004.F2ATB1FXM3MR4NXWOQ0WZEQL0], //CURRENCY004 &ZT_YEAR&
[UNIT004.F2ATB1FXM3MR4NXWOQ0WZEQL0], //UNIT004 &ZT_YEAR&
[CURRENCY005.F2ATB1FXM3MR4NXWOQ0XAAADW], //CURRENCY005 &ZT_YEAR&
[UNIT005.F2ATB1FXM3MR4NXWOQ0XAAADW], //UNIT005 &ZT_YEAR&
[CURRENCY006.F2ATB1FXM3MR4NXWOQ0XL42Z8], //CURRENCY006 &ZT_YEAR&
[UNIT006.F2ATB1FXM3MR4NXWOQ0XL42Z8], //UNIT006 &ZT_YEAR&
)
VARIABLES (
[NAME=ZU_FSPER, SIGN=I, OPTION=EQ, LOW=V32018003], //Fiscal year period for UPL (Single,Mandatory)
)
FROM [ZFIGL_M10];
Please need your urgent assistance on this.
Regards,
