Balance Sheet and Profit & Loss Statement in SAP BW

(1)

Balance Sheet and

Profit & Loss Statement in

SAP BW

(2)

Copyright

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation.

IBM®, DB2®, DB2 Universal Database, OS/2®, Parallel Sysplex®, MVS/ESA, AIX®, S/390®, AS/400®, OS/390®, OS/400®, iSeries, pSeries, xSeries, zSeries, z/OS, AFP, Intelligent Miner, WebSphere®, Netfinity®, Tivoli®, Informix and Informix® Dynamic ServerTM are trademarks of IBM Corporation in USA and/or other countries.

ORACLE® is a registered trademark of ORACLE Corporation.

UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group.

Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®, VideoFrame®, MultiWin® and other Citrix product names referenced herein are trademarks of Citrix Systems, Inc. HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

JAVA® is a registered trademark of Sun Microsystems, Inc.

JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

SAP, SAP Logo, R/2, RIVA, R/3, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP, mySAP.com, and other SAP products and services mentioned herein as well as their respective logos are

trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. MarketSet and Enterprise Buyer are jointly owned trademarks of

SAP Markets and Commerce One. All other product and service names mentioned are the trademarks of their respective owners.

(3)

Icons

Icon Meaning Caution Example Note Recommendation Syntax

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.

(4)

General Ledger Accounting: Balance Sheet & P&L Statement... 5

Cost-of-Sales Ledger: Balance Sheet and P&L ... 7

Stock Value... 9

Flow Value ... 10

Balance Sheet / P&L Statement Item ... 11

Balance-Dependency of a Hierarchy Node ... 12

Bal. Sheet and P&L (Cost-of-Sales Acc.): Actl/Actl Comparison ... 13

Balance Sheet and P&L: Actual/Actual Comparison ... 15

(5)

General Ledger Accounting: Balance Sheet &

P&L Statement

Technical Name: 0FIGL_VC1

Use

This InfoCube is a virtual cube with service. This means that it contains no data. Queries based on this cube are supplied by the implemented services with data from BasisCube 0FIGL_C01.

For queries for displaying a balance sheet and P&L according to a balance sheet/P&L structure, these services calculate the result (profit / loss) and ensure correct display of the balance-dependent

accounts assigned in the balance sheet/P&L structure.

Characteristics

Characteristic Description (long)

0COMP_CODE Company code 0BUS_AREA Business area 0CHRT_ACCTS Chart of accounts 0GL_ACCOUNT General ledger account 0GLACCEXT Balance sheet/P&L item

0VERSION Version

0VTYPE Reporting value type 0CURTYPE Currency type

Time Characteristics

Time

characteristic Description (long)

0FISCVARNT Fiscal year variant 0FISCYEAR Fiscal year 0FISCPER Fiscal year/period 0FISCPER3 Posting period

Key Figures

Key Figure Description (long)

0DEBIT Total debit postings 0CREDIT Total credit postings

(6)

0BALANCE Accumulated balance

0VAL_FLOW Flow value 0VAL_STOCK Stock value

Units

Key Figure Long Description

0CURRENCY Currency key

(7)

Cost-of-Sales Ledger: Balance Sheet and P&L

Technical Name: 0FIGL_VC2

Use

This is a virtual cube with services. This means that it contains no data. Queries based on this cube are supplied by the implemented services with data from BasisCube 0FIGL_C02.

For queries for displaying a balance sheet and P&L according to a balance sheet/P&L structure, these services calculate the result (profit / loss) and ensure correct display of the balance-dependent

accounts assigned in the balance sheet/P&L structure.

Characteristics

Characteristic Long description

0COMP_CODE Company code 0BUS_AREA Business area 0CHRT_ACCTS Chart of accounts 0GL_ACCOUNT General ledger account 0GLACCEXT Balance sheet/P&L item

0VERSION Version

0VTYPE Value type for Reporting 0CURTYPE Currency type

0FUNC_AREA Functional area

Time Characteristics

Time

characteristic Long description

0FISCVARNT Fiscal year variant 0FISCYEAR Fiscal year

0FISCPER Fiscal year / period 0FISCPER3 Posting period

Key Figures

Key figure Long description

0DEBIT Total debit postings 0CREDIT Total credit postings 0BALANCE Cumulative balance 0VAL_FLOW Flow value

(8)

Units

Key figure Long description

0CURRENCY Currency key

(9)

Stock Value

Technical Name: OVAL_STOCK

Use

This key figure is a component of the calculated key figure “balance sheet values” in the following queries:

• Balance sheet and P&L: Actual-Actual Comparison (0FIGL_VC1_Q0001)

• Balance sheet and P&L (Cost-of-Sales Accounting): Actual-Actual Comparison

(0FIGL_VC2_Q0001)

Technical Data

Available from Release SAP BW 3.20

Aggregation Summation

Exception Aggregation Last Value

Calculation Amount in 0CURRENCY

Restriction

(10)

Flow Value

Technical Name: 0VAL-FLOW

Use

This key figure is a component of the calculated key figure “balance sheet values” in the following queries:

• Balance sheet and P&L: Actual-Actual Comparison (0FIGL_VC1_Q0001)

• Balance sheet and P&L (Cost-of-Sales Accounting): Actual-Actual Comparison

(0FIGL_VC2_Q0001)

Technical Data

Available from Release SAP BW 3.20

Aggregation Summation

Exception Aggregation Summation

Calculation Amount using 0CURRENCY

Restriction

(11)

Balance Sheet / P&L Statement Item

Technical name: 0GLACCEXT

Technical Data

Available from Release BW 3.20

External hierarchy Available (not time-dependent)

Use

This characteristic is used to define queries in order to display the balance sheet and P&L account. For further information about queries, see

• 0FIGL_VC1_Q0001: Balance Sheet and P&L: Actual/Actual Comparison

• 0FIGL_VC2_Q0001: Balance Sheet and P&L (Cost-of-Sales Acc.): Actual/Actual Comparison

(12)

Balance-Dependency of a Hierarchy Node

Technical Name: 0BAL_DEPEND

Use

This characteristic is an attribute of a hierarchy node (here: balance sheet/P&L structure). It indicates whether an account is assigned to a balance sheet/P&L item depending on the balance.

Technical Data

Available from Release BW 3.0B

External hierarchy Unavailable

(13)

Bal. Sheet and P&L (Cost-of-Sales Acc.):

Actl/Actl Comparison

Technical name: 0FIGL_VC2_Q0001 Based on: virtual InfoCube 0FIGL_VC2

Use

This query is used to display the balance sheet and P&L according to the cost-of-sales accounting method in two different reporting periods. The reporting periods are expanded in the columns, the balance sheet/P&L item (hierarchically) in the reporting rows.

The balance sheet/P&L is created for a single company code that must be entered using a variable.

Filters

InfoObject Description of the InfoObject (and restriction or

calculation formula)

0COMP_CODE Company code, variable 0P_COCD (individual value, required entry)

0VERSION Version, constant value ‘1’

OCURTYPE Currency type, constant value ‘10’ (company code

currency)

0TYPE Value type, constant value ‘10’ (actual)

0FISCVARNT Fiscal year variant, variable 0P_FVAEX (SAP exit variable)

User-Defined Characteristics

InfoObject Description

0BUS_AREA Business area

0FUNC_AREA Functional area

0GL_ACCOUNT G/L account

Rows

0GLACCEXT Balance sheet/P&L item

Columns

Structure Key figures

Balance sheet value, calculated key figure for InfoCube

0FIGL_VC2:

0FIGL_VC2_CK001 = 0VAL_STOCK + 0VAL_FLOW

(14)

Report time period Selection for characteristic 0FISCPER, variable 0I_FPER

Comparison period Selection for characteristic 0FISCPER, variable 0I_FPER2 (= copy of variable 0I_FPER) Variance (absolute) Formula: ‘Report period’ - ‘Comparison period Variance (%) Formula: ‘Report period’ % ‘Comparison period’

(15)

Balance Sheet and P&L: Actual/Actual

Comparison

Technical name: 0FIGL_VC1_Q0001 Based on: Virtual InfoCube 0FIGL_VC1

Use

This query is used to display the balance sheet and P&L in two different report periods. The report periods are broken down in the columns, the balance sheet structure/P&L is displayed hierarchically in the report rows.

The balance sheet/P&L is created for exactly one company code. This must be entered using a variable.

Filters

0COMP_CODE Company code, variable 0P_COCD (individual value, required entry)

0VERSION Version, constant value “1”

0CURTYPE Currency type, constant value “10” (company code

currency)

0VTYPE Version, constant value “10” (actual)

0FISCVARNT Fiscal year variant, variable 0P_FVAEX (SAP exit variable)

User-Defined Characteristics

InfoObject Description

0BUS_AREA Business area

0GL_ACCOUNT General ledger account

Rows

0GLACCEXT Balance sheet/P&L item

Columns

Structure Key figures

0FIGL_VC1_CK001 1. • Balance value, calculated key figure for the

0FIGL_VC1:

0FIGL_VC1_CK001 = 0VAL_STOCK + 0VAL_FLOW

Structure Periods:

Report period

_1.

_•_{Selection for characteristic 0FISCPER, variable} 0I_FPER

Comparison period

_2.

_•_{Selection for characteristic 0FISCPER,} varianble 0FI_FPER2 (= copy of variable 0I_FPER)

(16)

BI Content 3.2 Add-On 16 3.

Absolute variance • Formula:

‘Report period’ – ‘comparison period’

Variance (%) 4. • Formula:

‘Report period’ % ‘comparison period’