EHP7 for SAP ERP 6.0
April 2014
EnglishEnglish
SAP ERP Reports for Accounting (221)APO
SAP AG
Dietmar-Hopp-Allee 16
69190 Walldorf
Germany / Business Process Documentation

© SAP SE Page 6 of 8

SAP Best Practices SAP ERP Reports for Accounting (221): BPD

Copyright

© 2014 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://global.sap.com/corporate-en/legal/copyright/index.epx#trademark 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.


Icons

Icon / Meaning
/ Caution
/ Example
/ Note
/ Recommendation
/ Syntax
/ External Process
/ Business Process Alternative/Decision Choice

Typographic Conventions

Type Style / Description
Example text / Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths, and options.
Cross-references to other documentation.
Example text / Emphasized words or phrases in body text, titles of graphics and tables.
EXAMPLE TEXT / Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.
Example text / Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.
EXAMPLE TEXT / Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.
Example text / Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.
<Example text> / Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.


Contents

1 Purpose 6

2 Prerequisites 6

2.1 Master Data and Organizational Data 6

2.2 Roles 6

2.3 Preliminary Steps 8

2.3.1 Setting Controlling Area 8

2.4 Adding an entry to the User Favorites Menu 8

2.4.1 Simplified : List Reports 9

2.4.2 Simplified : ODP (Operational Data Providers) Reports 9

3 Reports Overview Table 10

4 Reports 12

4.1 General Ledger Reporting 12

4.1.1 Recurring Entry Documents 12

4.1.2 G/L Account Statements 12

4.1.3 Financial Statement 13

4.1.4 Financial Statement: Actual/Actual Comparison 14

4.1.5 Compact Document Journal (List) 14

4.1.6 Line Item Journal (List) 16

4.1.7 Chart of Accounts (List) 18

4.1.8 GL Account Balances: List 19

4.1.9 Vendor Balances: Total List 21

4.1.10 Customer Balances: Total List 22

4.1.11 Document Journal List 23

4.2 Fixed Asset Reporting 25

4.2.1 Inventory List by Cost Center 25

4.2.2 Inventory List by Asset Class 26

4.2.3 Asset Balances 26

4.2.4 Asset Transactions 27

4.2.5 Asset Acquisitions 28

4.2.6 Asset Retirements 28

4.2.7 Asset History Sheet 29

4.2.8 Total Depreciation 30

4.2.9 Depreciation on Capitalized Assets (Depreciation Simulation) 30

4.2.10 Changes to Asset Master Records 31

4.2.11 Asset History (asset chart) 32

4.3 Cost Element Accounting 32

4.3.1 Controlling Documents: Actual Costs 32

4.3.2 Internal Orders: Master Data Report 33

4.4 Cost Center Accounting 33

4.4.1 Cost Centers: New Actual Line items 33

4.4.2 Cost Center: New Plan Line Items 35

4.4.3 Cost Centers: Actual/Plan/Variance 36

4.4.4 Range: Cost Centers 38

4.4.5 Range: Cost Elements 39

4.4.6 Cost Centers: Planning Overview 40

4.4.7 Range: Actual/Budget Commitments 40

4.4.8 Cost Centers: Activity Prices 41

4.5 Internal Orders 41

4.5.1 Orders: New Actual Line Items 41

4.5.2 Orders: New Plan Line Items 42

4.5.3 Orders: Commitment Line Items 43

4.5.4 List: Orders 44

4.5.5 Orders: Actual/Plan/Variance 44

4.5.6 Order: Planning Overview 45

4.5.7 Internal Orders: Master Data Report 45

4.5.8 List: Budget/Actual/Commitments 46

4.6 Product Costing 47

4.6.1 Multilevel BOM: Value/Amount/Status 47

4.6.2 Cost Component 48

4.6.3 Itemization 49

4.6.4 Cost Elements 51

4.6.5 Analyzing/Comparing Material Cost Estimates 52

4.6.6 Analyzing Product Cost Collector 52

4.6.7 Analyzing Product Order 53

4.7 Profitability Analysis 54

4.7.1 Executing Report 54

4.7.2 Profitability Analysis: Display Actual Line Items 55

4.8 Information System 56

4.8.1 Costs/Revenues/Expenditures/Receipts 56

4.8.2 Actual Costs/Revenues 57


SAP ERP Reports for Accounting

1  Purpose

The reporting tools and existing reports can be used to satisfy reporting requirements in most cases. In the area of Accounting various reports can be used to obtain information about all fields of financial accounting.

2  Prerequisites

2.1  Master Data and Organizational Data

The following descriptions refer to accounting-related reporting. There are no specific requirements concerning master data.

2.2  Roles

Use

The following roles must have already been installed to test this scope item in the SAP NetWeaver Business Client (NWBC). The roles in this Business Process Documentation must be assigned to the user or users testing this scope item. You only need these roles if you are using the NWBC interface. You do not need these roles if you are using the standard SAP GUI.

Prerequisites

The business roles have been assigned to the user who is testing this scope item.

A) Business role / B) Technical name / C) Process step /
Employee (Professional User) / SAP_NBPR_EMPLOYEE_S / Assignment of this role is necessary for basic functionality.
Finance Manager / SAP_NBPR_FINACC_M / Recurring Entry Documents
G/L Account Statements
Financial Statement
Financial Statement: Actual/Actual Comparison
Finance Manager/ Financial Reporting / SAP_NBPR_FINACC_M/ SAP_SR_SIMPLIFIED_REPORTING_5 / GL Account Balances
Chart of Accounts
Line Item Journal
Vendor Balance in Local Currency
Customer Balance in Local Currency
General Ledger Accountant/ Financial Reporting / SAP_NBPR_FINACC_S/ SAP_SR_SIMPLIFIED_REPORTING_5 / Compact Document Journal
Document Journal List
Asset Accountant / SAP_NBPR_ASSET_S / Asset Balances
Asset Transactions
Asset Acquisitions
Asset Retirements
Asset History Sheet
Total Depreciation
Depreciation on Capitalized Assets (Depreciation Simulation)
Changes to Asset Master Records
Asset History (asset chart)
Enterprise Controller / SAP_NBPR_CONTROLLER_M / Controlling Documents: Actual
Cost Centers: New Plan Line Items
Range: Cost Elements
Cost Centers: Planning Overview
Range: Actual/Budget/Commitments
Cost Centers: Activity Prices
Orders: New Plan Line Items
Orders: Commitment Line Items
Order: Planning Overview
Internal Orders: Master Data Report
Profitability Analysis : Executing Report
Profitability Analysis: Display Actual Line Items
Enterprise Controller/ Financial Reporting / SAP_NBPR_CONTROLLER_M/ SAP_SR_SIMPLIFIED_REPORTING_5 / Cost Centers: New Actual Line Items
Orders: New Actual Line Items
Enterprise Controller/ Internal Controller / SAP_NBPR_CONTROLLER_M/ SAP_CO_INTERNAL_CONTROLLER / Cost Centers: Actual/Plan/Variance
Orders: Actual/Pan/Variance
List Budget/Actual/Commitments
Product Cost Controller / SAP_NBPR_PRDCOST_CONTRLR_S / Multilevel BOM: Value/Amount/Status
Cost Elements
Analyzing/Comparing Material Cost Estimates
Analyzing Product Cost Collector
Product Cost Controller/ Financial Reporting / SAP_NBPR_PRDCOST_CONTRLR_S/ SAP_SR_SIMPLIFIED_REPORTING_5 / Cost Component
Product Cost Controller/ Internal Controller / SAP_NBPR_PRDCOST_CONTRLR_S/ SAP_CO_INTERNAL_CONTROLLER / Itemization
Analyzing Product Order
Project Manager / SAP_NBPR_PROJECTMANAGER_M / Costs/Revenues/Expenditures/Receipts
Actual Costs/Revenues

2.3  Preliminary Steps

2.3.1  Setting Controlling Area

Use

The controlling area is to be set before you carry out the first steps in controlling.

If the controlling area is already assigned in the user parameters (see the Quick Guide), this step is no longer necessary and can be omitted.

Procedure

1.  Access the transaction choosing one of the following navigation options:

Option 1: SAP Graphical User Interface (SAP GUI)

SAP ECC menu / Accounting ® Controlling ® Cost Element Accounting ® Environment ® Set Controlling Area
Transaction code / OKKS

Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role

Business role / Enterprise Controller
(SAP_NBPR_CONTROLLER_M)
Business role menu / Overhead Cost Controlling ® Actual Postings ® Actual Posting Preparation ® Set Controlling Area

2.  In the Set Controlling Area dialog box, enter Controlling area 1000.

3.  Save your entry as a user parameter.

2.4  Adding an entry to the User Favorites Menu

The creation of a new entry in the favorites menu is only required if you want to make use of the Web Dynpro based reporting functionality using the SAP GUI as listed in the subsequent chapters (section 4. Process Steps). If you only want to use the SAP NWBC or if you do not want to use the Web Dynpro based reporting functionality at all you can skip the following steps.

You can only make use of the Web Dynpro based reporting functionality if the Building Block 589 Planning and Reporting with Web Dynpro has been activated. Please contact your system administrator to find out if this Building Block has been activated.

2.4.1  Simplified : List Reports

Use

This scope item demonstrates simplified reports available with business function. If you do not want to use the NWBC, you might also start the Web Dynpro Applications directly from the Easy Access Menu.

·  With Business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2, List Reports are delivered. The reports cover areas of: General Ledger Accounting (FI-GL) , Accounts Receivable (FI-AR), Accounts Payable (FI-AP), Asset Accounting (FI-AA), Overhead Cost Controlling(CO-OM), Product Cost Controlling (CO-PC), Profitability Analysis (CO-PA).

·  With Business function FIN_REP_SIMPL_4, ODP reports (Operational Data Providers) are delivered.

Procedure

  1. In the SAP Easy Access menu, right-click the Favorites folder and choose Add other objects.
  2. From the list, scroll to the bottom and choose Web Dynpro Application.
  3. In the Web Dynpro Application dialog box, enter the following values:

Field name / User action and values / Comment /
Web Dynpro Applicat. / APB_LAUNCHPAD
Description / Financial Reporting
Application Config.
Parameter / Name:ROLE
Value: FINREP
Parameter / Name:INSTANCE
Value: ERP63

4.  Choose Enter to create the new entry.

2.4.2  Simplified : ODP (Operational Data Providers) Reports

Use

This scope item demonstrates simplified reports available with business function. If you do not want to use the NWBC, you can start the Web Dynpro Applications directly from the SAP Easy Access Menu.

With Business function FIN_REP_SIMPL_4, ODP reports (Operational Data Providers) are delivered.

Procedure

  1. In the SAP Easy Access menu, right-click the Favorites folder and choose Add other objects.
  2. From the list, scroll to the bottom and choose Web Dynpro Application.
  3. In the Web Dynpro Application dialog box, enter the following values:

Field name / User action and values / Comment /
Web Dynpro Applicat. / WDR_CHIP_PAGE
Description / Reports
Application Config. / FCOM_CTRL_PAGE_REPORTS

4.  Choose Enter to create the new entry.

3  Reports Overview Table

A) Report Name / B) Transaction Code / C) Remarks /
General Ledger:
Recurring Entry Documents / S_ALR_87012346
G/L Account Statements / S_ALR_87012332
Financial Statement / S_ALR_87012284
Financial Statement: Actual/Actual Comparison / S_PL0_86000028
GL Account Balances / S_ALR_87012277
Compact Document Journal / S_ALR_87012289
Line Item Journal / S_ALR_87012291
Document Journal List / S_ALR_87012287
EC Sales List / S_ALR_87012400
Advance Return for Tax on Sales/Purchases / S_ALR_87012357
Chart of Accounts / S_ALR_87012326
Vendor Balance in Local Currency / S_ALR_87012082
Customer Balance in Local Currency / S_ALR_87012172
GL Accounts: Balances List / N/A –New Simplified List Report
Vendor Balances: Total List / N/A –New Simplified List Report t
Customer Balances: Total List / N/A –New Simplified List Report
Document Journal List / N/A –New Simplified List Report
Compact Document Journal / N/A –New Simplified List Report
Line Item List / N/A –New Simplified List Report
Chart of Accounts / N/A –New Simplified List Report
Fixed Assets:
Inventory List by Cost Center / S_ALR_87011979
Inventory List by Asset Class / S_ALR_87011981
Asset Balances / AR01
Asset Transactions / S_ALR_87012048
Asset Acquisitions / S_ALR_87012050
Asset Retirements / S_ALR_87012052
Asset History Sheet / S_ALR_87011990
Total Depreciation / S_ALR_87012004
Depreciation on Capitalized Assets (Depreciation Simulation) / S_ALR_87012936
Changes to Asset Master Records / S_ALR_87012037
Asset History (asset chart) / S_ALR_87012075
Cost Element Accounting:
Controlling Documents: Actual Costs / KSB5N
Cost Center Accounting
Cost Centers: New Actual Line Items / KSB1N
Cost Centers: New Plan Line Items / KSBPN
Cost Centers: Actual/Plan/Variance / S_ALR_87013611
Range: Cost Elements / S_ALR_87013613
Cost Centers: Planning Overview / KSBL
Range: Actual/Budget/Commitments / S_ALR_87013648
Cost Centers: Activity Prices / KSBT
Internal Orders:
Orders: New Actual Line Items / KOB1N
Orders: New Plan Line Items / KOBPN
Orders: Commitment Line Items / KOB2N
Orders: Actual/Plan/Variance / S_ALR_87012993
Order: Planning Overview / KABL
ListBudget/Actual/Commitments / S_ALR_87013019
Internal Orders: Master Data Report / KOK5
Product Costing:
Multilevel BOM: Value/Amount/Status / CK86_99
Cost Component / CK80_99
Itemization / CK84_99
Cost Elements / KKBC_MAT
Analyze/Compare Material Cost Estimates / S_P99_41000111
Analyze Product Cost Collector / KKBC_PKO
Analyze Product Order / KKBC_HOE
Profitability Analysis:
Execute Report / KE30
Display Line Item: Actual / KE24
Information System:
Costs/Revenues/Expenditures/Receipts / S_ALR_87013531
Actual/Costs/Revenues / CJI3

4  Reports

4.1  General Ledger Reporting

4.1.1  Recurring Entry Documents

Use