SAP Program RFKK_ZWFEWB_BWBER_INIT - Prepare Valuation Areas for Doubtful Entry/Individual Value Adjustment

Purpose
The example report RFKK_ZWFEWB_BWBER_INIT provided by SAP makespreparations for the use of valuation areas fordoubtful entries/individual value adjustments.
For technical reasons, the following new database tables are required inorder to use valuation areas for doubtful entries and individual valueadjustments:

  • DFKKZWFT (new trigger table)

  • DFKKZWFH (new history table)

  • DFKKZWFP (new transfer table)

  • All of the data from the previously used database tables (DFKKZW,
    DFKKZWH, and DFKKZW2) must be transferred to the newdatabase tables. In addition, the data might need to be adjusted to thevaluation areas. This adjustment is based on the fact that all data forthe defined valuation areas is duplicated; this means that after thereport is executed, the doubtful entries and individual valueadjustments have the same status in all valuation areas.
    If you have not (yet) defined valuation areas for a company code, thereport simply transfers the data to the new database tables. If youdefine valuation areas for a company code at a later date, you can runthe report for that company code again to adjust the data. However, youshould note that this process can only be performed once; you cannotmake this adjustment a second time for a company code.

    Prerequisites
    For each relevant company code, you must define your valuation areas(see Customizing for Contract Accounts Receivable and Payable under
    Business Transactions -> Doubtful Items and Individual Value Adjustment-> Define Valuation Areas for Receivables Adjustments).

    Selection
    You select the company codes for which you want data to be transferredto the new tables and if necessary adjusted to the valuation areas.
    Note: You have to run the report for all company codes for which thereis data relevant to doubtful entries or individual value adjustments.The transactions for doubtful entries and individual value adjustmentsremain locked, after the valuation areas are activated, until all thedata has been completely transferred to the new database tables.

    Activities
    Simulation Run
    The report checks if the data for the selected company codes can betransferred and adjusted to the valuation areas, if necessary.
    Update Run
    The report transfers the existing data to the new database tables and,if necessary, adjusts it to the valuation areas for each company code.The report records the status for each company code in the
    DFKKZWF_STATUS table.
    Note
    Since this is a conversion of mass data, the run can be verytime-consuming. Note also that the volume of data in the database tablesis multiplied by the number of valuation areas.

    Example
    You want to adjust company code 0001 to valuation areas HGB and US GAAP,so that both valuation areas initially have the same level regardingdoubtful entries/individual value adjustments. For company code 0002,you also want to use valuation areas HGB and US GAAP, however, you onlywant to transfer data for HGB. This means that company code 0002 shouldinitially not have any data for doubtful entries/individual valueadjustment in the US GAAP valuation area. For company code 0003, you donot want to use any valuation areas (at first).
    In Customizing, assign the valuation areas HGB and US GAAP to companycode 0001. Assign valuation area HGB to company code 0002.
    Run report RFKK_ZWFEWB_BWBER_INIT for company codes 0001, 0002,and 0003.
    Now assign valuation area US GAAP to company code 0002 in Customizing.
    At a later date, you decide that company code 0003 should also use thevaluation areas for HGB and US GAAP, just as company code 0001 does.This means that both valuation areas should initially show the samestatus for doubtful entries/individual value adjustments.
    RESET N1
    In Customizing, assign the valuation areas HGB and US GAAP to companycode 0003.
    Run the report RFKK_ZWFEWB_BWBER_INIT for company code 0003 asecond time.
    Note
    Also keep the reconciliation with the general ledger in mind. For moreinformation, see the release note.