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

[FCI]

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

[Former Member]

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