Regular Mass uploads of Measuring Documents – Your Options
While I was giving a very detailed reply to a Discussion post sometime ago, the idea of posting this blog came to my mind.
The client, a process Industry has several thousands of measuring points on which measurements taken at certain frequencies.
The queries were
1. How can I schedule the Measurement taking?
2, What are the Standard Tools available for Mass upload of the Measuring Documents?
In my reply I have added point3 as under:
3. What are the User-friendlily tools available for uploading Mass Measuring Documents.
My reply was in these lines
1. You know about Entry Lists (IK31). Segregate your 1000s of measuring points as per their schedules (frequency of reading). Suppose you came out with 12 lists. Make 12 Entry Lists using IK31 with these 12 sets of Measuring points. Now make 12 Maintenance plans (Notifications) each having the frequencies as cycle periods. In the Plan title give the Entry list Number and Timing of Measurement also. if needed, like “Measurements with Entry list 243, at 10:00 AM“.
The purpose of Maint Plans is to remind you through a system Notification that you are supposed to take readings on the measuring points in the Entry List. Then you run IK34 and take readings for that list of measuring points.
2, If you insist on Standard method of recording mass measuring documents, I think i have already answered. The answer is the Entry List (picture)
3. Coming out of the box (i.e., the Entry List method)
We have 2 more custom models in use,
1. Module pool (Screen program) development, to upload the readings. (picture)
In the attached picture only a part of the screen is shown, It is a wide screen, having input fields for all types of Measuring points (About 120)
The Input Process here.:
Enter all readings in the respective input fields of the screen and click Save
2. BDC program using Excel template : This program also gives similar convenience as above, by filling the Excel sheet (picture) and then upload through a Tcode. (I need not elaborate that in this case we will be having 12 Excel templates with respective M/Pts filled and named after the 12 M/Pt Groups)
Also I want to mention that this BDC program is designed to take care of all tyoes of Measuring points i.e., Measuring points with Simple Readings, Counter Readings and Valuation Codes.
Bottom line from my side
The ultimate user-friendliness in this area of one-stroke uploading of mass measuring documents can not avoid the ABAP development.
… And I prefer BDC program to a Module pool program.
Often during discussions related to User-friendliness, some members refer to a recently added SAP product namely SAP Screen personas . Because I do not have it at my place, unable to comment on the suitability of the same for issues like this.
Jogeswara Rao K
Of course other solutions are available depending on your architecture and wilingness to introducing new components , products ...
You have the SAP GWPAM suite which includes an EXCEL addin (relying on SAP NW Gateway and odata services).
You have also the 3rd party product WINSHUTTLE (may require less code development).
Both of them could enable an enhanced user experience.
Thank you Patrick for throwing some light in angles other than conventional.
If you have any doc. on this . Please share on SCN 🙂
Like to see how new things works
I should become a SAP marketing guy 😉
SAP (as usual ?) has changed the product name ......called now Gateway for Microsoft.
A recent SDN article with some videos given as examples.
SAP Gateway for Microsoft: Business use cases offline speed demo
Good article..thanks for shareing 🙂
Thank you very much Arjun !
Jogeswara Rao K
Thanks for the article. There might be one more way to plan and schedule measurements which is assigning measurement points as PRT to the order operation.
Thanks for the comments. Even Scheduled Notifications can have Measuring Documents. This article discusses about the 100s of Readings recorded manually daily (in some cases hourly) independent of Orders or Notifications.
Jogeswara Rao K
Many consultant forget one additional Standard feature for collective measurement document creation.
Order's Operation Confirmation screen
Here we have option of creating collective measuring document creation.
You are right as per the application ! 🙂
Hello Jogeswara Rao K.
Once more a very helpful document, thanks again for sharing.
By the way, exploring the same theme, there is one question:
In this project, create measurement documents are created trhu a notification for an equipment (IW21) and them "Extras -> MeasDocuments -> All Measuring Points on Object". Thus, we fill every reading.
In parallel there is an operation of massive upload using a file, and I will ABAP this. Thus, here is my question: Is there any function module/bapi to create measurement document in the same way? I mean, create measurement documents associated to a notification.
Using FM MEASUREM_DOCUM_RFC_SINGLE_001, it is possible to create a notification for every measurement document, but the real need is to pick a batch of readings, create measurement documents associated to one single notification, as standard system does.
Please, let me know if I coudn't make myself clear and thaks in advance for any help.
Carlos Eduardo Araujo
Thanks Jogeswara Rao Kavala
I did exactly the three points above before ask for help, with no success. I will try to find another way.
Thanks a lot for you time and effort.
Carlos Eduardo Araujo.
Hi Jogeswara Rao,
I have requirement to display the measurement reading entry list from the database.
I have already custom field in the IW22 as a Measurement list number based on the custom enhancement(QQMA0021) i have added the field in the screen.So now in IW22 while clicking the Menubar->Extras->MeasDocuments from the screen field value pass as input to pass the FM MEASUREM_ENTRYLIST_READ_DB and to the measurement entry list but here where i have to do the enhancement and what i have to do the from this note 377323 - Measurement reading entry list and maintenance plan.
Could you please explain the right enhancement and the ways to implement this note.
I am sure you'll agree that this is not the right place to discuss such deviated subjects here. You should post a query especially in ABAP space.