Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Clear Script

Hi,

We need a clear process via a script (package) on the data. The user has to select the time periods at the beginning of the package. We created a clear process that is working on all time periods that have been selected. The problem is that the clear process should start on the second period and not on the first one.

Example:

Data before clear process:

Jan 2015     Feb 2015     Mar 2015     Apr 2015     May 2015     Jun 2015

125             255             70               56               55               85

User processes Package with time selection: Feb 2015 to May 2015.

The current result of our clear package is

Jan 2015     Feb 2015     Mar 2015     Apr 2015     May 2015     Jun 2015

125             0                 0                0                 0                  85

But as I described the clear process should start with +1 for the time window selected. So the result should be:

Jan 2015     Feb 2015     Mar 2015     Apr 2015     May 2015     Jun 2015

125             255                 0                0                 0                  85

Does anybody know how to solve this? Thanks in advance.

Regards

Derk

Former Member
replied

Then the question is answered:

*SELECT(%MNTHS%,[ID],TIME,[TIMEID]>=%SMNTHTID% AND [TIMEID]<%EMNTHTID%)

Hope you have properly maintained TIMEID for base members!

P.S. And if you are asking question about some script it's better to show the script you have tested....

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question