Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

big_dreams
Contributor III

SAP B-Ex connector issue

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,

1 Reply
big_dreams
Contributor III

Re: SAP B-Ex connector issue

any one???????

Community Browser