42Q-MES0167 SAP Adapter

42Q Home > Tools > 42Q SAP Adapter > SAP Adapter

    

 

 

Tools SAP Adapter   Version MES15.75 Revision E1

 

   

Introduction

The SAP Adapter is a middleware software that has been developed for customers to seamlessly integrate their SAP systems with 42Q. This adapter can be installed in the customer’s SAP system in order to allow SAP users to monitor and iterate with 42Q.

The below diagram explains the capabilities provided by these SAP Adapters:

 

Figure 1: SAP Diagram

 

The SAP adapter requires an initial setup for new customers.  

1. In the command field, enter the following command: /A42Q/CONSTANT (or ZQWO_CONSTANT, ZWO_CONSTANT), and then press Enter.

 

Figure 2: Command Field

 

 

2. On the new window, set up the Org. Id (Organization code) and the Customer (Customer code).

Figure 3: Initial Set Up

 

3. Now it’s time to set up the BOM’s information, enter the next command: CS02, and then press Enter.
4. Click on the Header icon: 
5. Click on the SAP-42Q Interface tab.

Figure 4: 42Q Interface

 

6. In the SFDC System field, click on the icon: , select the value MES and then click on the icon: 
7. In the Interface Type field, click on the icon: , select one of the following values:

• DEFAULT: Use this value if you want to send WO Header, WO Route, Flex field, or ATO Details (if applicable) to 42Q.
• SYS-BUILD: Use this value if you want to send WO Header, WO Route, or BOM to 42Q.

8. Click on the icon: 

Note: In the previous step 2, users set up the Organization code and Customer code, the purpose of these fields is to determine how the adapter will perform for each plant.

 

 

Create a Work Order

 

1. Enter the next command: CO01, and then press Enter.
2. In the Material field, enter a Part Number.
3. Enter the Production Plant.
4. Enter the Planning Plant.
5. Enter the Order Type.
6. Press Enter.

 

Figure 5: Production Order Create

   

7. Set the Total Qty, Start Date, and End date.

 

 

Figure 6: Work Order Creation

 

8. Click on the icon:  to release the Work Order.
9. Click on the Save icon to save the Work Order. The work order will be sent to 42Q.

  Based on correct setups Work Order XML will include the following information:

• WO Header
• WO Production Version
• WO Routing and standard times for each operation (For sending standard time setup should be done correctly, see section nn for that)
• WO Component

 

 

 

Mapping an Operation

Mapping of operation happens on 42Q when we map the operation/routing received from SAP to the process/routing on 42Q. If users want to map a particular operation to a location in the 42Q site  

1. Enter the next command: CO01 and then press Enter.
2. Click on the Operation Overview icon: 
3. A new list of operations will be displayed, choose one operation and hover the mouse cursor over its corresponding Control Key field, when a hover icon appears next to this field, click on it.

 

 

Figure 7: Component Overview

 

4. A new pop-up window will appear, then in the last field in the lower right corner select the Milestone confirmation (not PS/PM) option.
5. Click on the icon:  to save changes.

 

 

Figure 8: Control Key Selection

     

6. Click on the icon:  to go back to the Production Order Create: Header.
7. Click on the Save icon: , then select Yes to save it, or select No or Cancel to abort.
8. A pop-up window will be displayed to show you the information of the recently mapped operation, finally, click on the icon:  to close the window.

   

 

Monitor SAP updates

If the users want to see all transactions between SAP and 42Q, such as Acknowledgement, WIP-Move, MAT-Move, Shipment, and MAP-Issue, follow the next steps:  

1. Enter the next command: /A42Q/PROCESS (or ZQWO_PROCESS, ZWO_PROCESS), and then press Enter.
2. Users can see in the Message column if the information was received successfully by 42Q.

 

 

Figure 9: Work Order Transactions

 

Update / Change

Users can view updates or changes made to a Work Order (e. g. changes in quantity) by following the next steps:  

1. Click on the Update/Change button.
2. In the new window that will appear, users can see the data that was updated as well as a confirmation message, notifying that 42Q received the update successfully.

 

Figure 10: Work Order Updates-Changes

 

WIP-Move

Users can view Work Order WIP-Moves by following the next steps:  

1. Select a row.
2. Click on the WIP-Move button.

 

Figure 11: View WIP-Moves

 

 

3. A new window will appear, users can see all WIP-Moves belonging to that specific Work Order, as well as all detailed information. To see the Production Order information from a specific WIP-Move, click on the Work Order number.

Figure 12: Work Order WIP-Moves

 

4. To see the WIP-Moves transactions, click on the SAP-42Q Interface tab.
5. To see the overview of each operation, click on the Operation Overview button.

Figure 13: WIP-Moves Transactions

 

Figure 14: WIP-Moves Operation Overview

   

6. Users can also view each individual WIP-Move, as well as their details. In this view, it is easier to identify in what WIP-Move an error occurred by looking at the Message column. To see this view, click on the Display button.

 

 

Figure 15: Display WIP-Moves Process Details

 

Figure 16: WIP-Moves Process Details

 

Note: If there is one milestone operation in the Routing, then WIP Move confirmations only happen when a WIP Move is received for the milestone operation, all the non-milestone operations will be confirmed with that WIP Move. If there are no milestone operations in the routing, then confirmations happen when the WIP moves of respective operations are received.

 

 

 

MAT-Move

To get a material issue from 42Q the component/ BOM item should be set as PUSH type in SAP. If it is PULL type material standard backflush will happen for that BOM item

An assembly definition should be created for that component on 42Q. 42Q sends WIP moves when the assembly is either Standard, Unique, Custom, Consume from NSB or Non Tracked with Quantity.

 

Users can view Work Order MAT-Moves (Material Movements) by following the next steps:

1. Select a row.
2. Click on the MAT-Move button.

Figure 17: View MAT-Moves

 

Figure 18: Work Order MAT-Moves

 

3. A new window will appear, users can see all MAT-Moves belonging to that specific Work Order, as well as all detailed information.

 

 

MAT-Issue

Users can view Work Order MAT-Issues (Material Issues) by following the next steps:

1. Select a row.
2. Click on the MAT-Issue button.

Figure 19: View MAT-Issues

 

 

Figure 20: Work Order MAT-Issues

   

4. A new window will appear, users can see all MAT-Issues belonging to that specific Work Order, as well as all detailed information.

Note: When you receive a Work Order from SAP (or ERP) to 42Q, this Work Order Status will be set as N (Not released) in the 42Q system, if you want to release it, you must do it using 42Q.   Figure 21: Work Order Received by 42Q.

  Figure 21: Work Order Received by 42Q        

 

Update Work Order

SAP Adapter allows users to send work order changes to 42Q in the form of Work Order Update Transaction.

Following are the common WO updates from the ERP sent to 42Q:  

1. Work Order Header

• Status change:
  • Unreleased to Released  --  Send the entire work order details to 42Q
  • On Hold
  • Closed
  • Canceled -  Online call directly to 42Q to allow or not allow this change
  • Complete - No Charges -Online call directly to 42Q to allow or not allow this change

 

• Scheduled Start Date change
• Scheduled Completion Date
• Start Quantity
  • Increase
  • Decrease - Online call directly to 42Q to allow or not allow this change

 

2. Work Order Routing/ Production Version/ Component Change 

 

Note: The routing and component change will only happen if the work order is in status ‘N’ on 42Q. In order to update a Work Order, users must follow the next steps:  

 

1. Enter the next command in SAP: CO02.
2. Enter the Work Order number in the field Order.
3. Click on the icon: 
4. Once the new window is open, modify the data you want to change.
5. Click on the Save icon: 
6. Select Yes to save it, or select No or Cancel to abort.
7. Finally, a pop-up window will appear which shows the information changed, to close the window click on the green icon.

 

 

 

Checking Transaction Errors

 

1. Enter the next command in SAP: SE11.
2. In the field of the Database table, enter /A42Q/* (or ZQWO_*, ZWO_*), and click on the icon:  to display all types of transactions.
3. A pop-up window will appear, select one value from the Table Name column, and click on the accept button.

 

 

Figure 22: Table Name Values

 

4. Click on the Display button.

Figure 23: Display Transaction Errors

 

5. To search for specific information, click on the Contents button.

 

 

Figure 24: View Contents

SA View Contents.png

 

6. Enter the information you want to look for. The next image will look for rejected WIP-Moves.
7. Click the Execute button.

 

 

Figure 25: Search for Rejected WIP-Moves

SA Search for Rejected WIP-Moves.png

 

 

Figure 26: Rejected WIP-Moves Found

SA Rejected WIP-Moves Found.png

 

 

Send Ship Notification From SAP to 42Q

 

 

Create a Sales Order

1. Enter the next command in SAP: VA01.
2. In the field Order Type, enter the value ZSOR and click on the icon: 

 

 

Figure 27: Create Sales Order Initial Screen

 

 

3. Enter the corresponding information for Sold-To Party, PO Number, Material, Order Quantity.

 

Figure 28: Filling out Sales Order Data

 

 

4. Click on the Save icon. In the lower-left corner, users will see the Standard Order Number generated.

Figure 29: Standard Order Number Generated

 

5. After creating a Sales Order, the next step is to create an Outbound Delivery.

   

Create an Outbound Delivery

1. Enter the next command in SAP: VL01N.
2. Enter the Shipping point value 1000 (Sanmina Shipping Point) and Order number, then press Enter.

Figure 30: Create Outbound Delivery Initial Screen

 

 

3. Since we already had a Sales Order created, SAP will take the corresponding data automatically. Click on the Picking tab.
4. In the SLocation field, enter the value S001 (Finished goods).
5. Click on the Save icon.
6. Select Yes to save it, or select No or Cancel to abort.

 

 

Figure 31: Filling out Outbound Delivery Data

 

   

7. After creating an Outbound Delivery, the next step is to create a Transfer Order.

 

 

 

Create Transfer Order

1. On the menu bar, click on the Subsequent Functions option.
2. Select the option Create Transfer Order.

 

 

Figure 32: Create Transfer Order

 

3. A new window will be displayed, you will notice that in the lower-left corner will appear the Outbound Delivery number generated, make sure that number is entered in the Delivery field, then click on the icon: 

Figure 33: Outbound Delivery Number Generated

 

 

4. Click on the Generate TO Item button.
5. Click on the Save icon: 

Figure 34: Generate TO Item

 

6. In the lower-left corner you will see the Transfer Order number generated. Copy the value from the field Delivery.

Figure 35: Transfer Order Number Generated

 

7. Enter the next command in SAP: VL02N.
8. A new window will be displayed. Click on the icon: 

Figure 36: Change Outbound Delivery Initial Screen

 

 

9. On the menu bar, click on the Extras option.
10. Select Serial Numbers.

 

 

Figure 37: Extras Options

 

11. Click on the button Create serial number automatically.

Figure 38: Maintain Serial Numbers

 

12. A new pop-up window will appear, check the boxes of the Order Numbers you want.
13. Click on the Copy icon: 
14. Then click on the Continue button: 
15. Select a specific row.
16. Click on the icon:  to execute.
17. Click on the Post Goods Issues button.

 

 

Figure 39: Outbound Delivery Change Overview

 

18. Users will notice in the lower-left corner that the Outbound Delivery number was generated.

Figure 40: Outbound Delivery Number Generated

 

19. The next step is to create a Shipment.

 

Create a Shipment

1. Enter the next command: VT01N and press Enter.
2. Click on the Deliveries button.
3. Once the new window is displayed, scroll down to the section W.ref.to, in the field Outbound Delivery, enter the Outbound Delivery number that was just created.
4. In the Delivery Status section, in case you don’t need the Total GDS mvt stat. or Trms.plan.status, simply delete their multiple values.
5. Click on the Execute button.

 

 

Figure 41: Selecting Outbound Deliveries

 

6. Users will notice the Number of Deliveries found.

Figure 42: Number of Deliveries Found

 

7. Select the shipment number that you just created.
8. Click on the button Overview of Current Shipment.

 

 

Figure 43: Selecting Shipment Number

 

 

9. In the lower right corner, you must select all the options (Planning, Check-in, Loading start, Shipmt. Completion, Shipment start, and Shipment end).

Figure 44: Selecting Shipment Steps

 

 

10. Click on the Save icon: 

 

 

 

Key Value Pairs

Key Value Pairs (Custom Attributes) allow users to send custom fields or native fields, which are not part of the standard adapter from ERP to 42Q.

Key value pairs can be sent from the following 4 ERP levels: 

1. Work Order (shop order): ‘WO_ATTRIBUTE’ tag in WO Create.
2. Work Order Assembly (shop order part number): ‘WO_PART_ATTRIBUTE’ tag in WO Create.
3. BOM Item (shop order BOM component part): ‘COMPONENT_PART_ATTRIBUTE’ tag in WO Create.
4. Work Order BOM Item (specific to work order): ‘WO_BOM_ATTRIBUTE’ XML tag in WO Create.

 

To send these custom attributes, users need to follow the next steps:

1. Enter the Lookup Name, which is composed of the suffix: ‘DYN_’ and then, add the Key Value Pairs Tag, e.g., ‘DYN_WO_ATTRIBUTE’.
2. Enter the Plant.
3. Enter the Sequence Number (Work ctr).
4. Enter the Attribute Name (Attribute Name sent to 42Q) .
5. Enter the Attribute Value (field name in SAP).

 

Figure 45: Lookup Table for WO Attributes and Cycle Time

 

 

Standard Cycle Time and Hands on Time

Note: Part of 42Q 15.66 updates.

 

 

Hands on Time Setup

To configure Hands on Time on SAP, users must follow the next steps:  

1. In the command field, enter the following command: /A42Q/LOOKUP (or ZQWO_LOOKUP, ZWO_LOOKUP), and then press Enter.
2. For hands on-time setup, enter the following details in the lookup table:

 

Lookup Name: HANDS_ON_TIME

Plant: Customer Plant name 

WorkCenter: Enter work center linked to the operation 

Attribute Name: Leave a blank value

Attribute Value: LABOUR or MACHINE or SETUP

 

3. Click the Save button.

 

42Q records cycle time (hands-on time) for each process. The cycle time recordings are sent to SAP with the WIP Move transaction. WorkCenter Attribute value decides if the hand-on time should be posted in machine, setup or labor activity hours.

 

Figure 46: Lookup Table

Users can verify the Hands-on Time and Cycle Time by navigating to: Reporting > MESWeb > Default Reports > Cycle Time Details Report, filling out the information users are looking for, and press the Go button.

 

Figure 47: Cycle Time Details Report

 

 

 

Check Hands on Time Values

To check the HANDS_ON_TIME values on SAP, users must follow the next steps:  

1. In the command field, enter the following command: CO03 and then press Enter.
2. Click on the Operation Overview button.

Figure 48: Production Order Display

 

 

3. Double-click on the operation sequence for which the hands-on time needs to be checked.

 

 

Figure 49: Selecting Operation Value

 

 

4. Click in the Folder Icon and select Qties/Activities from the list.

Figure 50: Displaying More Options

Figure 51: Qties-Activities Tab

 

Standard Cycle Time Setup

  To configure Standard Cycle Time on SAP, users must follow the next steps:  

1. In the command field, enter the following command: /A42Q/LOOKUP (or ZQWO_LOOKUP, ZWO_LOOKUP), and then press Enter.
2. Enter the correct Attribute Name (the parameter which stores the standard time on SAP) mapping to Attribute Value (this parameter determines where to store the mapped attribute on 42Q).

Figure 52: Attributes from Lookup Table

Note: For reference see the different attribute values that exist:

1. Item: Machine time
2. Lot: Setup time
3. Labor: Labor time

The standard time will be sent for all the operations, which will have an attribute name listed in the Lookup table and have a time value greater than zero.

 

Figure 53: Operation Value

 

To visualize the operation value (Operation Sequence Number), in the command field, enter the following command: /A42Q/PROCESS (or ZQWO_PROCESS, ZWO_PROCESS), and then, press Enter, select the Work Order and click the Display XML button.
 

 

Figure 54: Operation Value in Work Order Creation Code

Standard Cycle Time from Work Order

To send resource information such as setup time, machine time for operations from WO Level, users must select the ‘Ord lv Stf’ flag in /A42Q/CONSTANT (or ZQWO_CONSTANT, ZWO_CONSTANT) form.

 

 

Figure 55: Select ‘Ord lv Stf’ Flag

 

 

With this flag checked any resource changed or added at the time of work order creation will be sent to 42Q. If the flag is not sent the resource information is picked from route level and sent to 42Q. For standard cycle time, check the setups under: Standard Cycle Time Setup.

 

 

Date Code Setup

  To configure Data Code on SAP, users must follow the next steps:  

1. In the command field, enter the following command: /A42Q/LOOKUP (or ZQWO_LOOKUP, ZWO_LOOKUP), and then press Enter.
2. For the Data Code setup, enter the following details in the lookup table:

Lookup Name: WO_ATTRIBUTE

Plant: Enter a customer plant name 

WorkCenter: Leave a blank value

Attribute Name: DATE CODE FOR MOULDING

Attribute Value: LABOUR or MACHINE or SETUP

 

When 42Q records the DATE CODE FOR MOULDING attribute. The recorded value is sent to SAP.


Figure 56: Recorded Value Received by 42Q

 

 

Check Data Code

To check the Data Code on SAP, users must follow the next steps:  

1. In the command field, enter the following command: CO14 and then press Enter.
2. Enter the work order for which the date code information needs to be checked.

Figure 57: Entering Work Order

 

 

3. Select the Final Confirmation.
4. Click the Details button.

Note: The date code is available only at the final confirmation of the work order. 
 

 

Figure 58: Selecting Final Confirmation

     

5. Select the Personnel/Additional Data tab.
6. Users will see that the Date Code is available in the Confirmation text field.

 

Figure 59: Data Code

 

Perform GR

First of all, users must do two different types of configuration, Automatic GR Configuration and Enable Perform GR Flag:

 

 

Enable Perform GR Flag

This function allows users to use the adapter to do the delivery manually at a later stage:  

1. In the command field, enter the following command: /A42Q/CONSTANT (or ZQWO_CONSTANT, ZWO_CONSTANT) (constant table), and then press Enter.
2. Make sure the Perform GR option is enabled, users, will be able to go to the work order and see if the final operation control key is Automatic GR enabled or not, this way users will only do the confirmation if it is disabled users will do the confirmation and then do the GR.

 

 

Figure 60: Constant Table Window

Automatic GR Configuration

In order to do this configuration, users must follow the next steps:  

1. Enter the next command in SAP: CO02.
2. Enter the Work Order number in the field Order.
3. Click on the icon: 
4. Click on the Operation Overview icon: 
5. A new list of operations will be displayed, choose one operation and hover the mouse cursor over its corresponding Control Key field, when a hover icon appears next to this field, click on it.

 

 

Figure 61: Control Key Icon

 

6. Mark the Automatic Goods Receipt checkbox and click on the green Continue button.

 

 

Figure 62: Automatic Goods Receipt Option

 

Note: If the information or the final operation sequence are done, then the adapter will prevent users from marking the Automatic GR (Goods Receipt) option. On the other hand, if the Automatic GR is enabled the SAP system will take it forward but the adapter will not bate if the Automatic GR is successfully processed or not, if the Automatic GR fails, the delivered quantity will have an impact, so the delivered quantity will not be available and if it’s not available, users won’t be able to change the status to TECO  as inFigure 62.


Figure 63: Production Order Status

 

 

To access the Material Document, users must navigate from the menu option: Goto > Documented Goods Movements.

The material document will have a different range based on the adapter creator GR document and the system creator GR document. Users may notice that the Material Document Number will be ready, moreover to access the Material Document Window, users must click on the Material Document Number.

 

 

Figure 64: Documented Goods Movements Window

 

 

Users will be able to pass the serial number only if it was not configured with the Automatic GR option in Control Key.


Figure 65: Material Document Window

Scheduled Start and End Time Flag

This flag will allow the users to select between the two dates at the work order level.

If this flag is enabled at the constant table, the adapter will pick the dates from the Scheduled start date and end date column, but if it is disabled, users will pick the dates between the Basic start date and end date.

 

 

Figure 66: Scheduled Date Flag

 

Figure 67: WO Basic and Scheduled Date

   

 

 

TECO Flag

In the command field, enter the following command: /A42Q/PROCESS (or ZQWO_PROCESS, ZWO_PROCESS) (process table), press Enter, and enable the TECO flag as in Figure 67.

After the TECO flag is enabled at the process table, any updates to the work order will not be sent to 42Q.

If users want to make any change to the work order after marking the TECO flag option, users must remove this flag.

After users use the program /A42Q/RESET_WO_STATUS (or ZQWO_RESET_WO_STATUS, ZWO_RESET_WO_STATUS), the TECO flag will be removed and the user will be able to send the updates.   

 

 

Figure 68: Process Table Teco Flag

 

 

WIP Move Transaction Confirmation Change

Note: Part of 42Q 15.69 updates.

It is possible to WIP Move when a unit reaches a mapped operation as well as when a mapped operation is completed.

To enable the WIP Moves being sent when units leave a mapped operation go to: Administration > Generic Attribute Maintenance, set attribute: do_leave_move as: ‘true’, under the table wip_movement.

 

 

Figure 69: Activate ‘do_leave_move’ Attribute

 

 

For this logic, a new step type ‘Complete’ will be introduced. It will be used when a unit moves from a mapped operation to a non-mapped operation. Scenarios for ‘Complete’ step type:

1. In Queue to Complete - Confirm From sequence till To sequence.
2. Complete to Complete - Confirm (From sequence+1) till To sequence.
3. Reject to next station Complete - Cancel Rework and Confirm From sequence till To sequence.

 

Special Scenario: When a rework/scrap happens in the middle of a non mapped operation, users must send the reject/scrap to the next mapped operation. If 20 Mapped, 30 Non-Mapped, 50 Mapped and Reject or Scrap happens on op 30, 42Q should send 20 Complete to 50 Reject/Scrap, i.e., the reject/scrap happens at the next mapped operation. If there is no mapped operation the rework/scrap will be sent for the last operation 20 Complete to 50 Reject/Scrap.

 

Business Rule (If Milestones are used on SAP): Completion operation should always be a milestone/mapped on 42Q.

 

 

Common Issues on SAP

Figure 70: Common Issues on SAP