Resuits recording Directly to MIC with out Insp.lot

[Former Member]

Dear Experts,

My client Getting results from DCS system Day wise, they will take those results in Excel sheet. now they want to upload those Excel sheet results directly to the MIC with out generating any inspection lot or sampling points. later they want to generate  monthly report and daily report from these uploaded results .

Is it possible to upload results directly to the MIC with out creating any inspection lots?

[Former Member]

Result recording in MIC is possible only with inspection lot. If you do not want to use inspection lot process, you can try using Quality notification. You can create catalog codes to mimic MIC and enter results in the catalog code of quality notification.

[Former Member]

Dear A Marwadi,

here results coming from DCS system those results are capturing in Excel sheet. As you said above is it possible to upload results through excel to catalog code of quality notification i think it woundn't possible. if possible let me know how

thanks & regards \

sudheer

[anand_rao3]

Hi Sudheer,

I think Sujit and FF have good suggestions. If you have excel file ready with you, I suggest to develop a custom program for result recording. You may go either for BAPI or BDC for doing so. Give the same excel file as input to this program which subsequently will upload all results. Field mapping would be the governing factor here. But creation of  inspection lot is must!

Regards, Anand Rao

[former_member553099]

hi,

kindly let me know What is the BAPI to be used suggest steps at earliest....

[Former Member]

If not Inspection lot then where would you enter the results in SAP ? Other option lets is directly in data base.....But its not advisable....Rather should not be done.

What I can advise is to create Manual  Inspection lot of inspection type 89.Upload the results using idoc from excel to Inspection lot. This is much better way.

This can also help you to do analysis easily using the std sap-qm reports.

[Former Member]

Dear Sujit

here my client did nt want any inspection lot just they want to enter results for every day to only One MIC. Is it Possible?

[former_member42743]

No.  I had a similar request for a client.  Just to be clear, you cannot record any result against any MIC unless you have an inspection lot.  And you can't create an inspection lot unless you have a material.

We created a dummy material and an inspection plan using inspection points.  In our case we created a new inspection lot every day.  But you could just create one every week or month, or however you want.  You create a new inspection point for each time stamp you need to record data for.  The inspection point identifier would basically just be the date and time.

FF