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. The work order will be sent to 42Q. The order will be available on 42Q under Shop Order Control with ‘ERP’ status as checked.

  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

When a unit is moved from one location to another in 42Q, a WIP move transaction is sent to SAP for the mapped locations, or status change.

1. Incremental wip moves (based on SAP operation mapping wit 42Q route)
2. Status change wip moves (rework status 25, 29 / scrap status 50, 55)
3. Completion wip move (unit status 30)

 

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

 

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

 

 

Figure 26: Rejected WIP-Moves Found

 

 

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 and Hands on Time

To configure Hands on Time and Labor Time on SAP, users must follow the steps below:

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 or LABOR_TIME
Plant: Customer Plant name (Org Code)
WorkCenter: Enter work center linked to the operation or DEF for default settings
Attribute Name: Leave a blank value
Attribute Value: Activity type name (LABOUR, MACHINE, SETUP, etc)

 

3. Click the Save button.

 

Note: 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 labour activity hours. Hands on time and Labor time is sent in seconds from 42Q and is converted in hours to post it in SAP.

 

Figure 46: Lookup Table

 

 

4. To send the hands-on-time in WIP Move, go to the 42Q Portal, after that, navigate to: Administration > Generic Attribute Maintenance.
5. Use the filter to search for the wip_movement table.
6. Select the wip_movement table that contains the Attribute Name: get_hands_on_time.
7. Select the Edit Generic Attribute button.
8. To enable the get_hands_on_time generic attribute, set Value to true.
9. Select Save.

 

 

Labor Time Setup

1. To send labor time in WIP Move, go to the 42Q Portal, after that, navigate to: Administration > Generic Attribute Maintenance.
2. Use the filter to search for the wip_movement table.
3. Select the wip_movement table that contains the Attribute Name: get_labor_time.
4. Select the Edit Generic Attribute button.
5. To enable the get_labor_time generic attribute, set Value to true.
6. Select Save.

 

Note: For more information on how to record and set up Labor and Crews, refer to the Labor Tracking section contained in the next document: Production Workbench-Labor Tracking.

 

Figure 47: Searching for the wip_movement 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 48: Cycle Time Details Report

 

 

Users can set up only one Default Work Center, however, to add another work center, users have to define the following action types:

• ADD: Maps the additional activity center for a specific work center in addition to the default activity type. In this case the hands on time will be posted for both Electricity and Machine.

Figure 49: Default ADD Action Type And Machine Activity

 

Note: In the previous image, the action type is DEF_ADD (Attribute Name Column) and the activity for it can be MACHINE (Activity from the work center operation).

 

• OVERRIDE: Overrides the default activity type with a different activity type for a specific work center. In this case the hands on time will be posted for Machine instead of Electricity.

  
Figure 50: Default OVERRIDE Action Type And Machine Activity

 

• IGNORE: Ignores the default for a specific work center. In this case the hands on time will be ignored for that work center and the adapter will post the standard activity value during confirmation posting.

Figure 51: Default IGNORE Action Type

 

Note: If the work center is not mapped the adapter will always consider the Default activity mapped. Also, if the activity type is not mapped with any action then the adapter will post the standards for the activity type like before. 
 

 

Check Hands on Time or Labor Time Values

To check the HANDS_ON_TIME and LABOR_TIME values on SAP, users must follow the steps below:

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

Figure 52: Production Order Display

 

 

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

 

 

Figure 53: Selecting Operation Value

 

 

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

Figure 54: Displaying More Options

Figure 55: 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 56: 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 57: 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 58: 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 59: 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 60: 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 61: 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 62: 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 63: 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