Authorization Using Exits Special characters (*)

[Sandra_Rossi]

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

[Sandra_Rossi]

I don't understand the question, at all.

[DoanManhQuynh]

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.

[Former Member]

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

i am using value authorization..

[DoanManhQuynh]

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.