DUMP CX_SY_DYNAMIC_OSQL_SEMANTICS In Approve Service Entry Sheet App

[Former Member]

Hi gurus, I'm implementing the approve service entry sheet app, it is working fine for some users(specially with SAP_ALL) but for some other users I'm getting the following dump (in the backend).

CX_SY_DYNAMIC_OSQL_SEMANTICS in pogram   CL_MM_SES_APPROVE_SELECT======CP.

It is happening in the follow select statement

*     account assignments for all service lines in a SES => based on ESLH to get all service lines

       SELECT  eskl~packno AS packno,

             eskl~introw AS introw,

             eskl~numkn AS zekkn,

             eskn~kostl AS kostl,

             eskn~vbeln AS vbeln,

             eskn~vbelp AS vbelp,

             eskn~anln1 AS anln1,

             eskn~aufnr AS aufnr,

             eskn~ps_psp_pnr AS ps_psp_pnr,

             eskn~nplnr AS nplnr,

             anla~txt50 AS anla_text,

             essr~knttp AS knttp,

             t163i~knttx AS knttx,

             prps~poski AS poski,

             prps~post1 AS post1,

             aufk~ktext AS aufnr_text,

             cskt~ktext AS cost_center_text,

             eskl~wproz AS distribution_percentage,

             eskl~menge AS distribution_quantity,

             esll~meins AS distribution_unit,

             eskn~sakto AS gl_account,

             skat~txt20 AS gl_account_description

        FROM eslh

        INNER JOIN eskl ON eslh~packno = eskl~packno

        LEFT OUTER JOIN esll ON esll~packno = eskl~packno AND esll~introw = eskl~introw

        LEFT OUTER JOIN essr ON essr~packno = eslh~hpackno "#EC CI_BUFFJOIN

        LEFT OUTER JOIN eskn ON eskn~packno = essr~lblni AND eskn~zekkn = eskl~zekkn

        LEFT OUTER JOIN t163i ON t163i~knttp = essr~knttp AND t163i~spras = @sy-langu

        LEFT OUTER JOIN ekpo ON essr~ebeln = ekpo~ebeln AND essr~ebelp = ekpo~ebelp

        LEFT OUTER JOIN t001 ON t001~bukrs = ekpo~bukrs

        LEFT OUTER JOIN skat ON skat~ktopl = t001~ktopl AND skat~saknr = eskn~sakto AND skat~spras = @sy-langu

        LEFT OUTER JOIN anla ON anla~bukrs = ekpo~bukrs AND anla~anln1 = eskn~anln1 AND anla~anln2 = eskn~anln2 AND eskn~anln1 <> @space

        LEFT OUTER JOIN prps ON prps~pspnr = eskn~ps_psp_pnr AND eskn~ps_psp_pnr <> @space

        LEFT OUTER JOIN aufk ON aufk~aufnr = eskn~aufnr AND eskn~aufnr <> @space

        LEFT OUTER JOIN cskt_csks AS cskt ON cskt~kokrs = eskn~kokrs AND cskt~kostl = eskn~kostl AND cskt~datbi >= @sy-datum AND cskt~datab <= @sy-datum AND cskt~spras = @sy-langu UP TO 1 ROWS

        INTO CORRESPONDING FIELDS OF TABLE @et_accounts

        WHERE eslh~hpackno = @iv_package_number AND (lv_authority_check). "eskl~introw = @iv_line_number.

In class CL_MM_SES_APPROVE_SELECT Method ->IF_MM_SES_APPROVE_SELECT~SELECT_SES_ACCOUNTS

I think its about something related to authorizations, because for users with SAP_ALL error does not happen, but I've applied all required roles about this app, I really do not know why it happens.

OBS: This error occurs when user clicks on header area (to open item info).

Help will be very appreciated.

Thanks

[Former Member · Accepted solution]

Problem was solved by implementing oss note 2147736 - Fiori Approve Service Entry Sheets App: App cannot be started because of Authorization che...

Thanks Saurabh

[saurabh_vakil]

For the users which don't have SAP_ALL and are apparently facing this issue, have you checked SU53 in both the gateway and back end systems to see if indeed there are any missing authorizations?