BEx Report using Customer Exit

[Former Member]

Hi all,

I have a problem,I want to filter location storage data, using customer exit create variable

Ex.

LS: 0000,X00A,X00B,C00E,1YCP,1YC0.......

I need to 3 variable 1. 00

2. +Y*

3. *

I define 3 variable and assign to one element when excute analyzer appre error message

If a selection option-variable is used, no additional selections can be specified for this characteristic in this element.

how can i to do ?

[gary_ganesan · Accepted solution]

Hi Chi Wei,

You want to create a customer exit variable for storage location only?

and you created 3 variables for the same characteristics?

Regards,

Gary.

[Former Member · Accepted solution]

Hi Gray,

Yes, I want to create a customer exit variable for storage location only.

But I can't make it successful. do you have good suggestion for me ?

[Former Member · Accepted solution]

Hi weiChiWei,

You don't need to create 3 variables. You just need to create 1.

Use customer exit as its method. Write the relevant customer exit. and your work is done.

Let me know.

Regards,

Sree.

[Former Member · Accepted solution]

Hi Sree,

Could you teach to me step by step ? I don't know how to do.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Mohan,

Thank you reply,but that just provider Single Vaule couldn't use in selection-option.

Because i-table have to Sing = 'BT' ,low = '00'.

[Former Member · Accepted solution]

Hi,

see note 629697 for various combinations of SIGN and OPT in customer exits and 492504.

also see these articles for step by step procedure to use customer exits.

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/20f119d9-922d-2c10-88af-8c016638bd90

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f002c608-2533-2c10-25a1-d0e7f7b5b662

http://help.sap.com/saphelp_nw70/helpdata/EN/f1/0a56f5e09411d2acb90000e829fbfe/frameset.htm

hope this helps,

Rk.

[Former Member · Accepted solution]

Dear Ramakrishna,

Yes,I following these docments,but Bex Designer only Support one Selection-option,when I excute report

will be happen error.

abap code is ok,but Bex Report can not be one more than variables.

WHEN 'ZZLOC'.

CLEAR l_s_range.

l_s_range-low = '00'. "low value

l_s_range-sign = 'I'.

l_s_range-opt = 'CP'.

APPEND l_s_range TO e_t_range.

l_s_range-low = 'SL'. "low value

APPEND l_s_range TO e_t_range.

WHEN 'ZZLOCALL'.

CLEAR l_s_range.

i_vnam = 'ZZLOCALL'.

l_s_range-low = '*'. "low value

l_s_range-sign = 'I'.

l_s_range-opt = 'CP'.

APPEND l_s_range TO e_t_range.

[Former Member · Accepted solution]

Hi,

you can try this code. This will bring all the Z_LOC starting with AB and CC.

   
IF I_STEP = 1.
          DATA: ITAB3 TYPE STANDARD TABLE OF /BI0/SZ_LOC WITH HEADER LINE.
          SELECT * FROM /BI0/SZ_LOC INTO TABLE ITAB3 WHERE Z_LOC LIKE 'AB%' OR Z_LOC LIKE 'CC%'.
          CLEAR: L_S_RANGE.
          L_S_RANGE-SIGN = 'I'.
          L_S_RANGE-OPT = 'EQ'.
          LOOP AT ITAB3 .
            L_S_RANGE-LOW = ITAB3-Z_LOC.
            APPEND L_S_RANGE TO E_T_RANGE.
          ENDLOOP.
          CLEAR L_S_RANGE.

Regards,

Rk.