cancel
Showing results for 
Search instead for 
Did you mean: 

Need help in developing a query

Former Member
0 Kudos

Hi All,

i have two requirement.

1. in the selection screen, user enters a key date. the user would enter a from date and a to date. if the to date is left blank it should pick the system date when the report is run as to date.

2. in my cube i have data as 0calmonth. now if i want to display as january-11, how would i achieve the same.

Please provide me your suggestions at the earliest.

Thanks and Regards,

Sananda

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

First u will create 2 varibles for from date & to date ,from date is character variable with user entry,To date is characterstic variable with customer exit .In cmod u will wrote code for this.

If todate equal blank then it is equal to sy-datum & plz explain little brief 2nd reuirement.

Regards,

Sai.

Former Member
0 Kudos

For the first one, like SAI said creating an user-exit would be the option

2. If im right the report display 01/11 and u need to display it as January-11

There are 2 ways to do this.

a. Load master data text to 0CALMONTH and displaying text in the queries.

b. Other way is before the data updates to the cube, create a routing for 0CALMONTH.

Thanks,

Rajesh

Answers (0)