copy data from pne planning area to another

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

thanks,

It is copying the data for more than 8 weeks. I need to copy the data only for 8 weeks.

Thanks,

Prabhat

[Former Member]

Thanks Amol,

I acknowledge your help.

[Former Member]

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

[Former Member]

Hi Datta,

thanks for your response.

What is the use of P_DATFR and P_DATTO ( 10th and 11th row in the screen ) ?

How to give the "To" range ?

Regards,

Prabhat

[Former Member]

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

[Former Member]

Hi Datta,

It is just changing the from date. I need to give the range for 8 weeks. from current week till 8th week.

I am not getting the desired result.

Prabhat

[Former Member]

It's not working.

We have to control the range in From and To field on the screen where we select the planning area and planning version.

so need to find the way to make the from and to field dynamic.

[Former Member]

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