hero
Home About

Categories

Archive

May 2024

April 2024

March 2024

February 2024

January 2024

December 2023

November 2023

October 2023

September 2023

August 2023

July 2023

June 2023

May 2023

April 2023

March 2023

February 2023

January 2023

December 2022

back to home

Dismantle SAP Production - How to get the next work orders of a workplace by using COOIS transaction in Peakboard

02 January 2024 • 5 mins

In another article, we discussed how to get the capacity of a workplace. This article covers a common way to list or process the work orders of a workplace.

We will use the data from a transaction COOIS to get the work orders. Technically, we are executing the report behind the COOIS transaction. This report is called PPIO_ENTRY.

If you don’t know how to find the name of the report from the transaction name, just call the transaction and go to the menu system -> status and find the text field for program. That’s the report name. If you do this for a COOIS transaction, you will find PPIO_ENTRY.

To execute a report in Peakboard, you need to do a small installation on the SAP side to get it working. All the details are explained in this article.

Understanding COOIS

COOIS is the number one reporting transaction for getting an overview of all production data. There are options to select production data from different levels (header, material, operations, etc.).

The select options and the selection screen might vary by SAP release. This article uses the 2019 S4/HANA COOIS transaction, which might look different from your SAP system. That doesn’t matter, because the general principle explained in this article remains the same for all common SAP releases over the last few years.

Let’s assume we’re interested in the operations of a certain workplace. So we fill out the selection screen according to the given plant and workplace. We also limit the operations on “not confirmed” and “partly confirmed.”

The status values to chose here depends heavily on the customizations of the SAP production module. The values in the screenshot are only valid for this particular SAP system.

We must also take care of the layout. The layout determines which columns are selected. Under certain circumstances, it makes sense to create an individual layout only for use with Peakboard. All the columns we need later in the application should be covered.

image

image

Let’s try out the selection and check the result.

Side note: It might be necessary to apply additional filters on the result after the selection. If you want to do this, you must save these filters together with the layout. Then, you must apply the layout in the selection screen.

image

After having checked the result, we go back to the selection and save the selection as a variant. A good practice is to use the workplace in the selection as part of the name of the variant.

image

image

Call the report from Peakboard

In Peakboard Designer, we create another SAP data source and apply the following XQL, which executes the report PPIO_ENTRY with the just created variant PB_Z_ASM3.

EXECUTE REPORT 'PPIO_ENTRY' USING 'PB_Z_ASM3'

The following screenshot shows the data source together with the preview. This should match what we checked directly in the COOIS transaction earlier.

Note: The name of the report columns are language-dependent. So if we change the login language, it will change the column names and mess up all your metadata.

image

Final result

If we use a regular table and adjust the column width, format, and naming of the columns, we can easily create a cool table with the workplace’s operations. These screenshots show the table in design and at runtime.

image

image

Additional hints

Here are some more things to consider:

  1. If for whatever reason the COOIS transaction does not fulfill your needs, you can try to build and use a query instead.
  2. The pattern described in this article is fully language-dependent. This is also true for the system status values. For example, when you limit the operations to “Confirmed,” the English status is “CNF” while the German status is “RÜC.” So the selection value must be changed when the login language changes.
  3. Using reports for data selection gives you any date value in the format of the current language. The typical SAP date format YYYYMMDD can’t be used here. You need to convert it in Peakboard to your desired format.
  4. In our example, we have chosen the level of “Order Headers” for the selection. Depending on your use case, it might make more sense to choose “operations” or other levels.
Dismantle SAP Production - How to get the next work orders of a workplace by using COOIS transaction in Peakboard

Newsletter

Want to get notified when a new article is published? Sign up below!