Authorizations & Roles

Author(s)

Verification

Approval

João Matos Machado
RtR BO Country Operator
Hugo Vinagre
RtR BO I&D Operational Specialist

Klaus Henke
Regional Manager

Diann Shiver
Organization and Methods Team

Michel Berger
I&D Process Expert

31/08/2015

11/9/2015

21/09/2015


Version Control

Version

Date

Description

01

21/09/2015

New Document


Table of contents
1 Objective and Scope
1.1 Objective of this Procedure
1.2 Scope
2 Reference Documents
3 Definitions
3.1 Abbreviations
 Definitions
 Responsability
4 Main part: Reporting
4.1 General Remarks
4.2 IM Reports only for PF1
4.3 PS Reports
4.4 AA Reports
4.5 Miscellaneous
5 Attachments

 

Objective and Scope

Objective of this Procedure

This document describes the asset accounting related reporting, SAP standard as well as special reports and how to work with variants, sort keys and selection criteria..

Scope

This document includes the necessary transactions for asset accounting reports used in the current PF1 system.

Reference Documents

 

Definitions

Abbreviations


ARq
IM
FO
CAM
PS


Appropriation Request
Investment Management (SAP module)
Front Office
Country accounting Manager
Project System (SAP module)

WBS

Work Breakdown Structure of a project in SAP PS

MC

Material Code

AuC
CO
ALV

Asset under Construction
SAP module cost accounting
ABAP List Viewer (SAP User interface element for displaying tabular data in applications)


 

Definitions

The Material Code (MC) is used for structure and control of investment project costs as well as classification of asset master data. Useful life and account allocation are part of MC definition.

Responsability

 

SBS BO: Group reporting for monthly and annual closing. Ensures a standardized group reporting that allows a high degree of comparability.

FO/CAM: Local reporting, especially for authorities and local statistics or other specific local requirements.

 

Main part: Reporting

The majority of asset accounting related reports are SAP standard reports. Only a few reporting requirements are not covered by standard reports. For these purposes Solvay IT created special reports. The report names and how to work with them is the content of this document.

General Remarks


The SAP standard reports are very flexible, if you use selection options, sort versions and different layouts. And it is possible to store a created version that will be used recurrent, as a variant. The following tools are available in most standard reports. use the standard structure is mandatory for all investment and demolition projects.









All selections



Some reports display on the initial screen chosen selections. To show all available selections, click on "All selections" button .

Multiple Selection



Multiple selections are always used to include or exclude single values or value ranges in or out of a report. Click on button and select.
Include single values:

Include value ranges:

Exclude single values:

Exclude value ranges:

Selection Options


The selection options are also used to include/exclude value in/out of reports. If you want – e.g. – a list of assets with book value only, you select as follows:
Click on multiple selection


click on selection options

Double click on "not equal to"

Result: the report will show assets with book value not equal to zero.

Sort Version


There are a lot of sort versions in the system. Normally you will find the appropriate sort version for your report in the match code table:



If, contrary to expectations, no appropriate sort version is available, contact the IT department. Sort versions are easy to create.

Dynamic Selections



If, after clicking on "All selections" button , the offered selections are not adequate to your requirements, click on "Dynamic selections" :

Additional selectable fields will be offered:

You can also use multiple selections and selection options in dynamic selections:

Variants


If you want to save your selection for recurrent use, create a new variant by clicking on "Save as variant" button:

Make the required entries "Variant name" and "Description":

Finally save your variant!



If you want to use the variant again, call up the report and click on button "Get variant":

To find the variant, enter e.g. the first digits of the variant name and click on "Enter":

Select your variant with a double click:

ALV grid / classic


"The standard system provides functions that allow the user to sort, filter and sum data in tables. Depending on the application, the ALV grid control includes additional application-specific functions and hides functions available in the standard system" (SAP glossary).
The layouts are as follows:


Change Layout


Some reports provide the opportunity to change the layout by including or excluding fields.
Click on the "Change layout" button:

Select the fields you want to show or hide and change the layout by using the arrows. Finally click on "Copy"

IM Reports only for PF1

 

Transaction only in PF1

Program

Description

Y_DE2_22000042

 

Total/annual plan from ARq

Y_DE2_22000044

 

ARq - submit download program

S_ALR_87012806

 

Structure and value list for invest. program








PS Reports

 

Transaction

Program

Description

CJI3

RKPEP003

Project actual cost line items

CJI5

RKPEP005

Project commitment line items

CJE0 (only PF1)

ZZJDOWNPAY

Budg/Plan/Actual/Downpaym/Commitm

S_ALR_87013533

GP3TA7B10C0VKK3GXVZOTZKHT5H

Plan/Actual/Cmmt/Rem.Plan/Assigned

CN41

RPSINFO

Structure overview

CN43N

RPSISPE000

WBS Elements Overview

CN60

RCNCHANGEDOC

Change Documents

S_ALR_87013543

GP19IKIISXT68SL5787G66QHP8F400

Actual/Plan/Variance

S_ALR_87013560 (only WP1)

GP3PP8LLL85SRTYMX9HPZVMU01P

Budget updates

Transaction

Program

Description

CJ20N

SAPLCNPB_M

Project Builder

CJ20

SAPLCJTR

Structure planning

CJ93

SAPLCJSS

Display Standard WBS

CNMASS

RCNMASSCHANGE

Mass Changes in Project System

CNMASSPROT

RCNMASSCHANGEPROT

Display log f. mass changes PS

CJSG

RKPSETG0

Generate WBS Element Group

KJH3

SAPLKKHI

Display WBS Element Groups

KP07

SAPLKPP0

Display Planning CElem/Act. Input

CJ27

SAPLCJWB

Project planning board

CJ2D

SAPLCJWB

Structure planning

CJ9BS

SAPMKPT4

Copy WBS Plan to Plan (Indiv.)

CJ9CS

SAPMKPT4

Copy WBS Actual to Plan (Indiv.)
















AA Reports

 

Transaction

Program

Description

S_ALR_87011990

RAGITT_ALV01

Asset history sheet

S_ALR_87011994

RABEST_ALV01

Asset Balances

S_ALR_87012013

RABIKA_ALV01

Depreciation Comparison

S_ALR_87012052

RAABGA_ALV01

Asset Retirements

S_ALR_87012050

RAZUGA_ALV01

Asset Acquisitions

S_ALR_87012054

RAUMBU_ALV01

Intracompany Asset Transfers

S_ALR_87012026/ S_ALR_87012035

RAHAFA_ALV01

Depreciation

S_ALR_87012015

RAMAFA_ALV01

Manual Depreciation

S_ALR_87012936

RASIMU02

Depreciation Simulation

S_ALR_87012056

RAANLA_ALV01

Directory of Unposted Assets

S_ALR_87012037

RAAEND01

Changes to asset master records

ZDEAPINVENTUR (only PF1)

ZDEAPINVENTUR

Inventory list

Z1A_AA_INVENTORY

Z1A_AA_INVENTORY

Inventory list

ZDEAPGRUND (only PF1)

ZDEAPGRUND

List of Lands


Transaction

Program

Description

S_ALR_87012058

ZDEAHERK01

List of origins of asset charges

S_ALR_87012048

RABEWG_ALV01

Asset Transactions

AUVA

RAUNVA00

Incomplete Assets-Detail List

S_ALR_87012033

AQZZ/SAPQUERY/AM13

Gain for Transfer of Reserves

S_ALR_87012043

RFSSLD00

G/L Account Balances

S_ALR_87012075

RAHIST01

Asset History

S_ALR_87012060

RAHERK02

List of Origins by Cost elements

Z1F_CHECK_FIAA - Check FI-AA Differences.

Z1F_CHECK_FIAA

Check FI-AA differences

Z1A_ASSET_NOTE - Asset Master Data Attachment Note

Z1A_ASSET_NOTE

Asset Master Data Attachment Note

 

Miscellaneous

 

Transaction

Program

Description

S_ALR_87012030

RAVERS01

Insurance Values

S_ALR_87012028

RAVERM_ALV01

Net worth valuation

S_ALR_87011992

RALEAS01

Liabilities from Leasing Agreements

ZDEAPLEAS

ZDEAPLEAS

Liabilities from Leasing Agreements

 

Attachments


End of document