Ansicht
Dokumentation
RFFMGRIRAN - Goods and Invoice Receipt Analysis in Funds Management
TXBHW - Original Tax Base Amount in Local Currency TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
Purpose
This program analyzes goods receipt (GR) and invoice receipt (IR) postings in Funds Management (FM). It determines whether the existing FM entries for the GR and IR documents for a particular purchase order (PO) document or a particular service entry sheet (SES) document are correct or not.
The program displays the analysis results in the form of NEW and ORIGINAL entries. NEW entries are those, which should have been posted. ORIGINAL entries are those which have previously been posted in the system. In other words, NEW entries are the results of a current simulation, ORIGINAL entries are existing entries in FM.
You can obtain a summarized list of POs, PO line items, and SES documents by clicking the button called PO / SES List. Once you have confirmed the results of the analyses, you can then repair the incorrect FM postings using standard tools or utilities delivered by SAP.
NOTE: The program may experience a performance issue since it has to analyze every GR and IR document in the PO history in a chronological order.
Integration
The program uses the PO documents and line items entered on the selection screen to determine the PO history. The PO history may include GR documents, GR cancellation documents, IR documents, IR cancellation or credit memo documents, and GR/IR clearing documents generated by transaction MR11. All these PO history documents are sorted in chronological order to retain the sequence in which they were originally created.
If a PO line item has a service item category, the program then pulls in all SES documents for the line item.
Next, for each document in the PO history, the program obtains its Financial Accounting (FI) document information from database tables BKPF and BSEG. It uses this FI information to simulate the FM posting, which in effect produces the NEW entries in the result listing.
Next, the program reads in the existing FM data either using the PO or the SES document. From this, it can determine the ORIGINAL entries.
Then, it determines whether the NEW and ORIGINAL entries match by calculating the delta between them. A delta is defined as a difference between the NEW entries and the ORIGINAL entries. When calculating the delta, the program disregards certain fields such as the following:
- Level number (FMIFIIT-STUNR)
- Year of cash effectivity (FMIFIIT-GNJHR)
- Year-end closing status (FMIFIIT-CFSTAT)
- Saved year-end closing status (FMIFIIT-CFSTATSV)
- Year-end closing number of carryforwards (FMIFIIT-CFCNT)
- Carryforward level (FMIFIIT-CFLEV)
- Item text (FMIFIIT-SGTXT)
- Transaction number (FMIFIIT-TRANR)
- Customer field (FMIFIIT-USERDIM)
- Payment status (FMIFIIT-PAYFLG)
- Posting day (FMIFIIT-PSOBT)
If a delta exists, the delta is appended to an internal buffer to be used in the next delta calculation for the next GR/IR document in the PO history. This is because, per a PO line item or SES document, the FM posting of a document in the history depends on what has already been posted.
Since the program does not update the actual underlying database table FMIFIIT, it simulates this effect by means of the internal buffer.
Prerequisites
You are using the FM module in your system. You turned on the "Goods receipt" checkbox and "Invoice receipt" checkbox on your PO line item.
Features
Selection
Standard Variants
Output
The program produces output in the form of two ALV grid displays. The first ALV grid screen shows the NEW and ORIGINAL entries sorted first by the PO or SES document numbers and next the transaction numbers (field FMIFIIT-TRANR). Within each group of entries with a distinct TRANR number, the NEW entries are highlighted in gray-blue and the ORIGINAL entries are highlighted in red.
With a single-click on the document numbers you can enter the original documents..
Sometimes it could be the case that a GR or IR document that was previously posted in the system was not posted into FM at all. In this case, there are no ORIGINAL entries. The results screen then shows only the NEW entries for this posting with a 16-digit TRANR number that begins with a number '9'. This is an artificial number the program uses only for the purpose of displaying the results and separating them from other groups of TRANRs. Therefore, it is important to note that this may not be the TRANR that will be posted in FM by some repair utilities. In addition, in such cases, both the FM document number (FMIFIIT-FMBELNR) and FM document line item (FMIFIIT-FMBUZEI) are left blank on the results screen.
The following FMIFIIT fields are not displayed on this screen:
- MANDT: Client
- STUNR: Number that clearly identifies the line key in database
- GNJHR: Year of cash effectivity
- CFSTAT: Year-end closing: Status
- CFSTATSV: Saved year-end closing status
- CFCNT: Year-end closing: Number of carryforwards
- CFLEV: Carryforward level
- SGTXT: Item Text
- USERDIM: Customer Field for FM Actual and Commitment Data
- PAYFLG: Payment status of FM documents
- PSOBT: Posting day
You get to this screen by clicking the button "PO / SES List" on the toolbar. It shows a summarized ALV grid of PO documents, line item numbers, SES documents, and predecessor account assignment number (FMIFIIT-VRFKNT). You may extract this list and use it to make entries on a selection screen of a repair utility.
If you run the program in the background (menu option Program >> Execute in background), the output results are displayed using ALV lists, instead of ALV grids, and stored in the spool, which can then be viewed using transaction SM37. The two result listings discussed above appear on the same results screen.
Activities
Example
TXBHW - Original Tax Base Amount in Local Currency RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 6805 Date: 20240520 Time: 114146 sap01-206 ( 123 ms )
