Hi Dogboy
I want to know what should be the standard process for Product allocation implementation w.r.t. any new product coming in.
I mean to say if my Allocations are up and running, but if the business decide to do product allocation for some other existing products, then what should be the approach to bring those products in. I understand that we need to follow the below steps ( correct me if I am wrong) :
1. Assign Allocation group in the Product master.
2. Create CVCs in the Planning area, //MC62
3. Copy CVCs to Allocation Group //ATPQ_PAREA_K
4. Create Collective Characteristics //ATPQ_COLLECT
5. Copy the resultant CVCs from the Allocation Group back into the Planning Area //ATPQ_PAREA_C
6.Transfer data to planning area //ATPQ_PAREA_W
7. Open book, maintain Allocation quantities //SDP94
8. Close book. Copy Values into Allocation Group //ATPQ_PAREA_R
Since all the above steps are technical for any end user to go and they cannot carry out these steps on their own.
Initially I had thought to create the CVC from Infocube and the load data into the infocube via a csv file, but that doesn't seem to be a viable option because of the technicalities and non reliability of loading data through a csv file.
Now I am thinking of creating an interface which will load the data directly into the planning area/book from an excel sheet. It will be similar to the data load for safety days of supply in SNP planning area/book. This data load through interface can replace step 7 above and we will not need any Infocube.
Now my question is how should i automate the process? through Program/ custom development/ batch jobs/process chains/ any other ? And what are your inputs for handling such a situation? How are these situations handled in other projects?
ARYANG