In a query, how to display the calendar day and the weekday in the heading

[Former Member]

Hi Experts,

I am in a situation where I need to have calendar day and the weekday in a heading of a column in a query? we are in BW 3.5.

Here is an example:

04.22.2007

Sun

Branch 001 1,000.00

Branch 002 2,000.00

Branch 003 3,000.00

in my query, this is a restricted key figure with sales qty and calendar day and I have a text variable to show the calendar day. In addition to that, the customer wants weekday as well.

Not sure how to do this.

Any help is much appreciated.

Thanks.

Jenny.

[Former Member · Accepted solution]

Hello ,

This InfoObject do not maintain the weekday ...so it is difficult to show the Weekday for a date as per the standard way.

You need to write a Customer exit variable..and you need to use a Function Module : DATE_TO_DAY. This will convert your date to day ie 23.04.2007 = Monday.

Note: This function module is not available in BW so try to copy this FM from R/3 system.

I am sure this will solve ur issue:-)

--EnjoySAP

• Have a great day!

[Former Member]

Hi Anil and Ajay,

Thanks for your great help.

I have assigned points. Since this is my first time, please let me know if I did not assign correctly.

Have a great day!

Jenny.

[Former Member]

Hi Jenny,

How do you get this Cal-day?

If it is user entry variable Create a Text Variable of processing type Customer Exit .

and get then get the Week day as suggested by Anil and Append them into this Text variable using ABAP.

We do not have standard functionality in BI to do this.

Hope this Helps you.

Regards

Ajay