天天看點

SAP MM 預留單據的曆史修改記錄?

SAP MM 預留單據的曆史修改記錄?

在筆者眼裡,SAP系統是一個高度嚴謹的軟體系統。使用者在SAP系統裡的相關操作,系統都會做記錄。使用者對于系統的相關單據的增删改,SAP系統都有保留change history,并且可以很友善被人查詢這些change history。但是筆者發現,并不是所有單據的修改,SAP系統都提供很好的查詢change history的方式,比如Reservation單據。

如下的預留單ITEM,筆者有将數量由80改成了81,

筆者試圖找到該預留單據的change history, 如同查詢其它單據修改記錄的方式,找遍了MB23事務代碼裡的諸多菜單,都找不到。

上網查資料,發現SAP标準系統是不保留預留單據的change history資訊的。看來SAP保持增删改的痕迹以友善後續追溯的嚴謹風格,執行的并不徹底!當然SAP系統對于任何單據的修改都有記錄在表CDHDR & CDPOS裡,但是标準系統裡,這2個表裡的資料,對于業務使用者,并不能友善的查詢。

SAP NOTE 1927840 供參考。

1927840 - Change log for reservations

Symptom

Create a Purchase Requisition with reference to a reservation and later make changes to delivery date,for example, in transaction ME52N. The field RESB-BDTER is updated with the delivery date changes but no change log is written.

You would like to record changes made to reservations.

Reproducing the Issue

Call a reservation in transaction MB22.

Make a change to the reservation.

Save the changes.

There is no change log.

Cause

This is standard SAP system design.

Resolution

In enhancement MBCF0007 you find user exit EXIT_SAPMM07R_001.

This user exit is called directly after the COMMIT WORK statement in MB21/MB22 and contains information related to the old and new item details in table RESB. You could use this user exit to update the reservation changes to a custom table.

The standard change log table are CDHDR & CDPOS. If you were to use these as part of a custom development to capture reservation changes you would have to pay special attention to performance as these tables are often very large.

2019-04-28 寫于蘇州市。

繼續閱讀