on 05-24-2011 12:01 PM
Hi Expert,
Required of varibale for days count (how many days report) in SAP Bex querry. i have querry restrcit on 0calyer/month & 0calmonth (cal.year/month) & 0calday (calender day). Querry starting date based on 0calmnonth variable. Advise me customer exit program for count of days in current month.
Regards,
Mohit
Hi,
Just give a try to this solution
You can use replacement path.For example1. creat a new formula variable
2. Tab General: Global Settings ->Processing by: choose "Replacementpath"
3. Field Reference Characteristic will appear, choose 0CALMONTh
4. Tab Replacement Path ReplacementRule -> Replace Variable
with InfoObject; Replace with Attrib. Value-> Field Attribute apears, choose "0NUMDAY Number of Days"
Hope it helps,
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I want to bring into your notic that 0numday and 0numwday are the attributes of 0calmonth so there might be a chance that these attributes are noit maintained in 0calmonth.
If possible make a new calmonth using refernce as 0calmonth and in that new calmonth maintain attributes 0numday and 0numwday.
You have to select the check box with master data in infoobject to add attributes.
Once done with all the steps then use this new calmonth in you bex query designer and that attribute value will be avaialable.
Hope it helps.
Regards,
AL
Edited by: AL1112 on May 25, 2011 1:22 PM
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.