SAP Knowledge Base Article - Preview

3329686 - SM21 error messages : database error 7 with PRE access to table FAA_M_AANLA

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

  • S4CORE 105 
  • S4CORE 106 
  • S4CORE 107

Product

SAP HANA, platform edition all versions

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.