Upload stability studies history

[Former Member]

Hi Gurus,

Does any body have an idea how can we upload the history of stability studies.

What I mean is: I'm implementing QM now, at my customer there is currently opened stability studies.

Is there a way to upload the results of this studies to the system and continue the study through SAP ?

Regards,

MaX

[former_member42743 · Accepted solution]

Max,

I don't think you'll be able to upload the history. You can continue the study by creating a stability study for it. You can even modify your inspection lots start and end dates. But I beleive the problem is loading actual results. The resutls will all show as being on the same day and I think that is where you will have the problem. There is no way to back date the results.

I think you'll need to talk directly to SAP about this. My guess is that no one, at least here on the forum, has actually tried this and done it for say a 3 year study that is 2/3 complete.

FF

[Former Member · Accepted solution]

Well Fire that's the same what I guess.

But tell me, is it possible to upload the study and results (forget about the dates) using LSMW?

Regards,

MaX

[former_member42743 · Accepted solution]

I'm out on limb here.... you can load almost anything via LSMW if you can break it down into small enough, logical chunks. But that can be difficult for some objects. Your probably better off with a program and BDC session for something like this. I don't think it would be easy and off the top of my head, if I had to give a project manager an estimate on development effort, (low, moderate, large) I would initially place it in the Large category. If it turns out to be moderate, the PM is happy.

Depending on how many studies you need to load, I might consider what I call a script approach. Develop a very detailed script, for loading the studies. Hire 10-12 temporary keyboarding specialists from your local temp agency and bring them into a training room. Train them on the script Monday morning. You spoon feed them the data which you already have organized in spreadsheets for them to load. They load it throughout the week. I should think each keyboarder could do at least 10-15 a day for about 150-200 studies in a week. What is the volume you are looking at?

QA can verify the procedures and run reports and table dumps in the system to check and verify the work. If you want, use a second week and have the keyboarders review the loaded work. Of course making sure they don't review ones they loaded.

A good keyboarder via an agency would probably run about 25.00/hr. About 1000 per keyboarder per wk. 12 keyboarders = 12,000/wk. .

If you don't want to use outside people, offer OT to your inhouse administrative assistants. Recurit about 20-30 and spread out the work over 2-3 weeks, train them, and have them each do 2-4 hrs in the evening in the training room. My guess is you'll have plenty of takers in todays economy. Not only that, but you'll have an in-house data entry Ninja team ready to handle similar future type of loads.

You'd probably spend more in development costs, testing, review, fixing and video conferences to India then you would for this.

Of course, if your working with a partner they'll fight this approach cause they won't make anything from it since there won't be any development costs.

But if this is a one time load process, you won't need the program once your done. It's a throw away load program. You'll probably never use it again. A oordinated manual load might be best.

FF

[Former Member · Accepted solution]

Dear Fire,

Thanks a lot for this clarification, but I need to clarify a point, hiring people is not possible, because in my company the consultant responsible for a module is responsible for every thing regarding it.

And in each module in a project there is only one consultant, and sometimes we ask for the ABAPers help in case of print outs or some freaky codes, otherwise all done by the functional consultant.

So practical wise your solution will not be applicable with my case.

Actually I found a way for uploading the studies (study & results) which are 5000 and I want to share with you.

First: I'll need to upload all the studies (till the point of calling the inspection lot), and here is the problem because I can't find a way up till this moment to upload them.

Second: I'll change the server calender to a date earlier than the earliest study, so as to be possible to call the inspection lots from trx IP30, I'll change the date because as you know trx IP30 call lots starting from the current date.

Third: I'll upload the results, and I can do this by recording, and same for the UD.

This is my idea, if you have any better ideas or comments please share with me, and if you know any idea for uploading the study itself other than hiring people please tell me.

Thanks a lot Fire and sorry for bothering you all the time.

Regards,

MaX

[former_member42743 · Accepted solution]

Not a problem. I understand.

I wish I could be of more help to you. But I think you'll find only a handful of QM people that have actually worked with stability in a real life situation.

I understand the project limitations. Every client and project is different.

I'm confident you'll figure a way to load the studies!

FF

[Former Member · Accepted solution]

Thanks a lot Fire, I'll update you if I got any solution

[Former Member · Accepted solution]

Dear,

What i understood form your detail is, you need history of results as your stability progress ,like your study is for year then you need results of 1st month , 2 nd month etc..... if i am correct and you are using QS notification then result histry will come automatically as your study progress as per schedule and strategy defined and it is std. setting. pl run one complete cycle in

devlopment and let us know.

Cheers.....

[Former Member · Accepted solution]

No...what I need exactly is:

There is a customer starting to implement SAP, and they are having currently about 5000 active studies.

These studies need to be uploaded to the system, other wise they will managed off the system.

My query is, how can I upload this studies to SAP, I reached a way to upload the results, but there is not a way yet to upload the study itself except manually which is rejected till this moment, so I need an automated way to upload the studies itself.

Regards,

MaX

[Former Member · Accepted solution]

?

[Former Member · Accepted solution]

Any ideas?

[Former Member · Accepted solution]

Hi Guys,

Here is the solution for the problem, I want to share with you.

Well, we have 2 phases, 1st uploading the notifications of the studies it self, and this is the hardest part, secondly, uploading the results which is easy.

For uploading the notification:

- The way I found for uploading notifications, is by recording...but here there is a problem, the clicks we make in the action box are not recorded....so we have to make a small adjustment for this....in the screen of the notification go to:

Extras -> Settings -> CTRL/Default Values -> Tab of Action Box -> Mark Action box: Table

Exit and enter again....the way the action box displayed is changed, in the way, our clicks are recorded.

- As you see now we can scroll down in the new action box, and this is the 2nd problem, scrolling down is not recorded...the solution is, you will re adjust the action box to display the actions you need in your recording, the action box as you can see now is displaying 3 actions, then you scroll down to get the rest....therefore you will need to re customize the notification in order to display the actions you need in your recording.

- You will have about 9 recordings, because each action makes a recording....and you will re customize the action box 3 times....my advice is to make a new notification type and not to play in the standard.

- This is the technique for recording the notification.

- Some hints: make all the dates (sample receiving, release, storage, and start dates) in the past....the dates when you started the study....let's say 01.01.2005

- Make sure from the EWB that the validity of the inspection plans to be used and the packages assigned are before this start dates

- After that you will have to upload you results, and this is made using recording...which is very easy.

Hope this useful.

Regards,

MaX

[former_member42743 · Accepted solution]

Great summary Max. Thanks for the update. This will go in my "good to know" folder. The techinique you used for the action boxes could also be applied for loading other types of historical data that might be required. For instance CAPA notifications that are in process.

It is by the nature of it, a very tedious and time-consumig process. I'm sure with number of studies you had to load, you had a lot of long days!

Congrats!

FF

[former_member662213]

Hi Max,

the stability study is performed via notification concept in SAP.

Thus, to upload the notification, you can use the BAPI of notification creation to upload the stability study.

Thanks

SUMIT

[Former Member]

Hi Sumit,

I know what you are saying, but this will only create the study, what about the results history ?

As you know in the action box, there is one link to display the history of results recorded with respect to storage condition and time.

How can I upload this?

Regards,

MaX

[former_member662213]

Hi Max,

The results history is the result recording and inspection lot decision of inspection lot ,i.e. assigned with the notification.

For that, you need to create inspection lot, and that can be done via some other batch upload tools.

This would be multuple step upload in SAP

1. Create notification first

2. Change Notification, i.e., creation of lot

3. Results Recording & Usage Decision

Thanks

SUMIT

[Former Member]

Hi Sumit,

Did you try this before?

You know exactly how can we do this or not?

Regards,