Kontakt

Ansicht
Dokumentation

RFFMUD_CORRECTION - Program RFFMUD_CORRECTION

RFFMUD_CORRECTION - Program RFFMUD_CORRECTION

Vendor Master (General Section)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

This program corrects inconsistencies that can occur in the database tables for Revenue Increasing Budget (RIB) in Former Budgeting (FB) in the case of distribution procedure 1.

Integration

Prerequisites

  • You use Former Budgeting.
  • You use distribution procedure 1(also called document-based procedure) for Revenue Increasing Budget (RIB).
  • You use a RIB rule where invoices, payments, down payments and/or transfer postings can increase the budget. Do this from the menu with the transaction FMIA..
  • You increase the budget with the transactions FMIB and FMIC.

Features

When you run this program, you correct inconsistencies in the data base tables for the RIB (FMUDBSEGH and FMUDBSEGP). When needed, the program reverses budget documents automatically. Moreover, you can force the reversal of budget documents even if inconsistencies are not found.

Note:

Typical inconsistencies which can be corrected by this report are:

  • A RIB budget document created automatically by transaction FMIB is manually reversed. The manual reversal process does not update the DB tables for RIB.
  • You post a FI-document on a revenue address for which a RIB rule exists. You run the transaction FMIC and FMIB. A RIB budget document is created for this FI-document. Now you reverse the FI-document by running the program RFFMDLFI Deleting Actual Data or the transaction FMN0 Document Transfer from Financial Accounting . A reversal line (FMIFIIT-PAYFLG ='Z' -> Reversal document) is registered in the data base table FMIFIIT for the same invoice number/item. You now have a RIB budget document whose corresponding FI-document was reversed. This is an inconsistency which cannot be corrected by calling again FMIC and FMIB. Transaction FMIC will sum the reversal and reversed lines in FMIFIIT for the FI-document number. The result is zero, therefore no budget is available for increase.

Constraints

  • This program does not correct inconsistencies created by the forecast of revenue documents.
  • Even if you define a budget sub-type for the automatic RIB, it is possible to increase the budget manually using the RIB rules for this budget sub-type. The DB tables for the RIB are not updated by manual RIB. There is no way to distinguish in the data base tables of the budget documents the RIB budget documents created manually from the ones created automatically. Therefore, there is no way to correct this inconsistency.
  • If you reassign a revenue invoice, new lines for the same invoice number/item with the amount type 0600 (sender address) and 0650 (receiver address) are updated in the table FMIFIIT. Lines with these amount types are not considered by the transaction FMIC. Therefore, they are never updated in FMUDBSEGH.

Selection

  • Enter the FM area and fiscal year you want to work with.
  • You can enter the company codes, document numbers and line items where you have found inconsistencies.
  • You can enter the revenue FM account assignments in order to further restrict the selection.
  • You can force the program to reverse budget documents for surplus lines or not, even if inconsistencies are not found.
  • Choose Test Run to run the program in test mode first.
  • You can enter the layout for the output

Standard Variants

Output

The output list contains the corrections done (or to be done in case of test run) in the database tables, including the new and the old values of the changed fields.

You can also display an error log if there were errors during the budget reversal process.

Activities

DB tables FMUDBSEGH and FMUDBSEGP are updated.

RIB budgets can be reversed. If this is the case, new corresponding lines are inserted in DB table FMUDBSEGP.

Below is a list of inconsistencies and corrections which are done by this report:

  1. Field FMUDBSEGH-FIBELNR is initial or Fields FMUDBSEGH-FIBELNR+FIBUZEI+Revenue FMAA does not exist in DB table FMIFIIT:
    1. Action: Reverse the budget
    2. FMUDBSEGP: New line is added for the reversal budget
    3. FMUDBSEGH: See 9
  2. Field FMUDBSEGH-STATUS='C' while FMIFIIT-PAYFLG='X' and Payments increase the budget:
    1. Action: Reopen the corresponding line in FMUDBSEGH
    2. FMUDBSEGH: Update line with STATUS='O'
  3. Field FMUDBSEGH-WRTBTR:
    1. Action: Check with correct value coming from the field FMIFIIT-FKBTR
    2. FMUDBSEGH: Update line if this field has a different value
  4. Field FMUDBSEGH-ERHBGTR:
    1. Action: Calculate the value using the correct WRTBTR value and the RIB rule
    2. FMUDBSEGH: Update line if this field has a different value
  5. Field FMUDBSEGP-BGBELNR is INITIAL or does not exit in the DB table for budget documents:
    1. Action: Reset budget value
    2. FMUDBSEGP: Line is updates with reset value for field BGBTR
    3. FMUDBSEGH: See 9
  6. Field FMUDBSEGP-BGBELNR is reserved and the reversal budget has no corrisponding line in the table FMUDBSEGP:
    1. Action: Add the missing line corresponding to the reversal budget
    2. FMUDBSEGP: New line is added for the reversal budget
    3. FMUDBSEGH: See 9
  7. Field FMUDBSEGP-BGBELNR is reserval and the reversed budget has no corrisponding line in the table FMUDBSEGP:
    1. Action: add the missing line corresponding to the reversed budget
    2. FMUDBSEGP: New line is added for the reversed budget
    3. FMUDBSEGH: See 9
  8. Field FMUDBSEGP-BGBTR:
    1. Action: calculate the value using correct values from budget tables
    2. FMUDBSEGP: Update the line if the value for field BGBTR is different
    3. FMUDBSEGH: See 9
  9. Field FMUDBSEGH-SUMBGBTR:
    1. Action: calculation of value using the correct values for BGBTR (see 8) -> SUMBGBTR = sum FMUDBSEGP-BGBTR
    2. FMUDBSEGH: Update the line if the value for field SUMBGBTR is different
  10. If FMUDBSEGH-ERHBGBTR < SUMBGBTR, the inconsistency can be solved only by reversing all budget documents related to this FI document:
    1. Action: All budgets related to this FI document must be reversed
    2. FMUDBSEGP: New lines are added for the reversed budget documents
    3. FMUDBSEGH: See 9 and set the line status as open.

Example






TXBHW - Original Tax Base Amount in Local Currency   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 7831 Date: 20240601 Time: 211800     sap01-206 ( 110 ms )