3391210 - SQLERRTEXT : feature not supported: cannot add result cache on " " because the semantics of table function is not suitable for caching (Function: " "."" is not fully unfolded)

• SM21 shows many errors like this :
  
  

16.10.2023    00:03:41    hostname_SID    BTC    054    000    SDMI_     @5C\Qvery high priority@    BY2    Database error 7 at EXE
16.10.2023    00:03:41    hostname_SID    BTC    054    000    SDMI_     @SR\Qinformation@    BY0    > feature not supported: cannot add result cache on
16.10.2023    00:03:41    hostname_SID    BTC    054    000    SDMI_     @SR\Qinformation@    BY0    > "CMMPURCONEXP" because the semantics of table function is no
16.10.2023    00:03:41    hostname_SID    BTC    054    000    SDMI_     @SR\Qinformation@    BY0    > suitable for caching (Function: "SAPABAP1"."CMMPURCONEXP" is
16.10.2023    00:03:41    hostname_SID    BTC    054    000    SDMI_     @SR\Qinformation@    BY0    > not fully unfolded): line 1 col 16 (at pos 15)

• Underlying work process traces contain the details and sql commands being sent to DB :

C Sun Oct 15 00:21:04:422 2023
C  *** ERROR =>   execute(), rc=1, rcSQL=7
 [dbsdbsql.cpp 1779]
C  {root-id=DB172C6D13801EEE9ADBFE3E98FF67AB}_{conn-id=00000000000000000000000000000000}_0
C  SQLCODE    : 7
C  SQLERRTEXT : feature not supported: cannot add result cache on "CMMPURCONEXP" because the semantics of table func\
C               tion is not suitable for caching (Function: "SAPABAP1"."CMMPURCONEXP" is not fully unfolded): line 1\
C                col 16 (at pos 15)
C  SQL COMMAND: alter FUNCTION CMMPURCONEXP add cache retention 1440 of SUM( NMBROFEXPIRINGCONTRACTS ), SUM( TARGETA\
C               MOUNT ), SUM( RELEASEORDERITEMNETAMOUNT ), MANDT, DISPLAYCURRENCY, SUPPLIER, SUPPLIERNAME, PURCHASIN\
C               GGROUP, PURCHASINGGROUPNAME , PURCHASINGORGANIZATION,  PURCHASINGORGANIZATIONNAME;
C  *** ERROR => EXECUTE on connection 0, rc=7
 [dbslsdb.cpp  3668]
C  SQLCODE    : 7
C  SQLERRTEXT : feature not supported: cannot add result cache on "CMMPURCONEXP" because the semantics of table func\
C               tion is not suitable for caching (Function: "SAPABAP1"."CMMPURCONEXP" is not fully unfolded): line 1\
C                col 16 (at pos 15)
C  SQL COMMAND: alter FUNCTION CMMPURCONEXP add cache retention 1440 of SUM( NMBROFEXPIRINGCONTRACTS ), SUM( TARGETA\
C               MOUNT ), SUM( RELEASEORDERITEMNETAMOUNT ), MANDT, DISPLAYCURRENCY, SUPPLIER, SUPPLIERNAME, PURCHASIN\
C               GGROUP, PURCHASINGGROUPNAME , PURCHASINGORGANIZATION,  PURCHASINGORGANIZATIONNAME;
B  ***LOG BY2=> sql error 7 performing EXE [dbds         772]
B  ***LOG BY0=> feature not supported: cannot add result cache on "CMMPURCONEXP" because the semantics of table function is not suitable for caching (Function: "SAPABAP1"."CMMPURCONEXP" is not fully unfolded): line 1 col 16 (at pos 15) [dbds         772]
C 

SAP HANA Platform Edition 2.0      

KBA , HAN-DB , SAP HANA Database , Problem