My client is using mixed costing. There are thousands of materials which need change in Procurement alternative for mixed costing (CK91N) and also in Create / change mix ratios (CK94). This exercise may be required quarterly.
Limitation of above transaction codes are that it does not have functionality to perform mass update to the materials, update can be done one materials/plant at a time. Due to the high volumes of materials, it is time consuming activity to run CK91N and CK94 for each of the materials. Now, client would like to have functionality where they can change these values in mass materials before recalculating MR21 and IR prices for the yearly and quarterly update processes.
Is there any other transaction code which allows mass update to procurement alternative and mixing ratios?? Has any one worked on this requirement? Is there any FM or BADi that can be used?
If there is no T-code available than I believe mass upload program could be the way out.
Kindly guide and share your opinion..