Production / Process Order Change Log using SAP Note: 390635

[SathyaNarayanan]

Issue Encountered:

The Revision Field in the Custom Production Order Job Card Printout was initially intended to be blank based on the Customer Template. However, the new requirement is to update this field automatically whenever there are changes to the Production Order and to reprint the Job Card with new data and a revised revision number.

Approach to Resolution:

Initially, the need arose to access the Production Order Change Log or History within any Database Tables to initiate the customization process. Regrettably, we were unable to locate any change log in both CDHDR and CDPOS for the Production Order (Order Category: 10 and 40).

Upon further investigation, we discovered that SAP has not incorporated this in the Standard Solution, as indicated in SAP Note: 390635. This is due to the fact that modifications to the Header Quantity will lead to changes in all BOM Component Quantities and Operations, resulting in an extensive list of change documents.

Link to SAP Note: https://me.sap.com/notes/390635/E

So, Consequently we opted to:

1. Capture changes in the Production Order (for specific fields alone). For example, generate a change log exclusively when there is a modification in Production Order Header Quantity, creation or updates to existing lines in both BOM and Routing, while ignoring any other changes.
2. Utilize the aforementioned log to automatically update the Revision Field in the Custom Production Order Job Card Printout.

Solution:

Following the guidelines provided in SAP Note: 390635, we executed the following steps:

1. Coordinated with the Technical Team to create and activate the Include in (SMOD / CMOD) in Project: PPCO0007, FM: EXIT_SAPLCOZV_001, and Include: ZXCO1U06.
2. Informed the Basis Team to implement SAP Note: 390635.
3. Subsequently, the SAP Sample Code is automatically generated in this Include. This Sample Code serves as a reference for generating the log for changes made in Routing.
4. Collaborated with our Technical Team to make the necessary modifications in this Include Program. We requested them to create a new entry whenever there is a change in Header Quantity or when there is data creation or updating in BOM/Routing.
5. After the Technical Team's modifications, we can observe all our changes in the Program: RSSCD100 / 150 / 200 (as specified in SAP Note).
6. Enter the details below in the Selection Screen of RSSCD100 and Execute,

   Object Class        - ORDER

   Object ID             - *<Production Order Number>

   Date Range         - As Required

   RSSCD100 Selection Screen
7. The output displayed is as follows:
8. If required, we can create this Program: RSSCD100 as the TCode as a Tile and Provide to the Customer.

Transitioning to the second half of the blog:

1. Within the Production Order, we've activated the "Customer Screen" tab, incorporating five fields—Revision Number, Changed By, Changed On, Changed At, and Document Number. These custom fields have been added to the table.Production Order - Customer Screen View
2. Whenever changes occur in the specified fields, and a document is generated through SNote: 390635, we captured the relevant data from the posted document within the Update BAdI. Subsequently, we calculated the Revision Number and displayed it in the Production Order. It's important to note that the program has been configured to generate only one document and, consequently, record a single revision if changes are made to all the fields and saved at once.
3. Leveraging this available data, we linked it to the customized Adobe Form for the Job Card Printout.

Conclusion:

We trust that this approach will be beneficial if you come across a similar scenario. If you have explored alternative methods, please feel free to comment and share your insights.