Skip to Content
avatar image
Former Member

copy data from pne planning area to another

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 01, 2010 at 12:57 PM

    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. D: 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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Sep 01, 2010 at 11:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Sep 01, 2010 at 12:57 PM

    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. D: 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

    Add comment
    10|10000 characters needed characters exceeded