sapguidance.comsapguidance.com/wp-content/uploads/2016/09/221_erp607... · web viewaccounting (...
TRANSCRIPT
EHP7 for SAP ERP 6.0April 2014English
SAP ERP Reports for Accounting (221)
SAP AGDietmar-Hopp-Allee 1669190 WalldorfGermany
Business Process Documentation
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.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
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.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Contents
1 Purpose.................................................................................................................................. 62 Prerequisites.......................................................................................................................... 6
2.1 Master Data and Organizational Data.............................................................................62.2 Roles............................................................................................................................... 62.3 Preliminary Steps............................................................................................................8
2.3.1 Setting Controlling Area...........................................................................................82.4 Adding an entry to the User Favorites Menu...................................................................8
2.4.1 Simplified : List Reports............................................................................................92.4.2 Simplified : ODP (Operational Data Providers) Reports...........................................9
3 Reports Overview Table.......................................................................................................104 Reports................................................................................................................................. 12
4.1 General Ledger Reporting.............................................................................................124.1.1 Recurring Entry Documents...................................................................................124.1.2 G/L Account Statements........................................................................................124.1.3 Financial Statement...............................................................................................134.1.4 Financial Statement: Actual/Actual Comparison....................................................144.1.5 Compact Document Journal (List)..........................................................................144.1.6 Line Item Journal (List)...........................................................................................164.1.7 Chart of Accounts (List)..........................................................................................184.1.8 GL Account Balances: List.....................................................................................194.1.9 Vendor Balances: Total List...................................................................................214.1.10 Customer Balances: Total List...............................................................................224.1.11 Document Journal List............................................................................................23
4.2 Fixed Asset Reporting...................................................................................................254.2.1 Inventory List by Cost Center.................................................................................254.2.2 Inventory List by Asset Class.................................................................................264.2.3 Asset Balances......................................................................................................264.2.4 Asset Transactions.................................................................................................274.2.5 Asset Acquisitions..................................................................................................284.2.6 Asset Retirements..................................................................................................284.2.7 Asset History Sheet................................................................................................294.2.8 Total Depreciation..................................................................................................304.2.9 Depreciation on Capitalized Assets (Depreciation Simulation)...............................304.2.10 Changes to Asset Master Records.........................................................................314.2.11 Asset History (asset chart).....................................................................................32
4.3 Cost Element Accounting..............................................................................................324.3.1 Controlling Documents: Actual Costs.....................................................................324.3.2 Internal Orders: Master Data Report......................................................................33
4.4 Cost Center Accounting................................................................................................334.4.1 Cost Centers: New Actual Line items.....................................................................334.4.2 Cost Center: New Plan Line Items.........................................................................354.4.3 Cost Centers: Actual/Plan/Variance.......................................................................364.4.4 Range: Cost Centers..............................................................................................384.4.5 Range: Cost Elements...........................................................................................394.4.6 Cost Centers: Planning Overview..........................................................................40
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
4.4.7 Range: Actual/Budget Commitments.....................................................................404.4.8 Cost Centers: Activity Prices..................................................................................41
4.5 Internal Orders..............................................................................................................414.5.1 Orders: New Actual Line Items...............................................................................414.5.2 Orders: New Plan Line Items.................................................................................424.5.3 Orders: Commitment Line Items............................................................................434.5.4 List: Orders.............................................................................................................444.5.5 Orders: Actual/Plan/Variance.................................................................................444.5.6 Order: Planning Overview......................................................................................454.5.7 Internal Orders: Master Data Report......................................................................454.5.8 List: Budget/Actual/Commitments..........................................................................46
4.6 Product Costing.............................................................................................................474.6.1 Multilevel BOM: Value/Amount/Status....................................................................474.6.2 Cost Component....................................................................................................484.6.3 Itemization..............................................................................................................494.6.4 Cost Elements........................................................................................................514.6.5 Analyzing/Comparing Material Cost Estimates......................................................524.6.6 Analyzing Product Cost Collector...........................................................................524.6.7 Analyzing Product Order........................................................................................53
4.7 Profitability Analysis......................................................................................................544.7.1 Executing Report....................................................................................................544.7.2 Profitability Analysis: Display Actual Line Items.....................................................55
4.8 Information System.......................................................................................................564.8.1 Costs/Revenues/Expenditures/Receipts................................................................564.8.2 Actual Costs/Revenues..........................................................................................57
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
SAP ERP Reports for Accounting
1 PurposeThe 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 Prerequisites2.1 Master Data and Organizational DataThe following descriptions refer to accounting-related reporting. There are no specific requirements concerning master data.
2.2 RolesUseThe 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.
PrerequisitesThe 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
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
A) Business role
B) Technical name C) Process step
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
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
A) Business role
B) Technical name C) Process step
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 Steps2.3.1 Setting Controlling AreaUseThe 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.
Procedure1. 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 MenuThe 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.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
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
UseThis 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.
Procedure1. 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:ROLEValue: FINREP
Parameter Name:INSTANCEValue: ERP63
4. Choose Enter to create the new entry.
2.4.2 Simplified : ODP (Operational Data Providers) Reports
UseThis 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.
Procedure1. 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
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Field name User action and values Comment
Description Reports
Application Config. FCOM_CTRL_PAGE_REPORTS
4. Choose Enter to create the new entry.
3 Reports Overview TableA) 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 S_ALR_87012936
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
A) Report Name B) Transaction Code C) Remarks
(Depreciation Simulation)
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:
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
A) Report Name B) Transaction Code C) Remarks
Costs/Revenues/Expenditures/Receipts S_ALR_87013531
Actual/Costs/Revenues CJI3
4 Reports4.1 General Ledger Reporting 4.1.1 Recurring Entry DocumentsUseYou use this report to create and print original recurring-entry documents.You are able to determine which documents are: Performed in a particular time period Not Performed during the next run of the recurring entry program
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Document General Recurring Entry Documents
Transaction code S_ALR_87012346
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager (SAP_NBPR_FINACC_M)
Business role menu General Ledger Posting Recurring Documents
2. Only SAP NetWeaver Business Client (SAP NWBC): Enter search criteria and choose Apply.
3. SAP Graphical User Interface (SAP GUI): On the Recurring Entry Documents screen, make the necessary entries to run the report as desired.
4. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result In addition to other information, the company code, document type, posting date, document number, and amounts are displayed. The recurring entry data includes the last run date, and the next run date.In SAP GUI using transaction S_ALR_87012346, you also have the information on document date, first run date and the number of runs.The payment block key, the terms of payment key, and the dunning block key are also displayed for customer and vendor items.
4.1.2 G/L Account Statements UseYou use this report to create statements for customer, vendor, and general ledger (G/L) accounts.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
The primary difference between this report and other item lists for the entry view (line item lists for customers, vendors, and G/L accounts) is that it can be used to produce item lists for G/L accounts without line item display in the entry view.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Line Items G/L Account Statements
Transaction code S_ALR_87012332
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager (SAP_NBPR_FINACC_M)
Business role menu General Ledger Periodic Processing Reporting Account Statement for Customer / Vendor / G/L Account
2. On the Statements for Customers/Vendors/G/L Accounts screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of items, ordered by account, for the customer, vendor, and G/L account types. The fixed asset accounts and material accounts are printed for the G/L account statements; that is, the G/L account statements include G/L accounts, deposit accounts, and material accounts. Clearing accounts in the new general ledger view cannot be displayed using this report because the entry view does not have any line items corresponding to the general ledger line items. The items are divided primarily into account types, that is, postings to reconciliation accounts are represented under the account type for which the relevant reconciliation account is defined.
4.1.3 Financial Statement UseYou use this report to create the balance sheet and profit and loss statements for a user-defined reporting period within a fiscal year, with absolute and relative comparisons for a comparison period.
PrerequisitesThe specified financial statement version must be defined in the system.The line items must be defined for the financial statement version.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Financial Statement/Cash Flow General Actual/Actual Comparisons Financial Statement
Transaction code S_ALR_87012284
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Business role Finance Manager (SAP_NBPR_FINACC_M)
Business role menu General Ledger Periodic Processing Reporting Balance Sheet/P+L Statement
2. On the Financial Statements screen, make the necessary entries to run the report as desired. Alternatively, planned values can also be used for comparison. To do this, the planned version number should be specified in the Plan version field.
3. With this report, you can create as many balance sheets and profit and loss (P+L) statements as required, based on different grouping principles that you define. You can determine how the balance sheet and P+L statement are created, using the financial statement version that you specify in the Fin.stat.version field.
4. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a balance sheet and/or a profit and loss statement.
4.1.4 Financial Statement: Actual/Actual ComparisonUseYou use this report to compare actual data within a certain period to reference data from another period.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Financial Statement/Cash Flow General Actual/Actual Comparisons Financial Statement: Actual/Actual Comparison
Transaction code S_PL0_86000028
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager (SAP_NBPR_FINACC_M)
Business role menu General Ledger Periodic Processing Reporting Fin. Statements: Act/Act Comparison
2. On the Selection: Fin. Statement: Actual/Actual Comparison screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a financial statement. The balance sheet item, values from the evaluation period, values from the reference period, and the absolute deviation are displayed.
4.1.5 Compact Document Journal (List)UseYou use this report to display the most important data from document headers and items for the selected documents, in table form. The list can be used as a journal, and for account
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
reconciliation with the lists of account balances.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Document General Compact Document Journal
Transaction code S_ALR_87012289
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role General Ledger Accountant (SAP_NBPR_FINACC_S)
Business role menu General Ledger Periodic Processing Reporting Compact Document Journal
2. On the Compact Document Journal screen, make the necessary entries to run the report as desired.
3. The information in the document display is divided into four groups (classic list): Document header Customer account/vendor account postings Tax postings G/L account postings
The system creates an individual list for each document status (normal documents, recurring entry documents, sample documents, statistical documents). The document status can be seen in the list heading.For each company code, the system outputs totals sheets following the compact document journal, which list the debit and credit totals for each account type (G/L, customer, or vendor accounts), separated by posting periods.The totals sheets for the corporate group are displayed after the preceding lists when there is more than one company code: first the individual company code totals sheets are displayed, then the company codes are combined with the same local currency, grouped by document status as before.If the totals sheets for the normal documents are used for account reconciliation with the account balances, then you can limit the output to the summary report, where only the totals sheets of the corporate group are issued.For performance reasons, the classic list selection parameters should always be used for large volumes of data.
Procedure II
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Web-Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for Reporting.You can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting General Ledger Reporting (FI-GL)Compact Document Journal (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting Compact Document Journal (List)
2. On the Compact Document Journal screen, make the necessary entries to run the report as desired.
3. The information in the document display is divided into four groups (classic list): Document header Customer account/vendor account postings Tax postings G/L account postings
The system creates an individual list for each document status (normal documents, recurring entry documents, sample documents, statistical documents). The document status can be seen in the list heading.For each company code, the system outputs totals sheets following the compact document journal, which list the debit and credit totals for each account type (G/L, customer, or vendor accounts), separated by posting periods.The totals sheets for the corporate group are displayed after the preceding lists when there is more than one company code: first the individual company code totals sheets are displayed, then the company codes are combined with the same local currency, grouped by document status as before.If the totals sheets for the normal documents are used for account reconciliation with the account balances, then you can limit the output to the summary report, where only the totals sheets of the corporate group are issued.For performance reasons, the classic list selection parameters should always be used for large volumes of data.
Result The system creates a compact document journal.
4.1.6 Line Item Journal (List)UseYou use this report to create an overview of the selected posting documents.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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 and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Document General Line Item Journal
Transaction code S_ALR_87012291
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager (SAP_NBPR_FINACC_M)
Business role menu General Ledger Periodic Processing Reporting Line Item Journal
2. On the Line Item Journal screen, make the necessary entries to run the report as desired.
In addition to other information, the posting date, the document number, document date, the line item, the posting key, the special G/L indicator, the sales-related indicator, the account numbers, and the amounts are output. For the higher control levels, the debit/credit totals of the local currency amounts (total balances) appear. If the parameter Total by Currency is selected, the summed up amounts are output by foreign currency.If the special documents are also to be output, this can be controlled using various parameters. In addition, the amount of data can be limited to certain line items or account types.
Procedure II
Web-Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting General Ledger Reporting (FI-GL)GL Accounts : Line Item (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting GL Accounts : Line Item (List)
Result
The system creates a line item journal.
4.1.7 Chart of Accounts (List)
UseYou use this report to display general ledger (G/L) account master data that is not specific to the company code, and to print out G/L account lists.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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 and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Master Data Chart of Accounts
Transaction code
S_ALR_87012326
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager(SAP_NBPR_FINACC_M)
Business role menu General Ledger Reporting G/L Accounts Chart of Accounts
2. On the Chart of Accounts screen List, make the necessary entries to run the report as desired.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
You can specify selection criteria to limit the number of G/L accounts printed.The system displays the G/L account number and long text first. Select an account from the list to display additional master data that is not specific to the company code.
Procedure II
Web-Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting General Ledger Reporting (FI-GL) Chart of Accounts (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting Chart of Accounts (List)
Result
The selected chart of accounts is displayed.
4.1.8 GL Account Balances: List
UseThis report Lists G/L account balances for individual posting periods
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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 and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Procedure I1. Access the transaction choosing the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Account Balances General G/L Account Balances G/L Account Balances
Transaction code
S_ALR_87012277
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager(SAP_NBPR_FINACC_M)
Business role menu
General Ledger Reporting G/L Accounts G/L Account Balances
2. On the G/L Account Balances screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
G/L account <GL Account> 288000
Company code 1000
Fiscal Year 2014
Currency type 10
Ledger 0L
Reporting Periods <period> From 1 to 16
3. Choose Execute (in NWBC, choose Apply).4. Choose the Display As button to change the reports view to Table and Graphic in NWBC
5. Procedure II
Web-Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting General Ledger Reporting (FI-GL)GL Account Balance : (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Business role menu
Financials Reporting Financials Reporting GL Account Balance (List)
Result
The system creates a list of general ledger balances.
4.1.9 Vendor Balances: Total List
Use
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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 and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure I1. Access the transaction choosing the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Financial Accounting Accounts Payable Information System Reports for Accounts Payable Accounting Vendor Balances Vendor Balances in Local Currency
Transaction code
S_ALR_87012082
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager(SAP_NBPR_FINACC_M)
Business role menu
General Ledger Reporting Payables Vendor Balances in Local Currency
2. On the Vendor Balances: Total List Items screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
Company code 1000
Vendor account <domestic vendor> 300000
Reconciliation account
Fiscal Year 2014
Reporting Periods <period> From 1 to 16
3. (SAP GUI) Choose Execute. (NWBC) Choose Apply.4. Choose the Display As button to change the reports view to Table and Graphic in NWBC.
Result
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Procedure II
Web-Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting Accounts Payable Reporting (FI-AP)Vendor Balance (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu Financials Reporting Financials Reporting Vendor Balance (List)The system creates a vendor line item list.
4.1.10 Customer Balances: Total List
Use
Two options are provided to execute this report:1. Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.2. Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure IReporting.1. Access the transaction choosing the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Financial Accounting Accounts Receivable Information System Reports for Accounts Receivable Accounting Customer Balances Customer Balances in Local Currency
Transaction code
S_ALR_87012172
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Finance Manager(SAP_NBPR_FINACC_M)
Business role menu
General Ledger Reporting Receivables Customer Balances in Local Currency
2. Enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
Customer account <domestic customer> 100000
Company Code 1000
Reconciliation Account
Fiscal Year <year> 2014
Reporting Periods <period> From 1 to 16
3. (SAP GUI) Choose Execute. (NWBC) Choose Apply.4. Choose the Display As button to change the reports view to Table and Graphic. in NWBC.
5. Procedure II
Web Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Financial Reporting Accounts Receivable Reporting (FI-AR)Customer Balance : Total (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting Customer Balance Total : (List)
4.1.11 Document Journal List
Use
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Both options will provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
Procedure IReporting.1. Access the transaction choosing the following navigation option:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Financial Accounting General Ledger Information System General Ledger Reports (New) Document General Document Journal
Transaction code
S_ALR_87012287
SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role General Ledger Accountant(SAP_NBPR_FINACC_S)
Business role menu
General Ledger Reporting Document Journal Document Journal
2. On the Document Journal screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
G/L Account <GL Account> 288000
Company code 1000
Fiscal Year <year> 2014
Ledger 0L
Reporting Periods <period> From 1 to 16
3. (SAP GUI) Choose Execute. (NWBC) Choose Apply.4. Choose the Display As button to change the reports view to Table and Graphic.in NWBC.
Procedure II
Web Dynpro Based UI for ReportingTo use new planning function you should activate BB 589 for ReportingYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies, operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Favorites Financial Reporting General Ledger Reporting (FI-
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
GL)Document Journal (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting Document Journal (List)
Result
The system creates a document journal list.
4.2 Fixed Asset Reporting UseThe Information System in Asset Accounting features a series of reports arranged in a tree structure. Since they are launched with predefined variants, all of the reports in the standard selection tree have an initial screen that is clearly structured and easy to use. These input screens allow you to define various primary selections (for example, by asset number, asset class, cost center, location, and so on). By choosing the All Selections button, you can display the entire input screen. All of the reports are started as standard with the display group totals only option. If you want to display the individual assets, however, you can change this option by choosing All Selections.By choosing the Dynamic Selections button on the report selection screen, you can use all the fields in the general master record section as selection parameters, in addition to the standard selections.Of all the selection criteria, the report date is of particular importance. It specifies which fiscal year is to be analyzed.
The report date is in the past or in the current fiscal yearIn this case, the report date can be the end of the year or a period-end date during the fiscal year. With fiscal years that are already closed, the report date must be the end of the year.
The report date is in a future fiscal yearIn this case, the system changes the report date to the last day in the relevant fiscal year.
You can find all the standard reports under the following menu path in the SAP ECC menu: Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting
Depending on requirements, you can assign additional reports to a copy of the business role Asset Accountant (SAP_NBPR_ASSET_S) in the business role menu Asset Accounting Reporting.
4.2.1 Inventory List by Cost CenterUseYou use this report to create an inventory list of fixed assets by cost center.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Asset Balances
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Inventory Lists Physical Inventory List …by cost center
Transaction code S_ALR_87011979
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Asset Balances Inventory List by Cost Center
2. On the Inventory List screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a physical inventory list by cost center.
4.2.2 Inventory List by Asset ClassUseYou use this report to create an inventory list of fixed assets by asset class.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Asset Balances Inventory Lists Physical Inventory List …by asset class
Transaction code S_ALR_87011981
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Asset Balances Inventory List By Asset Class
2. On the Inventory List screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a physical inventory list by asset class.
4.2.3 Asset BalancesUseYou use this report to create an asset balance and display fixed asset values.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Notes to Financial
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Statements International Asset Balances
Transaction code AR01
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Asset Balances Asset Balances
2. On the Asset Balances screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result This report displays the values of all assets in a depreciation area. The following values are displayed in detail for each asset:
The cumulative acquisition value at the beginning of the fiscal year Accumulated depreciation (the sum of all depreciation types), including the planned
depreciation for the current fiscal year The planned book value at the end of the reporting year
4.2.4 Asset TransactionsUseYou use this report to display asset transactions.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Day-To-Day Activities International Asset transactions
Transaction code S_ALR_87012048
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Day-To-Day Activities Asset Transactions
2. On the Asset Transactions screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The report displays all transactions in a fiscal year by asset. For each document, the report shows the:
Change to the acquisition and production costs Change to the value adjustments Ordinary and special depreciation planned for this transaction
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
4.2.5 Asset AcquisitionsUseYou use this report to display asset acquisitions.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Day-To-Day Activities International Asset Acquisitions
Transaction code S_ALR_87012050
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Day-to-Day Activities Asset Acquisitions
2. On the Asset Acquisitions screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The report displays all acquisition documents in a fiscal year by asset.The following is displayed for each document: Acquired APC Acquired quantity
4.2.6 Asset RetirementsUseYou use this report to display asset retirements.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Day-To-Day Activities International Asset Retirements
Transaction code S_ALR_87012052
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Day-to-Day Activities Asset Retirements
2. On the Asset Retirements screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Home (SAP NetWeaver Business Client).
The retirement costs have no influence on the gain or loss. Retirement costs are independent of gain or loss in this report, and are displayed for statistical purposes only.
Result The report displays, for each asset, the retirement documents in the fiscal year. Each document shows the: Retired acquisition and production costs Retired quantity Retired proportional depreciation Earned revenue Gain/loss Possible retirement costs
4.2.7 Asset History SheetUseThe asset history sheet is the most important and most comprehensive report for the year-end closing or for an interim financial statement.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Notes to Financial Statement International Asset History Sheet
Transaction code S_ALR_87011990
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Asset Balances Asset History Sheet
2. On the Asset History Sheet screen, make the necessary entries to run the report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Make sure that you select the appropriate History sheet version to meet your local legal requirements.
Result A list is generated that shows the progress of a fixed asset´s history from its opening balance through to the closing balance, by means of:
Acquisitions Retirements Transfers Accumulated depreciation
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
4.2.8 Total DepreciationUseThere are a number of depreciation lists to serve as addenda to the profit and loss statement. The depreciation totals list shows the total of all depreciation types.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Explanations for P&L International Depreciation Total Depreciation
Transaction code S_ALR_87012004
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Depreciation Total Depreciation
2. On the Depreciation screen, make the necessary entries to run the report as desired.3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
The depreciation values of the reporting year are planned total annual values. These planned values are not based on the values that have already been posted in the general ledger.
Result The report displays the following values in detail per asset:
The current acquisition value The planned ordinary depreciation for the current fiscal year The planned book value at the end of the fiscal year
4.2.9 Depreciation on Capitalized Assets (Depreciation Simulation)
UseThis report allows you to simulate depreciation many years into the future. The date you enter for the report determines the future fiscal year up to which you want to simulate depreciation.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Depreciation forecast Depreciation on Capitalized Assets (Depreciation Simulation)
Transaction code S_ALR_87012936
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Business role menu Asset Accounting Reporting Depreciation Depreciation Simulation
2. On the Depreciation Simulation screen, make the necessary entries to run the report as desired.
The date you enter for the report determines the future fiscal year up to which you want to simulate depreciation.
Result The report displays the following values:
The book value at the start of the year The cumulative transactions affecting APC, up to the beginning of the current fiscal year The transactions affecting APC in the current fiscal year The planned ordinary depreciation and other depreciation in the current fiscal year The planned net book value at the end of the year The planned interest in the current fiscal year and the cumulative interest up to the
beginning of the current fiscal year
4.2.10 Changes to Asset Master RecordsUseThe report lists changes to asset master records.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Preparation for closing International Changes to Asset Master Records
Transaction code S_ALR_87012037
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Master Data Assets Changes to Asset Master Records
2. On the Changes to Asset Master Records screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The changes are displayed in chronological order.
4.2.11 Asset History (asset chart)UseFor assets that have an especially long useful life and high acquisition and production costs, you may want to keep track of the values for the asset on paper in the form of an asset chart. The report Asset history in the Asset Accounting Information System enables you to print out all information on the history of an asset as a freely definable form.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting History Asset History
Transaction code S_ALR_87012075
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Asset Accountant (SAP_NBPR_ASSET_S)
Business role menu Asset Accounting Reporting Asset Balances Asset History (Asset Chart)
2. On the Asset History screen, make the necessary entries to run the report as desired.3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The Form YB_FIAA_F001 is used to print the asset chart for the selected assets.
4.3 Cost Element Accounting4.3.1 Controlling Documents: Actual CostsUseYou use this report to display actual cost documents.
Procedure1. 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 Information System Reports for Cost and Revenue Element Accounting (New) Document Display Controlling Documents: Actual Costs:New
Transaction code KSB5N
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 Postings Controlling Documents: Actual
With a system based on a database type HDB you can also call the following transaction by directly entering the transaction code to the command field.
Option 3 for HANA:
SAP Menu n/a
Transaction code KSB5N
2. On the Display Actual Cost Documents: Initial screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of documents.
4.3.2 Internal Orders: Master Data ReportUseYou use this report to display internal order documents.
Procedure1. 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 Information System Reports for Cost and Revenue Element Accounting (New) Master Data Indexes Internal Orders: Master Data Report
Transaction code KOK5
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 Master Data Internal Orders
2. On the Selection Criteria: Internal Orders screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of internal orders.
4.4 Cost Center Accounting4.4.1 Cost Centers: New Actual Line items
UseYou use this report to create a list of actual line items for cost center.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated and Business Function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 is active.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Line items Cost Centers: New Actual Line Items
Transaction code
KSB1N
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 Reporting Cost Centers Cost Centers: Actual Line Items New
2. On the Display Actual Cost Line Items for Cost Centers: Initial screen, make the necessary entries to run the report as desired.
3. To perform a more detailed analysis of the actual data, on the Line Item Display Hierarchy View screen, you can switch between various layout options by selecting the corresponding name. Depending on the selection criteria, these layout options are displayed in tabular form at the top or bottom of the screen.
4. Direct Navigation between cost center groups and cost center is available.
See SAP Note 1644201 for selection option details. Some important options are: Accelerated Selection: If this option is selected, the line item report is started
with new selection logic. Fast and summarized report is generated. Start with complete list: If this field is not active, only tree structure is
displayed, but no line item. If you want to drill to line item select this option. Source object (for cost center only): When you select this field, you can
select line item in which the specified posting object was original sender. You can change the current layout by adding new column or create your
own layouts. It provides one click access to predefined layouts.
Procedure IIYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Financial Reporting Cost Center reporting (CO-OM-CCA) Cost Center : Actual line item (list)
Transaction code
N/A
Option2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Business role menu
Financials Reporting Financials Reporting Cost Center reporting (CO-OM-CCA) Cost Center : Actual line item (list)
2. Select the Cost Center: Actual Line Item (List) report.
3. On the Cost Centers: Actual Line Items screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
Controlling Area Your controlling area For example, 1000
Cost Center <cost center> Take F4 and Select as required
Cost Center Group
Take F4 and Select as required
Cost Element Select as required
Cost Element Group
Select as required
Posting Date 01.01. <Current year> until 31.12.<Current year>
From and to
4. Choose Apply5. Choose the Display As button to change the reports view to Table and Graphic
Other List reports are also provided by SAP with this Business function. Some examples follow. All the following reports are not part of the SAP Best Practices role.
Cost centers: Actual/Plan/Variance-cost element (list) Cost Center: Actual /Plan/Variance-Statistical Key Figures (List) Cost Center: Breakdown by Period (list) Cost Center: Breakdown by Partner (List)
Result The system creates a report for actual line items for Cost center.View List reports for Cost Center with flexible analysis and Graphic views.
4.4.2 Cost Center: New Plan Line Items
UseYou use this report to create a list of actual line items for orders with multiple layouts on the same screen.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Line Items Cost Centers: New Plan Line Items
Transaction code KSBPN
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role N/A
Business role menu KSBPN
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
2. On the Display Plan Cost Line Items for Cost Centers: Initial screen, make the necessary entries to run the report as desired.
3. To perform a more detailed analysis of the planning data, on the Line Item Display Hierarchy View screen, you can switch between various layout options by selecting the corresponding name. Depending on the selection criteria, these layout options are displayed in tabular form at the top or bottom of the screen.
4. Direct Navigation between cost center groups and cost center is available.
Refer to Note 1644201 for selection option details. Some important options are listed below:
Accelerated Selection: If this option is selected, the line item report is started with new selection logic. A fast and summarized report is generated.
Start with complete list: If this field is not active, only a tree structure is displayed, but no line item. If you want to drill to a line item, select this option.
Source object (for cost center only): When you select this field, you can select a line item in which the specified posting object was the original sender.
You can change the current layout by adding a new column or create your own layouts. One-click access to predefined layouts is provided.
Result The system creates a report for plan line items for Cost center.
4.4.3 Cost Centers: Actual/Plan/VarianceUseYou use this report to list the actual and plan figures for a cost center or cost center area.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated. This can be verified by using transaction BSANLY_BI_ACTIVATION and check if content bundle FIN_REP_SIMPL_4 is active
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Plan/Actual Comparisons Cost Centers: Actual/Plan/Variance
Transaction code
S_ALR_87013611
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Enterprise Controller(SAP_NBPR_CONTROLLER_M)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Business role menu
Overhead Cost Controlling Reporting Cost Centers Cost Centers: Actual/Plan/Variance
2. On the Cost Centers: Actual/Plan/Variance: Selection screen, make the necessary entries to run the report as desired.
You can use the Report/Report-Interface to access the following reports: Cost Centers: Actual Line Items Cost Centers: Planning Overview Cost Centers: Plan Line Items CCtrs: Period Breakdown Actual/Plan Activity Types: Period Breakdown Stat. Key Figs: Period Breakdown Cost Centers: Breakdown by Partner Cost Centers: Breakdown by B.Trans. Area: Actual/Plan 2 Currencies Display planning long texts
Procedure II
This report lists actual and planned costs as well as the posted quantities on cost centers in the reporting timeframe, one line for each cost element. With business function FIN_REP_SIMPL_4 you can use real time operational reporting to analyze financial data in SAP ERP. After this business function is implemented, customers can access and analyze their ERP data without a separate Business Warehouse (BW) system. Operational Data Provisioning is a metadata concept in SAP NetWeaver that gives an analytic query access to operative data in a backend systemThis report is based on predefined content is delivered for operational reporting.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation optionsOption 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Reports Analytical Reports (on Operational Data Providers) Cost Center : Actual /Plan/Variance-Cost Element
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role
Internal Controller(SAP_CO_INTERNAL_CONTROLLER)
Business role menu
Internal Controller Reports Analytical Reports (on Operational Data Providers) Cost Center: Actual /Plan/Variance-Cost Elements
2. Select Report Cost Center: Actual /Plan/Variance-Cost Element
3. On the List Report on Analytic Query: Cost Centers: Actual/Plan/Difference (Cost Element) Screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Field name Description User actions and values
Comment
Controlling Area Your controlling are
f Take F4 and select or example 1000
Fiscal year/Period
<Current Year> Current yearTake F4 and Select your Fiscal year variant with budget year example K4/ 2014
Plan Version <Your plan version>
Plan/Actual Version 000
Cost Center hierarchy
< Take F4 and and select for example Germany <10001000>
Cost Center Group
Cost Center Take F4 and Select as required
Cost Element Hierarchy
Take F4 and selectFor example < 1000YB_ALL>
Cost element Group
Take F4 and Select as required
Cost Element
4. Choose Execute.5. Choose the Drilldown Settings button.6. Drag and drop to change the drilldown setting as needed.7. Choose the Display As button to change the reports view to Table and Graphic.
Additional ODP reports are provided by SAP, for example Cost centers: Actual Line Items and Cost Center: Actual /Plan/Variance-Statistical Key Figures. These reports though available in system are not part of the SAP Best Practices role.
Result The system creates a report with all actual and plan figures for a cost center or cost center area. View ODP reports with flexible analysis tools like drilldown and Graphic views. Creates a report with all actual and plan figures for a cost center or cost center area.
4.4.4 Range: Cost CentersUseYou use this report to display the actual and plan postings of a cost center area for each cost center, and to total them at area level.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Plan/Actual Comparisons Range: Cost Centers
Transaction code S_ALR_87013612
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Enterprise Controller
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
(SAP_NBPR_CONTROLLER_M)
Business role menu Overhead Cost Controlling Reporting Cost Centers Range: Cost Centers
2. On the Range: Cost Centers: Selection screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
You can use the Report/Report-Interface to access the following reports: Cost Centers: Planning Overview Cost Centers: Actual/Plan/Variance Area: Cost Elements Cost Centers: Breakdown by Partner Cost Centers: Breakdown by B.Trans.
Result The system creates a report with all actual and plan postings of a cost center area for each cost center.
4.4.5 Range: Cost ElementsUseYou use the report to list the plan and actual figures of a cost center area, and balance them for each cost element.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Plan/Actual Comparisons Range: Cost Elements
Transaction code S_ALR_87013613
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 Reporting Cost Elements Range: Cost Elements
2. On the Range: Cost Elements: Selection screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
You can use the Report/Report-Interface to access the following reports: Cost Centers: Actual Line Items Cost Centers: Plan Line Items
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
CCtrs: Period Breakdown Actual/Plan Cost Centers: Planning Overview Cost Centers: Breakdown by Partner
Result The system creates a report with all plan and actual figures of a cost center area.
4.4.6 Cost Centers: Planning OverviewUseYou use this report to create a planning overview for all cost centers.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Planning Reports Cost Centers: Planning Overview
Transaction code KSBL
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 Reporting Cost Centers Cost centers: Planning overview
2. On the Planning Report: Initial screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a cost center planning overview.
4.4.7 Range: Actual/Budget CommitmentsUseYou use this report to create an overview for each cost center with the following information:
Actual costs Commitments Allotted costs Budget
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting More Reports Range: Actual/Budget/Commitments
Transaction code S_ALR_87013648
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Enterprise Controller
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
(SAP_NBPR_CONTROLLER_M)
Business role menu Overhead Cost Controlling Reporting Cost Centers Cost Centers: Actual/Budget/Commitments
2. On the Range: Actual/Budget/Commitments: selection screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates an overview for each cost center outlining actual costs, commitments, allotted costs, and budgets.
4.4.8 Cost Centers: Activity PricesUseYou use this report to create a list of activity prices by cost centers or cost center groups.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Cost Center Accounting Information System Reports for Cost Center Accounting Prices Cost Centers: Activity Prices
Transaction code KSBT
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 Reporting Cost Centers Cost centers: Activity prices
2. On the Activity Type Price Report: Initial screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a price report by cost center.
4.5 Internal Orders4.5.1 Orders: New Actual Line Items
UseYou use this report to create a list of actual line items for orders.
Procedure1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Reports for Internal Orders Line Items Orders: New Actual Line Items
Transaction code KOB1N
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 Reporting Orders Orders: Actual Line Items New
1. On the Display Actual Cost Line Items for Orders: Initial screen, make the necessary entries to run the report as desired.
2. To perform a more detailed analysis of the actual data, on the Line Item Display Hierarchy View screen, you can switch between various layout options by selecting the corresponding name. Depending on the selection criteria, these layout options are displayed in tabular form at the top or bottom of the screen.
3. Direct Navigation between Order groups and order is available.
Refer to Note 1644201 for selection option details. Some important options are listed below:
Accelerated Selection: If this option is selected, the line item report is started with new selection logic. A fast and summarized report is generated.
Start with complete list: If this field is not active, only a tree structure is displayed, but no line item. If you want to drill to a line item, select this option.
You can change the current layout by adding a new column or create your own layouts. One-click access to predefined layouts is provided.
Result The program creates a Report for Actual Line Items for Orders as required.
4.5.2 Orders: New Plan Line Items
UseYou use this report to create a list of plan line items for orders with multiple layouts in same screen.
Procedure1.Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Reports for Internal Orders Line Items Orders: New Plan Line Items
Transaction code KOBPN
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role N/A
Business role menu KOBPN
4. On the Display Plan Cost Line Items for Orders: Initial screen, make the necessary entries to run the report as desired.
5. To perform a more detailed analysis of the actual data, on the Line Item Display Hierarchy View screen, you can switch between various layout options by selecting the corresponding
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
name. Depending on the selection criteria, these layout options are displayed in tabular form at the top or bottom of the screen.
6. Direct Navigation between Order groups and order is available.
Refer to Note 1644201 for selection option details. Some important options are listed below:
Accelerated Selection: If this option is selected, the line item report is started with new selection logic. A fast and summarized report is generated.
Start with complete list: If this field is not active, only a tree structure is displayed, but no line item. If you want to drill to a line item, select this option.
You can change the current layout by adding a new column or create your own layouts. One-click access to predefined layouts is provided.
Result The system creates a report for plan line items for orders.
4.5.3 Orders: Commitment Line Items
UseYou use this report to create a list of commitment line items for orders.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Report for Internal Orders Line Items Orders: Commitment Line Items
Transaction code KOB2
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 Reporting Orders Orders: Commitment Line Items
With a system based on the HDB database type, you have the option to call the transaction directly by entering the transaction code in the command field.
Option 3 for HANA:
SAP Menu N/A
Transaction code KOB2N
2. On the Display Commitment Line Items for Orders: Initial Screen, make the necessary entries to run the report as desired.
3. Choose Back (F3) to the SAP Easy Access screen (SAP GUI).Or
Choose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result © SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
The system creates a list of commitment cost line items for orders.
4.5.4 List: OrdersUseYou use this report to create a list of all orders, by controlling area, for a plan/actual comparison.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Report for Internal Orders Plan/Actual Comparisons List: Orders
Transaction code S_ALR_87012995
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 Reporting Orders List: Orders
2. On the List: Orders: Selections screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of orders by controlling area.
4.5.5 Orders: Actual/Plan/VarianceUseYou use this report to create an overview of the actual and plan data on internal orders in the reporting timeframe for each cost element, cost element group, and statistical key figure.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Report for Internal Orders Plan/Actual Comparisons Orders: Actual/Plan/Variance
Transaction code S_ALR_87012993
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 Reporting Orders Orders: Actual/Plan/Variances
2. On the Orders: Actual/Plan/Variance: Selection screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Result The system creates a list of the actual and plan data on internal orders.
4.5.6 Order: Planning OverviewUseYou use this report to create a planning overview by order.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Report for Internal Orders Planning Reports Order: Planning Overview
Transaction code KABL
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 Reporting Orders Orders: Planning Report
2. On the Planning Report: Initial Screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a planning report for orders.
4.5.7 Internal Orders: Master Data Report
UseYou use this report to display internal order documents.
Procedure4. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Controlling Internal Orders Information System Reports for Internal Orders Master Data Indexes Internal Orders
Transaction code
KOK5
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 Master Data Internal Orders Internal Orders Homepage
5. On the Master Data List for Orders: Initial screen, make the necessary entries to run the report as desired.
Result
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
The system creates a list of internal orders.
4.5.8 List: Budget/Actual/CommitmentsUseYou use this report to create a list concerning budget/actual/commitments for internal orders.This activity monitors the order progress.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.
Both options will provide the same results but with different analysis options.
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.
Procedure I1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Internal Orders Information System Reports for Internal Orders More Reports List: Budget/Actual/Commitments
Transaction code S_ALR_87013019
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 Reporting Orders Orders: List: Budget/Actual/Commitments
2. On the selection screen enter the following data:
Field name Description User action and values Comment
Controlling Area 1000
Order Group
Or value (s) <Enter order number as required>
3. Choose Execute (F8).
Procedure II
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter Error: Reference source not found Error: Reference source not found.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
SAP ECC menu Favorites Reports Analytical Reports (on Operational Data Providers) Orders: Budget/Actual/Commitment
Transaction code N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Internal Controller(SAP_CO_INTERNAL_CONTROLLER)
Business role menu Internal Controller Reports Analytical Reports (on Operational Data Providers) Orders: Budget/Actual/Commitment
2. On the List Report on Analytic Query: Budget / Actual / Commitment screen make the following entries in the Selection section:
Field name Description User actions and values Comment
Controlling Area is
1000
Order Hierarchy is
Order Group is
Order Number is <Enter order number as required>
3. Choose Execute.
Result The system creates a list outlining budget/actual/commitment for internal orders.
4.6 Product Costing4.6.1 Multilevel BOM: Value/Amount/StatusUseYou use this report to create a list of bills of materials (BOM) with costs.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Information Systems Accounting Controlling Reports for Product Cost Controlling Reports for Product Cost Planning Detailed Reports For Material Costed Multilevel BOM
Transaction code
CK86_99
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller(SAP_NBPR_PRDCOST_CONTRLR_S)
Business role menu
Product Cost Controlling Reporting Costs Multilevel BOM: Value / Amount / Status
2. On the Multilevel BOM: Value / Amount / Status Initial screen, make the necessary entries to run the report as desired.
Result The system creates a list of costed bills of materials.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
4.6.2 Cost Component
UseYou use this report to create a list of cost components for the cost estimate.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Information Systems Accounting Controlling Reports for Product Cost Controlling Reports for Product Cost Planning Detailed Reports For Material Cost Components
Transaction code
CK80_99
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller(SAP_NBPR_PRDCOST_CONTRLR_S)
Business role menu
Product Cost Controlling Reporting Costs Cost Component Split
2. On the Analyze Cost Components Split for Planned Cost: Cost Components: Initial screen, make the necessary entries to run the report as desired.
Procedure IIYou can use the new Reporting Financials business function FIN_REP_SIMPL_1 and FIN_REP_SIMPL_2 to generate reports from SAP NetWeaver Business Intelligence and POWER lists. For small to midsize companies operating without SAP NetWeaver BI, the business function offers a manageable and cost-effective option.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Financial Reporting Product Cost Reporting (CO-PC) Product Costing Analysis: Cost Component Split (List)
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role
Financial Reporting(SAP_SR_SIMPLIFIED_REPORTING_5)
Business role menu
Financials Reporting Financials Reporting Product Cost Reporting (CO_PC) Product Cost Analysis: Cost Component Split (List)
2. On Product Cost Analysis: Cost Component Split (List) Items screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Field name Description User actions and values
Comment
Material Any FERT or HALB material
Example F126
Plant Take F4 and Select for Example 1000
Costing Variant
< Standard Costing variant>
Take F4 and Select for example YPC1
Costing Version
< Standard Costing version>
Take F4 Select for example 01
Costing View Take f4 and Select as required, for example 01
Costing Date Required date
3. Choose Apply.4. Choose the Display As button to change the reports view to Table and Graphic.
Result The system creates a list of cost components.
4.6.3 ItemizationUseYou use this report to create a list showing itemization of the cost estimate.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options.
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. Contact your system administrator to find out if this Building Block has been activated. This can be verified by using transaction BSANLY_BI_ACTIVATION and check if content bundle FIN_REP_SIMPL_4 is active.
Procedure I1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Information Systems Accounting Controlling Reports for Product Cost Controlling Reports for Product Cost Planning Detailed Reports For Material Itemization
Transaction code
CK84_99
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller(SAP_NBPR_PRDCOST_CONTRLR_S)
Business role menu Product Cost Controlling Reporting Costs Itemization
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
2. On the Analyze Itemization: Item Categories (Grouped): Initial screen, make the necessary entries to run the report as desired.
Procedure IIDetailed material cost analysis based on multi-level itemization.With business function FIN_REP_SIMPL_4 you can use real time operational reporting to analyze financial data in SAP ERP. After this business function is implemented, customers can access and analyze their ERP data without a separate Business Warehouse (BW) system. Operational Data Provisioning is a metadata concept in SAP NetWeaver that gives an analytic query access to operative data in a backend systemThis report is based on predefined content is delivered for operational reporting.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Reports Analytical Reports (on Operational Data Providers) Product Costing Analysis: Itemization
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Internal Controller(SAP_CO_INTERNAL_CONTROLLER)
Business role menu
Internal Controller Reports Analytical Reports (on Operational Data Providers) Product Costing Analysis: Itemization
2. Select Report Product Cost Analysis: Itemization3. On the List Report on Analytic Query: Product Costing Analysis: Itemization Screen, enter
selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values
Comment
Plant Your plant Take F4 and select for example 1000
Costing View <Standard Costing view>
Take F4 and select for example 01
Material Plan/Actual Version Take F4 and select for example F126
Costing Variant <Standard Costing Variant>
Take F4 and select for example YPC1
Costing Version 01
Costing Date is between
Start and end date of the year
You can select any period
Costing Level For example 2
4. Choose Execute.5. Choose the Drilldown Settings button.6. Drag and drop to change the drilldown settings.7. Choose the Display As button to change the reports view to Table and Graphic.
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Result The system creates a list of item categories. View ODP reports with flexible analysis tools like drilldown and Graphic views. Creates a report Detailed material cost analysis based on multi-level itemization.
4.6.4 Cost ElementsUseYou use this report to create a list of cost elements in the cost estimate.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Information Systems Accounting Controlling Reports for Product Cost Controlling Reports for Product Cost Planning Detailed Reports For Material Cost Elements
Transaction code KKBC_MAT
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller (SAP_NBPR_PRDCOST_CONTRLR_S )
Business role menu Product Cost Controlling Reporting Costs Itemization
2. On the Analyze Material Cost Estimate: Cost Elements screen, make the necessary entries to run the report as desired.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of cost elements.
4.6.5 Analyzing/Comparing Material Cost EstimatesUseYou use this report to compare material cost estimates.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Product Cost Controlling Product Cost Planning Information System Object List For Material Analyze/Compare Material Cost Estimates
Transaction code S_P99_41000111
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller (SAP_NBPR_PRDCOST_CONTRLR_S )
Business role menu Product Cost Controlling Reporting Costs Analyze / Compare Material Cost Estimates
2. On the Analyze/Compare Material Cost Estimates screen, make the necessary entries to run the report as desired.
1. Choose Back to return to the SAP Easy Access screen (SAP GUI)
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list that allows you to compare material cost estimates.
4.6.6 Analyzing Product Cost CollectorUseYou use this report to analyze product cost collectors.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Product Cost Controlling Cost Object Controlling Product Cost by Period Information System Reports for Product Cost by Period Detailed Reports For Product Cost Collectors
Transaction code KKBC_PKO
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller (SAP_NBPR_PRDCOST_CONTRLR_S )
Business role menu Product Cost Controlling Reporting Production and Process Orders Analyze Product Cost Collector
2. On the Analyze Product Cost Collector: Target/Actual Comparison screen, make the necessary entries to run the report as desired.
2. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of product cost collectors.
4.6.7 Analyzing Product Order
UseYou use this report to analyze product orders.
Two options are provided to execute this report:Procedure I: Run the report with transactions in SAP GUI or SAP NWBC.Procedure II: Run the report via SAP GUI or SAP NWBC using Web Dynpro technology.Both options will provide the same results but with different analysis options
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. Contact your system administrator to find out if this Building Block has been activated. This can be verified by using transaction BSANLY_BI_ACTIVATION and check if content bundle FIN_REP_SIMPL_4 is active.
Procedure I© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Accounting Controlling Product Cost Controlling Cost Object Controlling Product Cost by Order Information System Reports for Product Cost by Order Summarized Analysis With Defined Summarization Hierarchy
Transaction code
KKBC_HOE
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Product Cost Controller(SAP_NBPR_PRDCOST_CONTRLR_S)
Business role menu
Product Cost Controlling Reporting Sales Orders Analyze Summarization Object
2. On the Analyze Summarization Object: Plan/Actual Comparison screen, make the necessary entries to run the report as desired.
Procedure IIAggregated target/actual variance analysis based on production orders.
With business function FIN_REP_SIMPL_4 you can use real time operational reporting to analyze financial data in SAP ERP. After this business function is implemented, customers can access and analyze their ERP data without a separate Business Warehouse (BW) system. Operational Data Provisioning is a metadata concept in SAP NetWeaver that gives an analytic query access to operative data in a backend systemThis report is based on predefined content is delivered for operational reporting.
To use option 1 (SAP GUI) make sure that you have executed all steps listed in chapter 2.4 Adding an entry to the User Favorites Menu.
1. Access the transaction choosing one of the following navigation options:Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu
Favorites Reports Analytical Reports (on Operational Data Providers) Production Cost Analysis: Variances
Transaction code
N/A
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role
Internal Controller(SAP_CO_INTERNAL_CONTROLLER)
Business role menu
Internal Controller Reports Analytical Reports (on Operational Data Providers) Production Cost Analysis: Variances (ODP)
2. On the List Report on AnalyticQuery: Production Cost Analysis: Variances Screen, enter selection criteria as follows or make the necessary entries to run the report as desired.
Field name Description User actions and values Comment
Controlling area Your controlling area For Take F4 and select for example 1000
Plant Take F4 and select for example 1000
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Field name Description User actions and values Comment
Target Cost Version
Basis of variance calculation Take F4 and select for example version 0
Material <Any material relevant for standard costing>
Take F4 and select for example F126
Period is between
Start and end date of the year You can select any period
Product Hierarchy
Take F4 and select For example PROHD
3. Choose Execute.4. Choose the Drilldown Settings button.5. Drag and drop to change the drilldown setting as needed.6. Choose the Display As button to change the reports view to Table and Graphic.
Result The system creates a list of product orders. View ODP reports with flexible analysis tools like drilldown and Graphic views. In this report, you get aggregated target/actual variance analysis based on production orders.
4.7 Profitability Analysis4.7.1 Executing ReportUseYou use this report to create several profitability reports:
Execute Drilldown Report Plan/Actual Sales Detail List Execute Drilldown Report Plan/Actual Sales Mat. Costs Execute Drilldown Report Plan/Actual Sales OH Costs Execute Drilldown Report Reconciliation
Procedure1. Access the report choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Profitability Analysis Information System Execute Report
Transaction code KE30
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Enterprise Controller (SAP_NBPR_CONTROLLER_M)
Business role menu Profitability Analysis Reporting Execute profitability report
2. On the Run Profitability Report: Initial Screen, choose one report as desired. 3. Choose Back to return to the SAP Easy Access screen (SAP GUI)
OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates the selected plan/actual sales report.
4.7.2 Profitability Analysis: Display Actual Line Items
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
UseYou use this report to display actual line item in COPA.
Procedure1. Access the report choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Accounting Controlling Profitability Analysis Information System Display List Item- Actual
Transaction code KE24
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Enterprise Controller(SAP_NBPR_CONTROLLER_M)
Business role menu Profitability Analysis Reporting Display Profitability Analysis Document
4. If you have called the transaction for the first time, the Set Operating Concern dialog box displays. Make the following entries:
Field name Description User action and values Comment
Operating Concern
10IN Your controlling area
5. Choose Enter.
6. On the Display Actual Line Items: Initial Screen, make the following entries:
Field name Description User action and values Comment
Period/year <period and year of the settlement, in format MM/YYYY>
CO order <your order number> Or any other selection criteria
Company code
1000
7. Choose Execute (F8) to run the report.
8. Confirm the Line Items: Selection Criteria dialog box by choosing Enter.
You reach the Display Actual Line Items: List screen.
9. On the Display Actual Line Items: List screen, highlight the line item you want to analyze by selecting it and choose the Choose (F2) button to display the detail, or double-click the line that you want to display.
10. On the Display Line Items screen, scroll down on the Characteristics tab.
11. On the Display Line Items screen, choose the Value Fields tab and scroll down. You see the total cost settled
12. Choose Back twice.
Result © SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
You have verified that your data has been properly transferred to Profitability Analysis.
4.8 Information System4.8.1 Costs/Revenues/Expenditures/ReceiptsUseYou use this report to create a cost/revenues/expenditures/receipts report for projects.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Information System General Report Selection Controlling Projects Costs/Revenues/Expenditures/Receipts
Transaction code S_ALR_87013531
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Project Manager (SAP_NBPR_PROJECTMANAGER_M)
Business role menu Project Management Project Execution Project Reports Costs/Revenues/Expenditures/Receipts
2. On the Selection Costs/Revenues/Expenditures/Receipts screen, make the necessary entries to run the report as desired. You should ensure that the desired selection criteria are correctly maintained in the system.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)OrChoose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a report outlining costs, revenues, expenditures, and receipts.
4.8.2 Actual Costs/RevenuesUseYou use this report to create a list of actual cost line items for projects.
Procedure1. Access the transaction choosing one of the following navigation options:
Option 1: SAP Graphical User Interface (SAP GUI)
SAP ECC menu Information System General Report Selection Controlling Projects Line Items Actual Costs/Revenues
Transaction code CJI3
Option 2: SAP NetWeaver Business Client (SAP NWBC) via Business Role
Business role Project Manager (SAP_NBPR_PROJECTMANAGER_M)
Business role menu Project Management Project Execution Project Reports Display Project Actual Cost Line Items
2. On the Display Project Actual Cost Line Items screen, make the necessary entries to run the report as desired. You should ensure that the desired selection criteria are correctly maintained in the system.
3. Choose Back to return to the SAP Easy Access screen (SAP GUI)Or
© SAP SE Page 6 of 8
SAP Best Practices SAP ERP Reports for Accounting (221): BPD
Choose Exit (Shift+F3) and confirm the Business client message with Yes to return to SAP Home (SAP NetWeaver Business Client).
Result The system creates a list of actual cost line items for projects.
© SAP SE Page 6 of 8