Tag: SAP

AFAB Dynamic Variant for Posting Period and Fiscal Year

(ECC 6.0 SP16)

Scenario:
User would like to have the current month depreciation posting run executed on ME-4 every month. Example: Month end is 30 Sept 2022. Therefore, depreciation should be executed on 26 Sept 2022.

Issue:
Fiscal Year and Posting Period does not have the dynamic calculation option when saving a variant.

Workaround solution:
Utilize standard SAP program RVSETDAT. This program updates both table TVARV and TVARVC for the following variables:
i. RV_ACTUAL_DATE – Updates current system date. Eg. 20220930
ii. RV_ACTUAL_MONTH – Updates month based on current system date. Eg. 09
iii. RV_ACTUAL_YEAR – Updates year based on current system date. Eg. 2022

Steps as follows:

  1. By default, the variables above are not maintained in TVARVC. Therefore, create the variables above in TVARVC via t-code STARV under “Parameter” tab.


  2. Save AFAB variant with Fiscal Year and Posting Period field as follows:



  3. Schedule a job with the following steps:

    Step 1
    Execute program RVSETDAT.
    This would update the values in table TVARVC.


    Step 2
    Execute program RAPOST2000 with the variant saved in Step #2 above.
    Fiscal Year and Posting Period is derived from TVARVC:

Summary:
If the above solution does not work for some reason, create a Z program based on RVSETDAT logic with Z variable to suit your requirement.

Example 1
Fiscal Year is not calendar year ie. fiscal year for calendar year 2022 is 2023.

  1. Create a Z program based on RVSETDAT logic
  2. Derive Fiscal Year with own logic ie. get year from current system date and +1

Example 2
Schedule job to be executed on 2nd working day for the depreciation of the previous month.

  1. Create a Z program based on RVSETDAT logic
  2. Derive Posting Period with own logic ie. get month from current system date and -1

How to export large pool of data from SP01

Before that, you will need to make sure you that have the folder in your local drive as follow:
C:\Users\<your_windows_userid>\Documents\SAP\SAP GUI

If you don’t have the abovementioned folder, please create them first.

• Select the spool you want to export
• Go to Spool Request > Forward > Export as Text…

The selected spool data will be saved to the file as <SAP_System_Name <Spool_Number>.TXT  in the abovementioned directory.

Retire Multiple Assets in SAP

I can suggest you an easy way of retiring multiple assets.

1. Use AR01 (Asset balances report)

2. Enter the assets to be disposed off and execute.

3. Click on “Create Worklist” (Edit-> Worklist-> Create).

1

4. Enter a name and click your selection.

1

5. In the next screen, enter the data as you would in ABAVN. Once you click on [Enter] button a work queue number will be created.

6. Go to AR31, use the work queue number and execute it. Release worklist and refresh it
till it is completed.

IMPORTANT: Try this in a test environment before you do it in Production.

Create Financial Statement Version

https://wiki.scn.sap.com/wiki/display/ERPFI/Creating+Financial+Statement+Versions

Purpose

This wiki provides the structure for creating a financial statement version in accordance with the principles outlined in note 1154817  Creating financial statement versions

Overview

Financial Statement Version (FSV) is a ‘tree’ that organizes and groups general ledger accounts. The tree is used by RFBILA00 and GL drill down reports in order to present data in an organized manner.  Financial Statement Version is also used by other programs and reports, for example RFBILA10, RFSBWA00, RFBILA00N.

Transaction code and menu path for Financial Statement Version

Transaction code OB58 is the transaction code used to create, edit and transport the financial statement version.  You can also use transactions FSE2/FSE3 to change/display the structure

The menu path for the financial statement verison is as follows:

In Customizing for classic General Ledger Accounting, choose Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Document -> Define Financial Statement Versions.

In Customizing for new General Ledger Accounting, choose Financial Accounting (New) -> General Ledger Accounting (New) -> Master Data -> G/L Accounts -> Define Financial Statement Verisons.

 

Financial Statement Version Tree

Rules for creating the Financial Statement Version

From note 1154817  the following is stated

1.  The following special items (highlighted in red in the structure maintenance) have to be assigned on the second hierarchy level (directly below the root node with the description of the financial statement version):

o  Assets

o  Liabilities

o  Not assigned


2.  The following special items (highlighted in red in the structure maintenance) have to be assigned below the special item Liabilities in the hierarchy:

o  Net result: loss

o  Net result: profit




 3.  The special item P+L result  can be assigned as required. However, it must not be assigned as a subnode of another special item.