Communications on this forum are not intended to be a substitute for basic training, but are designed for sharing of information about specific SAP APO software related problems. If you have a question about such a problem, we would be more inclined to respond.
APO PP/DS is used for planning, and not much else. Are you suggesting that you intend to connect some type of non-SAP ERP legacy system directly to APO, and have APO do the planning?
The normal model for APO is to be connected to SAP ERP. If you intend to use the normal model, you do not need a spreadsheet, SAP supplies all the tools to transparently replicate master data, and keep it in synch between ERP and APO..
If, however, you intend to create your own interface directly to some legacy system, and you have never tried this before, good luck to you!
You will need
Plant info
Material Master info
Work Center info
Production version info, which consists of BOMs and Routings
at a minimum.
Before you spend much effort on this project, I suggest that you perform basic research about APO, and upon the effort that it will take to make a direct connection to a legacy system. I think that once you have done this, you will reconsider this decision, or at least consider engaging a consulting company that has done this before.
The actual data items that will be required are dependent upon the business scenarios that you implement, and not solely upon the APO modules. You must first have your expected business processes settled, and at least the high-level concepts for the delivered solutions should have been created.
I believe that you are premature in asking for Master data info. In most APO PP/DS or SNP implementations, you do not even have to concern yourself with this matter. The Master data fields that will be required in APO will be sent automatically from ERP to APO. The SAP Core Interface determines which fields from which databases within ERP are necessary in APO. They will be replicated from existing data in the ERP. Do you have an existing ERP?
If you are, in addition, implementing a NEW ERP system at the same time that you implement a NEW APO system, then that is an entirely different topic. There are a huge number of Master Data Fields in the ERP system that must be populated, and most of them are not relevant to APO (again, APO PP/DS is only for planning). New ERP is typically a major project in and of itself. Generally, if you have created all the master data required for ERP production planning, there will be next to nothing else that must also be done in APO. The master
For you to make your NEW implementation of APO PP/DS also work in conjunction with your NEW implementation of the ERP, at a minimum you will need to populate (in ERP) the MRP1/2/3/4 and Work scheduling tabs of the ERP Material Master, you will need to create ERP Plants, ERP Work Centers, ERP Routings, ERP Bills of Materials, and ERP Production Versions. These data will thereafter be replicated AUTOMATICALLY in APO. You only need to connect the two systems, and then create and activate the Integration models.
Below is SAP best practices on Connectivity and data replication. Please read these thoroughly to get an idea of what happens during the setup of a new APO system that is connected to an ERP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.