SAP COOIS report is one of the most important report which is used in the production and planning module in SAP. SAP COOIS report can be used as single data source to view all the production related information. As its name suggest, the report can be accessed via the transaction COOIS.
Production and planning (PP) is a key module in SAP which handles all the manufacturing related activities. SAP manufacturing supports different manufacturing methods such as discrete manufacturing, process manufacturing and repetitive manufacturing.
At the end of a production process, it is important to have comprehensive reports to get the production and planning related information. This is important because, data in the reports are important to take decisions regarding the manufacturing process. Based on this information, manufacturing organization can take key decisions to make their production processes more efficient.
Structure of SAP COOIS Report
We can use the COOIS report to view details about production elements. There are two main production related element. These are the planned orders and production orders. Planned order is the preliminary state of the production order. At the planned order level, production is not yet confirmed thus plan orders can be changed if required. Once the plan order is completed, it is then converted to production order. Once a production order is created, it indicates that the production process can be initiated.
We can use SAP COOIS report to view details about the planned orders and production orders. There are lots of information which we can get in day-to-day basis on these elements. To make this information user friendly and easily understood, COOIS report is segregated into “Lists”.
Each of these lists display key information related to production orders and plan orders. Some of the useful lists in COOIS are,
- Order headers
- Automatic goods movements
- Documented goods movements
There are several other lists available which can be used. Next, we will look at the different information available in each of the above-mentioned lists.
As the name suggests, “order header” list can be used to view the header level information about the plan orders or the production orders. Header level information includes the production/plan order number, the material of the order, order quantity, confirmed quantity, delivered quantity etc. The list is useful to get a summarized view of the orders. Since COOIS is a ALV report, we can easily extract this information to an excel document for further analysis.
We create production orders for materials which must be manufactured. When manufacturing a material, we need additional materials. We call these as components. Components can be raw materials, semi-finished good or finished goods. If we want to view the components of a production order, we can use the component view. In this view we can see the information such as component material, requirement date, required quantity, withdrawn quantity, etc.
Automatic Goods Movements
When the production process in complete, we confirm the production orders. When the confirmation is done, we issue the components of the production order. Issuances of components against a production order reduces the inventory in the system for those components. Also, it creates finance entries since material consumption occurs. These issuances can be done automatically if the master data is setup in a way to facilitate it. If there are such automatic goods issuances happen against a production order, we can use the automatic goods movement list to view those. Like goods issuances there can be other automatic goods movements triggered during production order confirmation. All those can be viewed from this list.
Documented Goods Movements
Other than the automatic goods movements, there can be goods movements which are done during confirmation of an order. E.g. – receipt of by-products. Such goods movements can be viewed from the documented goods movements list. It will display the automatic goods movements also.
This is a key view in SAP COOIS report. Production orders can consist with one or more operations based on the complexity of the product that is being manufactured. These operations are called a routing operation. Routing is a sequence of operations which are performed during the manufacturing process. From the operations list, we can view the multiple operations, work centers, operation quantities, the confirmed quantities etc. This is important when calculating the daily outputs for each operation.
This list can be used to view the confirmations done against the production order. Confirmation details can be found in detail in this view.
Customizing a List
All the lists that we discussed up to now are pre-configured lists in SAP. If we want to view several of the above lists in a single screen, that is possible with a simple configuration. E.g., let’s assume that we want to view the order header information and documented goods movement in a single screen.
To achieve the above requirement, follow the below SPRO menu path.
SPRO -> Production -> Shop Floor Control -> Information System -> Define Profiles for ALV-Layout-Based Object Overview
Next click on “New Entries” to create and save an overall profile which contains the order header and the documented goods movements. Give the item numbers based on the sequence in which the lists should be displayed in the screen.
Once this is done, the configuration part is complete. Now in COOIS transaction, select the “Object Overview” list. In the profiles, we can find the profile which we configured. Select the profile and enter the selection parameters for the report. Once we execute SAP COOIS report, we can view the order headers and the documented goods movements list in the single screen. This is useful in a situation where a detail analysis is required for the order. Similarly, we can create multiple profiles in configuration by combining different lists and use them as and when required.
SAP COOIS report is used in discrete manufacturing. For Process Manufacturing, COOISPI report can be used to view the production related information. Structure of the COOISPI report is like of the COOIS report. This completes the brief introduction about the SAP COOIS report and its functionalities.
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully, it’s something we can address for you in the improvement of our free SAP PP tutorials.
Next lesson: SAP Number Ranges
Previous lesson: SAP MRP Reports
Overview of the course: SAP PP Training