Skip to Content
0
Former Member
Dec 07, 2018 at 06:15 AM

Database returned the SQL code 314. Error text: numeric overflow - Manage Customer Line Item Fiori

6054 Views

We are encountering an error whenever searching items specifically to one customer using the Manage Customer Line item Fiori application. The error displays as below:

Database returned the SQL code 314. Error text: numeric overflow: search table error: [6944] AttributeEngine: overflow in numeric calculation;string comma(string rtrim(string midstru(string rtrim(string fox_replace(string rtrim(string sqladd(string rtrim(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$0$"), string rtrim(string sqladd(string ' &@', string rtrim(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$1$"))))), string '&@', string '')), int '1', int '80')), string jf(int eq(int in(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$34$", string 'V', string 'W'), int '1'), string '3', string jf(int or(int or(int and(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$"), int ne(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '')), int ne(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '00000000')), int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '00000000')), int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '')), string '2', string '1')), string jf(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '00000000'), string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '20181207'), fixed8_5 jf(int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$7$", string 'X'), fixed8_5 '0', fixed8_5 jf(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string '19000101'), int lt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string '29001231')), fixed8_5 jf(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '19000101'), int lt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string "__common2")), fixed8_5 [here]checkdigits(fixed8_5 fixed_8(int dats_days_between(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$")), int '5'), fixed8_5 checkdigits(fixed8_5 fixed_8(int dats_days_between(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string "__common2")), int '5')), fixed8_5 '0')), string box(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$11$", string '0000', string jf(int lt(fixed8_5 "__common1", fixed8_5 '0'), string '1', string jf(int eq(fixed8_5 "__common1", fixed8_5 '0'), string '2', string '3')), string '')),(SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$0$ = "Urbano's Drugstore"[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$1$ = ''[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$ = '20180915'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$11$ = '2018'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$34$ = ''[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$ = '23010929'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$ = '00000000'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$7$ = ''[string]); checkNull false An exception was raised Close