Symptom
SM21 error messages : database error 7 with PRE access to table FAA_M_AANLA
The corresponding messages from developer trace:
C *** ERROR => prepare() of C_0901, rc=1, rcSQL=7
[dbsdbsql.cpp 3535]
C {root-id=DB2DDE2E20721EEDB2FAF1E3ECA3381F}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => PREPARE C_0901 on connection 0, rc=7
[dbslsdb.cpp 8417]
C SQLCODE : 7
C SQLERRTEXT : feature not supported: CONTAINS predicates on expression ABAP_UPPER(ANLA.TXT50)
C sc_p=7fff5b25a288,no=901,idc_p=(nil),con=0,act=1,slen=928,smax=1024,#vars=27,stmt=7fc6ec62d260,table=FAA_M_AANLA
C statementHash=5f12e50b633227137bc023178154d4fc
C SELECT /* CDS access control applied */ /* Contains Native SQL */ "BUKRS" "BUKRS" , "ANLN1" "ANLN1" \
C , "ANLN2" "ANLN2" , "ANLKL" "ANLKL" , "MCOA1" "MCOA1" , "KTOGR" "KTOGR" , "AKTIV" "AKTIV" , SCORE( )\
C "DSH_SCORE_ALIAS" FROM /* Entity name: FAA_M_AANLA CDS access controlled */ "FAAV_M_AANLA" "SEARCH_\
C STRUCTURE" WHERE "MANDT" = ? AND CONTAINS( ( "ANLKL" , "ANLN1" , "ANLN2" , "BUKRS" , "KTOGR" , "MCOA\
C 1" ) , ? , FUZZY( ( ? , ? ) , ( ? , ? ) , ( ? , ? ) , ( ? , ? ) , ( ? , ? ) , ( ? , ? ) ) ) AND "ASS\
C ETAUTHORIZATIONCONTEXT" = ? AND ( "ANLKL" BETWEEN ? AND ? AND "BUKRS" BETWEEN ? AND ? OR ( "ANLKL" L\
C IKE ? OR "ANLKL" LIKE ? ) AND "BUKRS" BETWEEN ? AND ? OR ( "ANLKL" LIKE ? OR "ANLKL" LIKE ? ) AND "B\
C UKRS" BETWEEN ? AND ? ) ORDER BY "DSH_SCORE_ALIAS" DESC , "SEARCH_STRUCTURE" . "ANLN2" , "SEARCH_STR\
C UCTURE" . "BUKRS" , "SEARCH_STRUCTURE" . "ANLN1" LIMIT 200 WITH PARAMETERS( 'LOCALE' = 'EN' ) WITH \
C RANGE_RESTRICTION('CURRENT');
B ***LOG BY4=> sql error 7 performing PRE on table FAA_M_AANLA [dbdbslst 5652]
B ***LOG BY0=> feature not supported: CONTAINS predicates on expression ABAP_UPPER(ANLA.TXT50) [dbdbslst 5652]
Read more...
Environment
Keywords
CDS view, FAA_M_AANLA, contains(), expression , KBA , HAN-DB , SAP HANA Database , FI-AA-AA-A , Master Data , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.