cancel
Showing results for 
Search instead for 
Did you mean: 

Creation of Q-Info record from data in exel sheet published in cfolder

Former Member
0 Kudos

Hi

Can any body help to give solution to create Q-Info Record from the data published in exel sheet under collaboration folder.

This we require for triggering the event for creation of Q-Info from the data available in cfolder in exel sheet which will be furnished by the user who can access organisation's network i.e. R3 network.

Thanks

YPB

Accepted Solutions (0)

Answers (1)

Answers (1)

anand_rao3
Active Contributor
0 Kudos

Hello YPB,

It seems that you want to create QM info records, data of which is being maintained in central excel file in the form of templates just like LSMW or BDC.

This file is stored centrally and you require that whenever any record is updated in this excel system should immediately create QM info record.

You can try QI06 transaction where in mass you can execute several QM info records instead of going for above development.

Best regards,

Anand Rao

Former Member
0 Kudos

Hello Rao,

My objective is to create/change Q-Info Record through event trigger mechanish from the input data submitted by the vendor in excel sheet input format in cfolder.Details of steps are as follows:-

1. Input data from the organisation like PO No. Item no, Material Code and all probable vendor code with details of vendor like address, city will be published in the cfolder in excel sheet. This sheet will be availble to vendor as Input data.\

2. Input data will be updated by the vendor in following manner

A- Material code of PO, Vendor code(Manufacturer code), Drawing No agreed between Organisation and vendor.

3. System will pick up the data updated in excel sheet and will trigger the event for creation of Q-Info which will check first existence of the Record, if exists then system will change the record.

How can I do this? Can any body help me.

YPB

anand_rao3
Active Contributor
0 Kudos

Hi Bahuguna,

To the best of my knowledge this is not feasible.

You have manually check the excel file whether any record is updated or not and accordingly create / change QM info record manually.

But PO, vendor address, city are not the constituents of QM info records.

Anand Rao