SAP Career Guide - A beginner’s manual on SAP careers for students and professionals

I wish I had been able to read this tutorial earlier.

O. Lázaro Arriola

Reporting for SAP Asset Accounting

This tightly-focused guide zeroes in on the crucial reporting options available in SAP for Fixed Assets Accounting, teaching readers how to manage and supervise fixed assets with the SAP ERP Financials Asset Accounting (FI-AA) component. Based on ECC 6.0,...



  • Preface
  • Preface
  • Chapter 1: Basic Asset Accounting Reporting Features
  • Chapter 2: Asset Balance Reports
  • Chapter 3: Asset Transaction Reports
  • Chapter 4: Asset History Sheet Report
  • Chapter 5: Asset Specialty Reports
  • Chapter 6: US Tax Reports
  • Chapter 7: Reporting Tools
  • Chapter 8: Asset Explorer
  • Resources
  • 1 Basic Asset Accounting Reporting Features
  • 1.1.1 The Importance of the LogDB in Asset Accounting
  • 1.1.2 Other Uses of the LogDB
  • 1.1.3 Accessing the LogDB
  • 1.2.1 Short (Abbreviated) and Full Version of the Basic Selection Screen
  • 1.2.2 Basic Selection Screen Elements
  • 1.3.1 Tracking Property Tax Information
  • 1.3.2 Using Dynamic Selections
  • 1.3.3 The Useful Life Field
  • 1.3.4 Other Not Included Fields
  • 1.4.1 Creating Custom Report Layouts
  • 1.4.2 ALV and Hierarchical Reports
  • 1.5.1 Sort Version Configuration Screen
  • 1.6.1 Multi-Line to Single-Line Conversion
  • 2 Balance Reports
  • 2.1.1 Main Report Purpose and Recipients
  • 2.1.2 Default Report Layout
  • 2.2.1 Main Report Purpose and Recipients
  • 2.2.2 Current Book Value
  • 2.2.3 Differences between the Asset Portfolio and Asset Balance Reports
  • 2.2.4 Reconciliation with the General Ledger
  • 2.3.1 Main Report Purpose and Recipients
  • 2.3.2 The Selection Screen
  • 2.3.3 Asset Fields
  • 2.3.4 Adding Fields to the Total Depreciation Report
  • 2.3.5 Extracting Asset Information
  • 2.4.1 Posted Depreciation by Asset and Posting Period Report
  • 2.4.2 Posted Depreciation related to Cost Centers Report
  • 2.4.3 Default Report Output
  • 2.5.1 Main Report Purpose and Recipients
  • 2.5.2 Actual Year-End Depreciation Amounts
  • 2.5.3 The Selection Screen
  • 2.5.4 Report Output
  • 2.5.5 Caveats
  • 3 Transaction Reports
  • 3.2.1 Main Report Purpose and Recipients
  • 3.2.2 Hierarchical Asset Display
  • 3.2.3 The Selection Screen
  • 3.2.4 Transaction Types
  • 3.2.5 Defining an Asset Acquisition
  • 3.3.1 Main Report Purpose and Recipients
  • 3.3.2 The Selection Screen
  • 3.3.3 Report Output
  • 3.3.4 Statistical Subsequent Cost or Revenue Postings
  • 3.4.1 Main Report Purpose and Recipients
  • 3.4.2 The Selection Screen
  • 3.4.3 Intra-Company Transfers
  • 3.4.4 Specifying Transaction Types
  • 3.4.5 Caveats
  • 3.5.1 Main Report Purpose and Recipients
  • 3.5.2 Creating a Custom Report
  • 3.6.1 Main Report Purpose and Recipients
  • 3.6.2 The Selection Screen
  • 3.6.3 Report Output
  • 3.7.1 Main Report Purpose and Recipients
  • 3.7.2 The Selection Screen
  • 3.7.3 Report Output
  • 4 Asset History Sheet Report
  • 4.2.1 The Selection screen
  • 4.2.2 Sample Report Output
  • 4.2.3 A Sample Custom Asset History Sheet
  • 4.2.4 Reconciling the Asset History Sheet Report
  • 4.3.1 Transaction Types
  • 4.3.2 Assigning Transaction Types to Asset History Sheet Groups
  • 4.3.3 Assigning Asset history Sheet Groups to Asset History Sheet Version Positions
  • 5 Specialty Reports
  • 5.1.1 Main Report Purpose and recipients
  • 5.1.2 The Selection Screen
  • 5.1.3 Standard Report Output
  • 5.1.4 Capturing Asset Information with Third-Party Tools
  • 5.2.1 Main Report Purpose and Recipients
  • 5.2.2 The Selection Screen
  • 5.2.3 Standard Report Output
  • 5.2.4 Specifying Assets to Include
  • 5.3.1 Main Report Purpose and Recipients
  • 5.3.2 The Selection Screen
  • 5.3.3 Limiting the Report to a Specific Field
  • 5.3.4 Basic Report Output
  • 5.3.5 Possible Uses
  • 5.4.1 Main Report Purpose and Recipients
  • 5.4.2 The Selection Screen
  • 5.4.3 Customizing the report
  • 5.4.4 Standard Report Output
  • 5.5.1 Main Report Purpose and Recipients
  • 5.5.2 The Selection Screen
  • 5.5.3 Report Output
  • 5.6.1 Main Report Purpose and Recipients
  • 5.6.2 The Selection Screen
  • 5.6.3 Report Output
  • 5.7.1 Main Report Purpose and Recipients
  • 5.7.2 The Selection Screen
  • 5.7.3 Report Output
  • 5.8.1 Main Report Purpose and Recipients
  • 5.8.2 The Selection Screen
  • 5.8.3 Report Output
  • 6 US Tax Reports
  • 6.1.1 Main Report Purpose and recipients
  • 6.1.2 Selection Screen
  • 6.1.3 Standard Report Output
  • 6.1.4 Including Prior Year Transactions
  • 6.2.1 Main Report Purpose and recipients
  • 6.3.1 Main Report Purpose and recipients
  • 6.3.2 Selection Screen
  • 6.3.3 Basic Report Output
  • 6.3.4 Caveats
  • 6.4.1 Main Report Purpose and recipients
  • 6.4.2 Selection Screen
  • 6.4.3 Standard Report Output
  • 6.5.1 Main Report Purpose and recipients
  • 6.5.2 Selection Screen
  • 6.5.3 Report Output
  • 7 Reporting Tools
  • 7.1.1 When to Use Simulation Versions
  • 7.1.2 Simulation Version Configuration Details
  • 7.2.1 Using Currency Translation Methods
  • 7.2.2 Currency Translation Methods Configuration
  • 7.2.3 Translation On
  • 7.3.1 Making Changes to the Calculation Logic Configuration
  • 7.3.2 Recalculating Values for Several or All Assets
  • 8 Asset Explorer
  • 8.1.1 Depreciation Areas
  • 8.1.2 Related Objects
  • 8.1.3 Asset Transactions
  • 8.1.4 Asset Values
  • 8.2.1 Simulating Changes to Depreciation Parameters
  • 8.2.2 Simulating Asset Transactions
  • A The Author
  • B Additional Resources
  • C Disclaimer

Weitere Informationen


Thomas Michael






1.3 Dynamic Selections

In addition to the fields displayed on the standard selection screen as explained in the previous section, all standard Asset Accounting reports offer what are called Dynamic selections. Dynamic selections provide additional fields for selection on the reporting screen.

These fields include additional asset master record fields and certain administrative information (such as the name of the user who created the asset master record, the date/time of creation, who last changed the asset record, etc.). You can call the dynamic selections by clicking on the corresponding icon as shown in Figure 1.5.

Fixed Assets Accounting

Figure 1.5: The Dynamic Selections icon

Once you invoke the dynamic selections an additional window displays on top of the selection screen which offers a list of additional selection fields. These fields include almost all fields of the asset master record. I say almost all fields because there are a few important fields that are not available, as I will explain in a moment.

Notice that the dynamic selections are organized according to the screen layout of the standard asset master record. For example, the asset master record contains a tab called Net Worth Tax—see Figure 1.6 for the list of fields available on this tab.

1.3.1 Tracking Property Tax Information

The Net Worth Tax tab is used to track certain property tax information for asset master records (Net Worth Tax is an awkward translation for Property Tax). Generally speaking, the fields on this tab are not available on the basic selection screen of asset reports.

Fixed Assets Accounting

Figure 1.6: The Net Worth Tax screen for the asset master record

They are, however, available as dynamic selections in asset reports as shown in Figure 1.7 in the section Net worth valuation.

Fixed Assets Accounting

Figure 1.7: Dynamic selections for Net worth valuation

1.3.2 Using Dynamic Selections

To use any of the fields listed under the dynamic selections, perform the following steps:

1. Select the field.

2. Click on the Copy icon.

The field will then appear as an additional selection criterion. For example, select the field Property indicator as shown in Figure 1.8 and click on the Copy button. SAP will show the Property indicator in a separate box to the right as a dynamic selection criterion.

Fixed Assets Accounting

Figure 1.8 : Dynamic selections—Property indicator

In addition to the most commonly used fields that are included in the asset master record, the dynamic selections also include a section called Administrative Data. This section includes helpful fields such as the name of the user who created the asset as well as the creation date.

Also available are the Changed by and Changed on fields as well as deletion or lock indicators. These fields can be helpful when analyzing who has changed an asset or when an asset was changed. See Figure 1.9 for the list of Administrative Data fields.

Fixed Assets Accounting

Figure 1.9: Dynamic selections—Administrative Data

1.3.3 The Useful Life Field

Remember that earlier I said ‘almost all’ fields are available as dynamic selections? Well, one field that is suspiciously missing from the list of available dynamic selections is the useful life field. Unfortunately, SAP did not include it in the dynamic selections and, as a result, none of the standard SAP Fixed Asset reports allow you to use the Useful Life as a selection criterion.

Since Useful Life is quite an important field in asset reporting, specifically for tax reporting purposes, I suggest you create a custom query or ABAP report that includes the useful life field in the selection screen.

1.3.4 Other Not Included Fields

Other fields that are not included in the dynamic selections are the Depreciation Key (this field is available on the basic selection screen of the Total Depreciation report however—see Chapter 3), Depreciation Start Date (not available on any report) and various other depreciation fields.

Again, a custom query or ABAP report would be a possible solution to this (or the use of BW—Business Warehouse).

Alle Inhalte. Mehr Informationen. Jetzt entdecken. - Ihre Lernplattform für SAP-Software

  • Zugriff auf alle Lerninhalte1
  • Regelmäßige Neuerscheinungen
  • Intelligenter Suchalgorithmus
  • Innovatives Leseerlebnis
  • Maßgeschneidere Lernpfade
  • Zertifikate & QA-Tests2

Sie haben bereits ein Konto?

1 Sie erhalten Zugriff auf alle Lerninhalte. Online-Trainings, Zertifikate sind NICHT Teil der Flatrate.

2 Weitere Informationen auf Anfrage.