on 09-01-2010 11:34 AM
Hi,
I have requirement to copy the data for 8 weeks to another planning area.
How to do it? If we use the TSCOPY then the from date and to date is fixed.Issue is with every week passes we will have another set of 8 weeks.
Thanks,
Prabhat
Dear Prabhat
As mentioned above you can define dates in the variants on dynamic basis.
Please go to u201CT-code /SAPAPO/TSCOPY - Copy/Version Managementu201D
Enter the respective source and Target planning area.
You can also select key figures for which you want to copy the data.
Header Go to Save as the variant
From row selection variable Put this as D i.e. 😧 Dynamic date calculation.
In the Name of variable column Put todays Day and +60 days (appx 8 weeks).
This will save the dynamic variant which will consider the rolling of buckets.
AMOL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
By your above logic it will change the From filed on the main screen and it will add no. of days to the from and then will proceed.
Where to give To field ?
We have to restrict the copy only for 8 weeks.if you give current date+60days then from will change and the copy function will copy the data from 60th days onwards not before that.
Thanks,.
Prabhat
Dear Prabhat
As mentioned above you can define dates in the variants on dynamic basis.
Please go to u201CT-code /SAPAPO/TSCOPY - Copy/Version Managementu201D
Enter the respective source and Target planning area.
You can also select key figures for which you want to copy the data.
Header Go to Save as the variant
From row selection variable Put this as D i.e. 😧 Dynamic date calculation.
In the Name of variable column Put todays Day and +60 days (appx 8 weeks).
This will save the dynamic variant which will consider the rolling of buckets.
AMOL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prabhat,
For having rolling dates every week, you can use variants with dynamic date calculations.
While saving variant, you need to go to Variant Attributes:
Then you need to go on the 6th row field of "FROM ", in the 10th column, need to select "D" , dunamic date calculation and column 12th the appropriate variable with addition of days etc,
The dates will get shift automatically.
Regards
Datta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use those fields to specify your 8 weeks range there.
In the From date mention the start of 8 weeks, and in the end date mention the end of the 8 weeks date.
Now, in your case since it keeps moving forward do the following.
Go to the attributes screen and do the following for P_DATFR and P_DATTO
1) Check the check box in column "Save Field without values" for P_DATFR and P_DATTO
2) Go to "selection variable" and select D for both P_DATFR and P_DATTO
3) Go to "Name of Variable" and choose from F4 'Current Date' for P_DATFR and 'Current Date +' and give 8 weeks in days (8*7 = 56) for P_DATTO.
Save the variant.
This should take care of your requirement.
Thanks
Mani
Hmmm.... It should work...
How are you checking if it is working or not???
Ensure that there should be no values in the screen where you enter the planning area and version. Then proceed to the attribute screen and carry out the setting I have suggested.
Save and move out and come back in, the values as per the formula will be populated. Pls note you should not save the value at this stage. If you save at this stage, it wont change dynamically.
If you are planning to run this in background, it will dynamically keep updating based on the formula.
Hope this helps.
Thanks
Mani
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.