Avoid User Confusion by Reconciling Reports Containing SD, FI, and PCA Data with KEAT

  • by Gary Fullmer, Solution Architect, MI6 Solutions
  • November 15, 2002
CO-PA produces different period-end billing numbers than do the SD, FI, and PCA modules for the same period. This is because CO-PA looks ahead and sometimes estimates numbers that are not seen in the other modules until later. This confuses many users who needlessly resort to manual reconciliation. A new transaction, KEAT, reconciles the period billing differences within the reports. Here's how to set it up.

CO-PA’s unique reporting characteristics and the way it generates its numbers might create a problem for your users. The period-end billing numbers in CO-PA often do not mirror the same-period billing numbers generated in the SD, FI, and PCA modules. If you have detailed knowledge of CO-PA, then you know that CO-PA looks ahead or even estimates certain numbers that are not seen in the other modules until later on in the billing cycle. The discrepancy is intentional. For users who do not understand how CO-PA works, however, it causes confusion and even casts doubt on the integrity of CO-PA reporting.

As a result of this CO-PA "feature," many users spend a lot of time and effort "justifying" period-end billing reports in CO-PA. They often use Excel spreadsheets to track all billing entries occurring in SD, FI, and PCA, and then they compare and reconcile these with the totals of the CO-PA billing reports. This manual reconciliation is very frustrating.

Fortunately, your users don’t have to perform this pesky task. Starting with release 4.5A, SAP has added a standard transaction that generates a report that reconciles the period billing total differences within the various reports. This new transaction is KEAT. The good news for folks not yet running release 4.5A or higher is that they can apply a hot pack to their system that enables KEAT in releases as far back as 3.0F. (See CSN note 112938.)

Let me show you what KEAT can do by tracking a sales order through the system to CO-PA reporting. In Figure 1, the Conditions tab is selected for sales order 8106. This sales order is set up for the purchase of 10 P-100 pumps. The Conditions table outlines the price, tax, cash discount offered, total cost, and the projected profit on the order. Note that there is no entry for the cost of freight.

Gary Fullmer

Gary Fullmer is currently associated with MI6 Solutions as a solution architect. Prior to MI6 Gary recently worked for SAP Labs for 13+ years. While at SAP Labs, he spent his first four years as a CO instructor developing and delivering all CO courses offered in the SAP course catalog. For the next six years, he assumed the role of a FI/CO solution manager, where he focused on interfacing with customers for CO, SEM, and FI solutions. During the remainder of his time with SAP, he worked on SAP General Ledger migration techniques, the SAP IFRS adoption model, and SAP’s enhanced financial closing, and continues to consult on these topics. His educational background includes an MBA from Rensselaer Polytechnic Institute, an MS from Utah State University, and a BS from Utah State University.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.