Question Re: Authorization Using Exits Special characters (*) in Technology Q&A

Authorization Using Exits Special characters (*)

Former Member — Sat, 14 Sep 2019 20:48:24 GMT

Hi Dear ABAP Developer,

I would like add to my code a Special character logic. i need like this; if corresponding field had Null from Table (zabwp017), output should star '*'. its help me, that the user is authenticated all values. Could anyone help me for edit this code?

Table ZAWP017 :

Exampe : Testuser3 has authentication all of the "Sales_Grp" beucause there is NULL.

My Code worked, but i need *(Star) Logic.

another question:

I use BW on HANA. I got a Warning if i using statement "Select * from *.

WHEN 'Z0SALES_OFF_MC'.
IF i_step EQ '0'.

  CALL FUNCTION 'RSEC_GET_USERNAME'
    IMPORTING
      e_username = l_username.
  REFRESH lt_abwp017.
  SELECT * FROM zabwp017 INTO TABLE lt_abwp017 WHERE s_bbiuser = l_username
                                                            AND s_bberanz >= 1 .
    IF sy-subrc = 0.
      LOOP AT lt_abwp017 INTO wa_abwp017.
        CLEAR: l_s_range.
        l_s_range-low = wa_abwp017-sales_off.
        l_s_range-sign = 'I'.
        l_s_range-opt = 'EQ'.
        APPEND l_s_range TO e_t_range.
        CLEAR wa_abwp017.
      ENDLOOP.
    ENDIF.
  ENDIF.

Thanks Alot

Sascha

Re: Authorization Using Exits Special characters (*)

Sandra_Rossi — Sun, 15 Sep 2019 05:13:44 GMT

I don't understand the question, at all.

Re: Authorization Using Exits Special characters (*)

FCI — Mon, 16 Sep 2019 07:02:12 GMT

Just put a new record in e_t_range (I CP *) in case SALES_GRP is blank for your user.

What warning do you exactly have for your SELECT *. On Hana, a SELECT * could be costly (due to its column storiage), try to specify all the needed fields.

Regards,

Frederic

Re: Authorization Using Exits Special characters (*)

DoanManhQuynh — Tue, 17 Sep 2019 00:57:27 GMT

I don't understand your question. if your code worked what logic you need for *? beside, are you setting for value authorization or hierarchy authorization? they will be difference.

Re: Authorization Using Exits Special characters (*)

Former Member — Tue, 17 Sep 2019 20:06:28 GMT

Thanks alot.. I am very beginner. Could you please write this code?

Re: Authorization Using Exits Special characters (*)

Former Member — Tue, 17 Sep 2019 20:12:52 GMT

Why u dont understand my Question, i dont know how can i make clear it.

i am using value authorization..

Re: Authorization Using Exits Special characters (*)

DoanManhQuynh — Wed, 18 Sep 2019 00:25:16 GMT

what I mean I don't understand is that your code worked so what stop you use the same logic for *. do you mean that you don't know how to IF...ELSE?. I can write pseudo code like below:

CASE i_vnam.
  WHEN 'Z0SALES_OFF_MC'.
    IF i_step EQ '0'.
      CALL FUNCTION 'RSEC_GET_USERNAME'
        IMPORTING
          e_username = l_username.
      SELECT sale_grp, sales_off
         FROM zabwp017
         INTO TABLE @lt_abwp017
        WHERE s_bbiuser = @l_username
          AND s_bberanz >= 1 .
      IF line_exists( lt_abwp017[ sale_grp = space ] ). " All authorization
        e_t_range = VALUE #( ( low  = '*'
                               sign = 'I'
                               opt  = 'CP' ) ).
      ELSE.
        e_t_range = VALUE #( FOR wa_abwp017 IN lt_abwp017 ( low  = wa_abwp017-sales_off
                                                            sign = 'I'
                                                            opt  = 'EQ' ) ).
      ENDIF.
    ENDIF.
ENDCASE.

Re: Authorization Using Exits Special characters (*)

Loed — Thu, 19 Sep 2019 15:36:02 GMT

Try this:

WHEN 'Z0SALES_OFF_MC'.

IF i_step EQ '0'.



  CALL FUNCTION 'RSEC_GET_USERNAME'

    IMPORTING

      e_username = l_username.

  REFRESH lt_abwp017.

  SELECT * FROM zabwp017 INTO TABLE lt_abwp017 WHERE s_bbiuser = l_username

                                                            AND s_bberanz >= 1 .

    IF sy-subrc = 0.

      LOOP AT lt_abwp017 INTO wa_abwp017.

          CLEAR l_s_range.

          IF wa_abwp017-sales_off IS NOT INITIAL.

            DELETE lt_abwp017 WHERE sales_off = ''.

            l_s_range-low = lt_abwp017-sales_off.

            l_s_range-sign = 'I'.

            l_s_range-opt = 'EQ'.

            APPEND l_s_range TO e_t_range.

          ELSE.

            l_s_range-low = '*'.

            l_s_range-sign = 'I'.

            l_s_range-opt = 'EQ'.

            APPEND l_s_range TO e_t_range.

          ENDIF.

        ENDLOOP.

    ENDIF.

  ENDIF.

Regards,

Loed

Re: Authorization Using Exits Special characters (*)

Former Member — Thu, 19 Sep 2019 19:49:55 GMT

Thx Alot its work..

i have a warning like this : need a pseudo code?

Database features are functional enhancements in Open SQL that are no longer implementedon alldatabases. ... The name of thedatabase featurespecified in the warning is defined as a constant in the class CL_ABAP_DBFEATURES.

or should i ignore it?
thanks you..

Re: Authorization Using Exits Special characters (*)

DoanManhQuynh — Fri, 20 Sep 2019 08:13:09 GMT

don't understand why you have to delete inside loop, and you should set the correct value of opt for *. also when someone have ALL authorization, there is no use of loop.