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 - Build a Production Order Confirmation Terminal with no code

28 January 2024 • 5 mins

Peakboard is often used with SAP in production environments. One of the most common use cases is building interactive terminals for confirming operations of production orders.

An operation of a production order might require multiple confirmations. For example, a confirmation might be needed for starting the operation, submitting an update, and confirming the operation.

Usually, the operator (end users) uses a confirmation number to submit the confirmation. This number is often printed as a barcode on one of the papers that come with the instructions for fulfilling the operation.

The following GIF shows our finished interactive terminal. The user enters the confirmation number to get some details from SAP (in this case, the production order number and operation). Then, the user can submit the yield, scrap quantity, and machine time.

image

Of course, this is a sample use case. In the real world, the user might submit more sophisticated values, and the machine time would be detected automatically by the Peakboard application.

Get order details from SAP

Before we work on the SAP integration, let’s first take a look at the UI. It’s a text box that gets the confirmation number from the user, and a text box that prints the order number. The magic happens behind the button.

image

By submitting the confirmation number, we can use the function module BAPI_PRODORDCONF_GET_TT_PROP to get more information. So we create a SAP data source.

The following XQL fills the table TIMETICKETS and gets the return value in the same table from SAP. The actual number is injected into the XQL by using the variable placeholder. Make sure to pre-fill the variable during design time with a valid confirmation number, in order to hit the data load button and get some sample data.

EXECUTE FUNCTION 'BAPI_PRODORDCONF_GET_TT_PROP'
   TABLES
      TIMETICKETS = ((CONF_NO),
         ('#[ConfirmationNo]#'))
      INTO @RETVAL;

image

When the user clicks on Load Information, the user’s entry is written into the variable, and the data source is reloaded:

image

To write the data that is returned from the data source to the textbox output, we use some simple blocks in the refreshed script. (Pro tip: feel free to use data binding to get the data into the text boxes. That also works well.)

image

Submit the confirmation to SAP

To submit the user entry to SAP, we can use the same pattern as the previous part.

The XQL is slightly more complicated. We use the function module BAPI_PRODORDCONF_CREATE_TT. The actual data is submitted in the table TIMETICKET. In the XQL, we have to fill various columns. The fields CONF_NO, YIELD, and SCRAP are easy to understand.

For submitting a time value (machine time, in our case), this table offers dynamic values, depending on the operation. When we look at the operation in the SAP UI, we can see that the machine time is the second time attribute. That’s why we have to fill the ONF_ACTIVITY2 column. CONF_ACTI_UNIT2 is set to H for hour. CONF_TEXT is a random text with additional information.

image

Here’s the final XQL. Note that we need to add a call of a second function module called BAPI_TRANSACTION_COMMIT. If we don’t do this, SAP rolls back the command and doesn’t do anything.

The table DETAIL_RETURN contains the feedback message from SAP. We will use it later, so we define it as the output of the data source.

EXECUTE FUNCTION 'BAPI_PRODORDCONF_CREATE_TT'
   TABLES
      TIMETICKETS = ((CONF_NO, YIELD, SCRAP, CONF_ACTIVITY2, CONF_ACTI_UNIT2, CONF_TEXT),
         ('#[ConfirmationNo]#', '#[YieldQuantity]#', '#[ScrapQuantity]#', 
            '#[MachineTime]#', 'H', 'Submitted by Peakboard')),
      DETAIL_RETURN INTO @RETVAL;

EXECUTE FUNCTION 'BAPI_TRANSACTION_COMMIT'

The final data source looks like this:

image

On the canvas, we add some text boxes for user input, as well as a button for submitting the confirmation.

image

Behind the submit button, we cast the user input into numbers, put them into the global variables, and reload the data source that does the actual work.

image

Finally, here’s the refreshed script of the call. The output of the data source is used to forward the SAP message to the user. We use a regular pop up notification.

image

Conclusion

This example shows how easy it is to use the standard BAPIs of SAP to read and write production order confirmations. They are well suited for use with Peakboard.

Dismantle SAP Production - Build a Production Order Confirmation Terminal with no code

Newsletter

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