1 Reply Latest reply: Jul 18, 2018 12:09 AM by max payne RSS

    SAP B-Ex connector issue

    max payne

      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,