Skip to Content
avatar image
Former Member

DUMP CX_SY_DYNAMIC_OSQL_SEMANTICS In Approve Service Entry Sheet App

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).


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


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


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.


App Error.jpg (78.2 kB)
Backend Dump.jpg (97.2 kB)
Error Log.jpg (149.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 26, 2016 at 09:46 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2016 at 06:31 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded