AC305 Asset Accounting
.
.
EXERCISES AND SOLUTIONS
. Course Version: 15
SAP Copyrights and Trademarks
© 2017 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/ copyright/index.epx for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used.
This information is displayed in the instructor’s presentation
Demonstration
Procedure
Warning or Caution
Hint
Related or Additional Information
Facilitated Discussion
User interface control
Example text
Window title
Example text
© Copyright. All rights reserved.
iii
iv
© Copyright. All rights reserved.
Contents Unit 1: 1 7
Unit 2: 12 14 17 20 22 24 26 28 36 39
Unit 3: 45 51 59 62 71 77 85 89 94 99 105
Organizational Structures Exercise 1: Assign a Chart of Depreciation to a Company Code Exercise 2: Define Depreciation Areas and Post Values to the General Ledger (G/L) Master Data Exercise 3: Use Number Assignment for FI-AA Exercise 4: Use Account Determination Exercise 5: Maintain the Screen Layout of Asset Master Data Exercise 6: Maintain the Screen Layout of Asset Depreciation Areas Exercise 7: Copy Asset Classes from Reference Exercise 8: Display Asset Class 4000 Exercise 9: Manage Asset Classes for LVA Exercise 10: Create Asset Master Records Exercise 11: Maintain Time-Dependent Data Exercise 12: Define the User Fields and Mass Changes of Asset Master Records Asset Transactions Exercise 13: Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer Exercise 14: Create a Fixed Asset and Post Acquisition Exercise 15: Fill Master Data for Segment and Profit Center Reporting Exercise 16: Make Various Non-Integrated Asset Acquisition Postings Exercise 17: Make Postings Integrated with Materials Management Exercise 18: Post Integrated Asset Retirements with Accounts Receivable (AR) Exercise 19: Transfer Assets Within Company Code Exercise 20: Post Intercompany Asset Transactions (Within One Company) Exercise 21: Post Intercompany Asset Transfer (Across Company Boundaries) Exercise 22: Create and Post to an Asset Under Construction (AuC) and Settle It to Completed Assets Exercise 23: Post Unplanned Depreciation
© Copyright. All rights reserved.
v
Unit 4:
Periodic Processing and Valuation
109 114
Exercise 24: Analyze Depreciation Areas Exercise 25: Understand and Maintain Depreciation Keys
119 122 124 132 137
Exercise 26: Maintain Time-Dependent Depreciation Parameters Exercise 27: Analyze Cost-Accounting Depreciation Area Exercise 28: Execute and Analyze the Depreciation Run Exercise 29: Execute Year-End Closing in Asset Accounting (FI-AA) Exercise 30: Manage Parallel Accounting in FI-AA
Unit 5: 150 154 160 Unit 6:
Information System Exercise 31: Analyze the Asset Portfolio Exercise 32: Forecast Future Depreciation Amounts Exercise 33: Execute the Asset History Sheet Legacy Data Transfer No exercises
vi
© Copyright. All rights reserved.
vii
© Copyright. All rights reserved.
Unit 1 Exercise 1 Assign a Chart of Depreciation to a Company Code
Business Example In your enterprise, FI-AA will be mapped in the SAP system using general ledger (G/L) in FI. To achieve this, you need to process and analyze the chart of depreciation and depreciation area objects in a test system. Next, you need to assign a chart of depreciation to a test company code. Task 1 Define and configure a chart of depreciation. This chart is a prerequisite for many other settings that affect FI-AA. 1. Create your own chart of depreciation with the short description AA## (## = your group number) by copying the chart of depreciation 1AC (in all German-language courses). Hint: Use the chart of depreciation 1AC in SAP training courses only. In practice, you can use the country-specific sample chart of depreciation 0XY as your copy template, where XY represents a country. For example, use the sample chart of depreciation 0DE in Germany, 0US in the US, and 0GB in the UK.
Note: If the AC305 course is not taking place in a German-speaking country, ask your instructor about the chart of depreciation to use as a template before completing this exercise. AC305 courses in the US can use chart of depreciation 1ACU as a template. 2. Change the description of your new chart of depreciation AA##, for example, to chart of depreciation group ##. 3. Delete the depreciation areas that you do not require (in the course) in your chart of depreciation AA##. If you are not sure about the depreciation areas that you can or should delete, ask your instructor.
Task 2 Assign the chart of depreciation to your company code. 1. Link the chart of depreciation AA## to your company code AA## to use FI-AA in the SAP system with your new chart of depreciation. System analysis
© Copyright. All rights reserved.
1
Unit 1: Organizational Structures
1. When you analyze the tables displaying which charts of depreciation are assigned to a company code, you may find company codes with no chart of depreciation assigned to them. What could be the reason for this?
True or False 1. The chart of depreciation is defined at client level. Determine whether this statement is true or false. X
True
X
False
2. A country-specific sample chart of accounts supplied by SAP cannot be adapted to your own requirements. Determine whether this statement is true or false. X
True
X
False
3. Various company codes can be assigned to the same chart of depreciation. Determine whether this statement is true or false.
2
X
True
X
False
© Copyright. All rights reserved.
Unit 1 Solution 1 Assign a Chart of Depreciation to a Company Code
Business Example In your enterprise, FI-AA will be mapped in the SAP system using general ledger (G/L) in FI. To achieve this, you need to process and analyze the chart of depreciation and depreciation area objects in a test system. Next, you need to assign a chart of depreciation to a test company code. Task 1 Define and configure a chart of depreciation. This chart is a prerequisite for many other settings that affect FI-AA. 1. Create your own chart of depreciation with the short description AA## (## = your group number) by copying the chart of depreciation 1AC (in all German-language courses). Hint: Use the chart of depreciation 1AC in SAP training courses only. In practice, you can use the country-specific sample chart of depreciation 0XY as your copy template, where XY represents a country. For example, use the sample chart of depreciation 0DE in Germany, 0US in the US, and 0GB in the UK.
Note: If the AC305 course is not taking place in a German-speaking country, ask your instructor about the chart of depreciation to use as a template before completing this exercise. AC305 courses in the US can use chart of depreciation 1ACU as a template. a) Copy the reference chart of depreciation or depreciation areas in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Copy Reference Chart of Depreciation/Depreciation Areas . b) In the Choose Activity dialog box, under the Name of Activity column, double-click Copy Reference Chart of Depreciation . c) On the Organizational object Chart of depreciation screen, choose Organizational object → Copy org. object . d) In the Copy dialog box, enter the following data: Field Name or Data Type
Value
From Chart of dep.
1AC (Based on the chart of depreciation in your country)
© Copyright. All rights reserved.
3
Unit 1: Organizational Structures
Field Name or Data Type
Value
To Chart of dep.
AA##
e) Choose Continue . f) Confirm the information from the system, which states that the copy transaction was successful. g) Go back to the Choose Activity dialog box. 2. Change the description of your new chart of depreciation AA##, for example, to chart of depreciation group ##. a) In the Choose Activity dialog box, double-click Specify Description of Chart of Depreciation. b) On the Change View "Chart of depreciation: Specify name" Overview screen, search for the line with your chart of depreciation AA## and the description Sample Chart of Depreciation for AC Courses (Copy of 0DE) . c) Overwrite the Description column with the following data: Field Name or Data Type
Value
Chart of Depreciation (ChDep)
AA##
Description
Chart of Depreciation Group ##
d) Save the data. e) Go back to the Choose Activity dialog box. 3. Delete the depreciation areas that you do not require (in the course) in your chart of depreciation AA##. If you are not sure about the depreciation areas that you can or should delete, ask your instructor. a) In the Choose Activity dialog box, double-click Copy/Delete Depreciation Areas. b) In the Determine Work Area: Entry dialog box, if there is no default value for the Chart of dep. field, enter your chart of depreciation AA## . c) Choose Continue . Note: In the AC305 course, the depreciation areas 10, 41, and 51 can be deleted without any problem. d) On the Change View "Define Depreciation Areas" Overview screen, select the row for depreciation area 10. e) Choose Edit → Delete to delete the depreciation area 10. f) Similarly, delete depreciation areas 41 and 51. g) Save the data.
4
© Copyright. All rights reserved.
Solution 1: Assign a Chart of Depreciation to a Company Code
h) Choose Continue to confirm the messages that are displayed. i) Go back to the main Customizing screen for FI-AA.
Task 2 Assign the chart of depreciation to your company code. 1. Link the chart of depreciation AA## to your company code AA## to use FI-AA in the SAP system with your new chart of depreciation. a) Assign the chart of depreciation to your company code in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Assign Chart of Depreciation to Company Code . b) On the Change View (Maintain company code in Asset Accounting) Overview screen, find your company code AA##. c) In the Chrtdep (Chart of Depreciation) column, enter AA## . d) Save and go back to the main Customizing screen. System analysis 1. When you analyze the tables displaying which charts of depreciation are assigned to a company code, you may find company codes with no chart of depreciation assigned to them. What could be the reason for this? Company codes with no chart of depreciation cannot work with the FI-AA component. Based on their size, these company codes may not need FI-AA as an FI subledger. Therefore, you can perform Asset Accounting in an external system. True or False 1. The chart of depreciation is defined at client level. Determine whether this statement is true or false. X
True
X
False
2. A country-specific sample chart of accounts supplied by SAP cannot be adapted to your own requirements. Determine whether this statement is true or false. X
True
X
False
© Copyright. All rights reserved.
5
Unit 1: Organizational Structures
3. Various company codes can be assigned to the same chart of depreciation. Determine whether this statement is true or false.
6
X
True
X
False
© Copyright. All rights reserved.
Unit 1 Exercise 2 Define Depreciation Areas and Post Values to the General Ledger (G/L)
Business Example The FI-AA project team meets to agree on proposals for the settings and types of depreciation areas required or used. Task 1 Define how depreciation areas post to the G/L. 1. Depreciation areas do not always post their values (asset values or depreciation) to the G/L in FI. Verify how the depreciation areas of your chart of depreciation AA## post to the G/L. ●
Which FI-AA depreciation area posts the asset values in real-time to the G/L?
●
Which depreciation area only posts depreciation?
●
Which depreciation areas are currently reserved for reporting purposes and do not transfer values to the G/L?
Caution: Do not change predefined entries.
Task 2 Specify the financial statement version for asset reports. 1. The standard reporting functionality of FI-AA enables you to group your assets according to financial statement items and display the financial statement items in the asset reports. Note: You can do so by simply selecting a sort variant with the financial statement item field (structure ANLAV/field ERGSO) in the selection screen of the report. For the system to know with which financial statement version a depreciation area is to be listed, you need to assign the corresponding financial statement version to your depreciation areas. Assign the financial statement version INT to all depreciation areas. Only the areas 30 and 31, which are the standard areas for the consolidated balance sheet, must receive the financial statement version CAUS .
© Copyright. All rights reserved.
7
Unit 1: Organizational Structures
Task 3 Define a depreciation area for foreign currency. 1. Define that the asset values in depreciation areas 31 and 32 that report in the group currency of your depreciation plan AA## are displayed in U.S. dollars (USD).
8
© Copyright. All rights reserved.
Unit 1 Solution 2 Define Depreciation Areas and Post Values to the General Ledger (G/L)
Business Example The FI-AA project team meets to agree on proposals for the settings and types of depreciation areas required or used. Task 1 Define how depreciation areas post to the G/L. 1. Depreciation areas do not always post their values (asset values or depreciation) to the G/L in FI. Verify how the depreciation areas of your chart of depreciation AA## post to the G/L. ●
Which FI-AA depreciation area posts the asset values in real-time to the G/L?
●
Which depreciation area only posts depreciation?
●
Which depreciation areas are currently reserved for reporting purposes and do not transfer values to the G/L?
Caution: Do not change predefined entries. a) Define how depreciation areas post to the G/L in Customizing for Financial Accounting (New) under Asset Accounting → Integration with General Ledger Accounting → Define How Depreciation Areas Post to General Ledger . b) In the Determine Work Area: Entry dialog box, enter AA## and press ENTER. You can see depreciation area 01 posts values to the G/L in real-time, depreciation area 20 posts only depreciation and all other areas do not update the G/L. c) Save the data. d) Go back to the Customizing screen.
Task 2 Specify the financial statement version for asset reports. 1. The standard reporting functionality of FI-AA enables you to group your assets according to financial statement items and display the financial statement items in the asset reports.
© Copyright. All rights reserved.
9
Unit 1: Organizational Structures
Note: You can do so by simply selecting a sort variant with the financial statement item field (structure ANLAV/field ERGSO) in the selection screen of the report. For the system to know with which financial statement version a depreciation area is to be listed, you need to assign the corresponding financial statement version to your depreciation areas. Assign the financial statement version INT to all depreciation areas. Only the areas 30 and 31, which are the standard areas for the consolidated balance sheet, must receive the financial statement version CAUS . a) Specify the financial statement version for asset reports in Customizing for Financial Accounting (New) under Asset Accounting → Integration with General Ledger Accounting → Specify Financial Statement Version for Asset Reports . b) Select the line item for AA## and double-click Assign financial statement version under Company code selection in the dialog structure. c) Enter the following data: Field Name or Data Type
Value
Book depreciation
int
Special tax depreciation for APC in financial statement
int
Tax balance sheet
int
Cost-accounting depreciation
int
Consolidated balance sheet in local currency
caus
Consolidated balance sheet in group currency
caus
Book depreciation in group currency
int
d) Save the data.
Task 3 Define a depreciation area for foreign currency. 1. Define that the asset values in depreciation areas 31 and 32 that report in the group currency of your depreciation plan AA## are displayed in U.S. dollars (USD). a) Define depreciation areas for foreign currencies in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Currencies → Define Depreciation Areas for Foreign Currencies . b) Select the line item for AA## and double-click Depreciation area currency under Company code selection in the dialog structure. c) Enter the following data:
10
© Copyright. All rights reserved.
Solution 2: Define Depreciation Areas and Post Values to the General Ledger (G/L)
Field Name or Data Type
Value
31
USD
32
USD
d) Save the data.
© Copyright. All rights reserved.
11
Unit 2 Exercise 3 Use Number Assignment for FI-AA
Business Example The FI-AA project team is meeting to discuss proposals relating to the number of asset classes and their settings in relation to account determination and number assignment. Use number assignment for FI-AA. Create settings for number assignment. The quickest way to define a separate number range interval is to copy the number range interval of company code 1000. You can also choose your cross-company-code number assignment together with company code 1000, though as a result you may share number ranges with other groups. Select and complete one of the following tasks: 1. Copy the interval of company code 1000. 2. Assign a cross-company-code number to company code 1000.
12
© Copyright. All rights reserved.
Unit 2 Solution 3 Use Number Assignment for FI-AA
Business Example The FI-AA project team is meeting to discuss proposals relating to the number of asset classes and their settings in relation to account determination and number assignment. Use number assignment for FI-AA. Create settings for number assignment. The quickest way to define a separate number range interval is to copy the number range interval of company code 1000. You can also choose your cross-company-code number assignment together with company code 1000, though as a result you may share number ranges with other groups. Select and complete one of the following tasks: 1. Copy the interval of company code 1000. a) Define a number range interval in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Number Range Interval. b) On the Range Maintenance: Asset Number screen, enter 1000 as the company code. c) Choose Utilities → Copy. d) In the Copy: Company Code dialog box, enter the following data: Field Name or Data Type
Value
From
1000
To
AA##
e) Choose the Continue pushbutton. f) Confirm the dialog box displayed and then look at the message displayed in the status area. 2. Assign a cross-company-code number to company code 1000. a) Specify the number assignment across company codes in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Specify Number Assignment Across Company Codes. b) Select the row for AA## . c) Enter 1000 in the No. CoCd field. d) Save the data.
© Copyright. All rights reserved.
13
Unit 2 Exercise 4 Use Account Determination
Business Example The FI-AA project team is meeting to discuss proposals relating to the number of asset classes and their settings in relation to account determination and number assignment. Check the control parameters and account determination for asset class 3000. Task 1 Run the transaction that provides you with an overview of all the existing asset classes. 1. Which transaction code provides you with an overview of all existing asset classes? Task 2 Check the details for asset class 3000. 1. Check which control parameters are defined for asset class 3000. 2. Check which number range or number range interval is assigned to asset class 3000. 3. Use the help function to find detailed information about how account determination works. Task 3 Check the account determination key. 1. Check which account determination key is assigned for asset class 2000. 2. Check which balance sheet asset account is posted to by the system with account determination key 20000 for an asset acquisition in depreciation area 01 and chart of accounts INT. 3. Check which account number (in chart of accounts INT) is assigned for the expense account for cost-accounting depreciation (depreciation area 20) in asset class 2100.
14
© Copyright. All rights reserved.
Unit 2 Solution 4 Use Account Determination
Business Example The FI-AA project team is meeting to discuss proposals relating to the number of asset classes and their settings in relation to account determination and number assignment. Check the control parameters and account determination for asset class 3000. Task 1 Run the transaction that provides you with an overview of all the existing asset classes. 1. Which transaction code provides you with an overview of all existing asset classes? a) Access the overview of all asset classes in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes. The transaction code is OAOA . Task 2 Check the details for asset class 3000. 1. Check which control parameters are defined for asset class 3000. a) Check the defined control parameters for an asset class in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes . b) On the Change View “Asset classes”: Details screen, double-click the row containing asset class 3000 . Alternatively, place the cursor on the row containing asset class 3000 and choose Goto → Details . Notice the following parameters: account determination, screen layout rule, and number range. 2. Check which number range or number range interval is assigned to asset class 3000. a) Check the defined control parameters for an asset class in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes . b) On the Change View “Asset classes”: Details screen, double-click the row containing asset class 3000 . Alternatively, place the cursor on the row containing asset class 3000 , and choose Goto → Details . c) Check that the number range interval is 03 . d) Do not exit the Change View “Asset classes”: Details screen. 3. Use the help function to find detailed information about how account determination works.
© Copyright. All rights reserved.
15
Unit 2: Master Data
a) Place the cursor on the Account determ. field and press F1. The detailed information is displayed. Task 3 Check the account determination key. 1. Check which account determination key is assigned for asset class 2000. a) Check the defined control parameters for an asset class in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes . b) Double-click the row containing asset class 2000 . c) Check that the account determination key for asset class 2000 is 20000 . 2. Check which balance sheet asset account is posted to by the system with account determination key 20000 for an asset acquisition in depreciation area 01 and chart of accounts INT. a) Check the defined control parameters for an asset class in Customizing for Financial Accounting (New) under Asset Accounting → Integration with the General Ledger → Assign G/L Accounts . b) In the Change View “Chart of Accounts”: Overview screen, select the row for INT . c) In the dialog structure, double-click Account Determination . d) Select the row for 20000 . e) In the dialog structure, double-click Balance Sheet Accounts . The balance sheet asset account number is 11000 . 3. Check which account number (in chart of accounts INT) is assigned for the expense account for cost-accounting depreciation (depreciation area 20) in asset class 2100. a) Check the defined control parameters for an asset class in Customizing for Financial Accounting (New) under Asset Accounting → Integration with the General Ledger→ Assign G/L Accounts . b) Select the row for INT . c) In the dialog structure, double-click Account Determination . d) Select the row for 20000 . e) In the dialog structure, double-click Depreciation . f) Double-click the row for depreciation area 20 . The expense account number is 481000 .
16
© Copyright. All rights reserved.
Unit 2 Exercise 5 Maintain the Screen Layout of Asset Master Data
Business Example Your consultant has proposed an organizational structure for your corporate group. The FIAA project team is meeting to discuss the proposal regarding the settings and their effect on screen layout. Maintain the screen layout of asset master data. 1. Start transaction OAOA . Using asset class 2100, check the F1 help to get information about the functions of the screen layout rule. Check which screen layout rule is assigned to asset class 2100. 2. Note that the fields of the asset master record, Description 1 in the General data logical field group and Cost Center in the Time-Dependent Data logical field group, must always be filled when you create a new asset master record. Check whether these fields are defined as required in screen layout rule 2000 . 3. Check whether the Description 1 field was copied from the reference while creating assets with reference, when using screen layout rule 3000. Hint: Even if it is not copied, do not change the Customizing entry.
4. Check whether the Insurance Type field was copied while creating assets with reference, when using screen layout rule 3000.
© Copyright. All rights reserved.
17
Unit 2 Solution 5 Maintain the Screen Layout of Asset Master Data
Business Example Your consultant has proposed an organizational structure for your corporate group. The FIAA project team is meeting to discuss the proposal regarding the settings and their effect on screen layout. Maintain the screen layout of asset master data. 1. Start transaction OAOA . Using asset class 2100, check the F1 help to get information about the functions of the screen layout rule. Check which screen layout rule is assigned to asset class 2100. a) Execute transaction /NOAOA . b) Double-click the row for asset class 2100 . c) Press F1 to use the help function. You can see that the screen layout rule assigned is 2000 2. Note that the fields of the asset master record, Description 1 in the General data logical field group and Cost Center in the Time-Dependent Data logical field group, must always be filled when you create a new asset master record. Check whether these fields are defined as required in screen layout rule 2000 . a) Define the screen layout for asset master data in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → Screen Layout → Define Screen Layout for Asset Master Data . b) In the Choose Activity dialog box, double-click Define Screen Layout for Asset Master Data . c) Select the row for screen layout rule 2000 . d) In the dialog structure, double-click Logical field groups and select the logical field groups listed in the exercise. e) In the dialog structure, double-click Field group rules . 3. Check whether the Description 1 field was copied from the reference while creating assets with reference, when using screen layout rule 3000. Hint: Even if it is not copied, do not change the Customizing entry.
18
© Copyright. All rights reserved.
Solution 5: Maintain the Screen Layout of Asset Master Data
a) Define the screen layout for asset master data in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → Screen Layout → Define Screen Layout for Asset Master Data. b) In the Choose Activity dialog box, choose Define Screen Layout for Asset Master Data . c) Select screen layout rule 3000 . d) In the dialog structure, double-click Logical field groups and select the General Data logical field group. e) In the dialog structure, double-click Field group rules . The Description 1 field is not copied. 4. Check whether the Insurance Type field was copied while creating assets with reference, when using screen layout rule 3000. a) Define the screen layout for asset master data in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → Screen Layout → Define Screen Layout for Asset Master Data. b) In the Choose Activity dialog box, choose Define Screen Layout for Asset Master Data and select screen layout rule 3000 . c) In the dialog structure, double-click Logical field groups and select the Insurance logical field group. d) In the dialog structure, double-click Field group rules . The Insurance Type field is copied.
© Copyright. All rights reserved.
19
Unit 2 Exercise 6 Maintain the Screen Layout of Asset Depreciation Areas
Business Example Your consultant has proposed an organizational structure for your corporate group. The FIAA project team is meeting to discuss the proposal related to the settings and their effect on asset depreciation areas. Maintain the screen layout rule stored in the asset depreciation data section. 1. Run the transaction code to move to the depreciation area data section. Note: If you start this transaction for the first time after you have logged on, you still need to enter your chart of depreciation AA## in the Choose chart of depreciation dialog box and confirm your entries. The transaction code is OAYZ . 2. Check the default values for the depreciation keys for asset class 2100. 3. Check which screen layout rule is stored in the depreciation data section of asset class 3000. 4. Check whether the Depreciation key field for screen layout rule 1000 is specified as a required field.
20
© Copyright. All rights reserved.
Unit 2 Solution 6 Maintain the Screen Layout of Asset Depreciation Areas
Business Example Your consultant has proposed an organizational structure for your corporate group. The FIAA project team is meeting to discuss the proposal related to the settings and their effect on asset depreciation areas. Maintain the screen layout rule stored in the asset depreciation data section. 1. Run the transaction code to move to the depreciation area data section. a) Determine depreciation areas in the asset class in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Determine Depreciation Areas in the Asset Class .
Note: If you start this transaction for the first time after you have logged on, you still need to enter your chart of depreciation AA## in the Choose chart of depreciation dialog box and confirm your entries. The transaction code is OAYZ . 2. Check the default values for the depreciation keys for asset class 2100. a) Select asset class 2100 . b) In the dialog structure, double-click Depreciation Areas . The system displays depreciation key LINK, except for area 20. The depreciation key LINA is stored in the area 20. 3. Check which screen layout rule is stored in the depreciation data section of asset class 3000. a) Screen layout rule 1000 is stored for all areas. 4. Check whether the Depreciation key field for screen layout rule 1000 is specified as a required field. a) Define the screen layout for asset depreciation areas in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → Screen Layout → Define Screen Layout for Asset Depreciation Areas. b) Select screen layout rule 1000 . c) In the dialog structure, double-click Field group rules . The Depreciation Key field is declared as a required entry field.
© Copyright. All rights reserved.
21
Unit 2 Exercise 7 Copy Asset Classes from Reference
Business Example As part of your job, you need to map your assets in the system. To do so, you need a separate asset class for special-purpose machines. Therefore, you want to create a new asset class by copying an existing class. Create a new asset class by copying asset classes from reference. 1. Create a new asset class MA## by copying class 2100. The short text of the new asset class is given as Special Machines ## and asset class description as Special Machines Group ##. Hint: When you generate your new asset class by copying an existing asset class and changing this copy, you obtain a complete asset class containing the master data section and the depreciation data section. If you create a new asset class without a reference, you only obtain the master data section and have to configure the depreciation data section completely in a subsequent step.
22
© Copyright. All rights reserved.
Unit 2 Solution 7 Copy Asset Classes from Reference
Business Example As part of your job, you need to map your assets in the system. To do so, you need a separate asset class for special-purpose machines. Therefore, you want to create a new asset class by copying an existing class. Create a new asset class by copying asset classes from reference. 1. Create a new asset class MA## by copying class 2100. The short text of the new asset class is given as Special Machines ## and asset class description as Special Machines Group ##. Hint: When you generate your new asset class by copying an existing asset class and changing this copy, you obtain a complete asset class containing the master data section and the depreciation data section. If you create a new asset class without a reference, you only obtain the master data section and have to configure the depreciation data section completely in a subsequent step. a) Define a new asset class in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes . b) Select asset class 2100 . c) Choose Edit → Copy As . d) Overwrite 2100 in the Asset class field with the new entry MA##; maintain the short text and the description, mentioned in the exercise text. e) Confirm and save your data.
© Copyright. All rights reserved.
23
Unit 2 Exercise 8 Display Asset Class 4000
Business Example As an employee of the FI-AA department, you are concerned as to whether AuC can be adequately maintained in the SAP system. For this purpose, you want to know if there are different processes for settlement. Therefore, compare the settings for asset class 4000 (AuC) with the features of other standard asset classes, and explain the differences to your colleague (in this case, your neighbor). Investigate the settings for asset class 4000 (AuC). 1. Investigate the settings for asset class 4000 (AuC).
24
© Copyright. All rights reserved.
Unit 2 Solution 8 Display Asset Class 4000
Business Example As an employee of the FI-AA department, you are concerned as to whether AuC can be adequately maintained in the SAP system. For this purpose, you want to know if there are different processes for settlement. Therefore, compare the settings for asset class 4000 (AuC) with the features of other standard asset classes, and explain the differences to your colleague (in this case, your neighbor). Investigate the settings for asset class 4000 (AuC). 1. Investigate the settings for asset class 4000 (AuC). a) Display the asset class in Customizing for Financial Accounting (New) under Asset Accounting → Organizational Structures → Asset Classes → Define Asset Classes . b) Double-click asset class 4000. Most important difference: Asset class 4000 specifies that in the Status of AUC field group an AuC is not processed as a summary settlement but is settled on a line item basis.
© Copyright. All rights reserved.
25
Unit 2 Exercise 9 Manage Asset Classes for LVA
Business Example As an employee of the FI-AA department, you need to enter and administer LVA. You also need to manage asset classes for LVA. Define the maximum value for LVA for company code AA##.
Note: Remember that the LVA amount is country-specific. You can set the maximum LVA amount for normal acquisition postings and for acquisitions using purchase orders. 1. Define the maximum LVA amount of €1,000 for your company code AA## in depreciation area 15. 2. Check if asset class 3005 is checked against the maximum amount you defined. You do not need to set anything as this configuration has been adopted from your chart of depreciation template.
26
© Copyright. All rights reserved.
Unit 2 Solution 9 Manage Asset Classes for LVA
Business Example As an employee of the FI-AA department, you need to enter and administer LVA. You also need to manage asset classes for LVA. Define the maximum value for LVA for company code AA##.
Note: Remember that the LVA amount is country-specific. You can set the maximum LVA amount for normal acquisition postings and for acquisitions using purchase orders. 1. Define the maximum LVA amount of €1,000 for your company code AA## in depreciation area 15. a) Check the maximum amount for LVA and asset classes in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Amount Specifications (Company Code/Depreciation Area) → Specify Max. Amount for Low-Value Assets + Asset Classes . b) In the Choose Activity dialog box, choose Specify amount for low value assets . c) Select the company code AA## . d) In the dialog structure, double-click Amount for low-value assets. e) Enter the amount specified in the exercise in area 15 in the LVA Amount column. 2. Check if asset class 3005 is checked against the maximum amount you defined. You do not need to set anything as this configuration has been adopted from your chart of depreciation template. a) Specify the maximum amount for LVA and asset classes in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Amount Specifications (Company Code/Depreciation Area) → Specify Max. Amount for Low-Value Assets + Asset Classes . b) In the Choose Activity dialog box, choose Specify LVA asset classes . c) Select asset class 3005. d) In the dialog structure, double-click Low-val. asset check . Depreciation area 15 checks against a value-based maximum amount.
© Copyright. All rights reserved.
27
Unit 2 Exercise 10 Create Asset Master Records
Business Example Your company has ordered several assets. These assets are to be mapped in the system using master records. Create or change all variations of master records in FI-AA. Task 1 Create asset master records. 1. Create a master record for your company code. Your company has ordered two forklifts. Create a master record using the following data: Field Name or Data Type
Value
Asset class
3100 for vehicles
Company code
AA##
Description
Forklift group ##
Cost center
T-F05E## for Motorcycle Production
Make a note of the asset master record number. Reminder about basic navigation: ●
●
Menu path in the FI-AA application: On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets . Menu path to Customizing for FI-AA: On the SAP Easy Access screen, choose Tools → Customizing → IMG → Execute Project . Next, choose the SAP Reference IMG pushbutton and navigate in the SAP Customizing Implementation Guide ( Financial Accounting (New) → Asset Accounting) .
You also need the master records for all subsequent parts of the exercise (asset master records may contain descriptions, such as Drill ##). Note: If no details are provided in the exercise related to what information to enter in an input field (for example, for the cost center or the posting amounts to be used), you can select the entry. 2. Create the second master record using your first one as a reference. Name the master record Forklift 2 Group ##. Make a note of the asset master record number.
28
© Copyright. All rights reserved.
Exercise 10: Create Asset Master Records
3. Your colleagues from the corporate services department with the cost center T-F05A## need a new photocopier. Create an asset master record in the correct asset class with an appropriate description. Hint: If you do not know which asset class to use, look at the solution.
If necessary, make a note of the asset master record number. Task 2 The production department will receive five new computers. Create similar asset master records in the appropriate asset class using the quickest method. 1. Create similar asset master records in the appropriate asset class. Enter PC 1 to PC 5 as descriptions. Enter inventory numbers 0001 to 0005 for the PCs, and assign a cost center to the master records. Make a note of the asset master record numbers. Task 3 Create the following asset master records in the way that you find easiest. 1. Asset class 1100 for buildings: Two asset master records 2. Asset class 2100 for machines, straight-line: 10 asset master records with the descriptions Machine 01 to Machine 10 and inventory numbers 01 to 10 3. Asset class 3000 for fixtures and fittings: One fax machine 4. Asset class 3100 for vehicles: Two company cars with the descriptions Company car ## (1) and Company car ## (2) 5. Asset class 4000 for AuC: One AuC, with description AuC, group ## 6. Asset class MA## for your newly created asset class with short text “Special Machines ##”: Three assets with description Special machine 01 to Special machine 03 7. Optional: Asset class 3005 for LVA in the fixtures and fittings area (individual management): One coffee machine for the office kitchen Task 4 Create a separate asset master record for another company car. As an exercise, create it in the wrong asset class. 1. Create a separate asset master record for another company car. The required data is as follows: Field Name or Data Type
Value
Asset Class
3000
Description
Car 3000 Group ##
© Copyright. All rights reserved.
29
Unit 2: Master Data
Field Name or Data Type
Value
Cost Center
T-F05E##
Task 5 Change the asset master record. 1. Change the asset master of your PC 1 in company code AA##. Change the description to Superflux Scenic 4000 Gr. ##. 2. For the PC Superflux Scenic 4000 Gr. ##, create two more subnumbers, with the descriptions Monitor and Keyboard in a single step. Hint: The subnumber can be assigned internally or externally, depending on how the respective asset class is configured. Because you have to create two subnumbers in one step, asset class 3200 in the training system is set up with an internal subnumber assignment. The distinction or configuration can be displayed on the details screen for an asset class in transaction OAOA . Based on the settings in the relevant screen layout rule, it is possible that data for some of the input fields can only be maintained at an asset main number level.
Task 6 Review the master data you created. 1. View the directory of unposted assets report for your company code to review the master data you created. The report can be found in the FI-AA menu (Information System → Reports on Asset Accounting → Day-to-Day Activities → International) . The technical name of this program is RAANLA_ALV01.
30
© Copyright. All rights reserved.
Unit 2 Solution 10 Create Asset Master Records
Business Example Your company has ordered several assets. These assets are to be mapped in the system using master records. Create or change all variations of master records in FI-AA. Task 1 Create asset master records. 1. Create a master record for your company code. Your company has ordered two forklifts. Create a master record using the following data: Field Name or Data Type
Value
Asset class
3100 for vehicles
Company code
AA##
Description
Forklift group ##
Cost center
T-F05E## for Motorcycle Production
Make a note of the asset master record number. Reminder about basic navigation: ●
●
Menu path in the FI-AA application: On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets . Menu path to Customizing for FI-AA: On the SAP Easy Access screen, choose Tools → Customizing → IMG → Execute Project . Next, choose the SAP Reference IMG pushbutton and navigate in the SAP Customizing Implementation Guide ( Financial Accounting (New) → Asset Accounting) .
You also need the master records for all subsequent parts of the exercise (asset master records may contain descriptions, such as Drill ##). Note: If no details are provided in the exercise related to what information to enter in an input field (for example, for the cost center or the posting amounts to be used), you can select the entry. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial screen, enter the following data:
© Copyright. All rights reserved.
31
Unit 2: Master Data
Field Name or Data Type
Value
Asset class
3100
Company code
AA##
c) Press ENTER. d) On the Create Asset: Master data screen, enter Forklift Group ## in the Description field. e) Choose the Time-dependent tab page and enter T-F05A## in the Cost center field. f) Save your entries. 2. Create the second master record using your first one as a reference. Name the master record Forklift 2 Group ##. Make a note of the asset master record number. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
Reference area
None
Asset
3410 (number of the asset created in the previous step)
Company code
AA##
c) Press ENTER. d) On the Create Asset: Master data screen, enter Forklift 2 Group ## in the Description field. e) Save your entries. This creates a new asset. 3. Your colleagues from the corporate services department with the cost center T-F05A## need a new photocopier. Create an asset master record in the correct asset class with an appropriate description. Hint: If you do not know which asset class to use, look at the solution.
If necessary, make a note of the asset master record number. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) Use asset class 3000 and enter the data, as described in the exercise text. Task 2
32
© Copyright. All rights reserved.
Solution 10: Create Asset Master Records
The production department will receive five new computers. Create similar asset master records in the appropriate asset class using the quickest method. 1. Create similar asset master records in the appropriate asset class. Enter PC 1 to PC 5 as descriptions. Enter inventory numbers 0001 to 0005 for the PCs, and assign a cost center to the master records. Make a note of the asset master record numbers. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Asset
3200
Number of similar records
5
c) Enter the data as specified in the exercise text initially for the first asset. d) Save your data. e) In the Create multiple assets dialog box, choose the Maintain pushbutton. f) In the Maintain fields that Should Be Different in Similar Assets dialog box, enter PC1 in the Description field and 0001 as Inventory no. in the first row. g) Maintain the other fields and confirm your entries. h) In the Create multiple assets dialog box, choose the Create pushbutton. Task 3 Create the following asset master records in the way that you find easiest. 1. Asset class 1100 for buildings: Two asset master records a) Proceed following the solution to the previous exercise. 2. Asset class 2100 for machines, straight-line: 10 asset master records with the descriptions Machine 01 to Machine 10 and inventory numbers 01 to 10 a) Proceed following the solution to the previous exercise. 3. Asset class 3000 for fixtures and fittings: One fax machine a) Proceed following the solution to the previous exercise. 4. Asset class 3100 for vehicles: Two company cars with the descriptions Company car ## (1) and Company car ## (2) a) Proceed following the solution to the previous exercise. 5. Asset class 4000 for AuC: One AuC, with description AuC, group ## a) Proceed following the solution to the previous exercise. 6. Asset class MA## for your newly created asset class with short text “Special Machines ##”: Three assets with description Special machine 01 to Special machine 03 a) Proceed following the solution to the previous exercise.
© Copyright. All rights reserved.
33
Unit 2: Master Data
7. Optional: Asset class 3005 for LVA in the fixtures and fittings area (individual management): One coffee machine for the office kitchen a) Proceed following the solution to the previous exercise. Task 4 Create a separate asset master record for another company car. As an exercise, create it in the wrong asset class. 1. Create a separate asset master record for another company car. The required data is as follows: Field Name or Data Type
Value
Asset Class
3000
Description
Car 3000 Group ##
Cost Center
T-F05E##
a) Proceed following the solution to the previous exercise. Task 5 Change the asset master record. 1. Change the asset master of your PC 1 in company code AA##. Change the description to Superflux Scenic 4000 Gr. ##. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) Change the description of the asset master record to Superflux Scenic 4000 Gr. ## . c) Save your entries. 2. For the PC Superflux Scenic 4000 Gr. ##, create two more subnumbers, with the descriptions Monitor and Keyboard in a single step. Hint: The subnumber can be assigned internally or externally, depending on how the respective asset class is configured. Because you have to create two subnumbers in one step, asset class 3200 in the training system is set up with an internal subnumber assignment. The distinction or configuration can be displayed on the details screen for an asset class in transaction OAOA . Based on the settings in the relevant screen layout rule, it is possible that data for some of the input fields can only be maintained at an asset main number level. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Subnumber → Asset ( AS11 ). b) Ensure that the Asset field contains the asset number of the correct PC.
34
© Copyright. All rights reserved.
Solution 10: Create Asset Master Records
c) In the Number of similar subnumbers field, enter 2 . d) Press ENTER. e) On the Master data screen, change the description of the subnumber to Monitor . f) Save your data. g) In the Create multiple assets dialog box, choose the Maintain pushbutton. h) In the Maintain Fields that Should Be Different in Similar Assets dialog box, change the description of the second subnumber to Keyboard , and confirm your entry. i) In the Create multiple assets dialog box, choose the Create pushbutton. Task 6 Review the master data you created. 1. View the directory of unposted assets report for your company code to review the master data you created. The report can be found in the FI-AA menu (Information System → Reports on Asset Accounting → Day-to-Day Activities → International) . The technical name of this program is RAANLA_ALV01. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Day-to-Day Activities → International → Directory of Unposted Assets ( S_ALR_87012056 ). b) On the Directory of Unposted Assets screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
Asset Class
Blank
Sort variant
0013
c) Choose the Execute pushbutton. The directory of unposted assets appears.
© Copyright. All rights reserved.
35
Unit 2 Exercise 11 Maintain Time-Dependent Data
Business Example During normal business operations, assets can be transferred from one department to another. The CO department has to track and change the cost center assignment for these assets. Change the time-dependent data. 1. The CO department has changed the cost center assignment for some of its office equipment. The photocopier asset is currently assigned to cost center T-F05A## for corporate services. From June 01 to October 31 of the current year (CY), the photocopier is needed by the Board (cost center T-F05B##). 2. After saving a draft, map the next change for the copier. As of November 1 of the current year, you should return it to the previous department. Change the time-dependent data accordingly. 3. Check the related change documents.
36
© Copyright. All rights reserved.
Unit 2 Solution 11 Maintain Time-Dependent Data
Business Example During normal business operations, assets can be transferred from one department to another. The CO department has to track and change the cost center assignment for these assets. Change the time-dependent data. 1. The CO department has changed the cost center assignment for some of its office equipment. The photocopier asset is currently assigned to cost center T-F05A## for corporate services. From June 01 to October 31 of the current year (CY), the photocopier is needed by the Board (cost center T-F05B##). a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) Enter the asset number for the photocopier you created and confirm it. c) On the Change Asset: Master data screen, choose the Time-dependent tab page in the asset master record. d) Scroll down and then choose the More Intervals pushbutton. e) On the Change Asset: Overview of time intervals screen, choose the Add interval pushbutton. f) In the Create New Interval dialog box, enter June 1, CY. g) In the top row of the table, change the cost center from T-F05A## to T-F05B##. h) Save the changes. i) Go back to the master data screen. 2. After saving a draft, map the next change for the copier. As of November 1 of the current year, you should return it to the previous department. Change the time-dependent data accordingly. a) On the Change Asset: Master data screen, scroll down and choose the More Intervals pushbutton. b) Choose the Add Interval pushbutton. c) In the Create New Interval dialog box, enter November 1, CY. d) In the top row of the table, change the cost center back to T-F05A##. e) Save the changes. f) Go back to the Change Asset: Initial screen .
© Copyright. All rights reserved.
37
Unit 2: Master Data
3. Check the related change documents. a) On the Change Asset: Initial screen , choose Environment → Change documents → On asset. The change document appears.
38
© Copyright. All rights reserved.
Unit 2 Exercise 12 Define the User Fields and Mass Changes of Asset Master Records
Business Example The FI-AA department wants to use mass processing to change asset master records and needs system support. Define the user fields and mass changes of asset master records. Task 1 Define a user field and enter it in the asset class. 1. Maintain a maintenance contract in all assets of asset class MA##. Use the Evaluation group 3 (user) field to store this information. Define the new entry 99## with the description Maint. Contract gr. ## in Customizing for the Evaluation group 3 field. 2. Maintain the new user field option 99## as a default entry for evaluation group 3 in the asset class MA##. This means that all newly created assets of asset class MA## should have the proposal that a maintenance contract is signed. Hint: Confirm the displayed information messages when saving.
3. Verify if the proposal for the Evaluation group 3 field is displayed when you create asset master records in asset class MA##. Do not save a new master record, but verify the proposal on the Allocations tab page and then end the transaction again.
Task 2 Create a mass change rule and execute a mass change. 1. With the previous changes, existing asset master records have not been influenced. Now, you need to change the three existing assets of asset class MA## with a mass change. Therefore, define a new substitution Z## with description Substitution ## and save your data. Insert a new step in which you substitute the Evaluation group 3 field (Table ANLA, Field ORD43) with a constant value. The description of the new step is Step 01 Group ##. 2. Define asset class MA## as a prerequisite. 3. Make the new entry for the evaluation group 3 and save your data. 4. Assign a substitution to the company code.
© Copyright. All rights reserved.
39
Unit 2: Master Data
5. Create a worklist with the name Mass change group ## and the worklist task Change asset w/o dialog (bulk change) with all unposted assets of your company code AA##. Therefore, use the directory of unposted assets report. Note: When the system asks for a substitution, enter the created one Z##. At the end, the system displays a work queue number in the status line. 6. Edit and release your worklist. Use the 0007 sort variant so that you can easily see which assets have to be changed. 7. Verify if the change was successful. Display asset master records with company code AA## of asset class MA## and, for example, of asset classes 2100 and 3100.
40
© Copyright. All rights reserved.
Unit 2 Solution 12 Define the User Fields and Mass Changes of Asset Master Records
Business Example The FI-AA department wants to use mass processing to change asset master records and needs system support. Define the user fields and mass changes of asset master records. Task 1 Define a user field and enter it in the asset class. 1. Maintain a maintenance contract in all assets of asset class MA##. Use the Evaluation group 3 (user) field to store this information. Define the new entry 99## with the description Maint. Contract gr. ## in Customizing for the Evaluation group 3 field. a) Define a 4-character evaluation group in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → User Fields → Define 4-Character Evaluation Groups . b) On the Change View “Evaluation Groups for Asset Accounting”: Overview screen, choose the New Entries pushbutton. c) Enter the following data: Field Name or Data Type
Value
No (Number)
3
Evaluation groups 1-4
99##
Description
Maint. contract gr. ##
d) Press ENTER. e) Save your data. 2. Maintain the new user field option 99## as a default entry for evaluation group 3 in the asset class MA##. This means that all newly created assets of asset class MA## should have the proposal that a maintenance contract is signed. Hint: Confirm the displayed information messages when saving.
© Copyright. All rights reserved.
41
Unit 2: Master Data
a) Enter your user fields in the asset class in Customizing for Financial Accounting (New) under Asset Accounting → Master Data → User Fields → Enter Your User Fields in Asset Class . b) In the Change View “FI-AA: User fields for asset class”: Overview screen, select the asset class MA## and then choose the Details pushbutton. c) Enter 99## in the Evaluation group 3 field. d) Save the changes. e) Confirm the displayed information messages. f) Go back to the SAP Easy Access screen. 3. Verify if the proposal for the Evaluation group 3 field is displayed when you create asset master records in asset class MA##. Do not save a new master record, but verify the proposal on the Allocations tab page and then end the transaction again. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Asset Class
MA##
Company Code
AA##
Number of similar assets
1
c) Press ENTER. d) On the Create Asset: Master data screen, enter Special machine 01 in the Description field. e) Choose the Time-dependent tab page and then enter T-F05A00 in the Cost center field. f) Choose the Allocations tab page and then enter 9900 in the Evaluation group 3 field. g) Go back to the SAP Easy Access screen.
Task 2 Create a mass change rule and execute a mass change. 1. With the previous changes, existing asset master records have not been influenced. Now, you need to change the three existing assets of asset class MA## with a mass change. Therefore, define a new substitution Z## with description Substitution ## and save your data. Insert a new step in which you substitute the Evaluation group 3 field (Table ANLA, Field ORD43) with a constant value. The description of the new step is Step 01 Group ##. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Environment → Mass Change Rule ( OA02 ).
42
© Copyright. All rights reserved.
Solution 12: Define the User Fields and Mass Changes of Asset Master Records
b) Choose the Substitution pushbutton. c) On the Change Substitution: INVKENN (Header data) screen, choose Create from the Substitution menu. d) On the Create Substitution: New substitution (Header data) screen, enter Z## in the Substitution field and enter Substitution ## in the Description field. e) Save the inputs. A new substitution is generated. f) Choose Insert step from the Edit menu. g) In the Substitution fields (Class 033) dialog box, scroll down and then select the line with the description Evaluat.group 3. h) Confirm the selection in the Entering the substitution method dialog box. i) Confirm the dialog box with the Constant value option selected. 2. Define asset class MA## as a prerequisite. a) On the Change Substitution: Z## –Step 001 –Overview screen, enter Step 01 Group ## in the Step field. b) Choose Prerequisite under Step 001 . c) In the List of structures area, double-click Asset Master Record Segment . d) In the Asset Master Record Segment area, double-click Asset Class . e) Choose = from the Status area and then choose the Constant pushbutton. f) In the Enter constants: dialog box, enter MA## in the Asset Class field. g) Confirm your entries. 3. Make the new entry for the evaluation group 3 and save your data. a) Choose Substitutions under Step 001 . b) Enter 99## in the Constant value field for Evaluat. group 3. c) Save your data. d) Go back to the Change View “Substitution in Mass Changes”: Overview screen. 4. Assign a substitution to the company code. a) Choose the New entries pushbutton and enter the following data: Field Name or Data Type
Value
Company Code
AA##
Number
1
Substitution
Z##
b) Save your data. 5. Create a worklist with the name Mass change group ## and the worklist task Change asset w/o dialog (bulk change) with all unposted assets of your company code AA##. Therefore, use the directory of unposted assets report.
© Copyright. All rights reserved.
43
Unit 2: Master Data
Note: When the system asks for a substitution, enter the created one Z##. At the end, the system displays a work queue number in the status line. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Day-to-Day Activities → International → Directory of Unposted Assets ( S_ALR_87012056 ). b) On the Directory of Unposted Assets screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
Asset Class
No entry
Sort variant
0007 (for Company code/Asset class )
c) Choose the Execute pushbutton. d) Choose the Create worklist pushbutton. The Create Worklist: Choose Workflow Task dialog box appears. e) Enter Mass change group OC in WL name and select the Change asset w/o dialog (bulk change) task. f) Confirm your entries. g) In the Mass Change: Select Substitution dialog box, enter Z## in the Substitution field. h) Confirm your entries. The system displays a work queue number in the status line. 6. Edit and release your worklist. Use the 0007 sort variant so that you can easily see which assets have to be changed. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Environment → Worklist → Edit ( AR31 ). b) On the Edit worklist screen, enter 0007 in the Sort Variant field. c) Choose the Execute pushbutton. d) Choose the Release pushbutton. e) Choose the Refresh pushbutton until the status of the asset changes to Completed . 7. Verify if the change was successful. Display asset master records with company code AA## of asset class MA## and, for example, of asset classes 2100 and 3100. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Display → Asset ( AS03 ). b) Display the assets of different asset classes and verify the values on the Allocations tab page.
44
© Copyright. All rights reserved.
Unit 3 Exercise 13 Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer
Business Example The employees in the FI-AA department want to try out the various options for posting both integrated and non-integrated asset acquisitions. Asset transactions can be entered both in the FI-AA user department and in the AP department. Post and analyze an asset acquisition. Task 1 Create a vendor to post an integrated asset acquisition. 1. Create vendor 305## (where ## = your group number) in your company code AA##, so that you can post an integrated asset acquisition. Create the vendor using the Create with reference function in AP and enter the following data: Field Name or Data Type
Value
Vendor
305##
Company Code
AA##
Account group
Do not fill this field
Reference vendor
1000
Reference Company code
1000
Confirm your entries and fill the required fields on the first screen. Then, save your entries.
Task 2 Post and analyze the asset acquisition.
Hint: Use the asset master records that you created in the Master Data unit.
1. For your first forklift, post an acquisition to vendor 305## on January 7, CY (CY = current year). Choose a document type with automatic deduction of discount.
© Copyright. All rights reserved.
45
Unit 3: Asset Transactions
The purchase price you selected must contain the tax on sales and purchases (calculated with the applicable sales tax rate or with the simplified course tax rate of 10% [tax code 1I]). If you do not know which tax code to use, ask your instructor. Make a note of the data displayed after you save. 2. Check the asset values using the Asset Explorer. 3. Explain to your neighbor how you can go from the Asset Explorer to the posted FI document? To which balance sheet asset account (of the general ledger) did the document post? 4. Are you able to display the ordinary depreciation start date of depreciation area 01 (book depreciation) in the Asset Explorer? If so, what is it? 5. Are the planned depreciation values of the forklift the same in depreciation area 01 and area 20 in the current year? 6. In the Asset Explorer, look at how the new acquisition is displayed in the acquisition list. 7. Go from the Asset Explorer to the asset master record and check the changes there.
46
© Copyright. All rights reserved.
Unit 3 Solution 13 Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer
Business Example The employees in the FI-AA department want to try out the various options for posting both integrated and non-integrated asset acquisitions. Asset transactions can be entered both in the FI-AA user department and in the AP department. Post and analyze an asset acquisition. Task 1 Create a vendor to post an integrated asset acquisition. 1. Create vendor 305## (where ## = your group number) in your company code AA##, so that you can post an integrated asset acquisition. Create the vendor using the Create with reference function in AP and enter the following data: Field Name or Data Type
Value
Vendor
305##
Company Code
AA##
Account group
Do not fill this field
Reference vendor
1000
Reference Company code
1000
Confirm your entries and fill the required fields on the first screen. Then, save your entries. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Accounts Payable → Master Records → Create ( FK01 ). b) On the Create Vendor: Initial Screen , enter the following data: Field Name or Data Type
Value
Vendor
305##
Company Code
AA##
Under Reference : Field Name or Data Type
Value
Vendor
1000
© Copyright. All rights reserved.
47
Unit 3: Asset Transactions
Field Name or Data Type
Value
Company Code
1000
a) Choose Enter . b) Go back to the SAP Easy Access screen.
Task 2 Post and analyze the asset acquisition.
Hint: Use the asset master records that you created in the Master Data unit.
1. For your first forklift, post an acquisition to vendor 305## on January 7, CY (CY = current year). Choose a document type with automatic deduction of discount. The purchase price you selected must contain the tax on sales and purchases (calculated with the applicable sales tax rate or with the simplified course tax rate of 10% [tax code 1I]). If you do not know which tax code to use, ask your instructor. Make a note of the data displayed after you save. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → With Vendor ( F-90 ). b) On the Acquisition from purchase w. Vendor: Header Data screen, enter the following data: Field Name or Data Type
Value
Document Date
07.01.CY
Type
KN
Posting Date
07.01.CY
Pstky
31
Account
305##
c) Choose Enter . d) On the Enter Net vendor: Add Vendor item screen, enter the following data:
48
Field Name or Data Type
Value
Amount
55000
Tax code
1I
Calculate tax
Select
PstKy
70
© Copyright. All rights reserved.
Solution 13: Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer
Field Name or Data Type
Value
Account
Asset master record number of forklift 1
TType
100
e) Confirm your entries and continue. Field Name or Data Type
Value
Amount
* (or € 55,000 )
f) Choose Enter . g) On the Enter Net vendor: Add Asset item screen, choose Document → Simulate . h) Save your entries. i) Note down the document number. Document number: _______________ j) Go back to the SAP Easy Access screen. 2. Check the asset values using the Asset Explorer. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, double-click External asset acquisition . c) On the Display Document: Data Entry View screen, select the row for Account 2100 . d) Choose Back . 3. Explain to your neighbor how you can go from the Asset Explorer to the posted FI document? To which balance sheet asset account (of the general ledger) did the document post? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, select Book depreciation in the Depreciation Areas and then select the row for External asset acquisition in Transactions . c) Note down the balance sheet account: _______________ 4. Are you able to display the ordinary depreciation start date of depreciation area 01 (book depreciation) in the Asset Explorer? If so, what is it? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose the Parameters tab page and check the date in the ord.dep.start.date field. c) Select Cost-accounting depreciation in Depreciation and check the date in the ord.dep.start.date field. Solution: The depreciation start date is January 1, current year.
© Copyright. All rights reserved.
49
Unit 3: Asset Transactions
5. Are the planned depreciation values of the forklift the same in depreciation area 01 and area 20 in the current year? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose the Planned values tab page and select Book Depreciation . c) Select the row for APC transaction in Planned values Book depreciation . d) Choose the Comparison tab page, choose the <0 pushbutton and then the 20 pushbutton. The values are not the same because of different depreciation keys and useful lives. 6. In the Asset Explorer, look at how the new acquisition is displayed in the acquisition list. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose Goto → Call up reports . c) In the Select Report dialog box, select Asset Acquisition . d) Choose Continue . 7. Go from the Asset Explorer to the asset master record and check the changes there. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose Goto → Display Master Data . c) Look at the data in the Posting Information groups on the General tab page, the changes on the Origin tab page, and the changes on the Depreciation tab page. d) Choose Back .
50
© Copyright. All rights reserved.
Unit 3 Exercise 14 Create a Fixed Asset and Post Acquisition
Business Example To work in the SAP system, you want to know the possibilities, requirements, and impact of the Segment Reporting item in Customizing for Asset Accounting within your SAP system. Create a fixed asset and post an asset acquisition with the profit center and segment characteristics. 1. Check if Segment Reporting for fixed assets is activated in your client. 2. Create an asset in your company code AA## and asset class 2100 with the description New machine - Group ## and cost center T-F05B## . Verify that the Profit Center and Segment fields are derived and displayed in the asset master data. Save your data. Hint: The profit center is derived from the cost center and the segment is derived from the profit center. To verify this characteristic, use transaction KS03 to display cost center T-F05B## and transaction KE53 to display profit center 1402. 3. Try to change the profit center in the asset you saved in step 2, from 1402 to profit center 1100, and read the long text of the displayed error message. After that, cancel the attempt. 4. For your new asset, New machine - Group ##, try to post an external asset acquisition in your company code AA##, with your vendor, 305##. Specify the document and posting date as January 15 of the current year. The gross acquisition amount is €11,000. Calculate tax with the simplified course tax rate of 10% (tax code 1I). On the screen, the Profit Center field is displayed, but the Profit Center field is initial. Hint: From now on, you can post all asset transactions with profit center and segment information.
Note: If document splitting is activated with Profit Center or Segment as mandatory fields, a posting will be denied.
© Copyright. All rights reserved.
51
Unit 3: Asset Transactions
Hint: Because you do not want to post without profit center and segment, cancel the transaction. 5. Define the account assignment type (APC values posting) for the account assignment objects Profit Center and Segment for your company code AA## and depreciation area 01. 6. Try to post an external asset acquisition in your company code AA## with vendor 305##. Use the document and posting date as January 15 of the current year. The gross acquisition amount is €11,000. Calculate tax with the simplified course tax rate of 10% (tax code 1I). 7. Display the FI document and choose layout /AC_1. The profit center, segment, and business unit information are displayed. 8. Select layout /AC_1 as your default setting. 9. Check the asset values using the Asset Explorer. Is the profit center information displayed?
52
© Copyright. All rights reserved.
Unit 3 Solution 14 Create a Fixed Asset and Post Acquisition
Business Example To work in the SAP system, you want to know the possibilities, requirements, and impact of the Segment Reporting item in Customizing for Asset Accounting within your SAP system. Create a fixed asset and post an asset acquisition with the profit center and segment characteristics. 1. Check if Segment Reporting for fixed assets is activated in your client. a) Check the activation of Segment Reporting in Customizing for Financial Accounting (New) under Asset Accounting → Integration with General Ledger Accounting → Segment Reporting → Activate Segment Reporting . b) On the Change View “Activate Segment Reporting”: Details screen, select Segment Rpting Active . c) Save the data. d) Go back to the Customizing screen. 2. Create an asset in your company code AA## and asset class 2100 with the description New machine - Group ## and cost center T-F05B## . Verify that the Profit Center and Segment fields are derived and displayed in the asset master data. Save your data. Hint: The profit center is derived from the cost center and the segment is derived from the profit center. To verify this characteristic, use transaction KS03 to display cost center T-F05B## and transaction KE53 to display profit center 1402. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Asset Class
2100
Company Code
AA##
c) Choose Enter . d) On the Create Asset: Master data screen, enter New machine-Group## in the Description field. e) Choose the Time-dependent tab page and enter the following data:
© Copyright. All rights reserved.
53
Unit 3: Asset Transactions
Field Name or Data Type
Value
Business Area
9900
Cost Center
T-F05B##
Profit Center
1402
Segment
SERV
f) Save the data. g) Go back to the SAP Easy Access screen. 3. Try to change the profit center in the asset you saved in step 2, from 1402 to profit center 1100, and read the long text of the displayed error message. After that, cancel the attempt. a) On the SAP Easy Access screen, choose Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) Select the asset number of the previous exercise step. c) On the Change Asset: Master data screen, choose the Time-dependent tab page. d) Enter 1100 in the Profit Center field. e) Save the data. f) Read the displayed error message. g) Choose the Cancel pushbutton or press F12. h) Go back to the SAP Easy Access screen. 4. For your new asset, New machine - Group ##, try to post an external asset acquisition in your company code AA##, with your vendor, 305##. Specify the document and posting date as January 15 of the current year. The gross acquisition amount is €11,000. Calculate tax with the simplified course tax rate of 10% (tax code 1I). On the screen, the Profit Center field is displayed, but the Profit Center field is initial. Hint: From now on, you can post all asset transactions with profit center and segment information.
Note: If document splitting is activated with Profit Center or Segment as mandatory fields, a posting will be denied.
Hint: Because you do not want to post without profit center and segment, cancel the transaction.
54
© Copyright. All rights reserved.
Solution 14: Create a Fixed Asset and Post Acquisition
a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → With Vendor ( F-90 ). b) On the Acquisition from purchase.w.vendor: Header Data screen, enter the following data: Field Name or Data Type
Value
Document Date
Current date
Account
305##
Company Code
AA##
Posting date
Current date
PstKy
31
c) Choose Enter . d) On the Enter Vendor invoice: Add Vendor item screen, enter the following data: Field Name or Data Type
Value
Amount
11000
Calculate tax
Select
Tax Code
1I
Pstky
70
Account
Your asset number ####
TType
100
e) Choose Enter . f) On the Enter vendor invoice: Add Asset item screen, enter the following data: Field Name or Data Type
Value
Amount
*
g) Choose Enter . h) On the Enter vendor invoice: Display Overview screen, the Profit Center field is displayed, but the Profit Center field is initial. Because you do not want to post the document, choose Cancel twice or press F12 twice and confirm the Exit Editing dialog box with Yes . Then, press F3 and confirm the Exit Editing dialog box again with Yes . i) Go back to the SAP Easy Access screen. 5. Define the account assignment type (APC values posting) for the account assignment objects Profit Center and Segment for your company code AA## and depreciation area 01. a) Specify the account assignment type for account assignment objects in Customizing for Financial Accounting (New) under Asset Accounting → Integration with General
© Copyright. All rights reserved.
55
Unit 3: Asset Transactions
Ledger Accounting → Additional Account Assignment Objects → Specify Account Assignment Types for Account Assignment objects . b) On the Display View “Company Code”: Overview screen, select the row for AA## in the Company Code area of the dialog structure. c) Double-click Account Assignment Objects in the dialog structure. d) In the Determine Work Area: Entry dialog box, enter 01 in the Depreciation area field. e) Choose the Continue pushbutton. f) On the Change View: “Account Assignment Object”: Overview screen, choose the New Entries pushbutton. g) On the New Entries: Overview of added Entries screen, enter the following data: Acc. Ass. Object
Transaction Type
Acc. Ass Type
Acct-Assignment
Profit Center
*
APC Values Posting
Select
Segment
*
APC Values posting
Select
h) Save the data. i) In the Prompt for Customizing request dialog box, choose the Continue pushbutton. 6. Try to post an external asset acquisition in your company code AA## with vendor 305##. Use the document and posting date as January 15 of the current year. The gross acquisition amount is €11,000. Calculate tax with the simplified course tax rate of 10% (tax code 1I). a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → With Vendor ( F-90 ). b) On the Acquisition from purchase w. vendor: Header Data screen, enter the following data: Field Name or Data Type
Value
Document Date
Current date
Document Type
KR or KN
Company Code
AA##
Posting Date
Current date
Account
305##
Currency/Rate
EUR
PstKy
31
c) Choose Enter . d) On the Enter Vendor invoice: Add vendor item screen, enter the following data and choose Enter :
56
© Copyright. All rights reserved.
Solution 14: Create a Fixed Asset and Post Acquisition
Field Name or Data Type
Value
Amount
11000
Calculate tax
Select
Tax Code
1I
Pstky
70
Account
Your asset number ####
Transaction Type
100
e) On the Enter vendor invoice: Add Asset item screen, enter the following data: Field Name or Data Type
Value
Amount
*
The Profit Center field is now filled with the profit center of the asset master record. f) Choose Document → Simulate . g) On the Enter vendor invoice: Display Overview screen, choose Document → Simulate General Ledger . The profit center is assigned to the asset line. Hint: If the document splitting is active for your company code AA##, all posting lines contain the profit center and segment of the asset master record. h) On the General Ledger Simulation screen, select the row for AA##. i) Choose Back and post the data. 7. Display the FI document and choose layout /AC_1. The profit center, segment, and business unit information are displayed. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → With Vendor ( F-90) . b) On the Acquisition from purchase w. vendor: Header Data screen, choose Document → Display . c) On the Display Document: Data Entry View screen, choose the Layout pushbutton. d) In the Choose layout dialog box, select the row for AC_1 and choose the Continue pushbutton. e) Do not exit the Display Document screen. 8. Select layout /AC_1 as your default setting. a) On the Display Document: Data Entry View screen, choose Manage Layouts . b) On the Layout: Management screen, select the row for AC_1 and choose the Define default Setting column.
© Copyright. All rights reserved.
57
Unit 3: Asset Transactions
c) Post the data. d) Go back to the SAP Easy Access screen. 9. Check the asset values using the Asset Explorer. Is the profit center information displayed? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01 ). b) On the Asset Explorer screen, double-click Administration . c) On the Display Profit Center screen, check the information.
58
© Copyright. All rights reserved.
Unit 3 Exercise 15 Fill Master Data for Segment and Profit Center Reporting
Business Example In the SAP system, you want to fill master data for segment (and profit center) reporting. Fill master data for segment (and profit center) reporting. 1. Post all asset transactions with the profit center and segment. This means that you will have to derive the profit center and segment for the already created or activated assets. Hint: As described earlier, you no longer want to post asset transactions without first having derived the profit center and segment. Furthermore, in practice, the account assignment type (APC values posting) is also maintained for CO objects (for example for the cost center). In this case, an acquisition posting to an asset without an updated profit center or segment is not possible. An easy way to derive the new entities for one asset is to run the transaction code AS02 and maintain the time-dependent data manually. Try to do so for your asset with the description Machine 01 in your company code AA##. 2. Fill master data in one step for all assets using program FAGL_ASSET_MASTERDATA_UPD. Execute this program for your company code AA## first in test mode, and then as a productive run (background execution). Verify the results in the spool lists of the program.
© Copyright. All rights reserved.
59
Unit 3 Solution 15 Fill Master Data for Segment and Profit Center Reporting
Business Example In the SAP system, you want to fill master data for segment (and profit center) reporting. Fill master data for segment (and profit center) reporting. 1. Post all asset transactions with the profit center and segment. This means that you will have to derive the profit center and segment for the already created or activated assets. Hint: As described earlier, you no longer want to post asset transactions without first having derived the profit center and segment. Furthermore, in practice, the account assignment type (APC values posting) is also maintained for CO objects (for example for the cost center). In this case, an acquisition posting to an asset without an updated profit center or segment is not possible. An easy way to derive the new entities for one asset is to run the transaction code AS02 and maintain the time-dependent data manually. Try to do so for your asset with the description Machine 01 in your company code AA##. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) On the Change Asset: Initial Screen , enter the following data: Field Name or Data Type
Value
Asset
Machine 01 asset number
Company Code
AA##
c) Choose Enter . d) On the Change Asset: Master Data screen, choose the Time-dependent tab page. e) Enter 9900 in the Business Area field. f) Choose Enter . g) When asked whether you want to overwrite the existing time-dependent data, choose Yes . The profit center and segment, derived from the cost center, are displayed. h) Save the data. i) Go back to the SAP Easy Access screen.
60
© Copyright. All rights reserved.
Solution 15: Fill Master Data for Segment and Profit Center Reporting
2. Fill master data in one step for all assets using program FAGL_ASSET_MASTERDATA_UPD. Execute this program for your company code AA## first in test mode, and then as a productive run (background execution). Verify the results in the spool lists of the program. a) Fill the master data for segment reporting in Customizing for Financial Accounting (New) under Asset Accounting → Integration with General Ledger Accounting → Segment Reporting → Fill Master Data for Segment Reporting . b) On the Fill Master Data for Segment Reporting screen, enter the following data: Field Name or Data Type
Value
Company Code
AA##
With Cost Object
Select
Text Mode
Select
c) Choose the Execute pushbutton and confirm the warning message with Yes . d) On the Fill Profit Center and Segment screen, analyze the displayed results and verify that the profit center and segment are derived. e) Go back to the Fill Master Data for Segment Reporting screen, and deselect test mode . f) Choose Program → Execute in Background . g) In the Background Print Parameters dialog box, choose LOCL ( LP01 ) in the Output Device field and choose the Continue pushbutton. h) In the Start Time dialog box, choose the Immediate pushbutton and save the data. i) On the Fill Master Data for Segment Reporting screen, choose System → Own Spool Request (to verify the results).
© Copyright. All rights reserved.
61
Unit 3 Exercise 16 Make Various Non-Integrated Asset Acquisition Postings
Business Example As an employee in the asset accounting department, you want to try out the various options for posting non-integrated asset acquisitions in the SAP system. Task 1 Make various non-integrated asset acquisition postings. 1. Post another acquisition, this time with automatic offsetting, to the first of your 10 machine master records with an APC (acquisition and production costs) value of €100,000. 2. Check the asset values. 3. Check the change in the asset master record.
Task 2 For each of the machines 02 to 05, post an external asset acquisition (with automatic offsetting entry). 1. For machines 02 to 05, post APC of €100,000 in the current year. 2. For machines 03 and 04, post APC of €100,000 each for 01.01.PY (PY = previous year) in a single posting. 3. For machine 05, post an APC of €100,000 in the previous year and then subsequent costs of €10,000 in the current year.
Task 3 Post the acquisitions. 1. Post an acquisition in the previous year to your forklift 2. 2. Post an acquisition in the current year to a new asset in class 3100 without first creating an asset master record. That is, create the master record during the acquisition posting.
Task 4 Enter the acquisition (for main numbers and subnumbers) with the automatic offsetting entry in the quickest way.
62
© Copyright. All rights reserved.
Exercise 16: Make Various Non-Integrated Asset Acquisition Postings
1. For PC Superflux Scenic 4000 Gr. ##, you have received an invoice containing the following net amounts: Field Name or Data Type
Value
PC
1000
Monitor
500
Keyboard
20
Enter the acquisition (for main numbers and subnumbers) with the automatic offsetting entry in the quickest way. 2. Analyze all the values of the asset in the Asset Explorer.
Task 5 Post the corrected APC amount of an asset. 1. The asset machine 01 was posted with an incorrect acquisition value. Reverse the document and then post the correct APC amount of €150,000.
Task 6 Optional: This exercise only works if you complete the optional exercises on low-value assets in the previous unit. Post an acquisition with an automatic clearing entry. 1. Post an acquisition of 1,200 for your low-value asset (coffee machine) on 01/07 of the previous year. The system should reject the posting. 2. Retain the posting and document date as 01.07.PY, with a capitalization amount of €800. 3. Check the values in the Asset Explorer. 4. Try a subsequent acquisition on the same low-value asset in the current year, for example, using the current date and an amount of €100. Look at the error message issued when the posting is executed. Post either an integrated or a non-integrated asset acquisition from the solutions of the preceding exercises. During transaction entry, the system issues an error message in the status line. Double-click the error message.
© Copyright. All rights reserved.
63
Unit 3 Solution 16 Make Various Non-Integrated Asset Acquisition Postings
Business Example As an employee in the asset accounting department, you want to try out the various options for posting non-integrated asset acquisitions in the SAP system. Task 1 Make various non-integrated asset acquisition postings. 1. Post another acquisition, this time with automatic offsetting, to the first of your 10 machine master records with an APC (acquisition and production costs) value of €100,000. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) In the Enter a Company Code dialog box, enter AA## in Company Code field and choose Continue . c) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Existing master record of machine number 1
Document Date
Current date
Posting Date
Current date
Amount posted
100,000
d) Choose Extras → Simulate . e) Post the data. f) Note the document number. g) Choose Back. 2. Check the asset values. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, check the asset values in Transactions . c) Do not exit the screen.
64
© Copyright. All rights reserved.
Solution 16: Make Various Non-Integrated Asset Acquisition Postings
3. Check the change in the asset master record. a) On the Asset Explorer screen, select Transaction and then choose Goto → Display Master Data . b) On the Display Asset: Master Data screen, choose the Time-dependent , Allocations , and General tab pages, one by one, and check the data. c) Go back to the SAP Easy Access screen.
Task 2 For each of the machines 02 to 05, post an external asset acquisition (with automatic offsetting entry). 1. For machines 02 to 05, post APC of €100,000 in the current year. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Existing master record of machine number 2
Document Date
Current date
Posting Date
Current date
Amount posted
100,000
c) Choose Extras → Simulate . d) Post the acquisition. e) Note the document number. 2. For machines 03 and 04, post APC of €100,000 each for 01.01.PY (PY = previous year) in a single posting. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, choose the Multiple assets pushbutton. c) Enter the following data: Field Name or Data Type
Value
Asset Value Date
01.01.PY
Document Date
01.01.PY
© Copyright. All rights reserved.
65
Unit 3: Asset Transactions
Field Name or Data Type
Value
Posting Date
01.01.PY
d) In the List of assets table, enter the two asset numbers for machines 03 and machine 04 and the posting amount of €100,000 each. e) Choose the Simulate pushbutton. f) Save your entries. g) Confirm the warning message with yes . 3. For machine 05, post an APC of €100,000 in the previous year and then subsequent costs of €10,000 in the current year. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Asset Value Date
01.01.PY
Document Date
01.01.PY
Posting Date
01.01.PY
Amount posted
100,000
c) Choose the Simulate pushbutton. d) Save your entries. e) Create a separate posting in the same transaction of €10,000 to the same asset with dates in the current year. f) Post the data.
Task 3 Post the acquisitions. 1. Post an acquisition in the previous year to your forklift 2. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data:
66
Field Name or Data Type
Value
Forklift 2
Your asset number ####
© Copyright. All rights reserved.
Solution 16: Make Various Non-Integrated Asset Acquisition Postings
Field Name or Data Type
Value
Asset Value Date
01.01.PY
Document Date
01.01.PY
Posting Date
01.01.PY
Amount posted
100,000
c) Choose Extra → Simulate . d) Save your entry. e) Choose Back . 2. Post an acquisition in the current year to a new asset in class 3100 without first creating an asset master record. That is, create the master record during the acquisition posting. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, select the New Asset radio button. c) Enter the following data: Field Name or Data Type
Value
Description
Large car TDI
Asset Class
3100
Cost Center
T-F05A##
Document Date
Current date
Posting Date
Current date
Amount posted
30,000
d) Choose Extras → Simulate. e) Post your data. f) On the report screen, choose the Display message pushbutton. g) In the Document lines: Display message dialog box, choose the Continue pushbutton. h) Go back to the SAP Easy Access screen.
Task 4 Enter the acquisition (for main numbers and subnumbers) with the automatic offsetting entry in the quickest way. 1. For PC Superflux Scenic 4000 Gr. ##, you have received an invoice containing the following net amounts:
© Copyright. All rights reserved.
67
Unit 3: Asset Transactions
Field Name or Data Type
Value
PC
1000
Monitor
500
Keyboard
20
Enter the acquisition (for main numbers and subnumbers) with the automatic offsetting entry in the quickest way. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, choose the Multiple assets pushbutton and enter the following data: Field Name or Data Type
Value
Asset Value Date
Current date
Document Date
Current date
Posting Date
Current date
Asset
Your asset number ####
c) Choose the Subnumbers pushbutton. The system displays the main number and all subnumbers of the asset in the List of Assets table. d) Enter 1000, 500 and 20 in the Posting Amounts field. e) Choose Extra → Simulate. f) Post your data. g) Choose Back. 2. Analyze all the values of the asset in the Asset Explorer. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, replace the subnumber 0 with an asterisk ( * ) and choose the Enter pushbutton. c) Go back to the SAP Easy Access screen.
Task 5 Post the corrected APC amount of an asset. 1. The asset machine 01 was posted with an incorrect acquisition value. Reverse the document and then post the correct APC amount of €150,000. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Reverse Document → Other Asset Documents ( AB08 ).
68
© Copyright. All rights reserved.
Solution 16: Make Various Non-Integrated Asset Acquisition Postings
b) On the Document for Asset screen, enter the following data: Field Name or Data Type
Value
Asset
Machine 01 asset number
Subnumber
0
c) Choose Enter. d) On the Overview of Asset Accounting Documents screen, select the asset and then choose the Reverse pushbutton. e) In the Specifications for reverse posting dialog box, enter the reversal reason as 01 (reversal in current period). f) Choose the Continue pushbutton. g) Post your data. h) Post an acquisition with an automatic clearing entry as specified in the exercise.
Task 6 Optional: This exercise only works if you complete the optional exercises on low-value assets in the previous unit. Post an acquisition with an automatic clearing entry. 1. Post an acquisition of 1,200 for your low-value asset (coffee machine) on 01/07 of the previous year. The system should reject the posting. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Your asset number ####
Document Date
01.07.PY
Posting Date
01.07.PY
Amount posted
1200
c) Choose Enter . The system rejects this data. 2. Retain the posting and document date as 01.07.PY, with a capitalization amount of €800. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data:
© Copyright. All rights reserved.
69
Unit 3: Asset Transactions
Field Name or Data Type
Value
Existing asset
Your asset number ####
Document Date
01.07.PY
Posting Date
01.07.PY
Amount posted
800
c) Post your data. d) Choose Enter . e) Choose Back . 3. Check the values in the Asset Explorer. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, enter CY-1 in the Fiscal year field and choose Enter . c) Select the row for External asset acquisition in Transactions and choose the Translate Currency amounts pushbutton. d) In the Document Header: AA## Company Code dialog box, choose Continue . e) Go back to the SAP Easy Access screen. 4. Try a subsequent acquisition on the same low-value asset in the current year, for example, using the current date and an amount of €100. Look at the error message issued when the posting is executed. Post either an integrated or a non-integrated asset acquisition from the solutions of the preceding exercises. During transaction entry, the system issues an error message in the status line. Double-click the error message. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Your asset number ####
Document Date
Current date
Posting Date
Current date
Amount posted
100
c) Post the data. d) Double-click the error message. e) Go back to the SAP Easy Access screen.
70
© Copyright. All rights reserved.
Unit 3 Exercise 17 Make Postings Integrated with Materials Management
Optional Exercise Business Example Your asset accounting department plans to use MM functions for asset acquisitions; and, they ask you to test the posting transactions. Hint: Your company code AA## does not have MM integration. Therefore, you should try out the postings in company code 1000. In the following steps below, the logistics process chain purchase order – goods receipt – invoice receipt use the example of a PC acquisition. 1. Create an asset (description: PC 1000 group ##) in company code 1000. Use asset class 3200 (personal computer) and cost center 1000. Write down the asset number _______. Hint: The depreciation areas of the asset in company code 1000 may be structured differently than the depreciation areas in your company code AA##. This is due to the fact that company code 1000 works with another, global-oriented chart of depreciation.
Hint: This step is not necessary if the asset is created in the purchase order transaction (by a logistics employee). In practice, this is seldom done. However, if you do want to use this integration feature, you can use a dummy asset. 2. Create a standard purchase order for the PC. 3. Check the data for your PC by starting the Asset Explorer for this asset. 4. Do you see the PO number immediately? 5. Has a capitalization date been set in the master data for the asset? 6. Post the logistics goods receipt. 7. Check the asset value again by starting the Asset Explorer for the asset.
© Copyright. All rights reserved.
71
Unit 3: Asset Transactions
8. Post an invoice receipt for the above purchase order, using the current date and containing the following (accepted) amounts: Invoice amount (net): €1,995 (Sales) tax amount (10%): €199.50 Invoice amount (gross): €2,194.50 9. Check the asset value again by starting the Asset Explorer for the asset.
72
© Copyright. All rights reserved.
Unit 3 Solution 17 Make Postings Integrated with Materials Management
Optional Exercise Business Example Your asset accounting department plans to use MM functions for asset acquisitions; and, they ask you to test the posting transactions. Hint: Your company code AA## does not have MM integration. Therefore, you should try out the postings in company code 1000. In the following steps below, the logistics process chain purchase order – goods receipt – invoice receipt use the example of a PC acquisition. 1. Create an asset (description: PC 1000 group ##) in company code 1000. Use asset class 3200 (personal computer) and cost center 1000. Write down the asset number _______. Hint: The depreciation areas of the asset in company code 1000 may be structured differently than the depreciation areas in your company code AA##. This is due to the fact that company code 1000 works with another, global-oriented chart of depreciation.
Hint: This step is not necessary if the asset is created in the purchase order transaction (by a logistics employee). In practice, this is seldom done. However, if you do want to use this integration feature, you can use a dummy asset. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial Screen , enter the following data: Field Name or Data Type
Value
Asset Class
3200
Company Code
1000
© Copyright. All rights reserved.
73
Unit 3: Asset Transactions
c) Choose the Enter pushbutton. d) On the Create Asset: Master data screen, choose the general tab page and enter the following data: Field Name or Data Type
Value
Description
PC 1000 group##
e) On the Time-dependent tab page, enter the following data: Field Name or Data type
Value
Cost Center
1000
f) Save your data and go back to the SAP Easy Access screen. 2. Create a standard purchase order for the PC. a) On the SAP Easy Access screen, choose Logistics → Materials Management → Purchasing → Purchase Order → Create → Vendor/Supplying Plant Known ( ME21N ). b) On the Create Purchase Order screen, enter the following data: Field Name or Data Type
Value
Vendor
1000
Doc. Date
Current date
Under Header screen area, Org. Data tab page: Field Name or Data Type
Value
Purchasing organization
1000
Purch. Group
001
Company Code
1000
Under Item Overview screen area:
74
Field Name or Data Type
Value
A (account assignment type)
A
Material
Do not fill
Short text
Purchase order PC Group ##
PO Quantity
1
OUn=order unit
PC
Deliv. Date
Current date + 4days
Net price
2000
Material group
00103 (=Electronics
© Copyright. All rights reserved.
Solution 17: Make Postings Integrated with Materials Management
Field Name or Data Type
Value
Plant
1000 (Plant Hamburg)
c) Choose Enter to go to the Item screen area that opens along with the Account Assignment tab page. d) Enter your asset master record number ___________. e) In the Item screen area, choose the Delivery tab page. f) At the top right of the screen, you can decide whether the goods receipt should be valuated or non-valuated. Do not make any changes, as you want to enter a valuated goods receipt. g) Save your data and note your purchase order document number _______________. h) Go back to the SAP Easy Access screen. 3. Check the data for your PC by starting the Asset Explorer for this asset. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Asset Explorer (AW01N ). 4. Do you see the PO number immediately? a) No, not immediately, but in the screen area Objects related to the asset , you see that a purchase order exists for this asset. b) Double-click the purchase order date that is displayed. The PO screen containing the PO number is displayed. 5. Has a capitalization date been set in the master data for the asset? a) No, because only a purchase order document has been created and no values have been posted. However, the purchase order date is displayed. 6. Post the logistics goods receipt. a) On the SAP Easy Access screen, choose Logistics → Materials Management → Inventory Management → Goods Movement → Goods Receipt → For Purchase Order → PO Number Known ( MIGO ). b) On the Goods Receipt Purchase Order screen, enter your purchase order number at the top of the screen in the third input field from the left. c) If you choose Enter , the goods receipt screen is filled with data from the purchase order. d) Open the Detail data , scroll down to the bottom, and set the OK indicator by selecting Item OK. (This should occur automatically.) e) Choose the Enter pushbutton. f) Choose the Check pushbutton. g) If the document is OK, you can Post or Save it. h) Go back to the SAP Easy Access screen. 7. Check the asset value again by starting the Asset Explorer for the asset.
© Copyright. All rights reserved.
75
Unit 3: Asset Transactions
a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Asset Explorer (AW01N ). 8. Post an invoice receipt for the above purchase order, using the current date and containing the following (accepted) amounts: Invoice amount (net): €1,995 (Sales) tax amount (10%): €199.50 Invoice amount (gross): €2,194.50 a) On the SAP Easy Access screen, choose Logistics → Materials Management → Logistics Invoice Verification → Document Entry → Enter Invoice ( MIRO ). b) On the Enter incoming Invoice: Company Code 1000 screen, enter the current date as the invoice and posting date. The amount field remains empty, initially. c) Look at the lower part of the screen/lower table and enter your purchase order number to the right of the entry field Purchase Order/Scheduling Agreement . d) When you choose Enter , the relevant amounts are copied from the purchase order to the MIGO screen. e) Does the net order amount, displayed on the screen, agree with the accepted net order amount above? Change the amount in the row marked in yellow to the net invoice price (€1,995) in the Amount column. f) Choose Enter . Now have the system check whether the vendor has included the correct tax on the invoice. First, check (at the top of the screen) whether the correct tax code, 1I has been set. g) Select the Calculate tax indicator. The system should display a tax amount next to this indicator on the left. Even if the tax amount is correct, only the gross invoice amount is still missing. At the top right, you will see the gross invoice amount displayed as a balance next to the red traffic light. Does this amount agree with the amount in the invoice above? If so, the invoice check is complete. h) Enter the gross invoice amount 2194.50 at the top of the screen in the Amount field. i) Post your data. j) Go back to the SAP Easy Access screen. 9. Check the asset value again by starting the Asset Explorer for the asset. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset → Asset Explorer (AW01N ). You will see another transaction that reduces the capitalization amount of the asset by €5.
76
© Copyright. All rights reserved.
Unit 3 Exercise 18 Post Integrated Asset Retirements with Accounts Receivable (AR)
Business Example To be able to use the SAP component FI-AA, you want to learn and test the various options for posting asset retirement. Task 1 Machine 03 is to be sold (completely) on July 01 of the current year. 1. Create customer 305## (## = your group number) in your company code AA## so that you can post an integrated asset retirement. Create the customer using the Create with Reference function in AR, and use the following data: Field Name or Data Type
Value
Account group
Leave as selected (No changes)
Customer
305##
Company code
AA##
Reference customer
1000
Reference company code
1000
Using your own judgment, enter data in the required fields on the first screen (for example, you can choose 0000000001 [North region] as the transport zone) and then save your entries. 2. Post an integrated complete retirement for machine 03 (value date: July 1, Current Year (CY)). You gain a sales price/sales revenue of €10,000 (net). Calculate the gross sales price using the selected output tax key. Note: If you want to work with an output tax of 10%, use tax key 1O (in words: one O, not one zero).
Hint: The Revenue from asset retirement account has the number 820000 in the chart of accounts you are using. 3. Display the asset retirement on the Asset Explorer.
© Copyright. All rights reserved.
77
Unit 3: Asset Transactions
4. How are the values of the assets sold displayed in the asset history sheet?
Task 2 Part (60%) of a second asset (machine 04) should be sold. Post the integrated retirement in the current year, and check the asset values in the Asset Explorer. 1. Post the (integrated) retirement in the current year, and enter a revenue or sales price of your choice. 2. Check the posting document, the changes in the asset master record, and the asset values in the Asset Explorer.
Task 3 The production department wants to scrap PC 02. 1. Post an asset acquisition to this asset in the previous year (PY). 2. Post the asset retirement without revenue in the current year. 3. Check the posting document, the change in the asset master record, and the asset values. Has the asset been deactivated?
78
© Copyright. All rights reserved.
Unit 3 Solution 18 Post Integrated Asset Retirements with Accounts Receivable (AR)
Business Example To be able to use the SAP component FI-AA, you want to learn and test the various options for posting asset retirement. Task 1 Machine 03 is to be sold (completely) on July 01 of the current year. 1. Create customer 305## (## = your group number) in your company code AA## so that you can post an integrated asset retirement. Create the customer using the Create with Reference function in AR, and use the following data: Field Name or Data Type
Value
Account group
Leave as selected (No changes)
Customer
305##
Company code
AA##
Reference customer
1000
Reference company code
1000
Using your own judgment, enter data in the required fields on the first screen (for example, you can choose 0000000001 [North region] as the transport zone) and then save your entries. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Accounts Receivable → Master Records → Create ( FD01 ). b) In the Customer Create: Initial Screen dialog box, enter the following data: In Account group : Field Name or Data Type
Value
Customer
305##
Company Code
1000
In Reference : Field Name or Data Type
Value
Customer
1000
© Copyright. All rights reserved.
79
Unit 3: Asset Transactions
Field Name or Data Type
Value
Company Code
1000
c) Choose the Continue pushbutton. d) Save your data. e) Go back to the SAP Easy Access screen. 2. Post an integrated complete retirement for machine 03 (value date: July 1, Current Year (CY)). You gain a sales price/sales revenue of €10,000 (net). Calculate the gross sales price using the selected output tax key. Note: If you want to work with an output tax of 10%, use tax key 1O (in words: one O, not one zero).
Hint: The Revenue from asset retirement account has the number 820000 in the chart of accounts you are using. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Retirement → Retirement w/revenue → With Customer ( F-92 ). b) On the Asset Retire. frm Sale w/Customer: Header Data screen, enter the following data and choose Enter : Field Name or Data Type
Value
Document Date
01.07.CY
Posting Date
01.07.CY
Period
7
Account
305##
Type
DR
Company Code
AA##
Currency/Rate
EUR
PstKy
01
c) Confirm your entries and press Continue pushbutton. d) On the Enter Customer invoice: Add Customer item screen, enter the following data and choose Enter :
80
Field Name or Data Type
Value
Amount
11000
© Copyright. All rights reserved.
Solution 18: Post Integrated Asset Retirements with Accounts Receivable (AR)
Field Name or Data Type
Value
Calculate Tax
Select
Tax Code
10
e) Confirm your entries and press Continue pushbutton. f) On the Enter Customer invoice: Correct Customer item screen, enter the following data and choose Enter : Field Name or Data Type
Value
PstKy
50
Account
820000
g) On the Enter Customer invoice: Add G/L account item screen, enter * in the Amount field and select Asset retirement . h) Choose Enter . i) In the Create Asset Retirement dialog box, enter the following data and choose the Continue pushbutton: Field Name or Data Type
Value
Asset
The value may vary
Asset value date
01.07.CY
Complete retirement
Select
j) Choose Document → Simulate . k) Save the data and go back to the SAP Easy Access screen. 3. Display the asset retirement on the Asset Explorer. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, double-click Retirement of current-year acquis. with revenue . c) On the Display Document: Data Entry View screen, choose the Display Document Header pushbutton. d) In the Document Header: AA## Company Code dialog box, choose the Continue pushbutton. e) Go back to the SAP Easy Access screen. 4. How are the values of the assets sold displayed in the asset history sheet? a) Enter the transaction code AW01 . b) On the Asset Explorer screen, choose Goto → Call up reports . c) In the Select Report dialog box, double-click the Asset History Sheet report to select it.
© Copyright. All rights reserved.
81
Unit 3: Asset Transactions
d) Go back to the SAP Easy Access screen.
Task 2 Part (60%) of a second asset (machine 04) should be sold. Post the integrated retirement in the current year, and check the asset values in the Asset Explorer. 1. Post the (integrated) retirement in the current year, and enter a revenue or sales price of your choice. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Retirement → Retirement w/revenue → With Customer ( F-92 ). b) On the Asset Retire. frm Sale w/Customer: Header Data screen, enter the following data and choose Enter : Field Name or Data Type
Value
Document Date
01.07.CY
Posting Date
01.07.CY
Period
7
Account
305##
Type
DR
Currency/ Rate
EUR
c) On the Enter Customer invoice: Add Customer item screen, enter the following data: Field Name or Data Type
Value
Amount
11000
Calculate Tax
Select
Tax Code
10
PstKy
50
Account
820000
d) Choose Enter . e) On the Enter Customer invoice: Add G/L account item screen, enter * in the Amount field and select Asset retirement and choose Enter . f) In the Create Asset Retirement dialog box, enter the following data:
82
Field Name or Data Type
Value
Asset
The value may vary
Asset value date
01.07.CY
© Copyright. All rights reserved.
Solution 18: Post Integrated Asset Retirements with Accounts Receivable (AR)
Field Name or Data Type
Value
Percentage rate
60
g) Choose the Continue pushbutton. h) Choose Document → Simulate . i) Save your data and go back to the SAP Easy Access screen. 2. Check the posting document, the changes in the asset master record, and the asset values in the Asset Explorer. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, select the row for 60,000,00 in the Transaction field. c) Choose Goto → Call up reports . d) In the Select Report dialog box, select the Asset History Sheet and choose the Continue pushbutton. e) Go back to the SAP Easy Access screen.
Task 3 The production department wants to scrap PC 02. 1. Post an asset acquisition to this asset in the previous year (PY). a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Asset
The value may vary
Document Date
01.07.PY
Posting Date
01.07.PY
Amount Posted
10000
Use help to find out your PC 02 asset. Hint: If you cannot find PC 02 initially when using help, remember that it may be because only the last 10 assets edited are displayed. If so, you can use the All Values pushbutton to display all master records. c) Post your data.
© Copyright. All rights reserved.
83
Unit 3: Asset Transactions
d) Choose Enter . e) Go back to the SAP Easy Access screen. 2. Post the asset retirement without revenue in the current year. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Retirement → Asset Retirement by Scrapping ( ABAVN ). b) On the Enter Asset Transaction: Asset Retirement by Scrapping screen, enter the following data: Field Name or Data Type
Value
Asset
PC02
Document Date
Current date
Asset Value Date
Current date
Posting Date
Current date
c) Post your data. d) Go back to the SAP Easy Access screen. 3. Check the posting document, the change in the asset master record, and the asset values. Has the asset been deactivated? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, double-click PC2 in Equipment . On the Display Equipment: Organization screen, you will notice that the asset is deactivated. c) Choose Back . d) On the Asset Explorer screen , select the row for Retirement without revenue . e) Choose Goto → Call up reports . f) In the Select Report dialog box, select Asset History Sheet and choose the Continue pushbutton. g) Go back to the SAP Easy Access screen.
84
© Copyright. All rights reserved.
Unit 3 Exercise 19 Transfer Assets Within Company Code
Business Example As part of your job, you need to transfer an asset within a company code because an incorrect asset class was selected earlier. Task 1 Transfer an asset within a company code. 1. When you created an asset master record for a company car ( CAR 3000 group ## ) you made a mistake and created it in the wrong asset class (exercise in the Master Data unit). Assumption: You still do not identify the mistake. Post €60,000 (net) to this master record for January of the previous year.
Task 2 Now, you have noticed your error and would like to transfer the asset to a (new) asset master record in the correct asset class (asset class 3100). 1. Create a (new) master record in asset class Vehicles (asset class 3100) of your company code AA## with the description Car 3100 Group ## and cost center T-F05E##. Make a note of the asset number. Field transfers allow you to copy data from the old master record to the entry fields of the new master record. Typically, the system uses the (acquisition) transaction type to control how the depreciation start date is copied into the new master record. 2. Post a (complete) transfer within company code of your Car 3000 Group ## asset to the new master record (Car 3100 Group ##). Enter the current date as the posting and document date. Caution: The system should calculate the correct depreciation for the complete current year. Therefore, set the asset value date to January 01, current year (CY). 3. Display the asset values of both assets and check the posting and asset value dates. In the new asset, also check the Original asset field (on the Origin tab page) and the useful life. Result: An expired useful life of one year must be displayed. The remaining useful life is four years. From the Asset Explorer, go to the master record for the (new) asset and display the Origin tab page. Result: You should see the asset number of the original asset (of asset class 3000).
© Copyright. All rights reserved.
85
Unit 3 Solution 19 Transfer Assets Within Company Code
Business Example As part of your job, you need to transfer an asset within a company code because an incorrect asset class was selected earlier. Task 1 Transfer an asset within a company code. 1. When you created an asset master record for a company car ( CAR 3000 group ## ) you made a mistake and created it in the wrong asset class (exercise in the Master Data unit). Assumption: You still do not identify the mistake. Post €60,000 (net) to this master record for January of the previous year. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Asset number created in the wrong asset class
Document Date
20.01.PY
Posting Date
20.01.PY
Amount posted
60,000
c) Choose Extras → Simulate . d) Save your data and choose Enter . e) Go back to the SAP Easy Access screen.
Task 2 Now, you have noticed your error and would like to transfer the asset to a (new) asset master record in the correct asset class (asset class 3100). 1. Create a (new) master record in asset class Vehicles (asset class 3100) of your company code AA## with the description Car 3100 Group ## and cost center T-F05E##. Make a note of the asset number.
86
© Copyright. All rights reserved.
Solution 19: Transfer Assets Within Company Code
Field transfers allow you to copy data from the old master record to the entry fields of the new master record. Typically, the system uses the (acquisition) transaction type to control how the depreciation start date is copied into the new master record. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Create → Asset ( AS01 ). b) On the Create Asset: Initial Screen , enter the following data: Field Name or Data Type
Value
Asset Class
3100
Company Code
AA##
c) Choose Enter . d) On the Create Asset: Master data screen, enter the following data: Field Name or Data Type
Value
Description
Car 3100 Group ##
e) Click the Time-dependent tab page, enter the following data: Field Name or Data Type
Value
Cost Center
T-F05E##
f) Save your data. g) Go back to the SAP Easy Access screen. 2. Post a (complete) transfer within company code of your Car 3000 Group ## asset to the new master record (Car 3100 Group ##). Enter the current date as the posting and document date. Caution: The system should calculate the correct depreciation for the complete current year. Therefore, set the asset value date to January 01, current year (CY). a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Transfer → Transfer within Company Code ( ABUMN ). b) On the Enter Asset Transaction: Transfer within Company Code screen, enter the following data: Field Name or Data Type
Value
Asset
Asset number created in the wrong asset class
Document Date
Current date
Posting Date
Current date
© Copyright. All rights reserved.
87
Unit 3: Asset Transactions
Field Name or Data Type
Value
Asset Value Date
01.01.CY
Existing asset
Select the asset created in the previous step (asset class 3100)
c) Choose the Switch on Simulation pushbutton. Look at the value adjustment. Is the depreciation of the previous year corrected completely? Answer: Yes. If you have defined the posting amounts and data in accordance with the exercise, you see a value adjustment of €20,000 in the document simulation, and this adjustment is adopted by the new class 3100 master record. d) On the Enter Asset Transaction: Transfer within Company Code screen, check the values. e) Save your data. f) Go back to the SAP Easy Access screen. 3. Display the asset values of both assets and check the posting and asset value dates. In the new asset, also check the Original asset field (on the Origin tab page) and the useful life. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, double-click the row for 60,000,00 in Transactions . c) On the Display Document: Data Entry view screen, check the Posting Date and Document Date . d) Go back to the Asset Explorer screen and go to the Parameters tab page for your (new) asset in class 3100. Result: An expired useful life of one year must be displayed. The remaining useful life is four years. From the Asset Explorer, go to the master record for the (new) asset and display the Origin tab page. Result: You should see the asset number of the original asset (of asset class 3000).
88
© Copyright. All rights reserved.
Unit 3 Exercise 20 Post Intercompany Asset Transactions (Within One Company)
Business Example As part of your job, you need to perform intracompany asset transactions between company codes belonging to one company. 1. Assumption: Your corporate group has several small units that are mapped using different company codes but are defined (in Customizing) as belonging to the same (global) company (1000). You want to move the company car you created (Car 3100 Group##) from company code AA## to your trainers company code (usually AA00)..
Note: If your trainer does not work with company code AA00, you must use a different target company code and target cost center as appropriate in the following exercise. Therefore, you must transfer the asset from your company code AA## to company code AA00.
Caution: Carry out a transfer using the gross variant and, when doing so, create a new asset master record in the new company code AA00 with cost center TF05E00. Use the following data: Field Name or Data Type
Value
Document Date
23.12.CY
Posting Date
23.12.CY
Asset Value Date
23.12.CY
Transfer variant(Additional Details tab page)
1
Description of the asset to be created in the Car company code AA00/Gr.## transfer transaction in company code AA00 Cost center for new asset in company code AA00
© Copyright. All rights reserved.
T-F05E00
89
Unit 3: Asset Transactions
Hint: The standard SAP system assumes that in the case of a transfer of relationship type 2 (transfer within a company), revenue is not posted. If you think otherwise and want to implement a different model, you can use a user exit. 2. Access Asset Explorer for the transferred asset from your company code AA## (asset Car 3100 Group ##). Note: The system always shows you the most recently edited asset in the Asset Explorer. This asset is the asset in company code AA00 . Go back to your company code AA## . Which transaction type was used? 3. Display the transfer’s FI document. 4. To view both documents of the transfer, call up the cross-company (document) number.
90
© Copyright. All rights reserved.
Unit 3 Solution 20 Post Intercompany Asset Transactions (Within One Company)
Business Example As part of your job, you need to perform intracompany asset transactions between company codes belonging to one company. 1. Assumption: Your corporate group has several small units that are mapped using different company codes but are defined (in Customizing) as belonging to the same (global) company (1000). You want to move the company car you created (Car 3100 Group##) from company code AA## to your trainers company code (usually AA00)..
Note: If your trainer does not work with company code AA00, you must use a different target company code and target cost center as appropriate in the following exercise. Therefore, you must transfer the asset from your company code AA## to company code AA00.
Caution: Carry out a transfer using the gross variant and, when doing so, create a new asset master record in the new company code AA00 with cost center TF05E00. Use the following data: Field Name or Data Type
Value
Document Date
23.12.CY
Posting Date
23.12.CY
Asset Value Date
23.12.CY
Transfer variant(Additional Details tab page)
1
Description of the asset to be created in the Car company code AA00/Gr.## transfer transaction in company code AA00 Cost center for new asset in company code AA00
© Copyright. All rights reserved.
T-F05E00
91
Unit 3: Asset Transactions
Hint: The standard SAP system assumes that in the case of a transfer of relationship type 2 (transfer within a company), revenue is not posted. If you think otherwise and want to implement a different model, you can use a user exit. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Transfer → Intercompany Asset Transfer ( ABT1N ). b) On the Enter Asset Transaction: Intercompany Asset Transfer screen, enter the following data: Field Name or Data Type
Value
Asset
Your asset number ####
Document Date
23.12.CY
Posting Date
23.12.CY
Asset Value Date
23.12.CY
Company Code
AA##
c) Select the New Asset radio button and choose the Master Data pushbutton to enter data for the new asset to be created in company code AA00. d) In the Create Asset dialog box, enter the following data: Field Name or Data Type
Value
Asset class
3100
Description
Car company code AA00/Gr.
Cost Center
T-F05E00
e) Choose the Continue pushbutton. f) Choose Extras → Simulate . g) On the Enter Asset Transaction: Intercompany Asset transfer screen, check the values and save your data. h) In the Document lines: Display message dialog box, the last message shows you the new asset number in company code AA00 . i) Choose the Continue pushbutton. 2. Access Asset Explorer for the transferred asset from your company code AA## (asset Car 3100 Group ##).
92
© Copyright. All rights reserved.
Solution 20: Post Intercompany Asset Transactions (Within One Company)
Note: The system always shows you the most recently edited asset in the Asset Explorer. This asset is the asset in company code AA00 . Go back to your company code AA## . Which transaction type was used? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, enter the following data: Field Name or Data Type
Value
Asset
Your asset number ####
Company Code
AA##
Fiscal year
CY
c) Choose Enter . You now see two transactions on the Planned Values tab page. The second transaction is the transfer. d) Do not exit the screen. Answer: Transaction type 300 was used for the transfer. 3. Display the transfer’s FI document. a) On the Asset Explorer screen, select the row for 300 ( TType ) and then double-click. b) On the Display Document: Data entry view screen, check the transferred data. c) Do not exit the screen. 4. To view both documents of the transfer, call up the cross-company (document) number. a) Double-click the cross-company (document) number, visible in the document header.
© Copyright. All rights reserved.
93
Unit 3 Exercise 21 Post Intercompany Asset Transfer (Across Company Boundaries)
Business Example As part of your job, you need to transfer an asset to another company, which is legally independent (across company ID boundaries). Intercompany asset transfer between legally independent companies (across company ID boundaries). 1. Another driver of a company car in your company code AA## moves to company code AA31 (company ID AC305 ) and takes the car along. First, post an acquisition with a value of €50,000 (net) to one of your previously unposted company cars on January 01, PY. 2. After 2 years of use in your company code AA##, the asset is to be transferred to company code AA31, on December 31, CY. Since both company codes are legally independent, a sale price is also agreed upon. It is €30,000, the net book value of the asset after two years use. In the new company code AA31, the asset is depreciated for further three years. Carry out the transfer using the following data: Field Name or Data Type
Value
Value Date
31.12.CY
Document Date
31.12.CY
Posting Date
31.12.CY
Specifications for revenue
Net book value from area 01
Transfer to company code
AA31
Transfer variant (see Additional Details tab page)
7
Create (in the intercompany transfer trans- Yes action) the new asset in company code AA31 and use the sending asset as reference: Cost center in company code AA31
94
T-F05A31
© Copyright. All rights reserved.
Exercise 21: Post Intercompany Asset Transfer (Across Company Boundaries)
Note: Transfer variant 7 is also one of the standard transfer variants supplied by SAP. It is effectively the gross equivalent of transfer variant 2, but depreciations are calculated correctly on the sending and receiving sides, even in the case of mid-year transfers. This is not automatically the case for transfer variant 2. 3. Display the values of both assets in the Asset Explorer. Analyze the transactions and both FI documents. Display also the cross-company number. 4. Display the Transaction Type and Trading Partner fields (technical filed name ANBWA and VBUND) by changing the layout in the cross-company number display.
© Copyright. All rights reserved.
95
Unit 3 Solution 21 Post Intercompany Asset Transfer (Across Company Boundaries)
Business Example As part of your job, you need to transfer an asset to another company, which is legally independent (across company ID boundaries). Intercompany asset transfer between legally independent companies (across company ID boundaries). 1. Another driver of a company car in your company code AA## moves to company code AA31 (company ID AC305 ) and takes the car along. First, post an acquisition with a value of €50,000 (net) to one of your previously unposted company cars on January 01, PY. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Your existing asset
Document Date
01.01.PY
Posting Date
01.01.PY
Asset Value Date
01.01.PY
Amount posted
50,000
c) Choose Extras → Simulate . d) Save your data and choose Enter . e) Go back to the SAP Easy Access screen. 2. After 2 years of use in your company code AA##, the asset is to be transferred to company code AA31, on December 31, CY. Since both company codes are legally independent, a sale price is also agreed upon. It is €30,000, the net book value of the asset after two years use. In the new company code AA31, the asset is depreciated for further three years. Carry out the transfer using the following data:
96
Field Name or Data Type
Value
Value Date
31.12.CY
© Copyright. All rights reserved.
Solution 21: Post Intercompany Asset Transfer (Across Company Boundaries)
Field Name or Data Type
Value
Document Date
31.12.CY
Posting Date
31.12.CY
Specifications for revenue
Net book value from area 01
Transfer to company code
AA31
Transfer variant (see Additional Details tab page)
7
Create (in the intercompany transfer trans- Yes action) the new asset in company code AA31 and use the sending asset as reference: Cost center in company code AA31
T-F05A31
Note: Transfer variant 7 is also one of the standard transfer variants supplied by SAP. It is effectively the gross equivalent of transfer variant 2, but depreciations are calculated correctly on the sending and receiving sides, even in the case of mid-year transfers. This is not automatically the case for transfer variant 2. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Intercompany Asset Transfer ( ABTIN ). b) In the Enter a Company Code dialog box, enter AA## in the Company Code field and choose the Continue pushbutton. c) On the Enter Asset transactions: Intercompany Asset Transfer screen, enter the following data: Field Name or Data Type
Value
Asset
Your existing asset
Document Date
31.12.CY
Posting Date
31.12.CY
Asset value date
31.12.CY
d) Select the Rev.from NBV radio button and enter 01 in the Depreciation area field. e) Enter AA31 in the Company Code field, and select the New asset radio button. f) Choose the Master data pushbutton, in the Create Asset dialog box, enter T-F05A31 in the cost center field and choose the Continue pushbutton. g) Choose Extras → Simulate , on the Enter Asset transaction: Intercompany Asset transfer screen, check the value.
© Copyright. All rights reserved.
97
Unit 3: Asset Transactions
Note: The value adjustment should be corrected by 20000 on the source asset and net book value of the new asset in company code AA31 is 30000 on 31.12.CY. h) Save the data. i) In the Document lines: Display messages dialog box, note down the asset number created for company code AA31, and choose the Continue pushbutton. 3. Display the values of both assets in the Asset Explorer. Analyze the transactions and both FI documents. Display also the cross-company number. a) Enter the transaction code AW01 . b) On the Asset Explorer screen, enter the following data: Field Name or Data Type
Value
Company Code
AA31
Asset
New asset created in company code AA31
Fiscal year
CY
c) Choose Enter . d) Double-click the row in Transaction . e) On the Display Document: Data Entry View screen, check the cross-company number. f) Do not exit the screen. 4. Display the Transaction Type and Trading Partner fields (technical filed name ANBWA and VBUND) by changing the layout in the cross-company number display. a) On the Display Document: Data Entry View screen, choose the Change Layout pushbutton. b) In the Change layout dialog box, select the row for transact.type in Column Set and transfer in to (left-hand) table Displayed Columns . c) Select the row for Trading Partner and transfer into (left-hand) table Displayed Columns . d) Choose the Copy pushbutton. e) Choose Back .
98
© Copyright. All rights reserved.
Unit 3 Exercise 22 Create and Post to an Asset Under Construction (AuC) and Settle It to Completed Assets
Business Example You work in the asset accounting department, and want to demonstrate a settlement for the AuC without integrating the IM. Post, distribute, and settle an AuC. 1. Assign a settlement profile to your company code AA##. SAP provides standard settlement profile AI. 2. Post three acquisitions for the previous and current year to your master record in the class AuC (asset class 4000) in your company code AA##. Hint: If you have not created a class 4000 asset in the exercise part at the beginning of the course where asset master records were created, you can do so now. Depending on your personal value list, your master record in class 4000 does not directly display in the help. Enter the following acquisitions on the AuC and ensure that the posting, document, and asset value dates are correct: Jan 1, PY
10,000
Posting Text: Acquisition 1
Oct 1, PY
60,000
Posting Text: Acquisition 2
Feb 1, CY
35,000
Posting Text: Acquisition 3
3. Look at your AuC in the Asset Explorer and view the transactions in the previous and current years. 4. Distribute the acquisition of €60,000 completely to the (completed) asset of Machine 07. Distribute and settle the other two acquisitions to the AuC as follows: 70% to the asset of Machine 08 and 30% to the asset Machine 09.
© Copyright. All rights reserved.
99
Unit 3: Asset Transactions
Hint: You can enter the current date as the settlement date if the course is not being held in January. If the course is being held in January, use the settlement date February 18, CY. Always start an update run after the test run. Select the SAP standard layout in the line item list of the distribute transaction. Your posting texts display. 5. Call the Asset Explorer for the AuC. Has the AuC been credited completely? Is the same transaction type used for all credit transactions? If not, why? 6. Look at the values of your assets of Machine 07 to Machine 09 in the Asset Explorer and in the asset history sheet. How do the values display in the asset history sheet?
100
© Copyright. All rights reserved.
Unit 3 Solution 22 Create and Post to an Asset Under Construction (AuC) and Settle It to Completed Assets
Business Example You work in the asset accounting department, and want to demonstrate a settlement for the AuC without integrating the IM. Post, distribute, and settle an AuC. 1. Assign a settlement profile to your company code AA##. SAP provides standard settlement profile AI. a) Assign a settlement profile in Customizing for Financial Accounting (New) under Asset Accounting → Transactions → Capitalization of Assets under Construction → Define/ Assign Settlement Profiles . b) In the Choose Activity dialog box, select Assign Settlement Profile to Company Code and choose the choose pushbutton. c) On the Change View “FI-AA: Settlement profile”: Overview screen, choose the Position pushbutton. d) In the Another Entry dialog box, enter AA## as the company code and choose the Continue pushbutton. e) Enter AI (settlement AuC) in your company code AA## . f) Save the data. g) Go back to the Customizing screen. 2. Post three acquisitions for the previous and current year to your master record in the class AuC (asset class 4000) in your company code AA##. Hint: If you have not created a class 4000 asset in the exercise part at the beginning of the course where asset master records were created, you can do so now. Depending on your personal value list, your master record in class 4000 does not directly display in the help. Enter the following acquisitions on the AuC and ensure that the posting, document, and asset value dates are correct: Jan 1, PY
© Copyright. All rights reserved.
10,000
Posting Text: Acquisition 1
101
Unit 3: Asset Transactions
Oct 1, PY
60,000
Posting Text: Acquisition 2
Feb 1, CY
35,000
Posting Text: Acquisition 3
a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). Carry out the three acquisitions to the AuC consecutively, in accordance with the exercise text, and fill out the entry field text in the posting transaction. b) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Existing asset
Your asset number ####
Document Date
01.01.PY
Posting Date
01.01.PY
Asset Value Date
01.01.PY
Amount posted
10,000
Text
Acquisition 1
c) Choose Extra → Simulate . d) Save the data and choose Enter . e) Similarly, create the other two acquisitions. f) Go back to the SAP Easy Access screen. 3. Look at your AuC in the Asset Explorer and view the transactions in the previous and current years. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). To view the acquisitions of the previous year, select the previous fiscal year in the entry field Fiscal Year . b) On the Display Document: Data Entry View screen, choose the Display Document Header pushbutton. c) In the Document Header: AA## Company Code dialog box, choose the Continue pushbutton. d) On the Display Document: Data Entry View screen, choose the Display Document Header pushbutton. e) In the Document Header: AA## Company Code dialog box, choose the Continue pushbutton. f) Go back to the Asset Explorer screen, and select CY in the Fiscal Year field. g) Repeat the previous steps.
102
© Copyright. All rights reserved.
Solution 22: Create and Post to an Asset Under Construction (AuC) and Settle It to Completed Assets
The AuC has now been completely posted. You can distribute and capitalize the acquisitions. 4. Distribute the acquisition of €60,000 completely to the (completed) asset of Machine 07. Distribute and settle the other two acquisitions to the AuC as follows: 70% to the asset of Machine 08 and 30% to the asset Machine 09. Hint: You can enter the current date as the settlement date if the course is not being held in January. If the course is being held in January, use the settlement date February 18, CY. Always start an update run after the test run. Select the SAP standard layout in the line item list of the distribute transaction. Your posting texts display. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Capitalize Asset u. Construction → Distribute ( AIAB ). b) On the Settlement AuC: Initial Screen, choose the Execute pushbutton. c) On the Settlement AuC: Line Items list screen, choose the Settings → Layout → Choose from the menu bar. In the Choose Layout dialog box, select the row for 3SAP . d) Select the row for 60,000 , and choose Edit → Enter Distribution Rules . e) On the Maintain Settlement Rules: Overview screen, enter the asset number of Machine 07 in the settlement receiver field, choose Enter , and then choose Back . f) On the Settlement AuC: Line Items list screen, Acquisition 2 now appears with a green traffic light. Select the other two acquisitions using the CTRL key. Select Edit → Enter Distribution Rules again . g) On the Maintain Settlement Rules: Overview screen, enter the asset number of Machine 08 ( 70% ) and Machine 09 ( 30% ) in the settlement receiver field. Choose Enter . Choose Back and save your data. h) On the Settlement AuC: Line Items list screen, choose Environment → Execute Settlement . i) On the AuC Settlement: Initial Screen , choose Settlement → Execute . Go back to the previous screen, deselect Test Run and choose Settlement → Execute . 5. Call the Asset Explorer for the AuC. Has the AuC been credited completely? Is the same transaction type used for all credit transactions? If not, why? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, check Transaction Type in the Transactions field. c) Go back to the SAP Easy Access screen. Solution : The AuC is credited completely. The credit transaction types are not the same because the acquisitions on the AuC were from the previous and current years.
© Copyright. All rights reserved.
103
Unit 3: Asset Transactions
6. Look at the values of your assets of Machine 07 to Machine 09 in the Asset Explorer and in the asset history sheet. How do the values display in the asset history sheet? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose Goto → Call up reports . c) In the Select Report dialog box, select Asset History Sheet and choose the Continue pushbutton. d) To display the asset history sheet for Machines 07–09 in one go, on the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Notes to Financial Statements → International → Asset History Sheet ( S_ALR_870990 ). e) On the Asset History Sheet screen, enter the following data: Field Name or Data Type
Value
Asset number
Asset number of Machine 07-09
Sort variant
0013
List Asset radio button
Select
f) Choose the Execute pushbutton. g) Go back to the SAP Easy Access screen.
104
© Copyright. All rights reserved.
Unit 3 Exercise 23 Post Unplanned Depreciation
Business Example To work in the SAP system for the FI-AA department, you want to map a long-term, unplanned reduction of value for an asset. The second forklift, which was delivered and capitalized last year, was involved in an accident in the current year. Task 1 1. Enter this long-term, unplanned reduction of value in the system with the current date. The unplanned depreciation amount should be higher in the book depreciation area than in the cost-accounting depreciation area. 2. Display the asset values and explain to the course participant beside you why no FI document is present when you double-click the relevant transaction. 3. What transaction type would you use to post unplanned depreciation on a new acquisition?
Task 2 Limit transaction types to depreciation areas and check the result. 1. How can you make sure that only certain depreciation areas (for example, the group depreciation areas) are posted with values? 2. Limit transaction types to depreciation areas. 3. Make postings to the PC 03 master record that you created in the previous unit, using transaction type 030, and then check the asset values. 4. Start the Asset Explorer for this asset. Display the asset values in depreciation areas 30 and 31.
© Copyright. All rights reserved.
105
Unit 3 Solution 23 Post Unplanned Depreciation
Business Example To work in the SAP system for the FI-AA department, you want to map a long-term, unplanned reduction of value for an asset. The second forklift, which was delivered and capitalized last year, was involved in an accident in the current year. Task 1 1. Enter this long-term, unplanned reduction of value in the system with the current date. The unplanned depreciation amount should be higher in the book depreciation area than in the cost-accounting depreciation area. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Manual Value Correction → Unplanned Depreciation ( ABAA ). b) On the Unplanned depreciation: Initial Screen , enter the following data: Field Name or Data Type
Value
Asset
Your asset number ####
Transaction Type
640
Company Code
AA##
c) Choose Enter . d) On the Create Asset Transaction: Unplanned depreciation on old assets data screen, enter 1000 in the Amount Posted field and choose the Line Items pushbutton. e) In the Area: 20 Cost-acc dialog box, enter 500,00 in the Amount posted field. f) Choose the Continue pushbutton. g) Save your data. h) Go back to the SAP Easy Access screen. 2. Display the asset values and explain to the course participant beside you why no FI document is present when you double-click the relevant transaction. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset Explorer ( AW01 ). b) On the Asset Explorer screen, select the row for Unplanned depreciation on old assets data and choose the Display FI document pushbutton. c) Check that there is not FI document. Reason: The system has only made a note of the unplanned depreciation. It is not posted until the depreciation posting runs along with all other depreciations.
106
© Copyright. All rights reserved.
Solution 23: Post Unplanned Depreciation
3. What transaction type would you use to post unplanned depreciation on a new acquisition? a) Transaction type 650 .
Task 2 Limit transaction types to depreciation areas and check the result. 1. How can you make sure that only certain depreciation areas (for example, the group depreciation areas) are posted with values? a) Answer: In Customizing, you can restrict transaction types so that they only post to specific depreciation areas. 2. Limit transaction types to depreciation areas. a) Define the transaction types for acquisitions in Customizing for Financial Accounting (New) under Asset Accounting → Transactions → Acquisitions → Define Transaction Types for Acquisitions . b) In the Choose Activit y dialog box, select Limit Transaction Types to Depreciation Areas , and then choose the Choose pushbutton. c) In the Chart of depreciation selection dialog box, enter AA## and choose Continue. d) On the Change view “Transaction type selection”: Overview screen, select the row for transaction type 030 . e) In the dialog structure, double-click Depreciation Area Specification . On the Change view “Depreciation area specification”: Overview screen, transaction type 030 posts only to depreciation areas 30 and 31 . f) Go back to the Customizing screen. 3. Make postings to the PC 03 master record that you created in the previous unit, using transaction type 030, and then check the asset values. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Miscellaneous ( ABSO ). b) On the Miscellaneous Transactions: Initial Screen , enter the following data: Field Name or Data Type
Value
Company Code
AA##
Asset
Your asset number ####
Document Date
Current date
Posting Date
Current date
Posting Period
2
Transaction type
030
c) Choose Enter . d) On the Create Asset transaction: Acquisition in the group area screen, enter 100,000 in the posting amount field.
© Copyright. All rights reserved.
107
Unit 3: Asset Transactions
e) Post the data. f) Go back to the SAP Easy Access screen. 4. Start the Asset Explorer for this asset. Display the asset values in depreciation areas 30 and 31. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, enter the master number record for PC 03. c) Choose Enter . d) Check the values in the depreciation area.
108
© Copyright. All rights reserved.
Unit 4 Exercise 24 Analyze Depreciation Areas
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you want to analyze depreciation areas and master data changes for depreciation terms. Analyze depreciation areas and master data changes for depreciation terms. Task 1 Check which depreciation areas allow ordinary depreciation. 1. Check which depreciation areas allow ordinary depreciation in your chart of depreciation AA##. Caution: Do not change any of the entries.
Task 2 Post the asset. 1. Post €12,000 on January 01, CY to an asset of asset class 3000 that is not yet capitalized. 2. Is it true that if you start the Asset Explorer, you can see that the system shows a planned depreciation of €4,000 for the current year because of the depreciation key LINR in area 01? 3. In change mode, go to the master record of the asset and change the depreciation key in depreciation areas 01 and 02 of LINR to LINK. Before you confirm the changes, reduce the useful life from 3 to 2 years. Save the changes and read the warning messages the system displays by calling the warning messages with a double-click. 4. Analyze the planned book depreciation again in the Asset Explorer. Did the planned depreciation amount change? Display the calculation of the planned depreciation amount. 5. One of the texts in the warning messages you called previously explains the situation with the one-to-one transfer of depreciation terms. Where can you find the table or control options for your chart of depreciation AA## in Customizing?
© Copyright. All rights reserved.
109
Unit 4: Periodic Processing and Valuation
Caution: Do not make changes to the system.
110
© Copyright. All rights reserved.
Unit 4 Solution 24 Analyze Depreciation Areas
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you want to analyze depreciation areas and master data changes for depreciation terms. Analyze depreciation areas and master data changes for depreciation terms. Task 1 Check which depreciation areas allow ordinary depreciation. 1. Check which depreciation areas allow ordinary depreciation in your chart of depreciation AA##. Caution: Do not change any of the entries. a) Determine depreciation areas in Customizing for Financial Accounting ( New ) under Asset Accounting → Depreciation → Ordinary Depreciation → Determine Depreciation Areas . b) Enter AA## as the chart of depreciation and then confirm the entries. c) Check which depreciation areas allow ordinary depreciation. d) Go back to the SAP Easy Access screen.
Task 2 Post the asset. 1. Post €12,000 on January 01, CY to an asset of asset class 3000 that is not yet capitalized. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry . b) Enter the following data: Field Name or Data Type
Value
Document Date
01.01.CY
Posting Date
01.01.CY
Asset value date
01.01.CY
© Copyright. All rights reserved.
111
Unit 4: Periodic Processing and Valuation
Field Name or Data Type
Value
Amount Posted
12000
c) Choose the Simulate pushbutton. The line items are posted. d) Save the data. 2. Is it true that if you start the Asset Explorer, you can see that the system shows a planned depreciation of €4,000 for the current year because of the depreciation key LINR in area 01? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer . b) Double-click a transaction and check the depreciation amount. Answer: Yes, the depreciation amount is €4,000. 3. In change mode, go to the master record of the asset and change the depreciation key in depreciation areas 01 and 02 of LINR to LINK. Before you confirm the changes, reduce the useful life from 3 to 2 years. Save the changes and read the warning messages the system displays by calling the warning messages with a double-click. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) On the Change Asset : Initial screen, enter the following data: Field
Value
Asset
####
Company Code
AA##
c) Press ENTER. d) Choose the Deprec. Areas tab page and enter the following data: Field
Value
Useful
2 (for all depreciation areas)
Dkey
LINK (for 01 and 02 depreciation areas)
4. Analyze the planned book depreciation again in the Asset Explorer. Did the planned depreciation amount change? Display the calculation of the planned depreciation amount. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AWO1N ). Answer: Yes, the planned depreciation amount is now €6,000 per year and this amount is to be distributed over two years. 5. One of the texts in the warning messages you called previously explains the situation with the one-to-one transfer of depreciation terms. Where can you find the table or control options for your chart of depreciation AA## in Customizing?
112
© Copyright. All rights reserved.
Solution 24: Analyze Depreciation Areas
Caution: Do not make changes to the system. a) Specify the transfer of depreciation terms in Customizing for Financial Accounting under Asset Accounting → Valuation → Depreciation Areas → Specify Transfer of Depreciation Terms . The Change View “Depreciation areas: Rules for takeover of deprec. terms” screen is displayed.
© Copyright. All rights reserved.
113
Unit 4 Exercise 25 Understand and Maintain Depreciation Keys
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you need to understand and maintain the depreciation keys. Understand and maintain the depreciation keys. Task 1 Maintain the depreciation keys. 1. In the training system, all depreciation keys will already have their status as active. However, look at the Customizing settings for the depreciation keys (for your chart of depreciation AA##). 2. What is the transaction code used for Customizing?
Task 2 Create a new depreciation key. A typical example from everyday experience: Sections of SAP Note 328780 are listed (with some course-specific supplements) 1. SAP Note 328780, Page 1 Field Name or Data Type
Value
Number
328780
Version
8 dated 09/01/08
Set on
02.09.2008
Language
EN
Text
Changes according to German law on tax reduction
Responsible
P. Mustermann
Component
FI-AA
Long text/symptom: With the introduction of the German law on tax reduction, the following measure is relevant to the valuation of complex assets: A reduction of straight line depreciation for buildings in the company assets from 4% to 3%. Procedure as of release 4.6A: Create a new depreciation key (for example, GL30 with the description Building linear 3%, Gr. ##) by copying the depreciation key GL20.
114
© Copyright. All rights reserved.
Exercise 25: Understand and Maintain Depreciation Keys
After that, replace multilevel method 007 with the new multilevel method A## (## = your computer number) and the description Multilevel method A##, 3%. It must have the following values: Acq.year
Year
Per
BaseVal.
Percent
9999
999
12
01
3
... ... ... Implement the solution described for your chart of depreciation AA##. Hint: When you create the new multilevel method, you can simplify the procedure by using a reference, copying an existing method (for example, multilevel method 007), and changing the copy. 2. Search for one of your building master records (asset class 1100) that has not been posted to yet. Post €1,000,000 to this master record on 01/01/CY. 3. Analyze the planned depreciation values of the asset. 4. After activating and analyzing the asset, change the depreciation terms of all areas (except for depreciation area 20) from GD50 to the new depreciation key GL30. 5. Look at the values in the Asset Explorer. Did the new depreciation key calculate the values correctly? How high is the annual-planned depreciation amount now? When will the asset in depreciation area 01 be written off completely?
© Copyright. All rights reserved.
115
Unit 4 Solution 25 Understand and Maintain Depreciation Keys
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you need to understand and maintain the depreciation keys. Understand and maintain the depreciation keys. Task 1 Maintain the depreciation keys. 1. In the training system, all depreciation keys will already have their status as active. However, look at the Customizing settings for the depreciation keys (for your chart of depreciation AA##). a) Maintain the depreciation keys in Customizing for Financial Accounting ( New ) under Asset Accounting → Depreciation → Valuation Methods → Depreciation Key → Maintain Depreciation Key . 2. What is the transaction code used for Customizing? a) Solution: The transaction is called AFAMA .
Task 2 Create a new depreciation key. A typical example from everyday experience: Sections of SAP Note 328780 are listed (with some course-specific supplements) 1. SAP Note 328780, Page 1 Field Name or Data Type
Value
Number
328780
Version
8 dated 09/01/08
Set on
02.09.2008
Language
EN
Text
Changes according to German law on tax reduction
Responsible
P. Mustermann
Component
FI-AA
Long text/symptom: With the introduction of the German law on tax reduction, the following measure is relevant to the valuation of complex assets: A reduction of straight line depreciation for buildings in the company assets from 4% to 3%.
116
© Copyright. All rights reserved.
Solution 25: Understand and Maintain Depreciation Keys
Procedure as of release 4.6A: Create a new depreciation key (for example, GL30 with the description Building linear 3%, Gr. ##) by copying the depreciation key GL20. After that, replace multilevel method 007 with the new multilevel method A## (## = your computer number) and the description Multilevel method A##, 3%. It must have the following values: Acq.year
Year
Per
BaseVal.
Percent
9999
999
12
01
3
... ... ... Implement the solution described for your chart of depreciation AA##. Hint: When you create the new multilevel method, you can simplify the procedure by using a reference, copying an existing method (for example, multilevel method 007), and changing the copy. a) Copy the depreciation key in Customizing for Financial Accounting ( New ) under Asset Accounting → Depreciation → Valuation Methods → Depreciation Key → Maintain Depreciation Key . b) Copy the multilevel method in Customizing for Financial Accounting ( New ) under Asset Accounting → Depreciation → Valuation Methods → Depreciation Key → Calculation Methods → Define Multi-Level Methods . c) Enter a new multilevel method in the new depreciation key in Customizing for Financial Accounting ( New ) under Asset Accounting → Depreciation → Valuation Methods → Depreciation Key → Maintain Depreciation Key . 2. Search for one of your building master records (asset class 1100) that has not been posted to yet. Post €1,000,000 to this master record on 01/01/CY. a) In the FI-AA application, choose Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry . 3. Analyze the planned depreciation values of the asset. a) In the FI-AA application, choose Asset → Asset Explorer . 4. After activating and analyzing the asset, change the depreciation terms of all areas (except for depreciation area 20) from GD50 to the new depreciation key GL30. a) In the FI-AA application, choose Asset → Change → Asset . Make the changes according to the exercise and save them. Confirm the warning messages. 5. Look at the values in the Asset Explorer. Did the new depreciation key calculate the values correctly? How high is the annual-planned depreciation amount now? When will the asset in depreciation area 01 be written off completely?
© Copyright. All rights reserved.
117
Unit 4: Periodic Processing and Valuation
a) In the FI-AA application, choose Asset → Asset Explorer . Solution: The yearly planned depreciation is €30,000. The asset in area 01 is written off completely over the course of year CY+33.
118
© Copyright. All rights reserved.
Unit 4 Exercise 26 Maintain Time-Dependent Depreciation Parameters
Business Example The legislature changed its mind. From July 1, CY+1 (current year = CY) onward, every asset including already activated assets, must be written off within 10.5 years starting from this date. Change the depreciation key GL30 to LINR from the preceding exercise from July 1, CY+1 onward in depreciation areas 01 and 02. Also, change the useful life in both the areas. Change the time-dependent depreciation parameters.
Caution: You can only do this exercise if you completed the previous exercise. Also, change the useful life to 12 years in both areas.
Hint: Changes you marked as time-dependent (for example, in a future year) are displayed immediately on the Depreciation Areas tab page of the asset master record. A time interval display is only available on the detail screen of the depreciation area and in the Asset Explorer. 1. Change the time-dependent depreciation parameters. 2. Analyze your asset in the Asset Explorer. Look at the planned depreciation value of the current year +1. It is greater than the planned value of the current year, which is €30,000. 3. What would the planned depreciation values of the asset be if you did not have the new depreciation calculation active?
© Copyright. All rights reserved.
119
Unit 4 Solution 26 Maintain Time-Dependent Depreciation Parameters
Business Example The legislature changed its mind. From July 1, CY+1 (current year = CY) onward, every asset including already activated assets, must be written off within 10.5 years starting from this date. Change the depreciation key GL30 to LINR from the preceding exercise from July 1, CY+1 onward in depreciation areas 01 and 02. Also, change the useful life in both the areas. Change the time-dependent depreciation parameters.
Caution: You can only do this exercise if you completed the previous exercise. Also, change the useful life to 12 years in both areas.
Hint: Changes you marked as time-dependent (for example, in a future year) are displayed immediately on the Depreciation Areas tab page of the asset master record. A time interval display is only available on the detail screen of the depreciation area and in the Asset Explorer. 1. Change the time-dependent depreciation parameters. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Change → Asset ( AS02 ). b) On the Change Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Asset
Your asset number
Company code
AA##
c) Choose the Deprec. Area tab page and double-click the first depreciation area, area 01. d) On the Change Asset: Depreciation area Book deprec. screen, choose the More Intervals pushbutton. e) Choose the Add Interval pushbutton. f) In the Create New Interval dialog box, enter July 1, CY+1.
120
© Copyright. All rights reserved.
Solution 26: Maintain Time-Dependent Depreciation Parameters
g) Make the depreciation term changes in the new interval as described in the exercise. h) Once you create the new interval in area 01, make the same change for depreciation area 02. i) Save your data. 2. Analyze your asset in the Asset Explorer. Look at the planned depreciation value of the current year +1. It is greater than the planned value of the current year, which is €30,000. a) In Asset Accounting, choose Asset → Asset Explorer . Go to the Comparisons tab page. 3. What would the planned depreciation values of the asset be if you did not have the new depreciation calculation active? a) Run the transaction code /OAW01_AFAR . b) Confirm the dialog box with the warning messages. Hint: The warning message explains that in the old depreciation logic, the current year is also calculated again because it was not closed yet. After confirming the warning messages, you see the planned depreciation values of the current year in a new session, but they are still calculated using the new logic. c) Choose the Recalculate dep. pushbutton and see how the planned depreciation values would change when calculated using the old logic. d) Go to the Comparisons tab page of the Asset Explorer to see all the years of the useful life of the asset, calculated using the old logic.
© Copyright. All rights reserved.
121
Unit 4 Exercise 27 Analyze Cost-Accounting Depreciation Area
Business Example As part of your job, you need to support the asset accounting department during month-end closing. You need to revalue some assets based on the index series. For this reason, you want to understand how to create and use index series. Create a new index series and replace the old series with this new series in your asset. 1. Carry out an acquisition posting to one of your unposted master records of class 3200 on January 15, CY for the amount of €7,000. 2. Check the values in the cost-accounting depreciation area (depreciation area 20). In particular, look at the APC and the cost-accounting interest, and how these values will develop in the future, because the effect of the index (index series 00070) cannot be viewed until the following year. It means that from CY+1, you must see an amount in the Revaluation row, which increases the APC. Based on this replacement value, the planned ordinary depreciation is calculated for the CY+1. 3. Create a new index series AA## (## = group number) in index class 3. Use the current year as the base year with the valuation key figure 100 and reduce this amount by 10 index points per year over three years. If you wish, you can work with a simulated yearly rate of + 5% (that is, 105%) after this period. 4. In your asset (of asset class 3200, with APC values of € 7,000), in depreciation area 20, replace the index series 00070 with the new index series AA##. Then go back to the Asset Explorer and determine whether the revaluation has been calculated based on your new index series.
122
© Copyright. All rights reserved.
Unit 4 Solution 27 Analyze Cost-Accounting Depreciation Area
Business Example As part of your job, you need to support the asset accounting department during month-end closing. You need to revalue some assets based on the index series. For this reason, you want to understand how to create and use index series. Create a new index series and replace the old series with this new series in your asset. 1. Carry out an acquisition posting to one of your unposted master records of class 3200 on January 15, CY for the amount of €7,000. a) In the FI-AA application, choose Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry . b) Post the acquisition described in the task. 2. Check the values in the cost-accounting depreciation area (depreciation area 20). In particular, look at the APC and the cost-accounting interest, and how these values will develop in the future, because the effect of the index (index series 00070) cannot be viewed until the following year. It means that from CY+1, you must see an amount in the Revaluation row, which increases the APC. Based on this replacement value, the planned ordinary depreciation is calculated for the CY+1. a) In Asset Accounting, choose Asset → Asset Explorer . b) Select depreciation area 20 and then choose the Comparisons tab page. 3. Create a new index series AA## (## = group number) in index class 3. Use the current year as the base year with the valuation key figure 100 and reduce this amount by 10 index points per year over three years. If you wish, you can work with a simulated yearly rate of + 5% (that is, 105%) after this period. a) Go to Customizing for Financial Accounting ( New ) under Asset Accounting → Special Valuation → Revaluation of Fixed Assets → Indexed Replacement Values → Define Index Series . b) Create the new index series described in the exercise. 4. In your asset (of asset class 3200, with APC values of € 7,000), in depreciation area 20, replace the index series 00070 with the new index series AA##. Then go back to the Asset Explorer and determine whether the revaluation has been calculated based on your new index series. a) In the Asset Accounting application, choose Asset → Change → Asset . b) Choose the Valuation tab page and make the changes described in the exercise.
© Copyright. All rights reserved.
123
Unit 4 Exercise 28 Execute and Analyze the Depreciation Run
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you must execute and analyze the depreciation run. Execute and analyze the depreciation run. Task 1 You must post the depreciation for the complete previous year of your company code AA##. 1. Make sure you have made all necessary Customizing settings for your company code AA##. Make sure the active account assignment objects in the client you are using include, at the minimum, the Cost Center (KOSTL) and the Internal Order (CAUFN). Additional objects are also activated. Caution: Do not change the entries in this table. Other objects may also remain active. In USA, these exercises cannot be performed in this manner. If necessary, obtain more information from your trainer. 2. In the cost accounting area, you want to post the cost accounting depreciation costs to the respective cost center in the asset master record. For the cost center account assignment object, verify whether the account assignment type for depreciation run has been set for your company code AA##, in depreciation area 20. However, this is not the case. So, create the corresponding entry. 3. Check which document type for depreciation posting is specified in your company code, AA##. 4. Make sure all depreciation areas in your company code (that are supposed to post depreciation) are posting depreciation monthly by default. 5. In addition, area 20 (cost-accounting) in your chart of depreciation AA## must post interest along with depreciation. Select the respective checkbox. 6. You made all the settings to execute the depreciation run for your company code AA## without errors. An FI document for depreciation areas 01 and 20 and a CO document for area 20 will be posted. But, you also want to derive a profit center and a segment in the FI documents of areas 01 and 20. To achieve that, you have to maintain the account assignment type as the depreciation run for the profit center and segment account assignment objects in depreciation areas 01 and 20.
124
© Copyright. All rights reserved.
Exercise 28: Execute and Analyze the Depreciation Run
7. Execute a test run of the depreciation posting program for your company code AA## for the month of January in the previous year. Select List assets . Compare the columns showing the Planned and To be Posted amounts. 8. Post the depreciation for the entire previous year in a single step. Start another (unplanned) test run for the complete previous year. Analyze the log of the test run, and branch to one or more simulated FI documents. 9. Carry out the update run for your company code AA##, in the background, for the complete previous year. Enter the LP01 printer as the output device. Start the job immediately.
Task 2 Display the posted documents. 1. You can call up the log (program RAPOST2001) of the depreciation run that you just posted. Or, you can have the system list all the assets again. Here, you can also display the posted documents at any time. 2. From the log, go directly to the monitor of the Schedule Manager. What were the start and end times of your program? Task 3 Call the Asset Explorer and check whether the depreciation of the previous year is posted. 1. Call the Asset Explorer, and use your Machine 03 (machine with complete retirement) as an example to check whether the depreciation of the previous year is posted. 2. From the Asset Explorer, can you see the corresponding FI document number using which the depreciation for Machine 03 was posted? Task 4 Assign cost accounting depreciation to WBS elements. 1. You decide to assign cost accounting depreciation from depreciation area 20 to WBS elements. What two basic settings do you need to change in Customizing for Asset Accounting before you can maintain a WBS element characteristic in the asset master data and post the depreciation to this object?
© Copyright. All rights reserved.
125
Unit 4 Solution 28 Execute and Analyze the Depreciation Run
Business Example As part of your job, you need to support the asset accounting department during month-end closing. For this reason, you must execute and analyze the depreciation run. Execute and analyze the depreciation run. Task 1 You must post the depreciation for the complete previous year of your company code AA##. 1. Make sure you have made all necessary Customizing settings for your company code AA##. Make sure the active account assignment objects in the client you are using include, at the minimum, the Cost Center (KOSTL) and the Internal Order (CAUFN). Additional objects are also activated. Caution: Do not change the entries in this table. Other objects may also remain active. In USA, these exercises cannot be performed in this manner. If necessary, obtain more information from your trainer. a) Activate the account assignment objects in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with General Ledger Accounting → Additional Account Assignment Objects → Activate Account Assignment Objects . 2. In the cost accounting area, you want to post the cost accounting depreciation costs to the respective cost center in the asset master record. For the cost center account assignment object, verify whether the account assignment type for depreciation run has been set for your company code AA##, in depreciation area 20. However, this is not the case. So, create the corresponding entry. a) Verify the account assignment types in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with General Ledger Accounting → Additional Account Assignment Objects → Specify Account Assignment Types for Account Assignment Objects . b) On the Display View “Company Code”: Overview screen, select the row for your company code AA## . c) In the dialog structure, double-click Depreciation Area and select the row for depreciation area 20 (cost-accounting).
126
© Copyright. All rights reserved.
Solution 28: Execute and Analyze the Depreciation Run
d) In the dialog structure, double-click Account Assignment Objects. e) Choose the New Entries pushbutton. f) Enter the following data: Field Name or Data Type
Value
Account Assignment Object
KOSTL (Cost Center)
Transaction type
*
Account assignment type
Depreciation Run
Account Assignment
Select
g) Save your data. 3. Check which document type for depreciation posting is specified in your company code, AA##. a) Check the document type in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with General Ledger Accounting → Post Depreciation to General Ledger Accounting → Specify Document Type for Posting of Depreciation . b) In the Choose Activity dialog box, choose Specify Document Type for Posting of Depreciation . Solution: AF document type is specified. 4. Make sure all depreciation areas in your company code (that are supposed to post depreciation) are posting depreciation monthly by default. a) Check the intervals and posting rules in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with General Ledger Accounting → Post Depreciation to General Ledger Accounting → Specify Intervals and Posting Rules . b) On the Change View "Company code selection": Overview screen, select the row for AA##. c) In the dialog structure, double-click Posting rules . d) Double-click area 01 and 20 and check whether posting is set to take place monthly in these areas. Note: The derived area 03 is not that important in this exercise. 5. In addition, area 20 (cost-accounting) in your chart of depreciation AA## must post interest along with depreciation. Select the respective checkbox. a) Activate the post interest checkbox in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with the General Ledger Accounting → Post Depreciation to the General Ledger → Specify Intervals and Posting Rules . b) Select the row for your company code AA## . c) In the dialog structure, double-click Posting rules .
© Copyright. All rights reserved.
127
Unit 4: Periodic Processing and Valuation
d) Double-click area 20 . e) In the Other posting settings field group, select the Post interest checkbox. f) Save your entries. 6. You made all the settings to execute the depreciation run for your company code AA## without errors. An FI document for depreciation areas 01 and 20 and a CO document for area 20 will be posted. But, you also want to derive a profit center and a segment in the FI documents of areas 01 and 20. To achieve that, you have to maintain the account assignment type as the depreciation run for the profit center and segment account assignment objects in depreciation areas 01 and 20. a) Maintain the account assignment type as the depreciation run in Customizing for Financial Accounting ( New ) under Asset Accounting → Integration with the General Ledger → Additional Account Assignment Objects → Specify Account Assignment Types for Account Assignment Objects . b) Select the row for your company code AA## . c) In the dialog structure, double-click the Depreciation Area and select the row for 01 . d) In the dialog structure, double-click the Account Assignment Objects . e) Choose the New Entries pushbutton and enter the following data: AcctAsgnOb
Acct. Assgnmt Obj. Name
Tra
Account Assignment Type
AcctAssgnt
PRCTR
Profit Center
*
Depreciation Run
select
SEGMENT
Segment
*
Depreciation Run
select
f) Save your data. g) Similarly, create account assignment objects for depreciation area 20. 7. Execute a test run of the depreciation posting program for your company code AA## for the month of January in the previous year. Select List assets . Compare the columns showing the Planned and To be Posted amounts. a) In the Asset Accounting application, choose Periodic Processing → Depreciation Run → Execute . b) Enter the following data:
128
Field Name or Data Type
Value
Company code
AA##
Fiscal year
Previous year: CY-1
Posting Period
01
Planned posting run
Select
List Assets
Select
© Copyright. All rights reserved.
Solution 28: Execute and Analyze the Depreciation Run
Field Name or Data Type
Value
Test Run
Select
c) Choose Program → Execute . d) Confirm the message appearing in the dialog box. 8. Post the depreciation for the entire previous year in a single step. Start another (unplanned) test run for the complete previous year. Analyze the log of the test run, and branch to one or more simulated FI documents. a) In the FI-AA application, choose Periodic Processing → Depreciation Run → Execute . b) Enter the following data: Field
Value
Company code
AA##
Fiscal year
Previous year
Posting Period
12
Unplanned posting run
Select
List Assets
Select
Test Run
Select
c) Choose Program → Execute . d) Confirm the dialog box. 9. Carry out the update run for your company code AA##, in the background, for the complete previous year. Enter the LP01 printer as the output device. Start the job immediately. a) On the Depreciation Posting Run screen, enter the following data: Field
Value
Company code
AA##
Fiscal year
Previous year
Posting Period
12
Unplanned posting run
Select
Test Run
Deselect
b) Choose Program → Execute in Background . c) In the Background Print Parameters dialog box, enter LOCL as the output device and confirm the details. d) In the Start Time dialog box, choose the Immediate pushbutton. e) Choose the Save pushbutton.
© Copyright. All rights reserved.
129
Unit 4: Periodic Processing and Valuation
Task 2 Display the posted documents. 1. You can call up the log (program RAPOST2001) of the depreciation run that you just posted. Or, you can have the system list all the assets again. Here, you can also display the posted documents at any time. a) In the Asset Accounting application, choose Periodic Processing → Depreciation Run → Display Log . b) Execute the report for your company code, the previous year, and period 12. c) Go to the FI document and the cost accounting document by clicking one of the figures displayed in the Reference Document column. 2. From the log, go directly to the monitor of the Schedule Manager. What were the start and end times of your program? a) Choose the Log of Schedule Manager pushbutton on the Depreciation Run Log for Company Code AA## screen. Task 3 Call the Asset Explorer and check whether the depreciation of the previous year is posted. 1. Call the Asset Explorer, and use your Machine 03 (machine with complete retirement) as an example to check whether the depreciation of the previous year is posted. a) In the Asset Accounting application, choose Asset → Asset Explorer . b) Select Machine 03, using F4. c) Display the values of the previous year. d) Choose the Posted Values tab page. 2. From the Asset Explorer, can you see the corresponding FI document number using which the depreciation for Machine 03 was posted? a) Select the row that displays the posted period. b) Choose the Display Deprec. Log pushbutton. Task 4 Assign cost accounting depreciation to WBS elements. 1. You decide to assign cost accounting depreciation from depreciation area 20 to WBS elements. What two basic settings do you need to change in Customizing for Asset Accounting before you can maintain a WBS element characteristic in the asset master data and post the depreciation to this object? a) Activate the account assignment object WBS Element (PS_PSP_PNR2) in Customizing for Asset Accounting, choose Integration with the General Ledger → Additional Account Assignment Objects → Activate Account Assignment Objects .
130
© Copyright. All rights reserved.
Solution 28: Execute and Analyze the Depreciation Run
b) Specify this account assignment object for account assignment type Depreciation Run for your company code AA## and depreciation area 20 in Customizing for Asset Accounting, choose Integration with the General Ledger → Additional Account Assignment Objects → Specify Account Assignment Types for Account Assignment Objects . c) Create the corresponding entry as described.
© Copyright. All rights reserved.
131
Unit 4 Exercise 29 Execute Year-End Closing in Asset Accounting (FI-AA)
Business Example Many tests have been completed and assets have been created, posted, and depreciated. You now need to help the FI-AA department with the year-end closing. Understand the logic of year-end closing program of FI-AA and execute the program. Carry out the year-end closing for the previous year in company code AA##. 1. Start a test run of the year-end closing program for your company code AA## for the previous year. 2. Year-end closing can only be carried out in the company code AA## when there are no periodic transactions left to be posted. You must start the periodic posting program as an update run. The program used for this purpose is (as of release 4.7, Enterprise Extension 1.10 ) program RAPERB2000. Execute a test run of program RAPERB2000 and you will see that it cannot be started immediately; you will receive another error message. Note: You need to specify the document type for periodic posting of asset values beforehand. 3. Use document type AP for periodic posting of asset values in Customizing for Asset Accounting for the company code AA##. Hint: Document type AP is not a standard document type delivered by SAP. It is a document type the course author created in the SAP ERP training system. You are supposed to create a new document for the periodic postings of asset values. If document type AP does not already exist, you may create it. 4. Start the test run for your company code AA## using the periodic posting program RAPERB2000 again. 5. Start the update run if the test run of program RAPERB2000 does not have any documents to post. For background processing, use printer LP01 to start immediately. 6. Run the test run and verify whether you can complete the year-end closing of the previous year for company code AA##. If the test run does not show any errors, start the update run.
132
© Copyright. All rights reserved.
Exercise 29: Execute Year-End Closing in Asset Accounting (FI-AA)
7. Check whether the previous year is entered as the last closed fiscal year for company code AA##.
© Copyright. All rights reserved.
133
Unit 4 Solution 29 Execute Year-End Closing in Asset Accounting (FI-AA)
Business Example Many tests have been completed and assets have been created, posted, and depreciated. You now need to help the FI-AA department with the year-end closing. Understand the logic of year-end closing program of FI-AA and execute the program. Carry out the year-end closing for the previous year in company code AA##. 1. Start a test run of the year-end closing program for your company code AA## for the previous year. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → Year-End Closing → Execute ( AJAB ). b) On the Year-end closing Asset Accounting screen, enter the following data: Field Name or Data Type
Value
Company code(s)
AA##
Fiscal year to be closed
Previous year
c) Choose the Execute pushbutton. d) In the Limitation online dialog box, choose the Yes pushbutton to continue processing anyway. e) The report of year-end closing for previous fiscal year is displayed. You will find that the year-end closing cannot be performed because it is possible that not all transactions were posted periodically. 2. Year-end closing can only be carried out in the company code AA## when there are no periodic transactions left to be posted. You must start the periodic posting program as an update run. The program used for this purpose is (as of release 4.7, Enterprise Extension 1.10 ) program RAPERB2000. Execute a test run of program RAPERB2000 and you will see that it cannot be started immediately; you will receive another error message. Note: You need to specify the document type for periodic posting of asset values beforehand. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → APC Values Posting ( ASKB ).
134
© Copyright. All rights reserved.
Solution 29: Execute Year-End Closing in Asset Accounting (FI-AA)
b) On the Periodic Asset Postings screen, choose the Execute pushbutton. Notice that when you try to start the program for your company code AA## in a test run, an error message appears. 3. Use document type AP for periodic posting of asset values in Customizing for Asset Accounting for the company code AA##. Hint: Document type AP is not a standard document type delivered by SAP. It is a document type the course author created in the SAP ERP training system. You are supposed to create a new document for the periodic postings of asset values. If document type AP does not already exist, you may create it. a) Specify the document type for periodic posting of asset values in Customizing for Financial Accounting (New) under Asset Accounting → Integration with the General Ledger Accounting → Post APC Values Periodically to General Ledger Accounting → Specify Document Type for Periodic Posting of Asset Values . b) On the Change View “Document Types for Periodic Posting of Asset Values”: Overview screen, enter AP in the DocTy field for the row of company code AA## . c) Save your data. d) Go back to the SAP Easy Access screen. 4. Start the test run for your company code AA## using the periodic posting program RAPERB2000 again. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → APC Values Posting ( ASKB ). b) On the Periodic Asset Postings screen, check whether AA## is displayed in the Company Code field. c) In the Limitation online dialog box, choose the Yes pushbutton. After the test run completes successfully, the status must say that no documents were created in this run. 5. Start the update run if the test run of program RAPERB2000 does not have any documents to post. For background processing, use printer LP01 to start immediately. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → APC Values Posting ( ASKB ). b) On the Periodic Asset Postings screen, deselect Test Run and choose Program → Execute in Background from the menu bar. c) In the Background Print Parameters dialog box, enter LP01 in the Output Device field and then choose the Continue pushbutton. d) In the Start Time dialog box, choose the Immediate pushbutton. The background job is scheduled for program RAPERB2000. e) Save the data.
© Copyright. All rights reserved.
135
Unit 4: Periodic Processing and Valuation
6. Run the test run and verify whether you can complete the year-end closing of the previous year for company code AA##. If the test run does not show any errors, start the update run. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → Year-End Closing → Execute . b) On the Year-end closing Asset Accounting screen, enter the following data: Field Name or Data Type
Value
Company code(s)
AA##
Fiscal year to be closed
Previous year
Asset class asset u. const.
Blank
c) Select Test run . d) Choose Program → Execute and confirm the message that appears . e) Go back to the previous screen. f) Deselect Test run and choose Program → Execute in Background . g) In the Background Print Parameters dialog box, enter LOCL in Output Device field and confirm your entries. h) In the Start Time dialog box, choose the Immediate pushbutton to select the start date of the job and then choose the Save pushbutton. The background job is scheduled. i) Save the data. 7. Check whether the previous year is entered as the last closed fiscal year for company code AA##. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → Year-End Closing → Undo → Entire Company Code ( OAAQ ). b) On the Change View “Remove Year-End Closing for Company Code”: Overview screen, check whether the previous year appears in the row for AA## .
136
© Copyright. All rights reserved.
Unit 4 Exercise 30 Manage Parallel Accounting in FI-AA
Business Example As part of your job, you need to configure a depreciation area that posts values periodically. For this purpose, you can use the program RAPERB2000 for the periodic postings. Alternatively, the values can be posting directly to the G/L. Configure and execute the periodic APC values posting. Task 1 In the future, a new depreciation area in your chart of depreciation AA## must periodically post asset balances of the group to the G/L. Use the accounts approach to represent this scenario.
Hint: It always makes sense to make such changes at the beginning of the fiscal year. For example, your instructor already made settings, in Customizing for FI, for the G/L account to have seven characters, and extend the account groups to a seven character account number interval. Customizing for FI permits the account numbers of chart of account INT, which your company codes are using. 1. In the G/L application, create the most important group accounts centrally for your company code AA##. Use the accounts for your company code as a reference. Hint: In the new group accounts, delete the alternative account number in the Control Data tab page and, if necessary, remove the Recon. account for acct type assets indicator.
Caution: The blank spaces in the account numbers listed in the table are only there to help you read the numbers. In the system, enter the account numbers without spaces. You only need the optional accounts if you also want to enter an asset retirement later on, for example. Leave them out during the first tests.
© Copyright. All rights reserved.
137
Unit 4: Periodic Processing and Valuation
Group Account to be Created
Possible account descripReference Account tion (for orientation purposes only, because you do not have to maintain them).
8 011 000
Technical Assets
11 000
8 011 010
Accum. dep. technical assets
11 010
8 199 990
Clrg. Asset Acquisition
199 990
8 204 000
Other Expense
204 000
8 211 100
Depreciation SA
211 100
Optional: As mentioned 8 825 000
Clear. fixed asset retirement 825 000
8 250 000
Gain on asset retirement
250 000
8 200 000
Loss on asset retirement
200 000
8 200 010
Losses from scrap
200 010
8 211 200
Unplanned depreciation
211 200
8 399 999
Stock initialization
399 999
2. Call your new account 8 204 000 and change the field status group from G013 to G001 on the Create/bank/interest tab page. 3. For your chart of depreciation AA##, create the new depreciation area 60 by copying depreciation area 01 and changing it as follows: Field Name or Data Type
Value
Depreciation area
60
Long text
Parallel valuation GR. ##
Short text
Group
Real dep. area
Must be correct from the reference
Post in general ledger
The new area must post asset values to the G/L periodically. Therefore, change the entry from 1 to 2 (Area posts asset values and depreciation periodically).
In Customizing for Asset Accounting, enter the document type AP for your company code AA## to post asset values periodically. 4. Activate your new depreciation area 60 as an example in your asset class 2100 (in the depreciation data section of the asset class) by removing the deactivation indicator for the new area. In the default values that appear for the new area, change the useful life to 5 years. 5. Verify whether the group accounts you created are included in your new group depreciation area 60. Go to the account determination of asset class 2100.
138
© Copyright. All rights reserved.
Exercise 30: Manage Parallel Accounting in FI-AA
6. Since segment reporting is activated in the SAP training client, you want to derive the profit center and segment from the asset master record when posting APC values periodically for the new depreciation area 60. You also need to define the two account assignment types for the profit center and segment in depreciation area 60 for posting depreciation in chart of depreciation AA##. 7. Create a new asset master record with the description Press Gr. ## in asset class 2100 of your company code AA##. In addition, check if your new depreciation area appears in the asset master record on the Dep. areas tab page. 8. Post the Press Gr. ## asset using the transaction code ABZO . Note that the transaction code ABZO is the old automatic offset posting that enables a different basis for valuation in the depreciation areas. Use January 12 of the current year (CY) as the posting and document date. Post a value of € 100,000 in the book depreciation area 01. In your new group area 60, enter a different acquisition value. 9. Call the Asset Explorer and check if the different base values for depreciation are present, at least in FI-AA.
Task 2 For your company code AA##, you still have to start the program for periodic APC postings using the RAPERB2000 program to keep the group values in the G/L consistent with FI-AA. 1. Execute a test run of program RAPERB2000 and navigate to the document simulation. Hint: Do not execute an update run so you can see the direct posting documents in the log by performing the following steps. Is the APC amount of the new area entered, which differs from depreciation area 01? 2. Are the group accounts correct? 3. Is the document type correct? 4. If you want to use the direct posting function, you have to change the depreciation posting rules for your new area 60 again. In Customizing, call up the definition of the depreciation areas and change the entry for area 60 from 2 (area posts asset values and depreciation periodically) to 4 (area posts APC directly and depreciation) for the post in the General Ledger column. 5. Post an acquisition to your Press Gr. ## asset for € 10,000 with a posting and document date of January 14, CY. This time, the capitalized amount must be the same in all areas. 6. Start the test run of periodic APC posting program RAPERB2000 in your company code AA## again. 7. Do you see a reference number in the log of the test run? 8. Start an update run for program RAPERB2000 in the background; to post the first acquisition to your new group depreciation area.
© Copyright. All rights reserved.
139
Unit 4: Periodic Processing and Valuation
Hint: A test run of the depreciation run (for example, for January, CY) shows that depreciation has also been entered for the Press Gr. ## asset in the group depreciation area in the relevant group accounts.
Note: The test run of program RAPOST2000 may run into errors if you have not already defined the optional accounts for one of the tasks before.
140
© Copyright. All rights reserved.
Unit 4 Solution 30 Manage Parallel Accounting in FI-AA
Business Example As part of your job, you need to configure a depreciation area that posts values periodically. For this purpose, you can use the program RAPERB2000 for the periodic postings. Alternatively, the values can be posting directly to the G/L. Configure and execute the periodic APC values posting. Task 1 In the future, a new depreciation area in your chart of depreciation AA## must periodically post asset balances of the group to the G/L. Use the accounts approach to represent this scenario.
Hint: It always makes sense to make such changes at the beginning of the fiscal year. For example, your instructor already made settings, in Customizing for FI, for the G/L account to have seven characters, and extend the account groups to a seven character account number interval. Customizing for FI permits the account numbers of chart of account INT, which your company codes are using. 1. In the G/L application, create the most important group accounts centrally for your company code AA##. Use the accounts for your company code as a reference. Hint: In the new group accounts, delete the alternative account number in the Control Data tab page and, if necessary, remove the Recon. account for acct type assets indicator.
Caution: The blank spaces in the account numbers listed in the table are only there to help you read the numbers. In the system, enter the account numbers without spaces. You only need the optional accounts if you also want to enter an asset retirement later on, for example. Leave them out during the first tests.
© Copyright. All rights reserved.
141
Unit 4: Periodic Processing and Valuation
Group Account to be Created
Possible account descripReference Account tion (for orientation purposes only, because you do not have to maintain them).
8 011 000
Technical Assets
11 000
8 011 010
Accum. dep. technical assets
11 010
8 199 990
Clrg. Asset Acquisition
199 990
8 204 000
Other Expense
204 000
8 211 100
Depreciation SA
211 100
Optional: As mentioned 8 825 000
Clear. fixed asset retirement 825 000
8 250 000
Gain on asset retirement
250 000
8 200 000
Loss on asset retirement
200 000
8 200 010
Losses from scrap
200 010
8 211 200
Unplanned depreciation
211 200
8 399 999
Stock initialization
399 999
a) On the SAP Easy Access screen, Accounting → Financial Accounting → General Ledger → Master Records → G/L Accounts → Individual Processing → Centrally ( FS00 ). b) On the Edit G/L Account Centrally screen, enter AA## in the Company Code field and 8011000 in the G/L Account field. c) Choose the With Template pushbutton. d) In the Reference Account dialog box, enter the following data: Field Name or Data Type
Value
G/L Account
11000
Company Code
AA##
e) Confirm the entries. f) On the Create G/L Account Centrally screen, check if Fixed assets accounts appears in the Account Group field. g) Choose the Control Data tab page and remove the entries in the Recon. Account for acct type and alternate account no. fields. They must be blank. h) Save your data. Confirm the messages displayed. i) Go back to the Create G/L Account Centrally screen. Do the same for all other accounts from the tables in the exercise.
142
© Copyright. All rights reserved.
Solution 30: Manage Parallel Accounting in FI-AA
2. Call your new account 8 204 000 and change the field status group from G013 to G001 on the Create/bank/interest tab page. a) Choose G/L account → Change . b) On the Change G/L Account Centrally screen, choose the Create/bank/interest tab page. c) Enter G001 in the Field status group field. d) Confirm the message displayed in the information box. e) Save your change. 3. For your chart of depreciation AA##, create the new depreciation area 60 by copying depreciation area 01 and changing it as follows: Field Name or Data Type
Value
Depreciation area
60
Long text
Parallel valuation GR. ##
Short text
Group
Real dep. area
Must be correct from the reference
Post in general ledger
The new area must post asset values to the G/L periodically. Therefore, change the entry from 1 to 2 (Area posts asset values and depreciation periodically).
In Customizing for Asset Accounting, enter the document type AP for your company code AA## to post asset values periodically. a) Define a new depreciation area in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Depreciation Areas → Define Depreciation Areas . b) In the Choose Activity dialog box, double-click Define Depreciation Areas . c) In the Determine Work Area: Entry dialog box, enter AA## as the chart of depreciation and confirm the entries. d) On the Change View “Define Depreciation Areas”: Overview screen, select the row for 1 and then choose the Copy As pushbutton. e) On the Change View “Define Depreciation areas”: Details of Selected Set screen, enter the following data: Field Name or Data Type
Value
Deprec. Area
60
Description
Parallel Valuation GR.00 Group
Posting in G/L
Select Area Posts APC and Depreciation on Periodic Basis
f) Press ENTER. g) Go back to the Customizing screen.
© Copyright. All rights reserved.
143
Unit 4: Periodic Processing and Valuation
4. Activate your new depreciation area 60 as an example in your asset class 2100 (in the depreciation data section of the asset class) by removing the deactivation indicator for the new area. In the default values that appear for the new area, change the useful life to 5 years. a) Determine the depreciation area in the asset class in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Determine Depreciation Areas in the Asset Class . b) On the Change View “Asset class”: Overview screen, select the row for 2100 . c) In the dialog structure, double-click Depreciation areas and check the following data for row 60 : Field Name or Data Type
Value
Deact
Not selected
Use
5
d) Save the data and go back to the Customizing screen. 5. Verify whether the group accounts you created are included in your new group depreciation area 60. Go to the account determination of asset class 2100. a) Assign the G/L accounts in Customizing for Financial Accounting (New) under Asset Accounting → Integration of General Ledger Accounting → Assign G/L Accounts . b) On the Change View “Chart of Accounts”: Overview screen, select the row for INT . c) In the dialog structure, double-click Account Determination and select the row for 20000 . d) In the dialog structure, double-click Balance Sheet Accounts and select the row for 60 . e) Choose the Details pushbutton. Check the details of the accounts stored for the new depreciation area 60. Verify the following accounts are maintained for your new depreciation area 60: Field Name or Data Type
Value
Acquisition: Acquis. and production costs
8 011 000
Contra account: Acquisition value
8 199 990
Near the bottom: Capitalization differences/Non-operating expense
8 204 000
Optional and, as already mentioned, not necessary for the time being:
144
Loss made on asset retirement without revenue
8 200 010
Clearing account revenue from asset sale
8 825 000
Gain from asset sale
8 250 000
Loss from asset sale
8 200 000
© Copyright. All rights reserved.
Solution 30: Manage Parallel Accounting in FI-AA
Store the following accounts for your new depreciation area 60: Field Name or Data Type
Value
Accumulated depreciation account for or- 8 011 010 dinary dep. Expense account for ordinary depreciation 8 211 100 Optional and, as already mentioned, not necessary for the time being: Special depreciation accumulated depreciation account
8 011 010
Expense account for special depreciation
8 211 200
f) Go back to the SAP Easy Access screen. 6. Since segment reporting is activated in the SAP training client, you want to derive the profit center and segment from the asset master record when posting APC values periodically for the new depreciation area 60. You also need to define the two account assignment types for the profit center and segment in depreciation area 60 for posting depreciation in chart of depreciation AA##. a) Specify the account assignment types for the account assignment objects in Customizing for Financial Accounting (New) under Asset Accounting → Integration of General Ledger Accounting → Additional Account Assignment Objects → Specific Account Assignment Types for Account Assignment Objects . b) On the Display View “Company Code”: Overview screen, select the row for AA## . c) In the dialog structure, double-click Depreciation Area and then select the row for 60 . d) In the dialog structure, double-click Account Assignment Objects . e) Choose the New Entries button and enter the following data: AcctAsgnOb
Tra
Account Assignment Type
AcctAssgnt
PRCTC
*
APC Values Posting
Select
PRCTC
*
Depreciation Run
Select
SEGMENT
*
APC Values Posting
Select
SEGMENT
*
Depreciation Run
Select
f) Save the entries. g) Go back to the SAP Easy Access screen. 7. Create a new asset master record with the description Press Gr. ## in asset class 2100 of your company code AA##. In addition, check if your new depreciation area appears in the asset master record on the Dep. areas tab page. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed assets → Asset → Create → Asset ( AS01 ).
© Copyright. All rights reserved.
145
Unit 4: Periodic Processing and Valuation
b) On the Create Asset: Initial screen, enter the following data: Field Name or Data Type
Value
Asset Class
2100
Company code
AA##
c) Press ENTER. d) On the Create Asset: Master data screen, enter Press Gr. ## in the Description field. e) Choose the Time-dependent tab page and enter T-F05A00 in the Cost Center field. f) Choose the Deprec. Areas tab page and check whether the new depreciation area is available. g) Save the data. h) Go back to the SAP Easy Access screen. 8. Post the Press Gr. ## asset using the transaction code ABZO . Note that the transaction code ABZO is the old automatic offset posting that enables a different basis for valuation in the depreciation areas. Use January 12 of the current year (CY) as the posting and document date. Post a value of € 100,000 in the book depreciation area 01. In your new group area 60, enter a different acquisition value. a) Enter the transaction code /NABZ0 . b) On the Asset acquis. autom. offset. Posting: Initial screen, check or enter the following data: Field Name or Data Type
Value
Company Code
AA##
Asset
Asset created in the last step
Document Date
Jan 12, CY
Posting Date
Jan 12, CY
Posting period
1
c) Choose Enter . d) On the Create Asset Transaction: External asset acquisition screen, enter 100000 in the Amount Posted field. e) Choose the Line Items pushbutton. f) In the Overview of Posted Areas dialog box, change the amount posted in the row 60 to 10000 . g) Confirm your entries. h) Save your data. i) Go back to the SAP Easy Access screen.
146
© Copyright. All rights reserved.
Solution 30: Manage Parallel Accounting in FI-AA
9. Call the Asset Explorer and check if the different base values for depreciation are present, at least in FI-AA. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) On the Asset Explorer screen, choose depreciation area 60 . c) Check its details.
Task 2 For your company code AA##, you still have to start the program for periodic APC postings using the RAPERB2000 program to keep the group values in the G/L consistent with FI-AA. 1. Execute a test run of program RAPERB2000 and navigate to the document simulation. Hint: Do not execute an update run so you can see the direct posting documents in the log by performing the following steps. Is the APC amount of the new area entered, which differs from depreciation area 01? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → APC Values Posting ( ASKB ). b) On the Periodic Asset Postings screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
List assets
select
List direct items
select
Test run
select
c) Choose Program → Execute . d) In the Limitation online dialog box, confirm to continue processing. Test run is completed successfully. A simulated FI document is displayed in the log. Choose the displayed document number to have the system go directly to the simulated periodic document. 2. Are the group accounts correct? a) Look at the accounts posted to in the simulation. If they have seven digits, the result is correct. 3. Is the document type correct? a) Search for the FI document type in the simulated document. 4. If you want to use the direct posting function, you have to change the depreciation posting rules for your new area 60 again.
© Copyright. All rights reserved.
147
Unit 4: Periodic Processing and Valuation
In Customizing, call up the definition of the depreciation areas and change the entry for area 60 from 2 (area posts asset values and depreciation periodically) to 4 (area posts APC directly and depreciation) for the post in the General Ledger column. a) Define the depreciation area in Customizing for Financial Accounting (New) under Asset Accounting → Valuation → Depreciation Areas → Define Depreciation Areas . b) In the Choose Activity dialog box, double-click Define Depreciation Areas . c) On the Change View “Define Depreciation Areas”: Overview screen, change the G/L value for the row 60 from 2 to 4 . 5. Post an acquisition to your Press Gr. ## asset for € 10,000 with a posting and document date of January 14, CY. This time, the capitalized amount must be the same in all areas. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) In the Company Code dialog box, enter AA## . c) On the Enter Asset Transaction: Acquis. w/Autom. Offsetting Entry screen, enter the following data: Field Name or Data Type
Value
Document Date
Jan 14, CY
Posting Date
Jan 14, CY
Asset Value Date
Jan 14, CY
Amount posted
10000
d) Choose Extras → Simulate . e) Post the acquisition. 6. Start the test run of periodic APC posting program RAPERB2000 in your company code AA## again. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Periodic Processing → APC Values Posting ( ASKB ). b) On the Periodic Asset Postings screen, enter the following data: Field Name or Data Type
Value
Company Code
AA##
List Assets
Select
List Direct
Select
Test Run
Select
c) Choose Program → Execute . d) In the Limitation online dialog box, confirm to continue processing. 7. Do you see a reference number in the log of the test run?
148
© Copyright. All rights reserved.
Solution 30: Manage Parallel Accounting in FI-AA
a) Check the reference document number and take special notice of the document header text. 8. Start an update run for program RAPERB2000 in the background; to post the first acquisition to your new group depreciation area. a) On the Periodic Asset Postings screen, enter the following data: Field Name or Data Type
Value
Company Code
AA##
List Assets
Select
List Direct
Select
Test Run
Do not select
b) Choose Program → Execute in Background . c) In the Background Print Parameters dialog box, enter LP01 in the Output Device field. d) In the Start Time dialog box, choose the Immediate pushbutton and then choose the Save pushbutton.
Hint: A test run of the depreciation run (for example, for January, CY) shows that depreciation has also been entered for the Press Gr. ## asset in the group depreciation area in the relevant group accounts.
Note: The test run of program RAPOST2000 may run into errors if you have not already defined the optional accounts for one of the tasks before.
© Copyright. All rights reserved.
149
Unit 5 Exercise 31 Analyze the Asset Portfolio
Business Example The cost-accounting department wants the asset accounting department to list the posted assets of your company code, AA##, sorted and totaled according to cost center. Analyze the asset portfolio and execute the report using sort variants. 1. Start an asset balance report (program RABEST_ALV01) with the appropriate sort variant. 2. Use the appropriate sort variant to confirm the profit centers to which the activated assets of your company code, AA##, are assigned. 3. Use SAPmail to send the list to the user sitting in front of or behind you. 4. Check which sort variant to use if you want to display the assets assigned to segments. 5. Change the asset report of your company code, AA##, so that the assets of your company code are listed by acquisition value in descending order. 6. Save the settings in a user-specific display variant or a user-specific layout and then call the variant again. 7. Test the Dynamic Selections function. In your company code, AA## , search for all posted assets that contain your group number in the Description master record field.
150
© Copyright. All rights reserved.
Unit 5 Solution 31 Analyze the Asset Portfolio
Business Example The cost-accounting department wants the asset accounting department to list the posted assets of your company code, AA##, sorted and totaled according to cost center. Analyze the asset portfolio and execute the report using sort variants. 1. Start an asset balance report (program RABEST_ALV01) with the appropriate sort variant. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Asset Balances → Balance Lists → Asset Balances → …by Asset Number ( S_ALR_87011963 ). b) On the Asset Balances screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
Report date
Last day of the CY
Sort variant
0014
c) Select List assets . d) Choose Program → Execute . A report is generated showing the asset balances. e) Go back to the Asset Balances screen. 2. Use the appropriate sort variant to confirm the profit centers to which the activated assets of your company code, AA##, are assigned. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Asset Balances → Balance Lists → Asset Balances → …by Asset Number ( S_ALR_87011963 ). b) On the Asset Balances screen, enter the following data: Field Name or Data Type
Value
Company code
AA##
Report date
Last day of the CY
Sort variant
0016
c) Select List assets . d) Choose Program → Execute . A report is generated showing the asset balances. e) Do not exit the screen. 3. Use SAPmail to send the list to the user sitting in front of or behind you.
© Copyright. All rights reserved.
151
Unit 5: Information System
a) On the report screen, choose List → Mail Recipient . b) Enter the relevant user name (typically, AC305-##) as the recipient. c) Confirm your entries. d) Choose Document → Send . e) Go back to the Asset Balances screen. 4. Check which sort variant to use if you want to display the assets assigned to segments. a) Enter 0024 (company code and segment) in the Sort variant field. b) Execute the report to see the difference between sort variant 0016 and 0024. c) Go back to the Asset Balances screen. 5. Change the asset report of your company code, AA##, so that the assets of your company code are listed by acquisition value in descending order. a) On the Asset Balances screen, enter the following values: Field Name or Data Type
Value
Company code
AA##
Report date
Last day of the CY
Sort variant
0013
b) Select List assets . c) Choose Program → Execute . A report is generated showing the asset balances. d) Select the Acquis. Value column and choose the Sort in Descending Order pushbutton. 6. Save the settings in a user-specific display variant or a user-specific layout and then call the variant again. a) After sorting in descending order, choose Settings → Layout → Save . b) In the Save as dialog box, enter VAR## (## = your group number) in the Layout and Name fields. c) Select User-specific and confirm your entries. The layout is saved. d) Go back to the Asset Balances screen. e) Execute the report. f) Choose Settings → Layout → Choose . g) In the Choose Layout dialog box, select your variant, VAR## . The layout is applied to the report. h) Go back to the Asset Balances screen. 7. Test the Dynamic Selections function. In your company code, AA## , search for all posted assets that contain your group number in the Description master record field. a) On the Asset Balances screen, enter the following data:
152
© Copyright. All rights reserved.
Solution 31: Analyze the Asset Portfolio
Field Name or Data Type
Value
Company code
AA##
Report date
Last day of the CY
Sort variant
0013
b) Select List assets . c) Do not execute this program yet. d) Choose Edit → Dynamic Selections . e) In the frame displayed, expand General data . f) Double-click Description . g) In the Dynamic selections area, enter *##* in the Description field. h) Choose Program → Execute . A report is generated based on the dynamic selection entry.
© Copyright. All rights reserved.
153
Unit 5 Exercise 32 Forecast Future Depreciation Amounts
Business Example You want to simulate depreciation for assets in the depreciation forecast. Forecast and simulate future depreciation amounts. Task 1 Forecast future depreciation amounts. 1. Post an acquisition to the last unposted company car master record. If you do not have any more asset master records without values, simply create a new one in asset class 3100. Post a value of €50,000 on 01/10/CY. 2. What is the quickest way to look at the changes in value of the asset for the next five years? 3. How high is the straight-line annual depreciation amount? 4. For tax reasons, you are considering reducing the useful life in area 01 and area 02 from five to four years. Simulate this change in the Asset Explorer. 5. How high would the annual depreciation amount be? 6. Simulate a subsequent acquisition of €20,000 for the asset on 06/30/CY. 7. You are now interested to find out where annual changes in value will occur in the future, not just for one asset, but for many assets, for example, and entire asset class. Therefore, call the depreciation simulation report (program RASIMU02) for your company code, AA##, and asset class 3100, and display values up to 12/31/CY+2. 8. Display the monthly depreciation amounts of the current year, rather than display the annual planned depreciation amounts, using program RASIMU02. 9. You now want to display the depreciation with alternative depreciation terms for several assets. Which object will you use?
Task 2 Simulate your complete asset class, 3100, again up to CY+2 with depreciation key DG30 instead of the default depreciation key of the asset class LINR.
154
© Copyright. All rights reserved.
Exercise 32: Forecast Future Depreciation Amounts
Hint: Germany currently does not allow depreciation DG30, but this exercise is only to understand the logic of the simulation versions. 1. Create a simulation version ## (## = group number), which reflects the scenario for depreciation areas 01 and 02. A change to the planned useful life is not expected. 2. Start program RASIMU02 for your company code, AA##, and asset class 3100, and display values up to 12/31/CY+2. Also use your new simulation version. What do you notice if you look at the values of the company car asset from preceding exercises, and why?
© Copyright. All rights reserved.
155
Unit 5 Solution 32 Forecast Future Depreciation Amounts
Business Example You want to simulate depreciation for assets in the depreciation forecast. Forecast and simulate future depreciation amounts. Task 1 Forecast future depreciation amounts. 1. Post an acquisition to the last unposted company car master record. If you do not have any more asset master records without values, simply create a new one in asset class 3100. Post a value of €50,000 on 01/10/CY. a) On the SAP E asy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Posting → Acquisition → External Acquisition → Acquis. w/Autom. Offsetting Entry ( ABZON ). b) Enter the posting date and enter 50000 in the Amount posted field. c) Post the acquisition. 2. What is the quickest way to look at the changes in value of the asset for the next five years? a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Asset → Asset Explorer ( AW01N ). b) Choose the Comparisons tab page. 3. How high is the straight-line annual depreciation amount? Answer: €10,000 4. For tax reasons, you are considering reducing the useful life in area 01 and area 02 from five to four years. Simulate this change in the Asset Explorer. a) On the Asset Explorer screen, choose the Switch on simulation pushbutton. b) Choose the Parameters tab page. c) Enter 004 in the Useful life field. d) Similarly, change the useful life for depreciation area 02. e) Choose the Planned values tab page. 5. How high would the annual depreciation amount be? Answer: €12,500 6. Simulate a subsequent acquisition of €20,000 for the asset on 06/30/CY.
156
© Copyright. All rights reserved.
Solution 32: Forecast Future Depreciation Amounts
a) On the Planned values tab page, in the Simulation Transact. area, choose the Trans. Simulation pushbutton. b) On the Simulate Asset Transaction screen, enter the following values: Field Name or Data Type
Value
Document date
06/30/CY
Posting date
06/30/CY
Asset Value Date
06/30/CY
Document type
AA
Amount posted
20,000
Trans. Type
100
c) Choose the Copy pushbutton. d) Go back to the SAP Easy Access screen. 7. You are now interested to find out where annual changes in value will occur in the future, not just for one asset, but for many assets, for example, and entire asset class. Therefore, call the depreciation simulation report (program RASIMU02) for your company code, AA##, and asset class 3100, and display values up to 12/31/CY+2. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Depreciation Forecast → Depreciation on Capitalized Assets ( S_ALR_87012936 ). b) On the Depreciation Simulation screen, enter the following data and execute the report: Field Name or Data Type
Value
Company code
AA##
Asset Class
3100
Report date
12/31/CY+2
The report is generated. Hint: If you simulate correctly, this report will display the master record of your company car as well. 8. Display the monthly depreciation amounts of the current year, rather than display the annual planned depreciation amounts, using program RASIMU02. a) On the report screen, select a different evaluation period. b) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Depreciation Forecast → Depreciation on Capitalized Assets ( S_ALR_87012936 ).
© Copyright. All rights reserved.
157
Unit 5: Information System
c) On the Depreciation Simulation screen, enter 12/31/CY as the report date. d) Choose Edit → All Selections . e) Scroll down to the Evaluation period field group and select Month . f) Execute the report. The simulated document appears. Note: If there is too much information, you can restrict the selection to asset class 3100 again. 9. You now want to display the depreciation with alternative depreciation terms for several assets. Which object will you use? Answer: Use a simulated version.
Task 2 Simulate your complete asset class, 3100, again up to CY+2 with depreciation key DG30 instead of the default depreciation key of the asset class LINR.
Hint: Germany currently does not allow depreciation DG30, but this exercise is only to understand the logic of the simulation versions. 1. Create a simulation version ## (## = group number), which reflects the scenario for depreciation areas 01 and 02. A change to the planned useful life is not expected. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Tools → Simulation Versions ( OAV7 ). b) On the Change View “Simulation versions”: Overview screen, choose the New Entries pushbutton and create simulation version ##. c) Confirm your entries. d) Select the new variant. e) In the dialog structure, double-click Simulation Rules . f) Choose the New Entries pushbutton. g) Create a substitution rule using the following values: Area
Class
Dep. key
1
3100
DG30
2
3100
DG30
h) Save your data. i) Go back to the Depreciation Simulation screen.
158
© Copyright. All rights reserved.
Solution 32: Forecast Future Depreciation Amounts
2. Start program RASIMU02 for your company code, AA##, and asset class 3100, and display values up to 12/31/CY+2. Also use your new simulation version. What do you notice if you look at the values of the company car asset from preceding exercises, and why? Answer: No values are simulated. a) On the Depreciation Simulation screen, choose the All Selections pushbutton. b) Scroll down to the Treatment of capitalizations in current fisc.yr (orders/WBS elements) box/group area. Here, you see that all asset values are simulated on 01/01/CY. However, at this point, the company car in question has not been capitalized; therefore, the report does not display any values of this asset. c) Select Reduce the basis for deprec. simulation of plan inv. by capitalization . d) Choose the Execute pushbutton. Now, you can see the alternative values. For further clarification, see SAP Note 333818. Note: Using asset values on the start date of the fiscal year, ensure that parts of planned capital investments that have been realized already are not counted twice: as plan or budget value of a planned capital investment and as a capitalization posting to an already active fixed asset. If you only carry out a depreciation simulation for active fixed assets, setting the Use asset values as of FY start indicator is not needed; therefore, the program ignores the setting.
Hint: As you can see from the note, the simulation report generated using program RASIMU02 is not only relevant for Asset Accounting (FI-AA), but also for colleagues who carry out major investment measures, in the Investment Management (IM) component.
© Copyright. All rights reserved.
159
Unit 5 Exercise 33 Execute the Asset History Sheet
Business Example As part of the year-end closing, you must present your assets in an asset history sheet. By default, SAP delivers the RAGITT_ALV01 program for that purpose. The asset accounting department wants to know how the program works. Execute and interpret the asset history sheet. 1. Request the asset sheet history (program RAGITT_ALV01) and, using sort variant 13 and asset history sheet version 0001, display all assets of your company code, AA##, individually and then as a group total.
160
© Copyright. All rights reserved.
Unit 5 Solution 33 Execute the Asset History Sheet
Business Example As part of the year-end closing, you must present your assets in an asset history sheet. By default, SAP delivers the RAGITT_ALV01 program for that purpose. The asset accounting department wants to know how the program works. Execute and interpret the asset history sheet. 1. Request the asset sheet history (program RAGITT_ALV01) and, using sort variant 13 and asset history sheet version 0001, display all assets of your company code, AA##, individually and then as a group total. a) On the SAP Easy Access screen, choose Accounting → Financial Accounting → Fixed Assets → Information System → Reports on Asset Accounting → Notes to Financial Statements → International → Asset History Sheet ( S_ALR_87011990 ). b) On the Asset History Sheet screen, enter 0013 in the Sort Variant field. c) Select List assets . d) Choose Program → Execute . The asset history sheet is generated individually. e) Go back to the previous screen. f) Select …or group totals only . g) Choose Program → Execute . The asset history sheet is generated as a group total. h) Double-click the aggregated company code row to display the sheet for each asset.
© Copyright. All rights reserved.
161