Using CMOD procedure?

[Former Member]

Dear All,

I am using BEx Query Designer. I made three date variables on 0netduedate(net due date) , 0pstng_date(posting date) and 0clear_date(clearing date). By inputting the netduedate at selection screen , that same date should go to posting date and clearing date automatically. For that I know I have to user exits but unfortunately I am new to BW and CMOD and enhancements. So could anybody tell me the procedure how to use CMOD and build a relation between these 3 dates?How are these user exits connected to our infoobjects and their variables in query designer?

Regards,

Ratish

[Former Member · Accepted solution]

Hi,

Customer exits are used to derive custom values for the variable value. When we have to derive a value based on another variable value, we go for a customer exit variable.

Now when Bex finds a variable of type exit, it get the value from customer exit code which is designed by the user.

here are some how to guides which will gives the step by step activities:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f1a7e790-0201-0010-0a8d-f08a4662...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/59069d90-0201-0010-fd81-d5e11994...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/25d98cf6-0d01-0010-0e9b-edcd4597...

Happy

[Former Member · Accepted solution]

Dear Happy,

Thankyou very much.Right on the button, your answer!!

Regards,

Ratish

[Former Member]

Use the following:

-

---

when '$POSTINGDATE$'.

Loop at i_t_var_range into loc_var_range

where vnam = '$INPUTDATE$'.

check sy-subrc = 0.

//do stuff

l_S_range-sign = 'I'.

l_s_range-opt = 'BT'. //use 'BT' for an interval

l_s_range-low = $START$.

l_s_range-high = $END$.

append l_s_range to e_t_range.

endloop.

In my example I entered $INPUTDATE$ (user entry single value variable) and I calculate a specific range (aging from 0 to 30 days old) which is determined in the 'do stuff' section (left out). At the end the interval for $POSTINGDATE$ is determined. This is part of include ZXRSRU01. Look for howto's on how to setup these includes in CMOD. SAP has several howto's available.