Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Support Wiki
Spaces
Help
Log in
Pages
ERP Financials
Reporting
Skip to end of banner
Go to start of banner
Report Painter
Skip to end of metadata
Created by SAI KRISHNA VALLURUPALLI on Oct 26, 2007
Go to start of metadata
1 FEATURES OF REPORT PAINTER (RP)
Relatively simple reporting creation - define rows and columns.
Use of sets (groups) for Cost Centers, Cost Elements, Funds, etc :
Sets for selections - for report overall, individual column filtering and totals.
Hierarchical sets for automatic sub-totals in the rows.
Suppression of reported details in the set.
Characteristic display : choose the key (e.g. "4700") or description ("Power Fund") or both.
Authorization checks, if required, on SAP pre-defined fields - e.g. Cost Center and Cost Elements in CO Cost Center Accounting reports.
Easier than Report Writer (RW) since it is really a graphical front-end to RW. There are a few limitations in RP which RW does not have :
a characteristic can only be used in one part of the report structure - in rows or columns or in the general selection.
cannot use existing multi-dimensional sets
page break specifications
defining thresholds per section, etc
RP reports can be edited with / converted to RW and even to ABAP if required.
Column display formats can be set : e.g. scaling to 000's with one decimal place.
Headers : can include selection / drilldown variables.
Several reports can be included in the same "Report Group" and are run together, with the same general selections.
Other reports can be called up - other RW/PR reports, ABAP Queries, ABAPs and transactions (including master data display) - the selected cell's characteristics (Year, Cost Center etc) are transferred.
Report results can be stored as extracts and re-displayed instead or re-running the report.
Report definition management : use TMS (transports), or use export/import to/from PC files, or copy across clients.
2 CONSTRAINTS
RP/RW only works with reporting structures that have been pre-defined. The existing database tables are linked through a reporting structure - like "CCSS" - and then there is further RW Control tables definition. This last step is very technical and is not recommended for SAP customers or for that matter most consultants. Also, the RW tables have the Authorization Check assigned - e.g. CCSS has E14_AUTHORITY_CHECK and filler routines for the fields. For user-defined tables there may need to be additional Authorization Check routines written and assigned to the RW table. [See GRCT for technical set-up of a RW "table".] Also, SAP recommends using selection variants and display variants for Line Item reports. Note : only the CO line items have the Fund field, not the CO totals tables.
3 SAP HELP
See : Financials / Special Purpose Ledger / Tools See : Financials / Controlling / Cost Center Accounting / Information System / Report Definition
4 ELEMENTS FOR REPORTING
4.1 Conventions
Each of the following aspects of defining the report will need naming conventions : - Libraries - e.g. cannot start with a number.
- Reports
- Report Groups - e.g. cannot start with a number.
- Sets
- Variables, Set Variables and Formula Variables. Additionally there need to be layout conventions for : - Report cover page
- Report titles
- Report headers - include run date, time, client
- Report footers
- Page numbering
- Column headings & formatting
4.2 REPORT WRITER TABLES AND LIBRARIES.
Report Writer Tables specify the data tables available for, and the reporting structure used for RW/RP reports. (These tables are defined with GRCT, and can include various ABAP routines for authorization exits, data filler and conversion routines for presentation and texts etc). Report Writer Libraries are set up to further define the data required for reports (limit available fields or change texts). Libraries are linked to the RW tables. RW (and RP) reports which require similar data or will be developed or run but a specific group of users can share a library. Many libraries can be linked to the same RW table.
- Libraries are usually set up, delivered and supported by SAP. It is possible to set up your own, but this can be a comlex task, depending on the reporting requirements and a Logical Database, Query InfoSet or ABAP may be a quicker option. The most often used RW Tables are :- CCSS Cost Center, Order and WBSE data. - RWCOOM Overhead Cost Controlling (Spec. Evaluations)
- FMRBCS FM Budget Control System data
- GMIT Grants Management
- ZZSPLITT FI-Special Ledger (Fund General Ledger)
- FIMC EC-CS Consolidations Ledger
- GLPCT, GLTPC EC-PCA Profit Center Accounting
- RPPS Project System Summarization table- COFIT CO/FI Reconciliation Ledger - use standard reports. - Sxxx Various Purchasing and SIS reporting structures SAP RW Library Numbering : e.g. :
- 0xx A few banking/GL reports
- 1xx Various different CCA reports- 1VK Most Standard Cost Center reports are in here
- 3xx Purchasing and SIS reporting
- 4xx Various - e.g. in Public Sector, 4FM (for FM reporting)
- 5xx CO/FI reconciliation ledger reports
- 6Ox Internal Order reporting
- 6P3 Project reporting - this has the "Object" field and is linked to the PS component, so the selection fields for the LDB PSJ are automatically included.
- 7xx Product Costing
- 8xx Profit Center Accounting
- 9xx Activity Based Costing
CUSTOMER RW Library Numbering : e.g. :
- ZVK Copy of 1VK - with Fund field activated. In DV1.210 and 220 only.
o Note : Fund is on Line Item table, so if referenced the report will take longer to run. Use a Cost Center group by Fund instead (see section 4.4 on Sets).
- ZP2, ZP3 Copy of 6P2 and 6P3 for project reporting
- ZSL Created for the Fund Accounting Ledger (Special Ledger)
- ZFM Copy of 4FM for Funds Management
Library definition
- Characteristics for reporting : like Cost Center, Fiscal Year, Cost Element, Plan/Actual Indicator.
- Default Sets can be entered - appear on report selection screens.
- Basic Key Figures : numeric fields from the tables - e.g. costs. Behind the scenes the Key Figure is categorized as value field or a field group with period counter in field name.
- (Predefined) Key Figures : basic key figures with additional characteristics - e.g. costs for the current fiscal year or the current period. Prefix for CO Module predefined Key Figures are typically :
- I = actuals, P = planned
- Y = stat. actual, Q = stat. planned
- O = commitments (requisitions & purchase orders).
- Predefined Basic Key Figures for CCSS :
See Appendix B.
4.3 REPORT GROUPS
a. A Report Group is a way to group reports with the same selection criteria. The program selects from the database only once, then each report is processed separately on the selected data.
b. The Report Group is the only way to run the report. It is the generated program based on the report code, variable definition, set definition etc.
c. Report : report group combinations :
- A Report Group can have only one report.
- A Report Group can have several reports.
- A report can be in more than one report group - e.g. in a group by itself, in a monthly run group with a few other reports and in a year-end group with many other reports.
d. A Report Group can be set up to re-generate each time it is executed - all reports in it will be recompiled before executing. Or the setting can be for manual generation, which is recommended in a production system - move the report group there, generate it and it does not waste time recompiling each time it is run.
e. When a Report Group is executed (GR55), the user has the option to deselect any reports not required.
f. The Report Group (or the Library) can also identify other reports (or transactions) to call up when drilling down on a cell in the executed report. E.g.
- Transaction FB03 Display FI-GL Document
- Transaction KSB5 Display CO Document
- ABAP RKPEP004 PS WSBE Line Item Report
- Transaction KSB1 Cost Center Line item Report - Actuals
- Transaction KSBP Cost Center Line item Report - Plan
- Transaction KSB2 Cost Center Line item Report - Commitments
- Report Group ZFM1 Budget Analysis
4.4 REPORTS
4.4.1 REPORTS - General
a. A report is always created with reference to the pre-defined library.
b. A standard SAP library can be copied and amended - e.g. 1VK can be copied to ZVK and changed so the "Fund" field is made available for reporting.
c. A characteristic can be specified in only one place - column, row or general selection criteria.
d. Most standard SAP reports focus on Cost Centers, or orders or Projects. Only a few cover more than one :
- Report 1SOP-001 has CC, Internal Order & WBSE - based on the Responsible Cost Center in the Order and WBSE.
- Report 1SO1-002 + 1SO1-003 has CC and Internal Order reported separately but run together.
4.4.2 REPORTS - Define Columns
a. Select a predefined Basic Key Figure (calculated value) to report in the column.
b. If a characteristic (e.g. Fiscal Year) is specified with the Key Figure - the characteristic cannot be used for row definition or general data selection.
c. Note: often use Value Type in the column 1 = Plan, 4 = Actual - if it is not already part of the Key Figure definition.
d. The column can also be a simple formula - for ratios and variances.
e. Predefined Column Models can be copied into the report.
f. Columns can be used for intermediate calculations - and hidden if they are not required to be reported.
g. Column Header can have a variable. Prefix with "&". Also, if the variable is numeric, can have a calculation in the heading: e.g. "&CURYEAR - 1".
4.4.3 REPORTS - Define Lead Column = rows.
a. Specify one or more characteristics for reporting down the left hand column = the "lead column" = the rows.
- If several characteristics are specified, they appear in the same column, not separate columns, as a roll-up : e.g. Fund / Cost Center / Cost Element. The sequence of the fields can be specified in Edit à Rows à Explode. Also :
o If Single is chosen, the field is listed.
o If Explode is chosen and a hierarchical set is specified, the report will sub-total on the nodes in the hierarchy.
b. Simple reports may need only one row.
c. More complex selection criteria for each row will require several rows to be defined (e.g. one row for revenues, with a specific set and selections, and a second row with costs using a different set and selections).
d. Rows with simple formulas can be used.
e. Rows can be hidden.
f. Predefined Row Models can be copied into the report.
g. Row text can have a variable. Prefix with "&".
4.4.4 REPORTS - Define a cell
a. Edit a Cell = define an element. Can select multiple cells. Used for calculations across sections or in part of the same section. E.g. a column total can be a cell and used in a column formula to calculate the % of the total for each row in that column.
4.4.5 REPORTS - Define the General Selection Criteria
a. Define the General Selection Criteria - characteristics not already used in the Row or Column definition.
b. If the report requires Orders and/or Projects to be selected on the basis of the Responsible Cost Center on the cost object master record, a special characteristic must be included in the General Selection Criteria :
If Cost Centers, Order and Project WBS are needed together, they are usually in separate sections of the one report. The Cost Center set is repeated in each section's lead column.
4.4.6 REPORTS - Assign to a Report Group
a. Assign the report to a report group. If several report always have the same
b. Note : always require Controlling Area, Fiscal Year, Period to be specified.
c. Reports can be set up in separate "sections" to get two or more reports in one.
- E.g. a summary section first, based on the results of a second, detailed section.
- Or report dollars in one section and quantities in another.
- However, to simplify development, creating separate reports and running them in the same report group can be easier to manage.
4.4.7 REPORTS - Header Texts
NOTE : The organization's ABAP report standards need to be applied, within constraints of RP functionality. a. Title Page - predefined SAP format - can be amended.
b. Header on each page
- Where Variations have been used, it is recommended to display the value and text associated with each characteristic used in the variation. So if the navigation tree (on the screen LHS) is not displayed, the user can still see where they are.
c. Footer on each page
d. End Page
c. Define report texts - headers, footers etc.
- If Variations were used, then the header should include the fields in the variation so when the user drills down, the report clearly shows the characteristic values being reported.
4.4.8 REPORTS - Variations in General Data Selection
a. The lead column's display and the drilldown variation can be managed in several ways if a hierarchical set is used in selection :
o No Explosion - total value only for selected items
o Single value - listing a items selected
o Explode - show levels in hierarchical set.
b. If a number range is used in selection, the "expand/explode" option is not applicable and you get a list.
c. When the users run the report, they can also influence the Variation to some extent - if originally "expand/explode" they can select "Single value" or Do not expand/explode.
a. Define any required Variations for the characteristic selected in the GSC. A "Variation" allows specification of output format if hierarchical sets/groups are used - show with hierarchy and sub-totals, or list individual items in the group with no sub-totals, or have one total with no detail.
- In most cases the Variation requirement can be amended at report run time - usually requesting a list or no explosion instead of an exploded set.
4.4.9 REPORTS - Assign to a Report Group
a. On initial creation of a report, it needs to be assigned to a report group before executing. The system will let you create a new report group
b. Go to GR52 to edit the report group and name it properly.
c. Initially, assign it to a single report group.
d. Later, it can be assigned to several report groups and those can have several reports each, if the same selection criteria apply and the users wants all reports at once.
e. Use GR52 to assign more reports, or delete reports from the group.
f. Selection Screen texts can be adjusted per report group. ???
4.4.10 REPORTS - Report layout pre-defined
a. There are several places the report layout can be influenced :
- Formatting - Section layout
- Formatting - Report layout, including Standard layout assignment
i. Note : THE ORGANIZATION prefers zero values displayed as 0.
ii. Note : THE ORGANIZATION prefers zero lines displayed.
- Formatting - Row
- Formatting - Column
- Formatting - Row / Column Texts
- Edit - Rows - Hide
- Edit - Rows - Insert Blank Line
- Edit - Columns - Hide
- Add any colors or under / over-scores to rows.
- Maximum of 253 characters wide.
4.4.11 REPORTS - Report layout amended after display
a. After executing the report, users can still influence the layout. If they have Authorization and the report definition allows it, they can save the changes.
b. Format which can be changed :
- Number format ( decimal places, scaling - e.g. 000s or 000,000s)
- Zero representation (blank of zero)
- Suppress zero rows and columns
- Setting Thresholds for traffic light Red / Green highlighting on columns.
- etc
4.5 SETS
a. Sets are user-defined groups of a characteristic (e.g. a cost center group).
b. A set hierarchy is a set of sets which is used to build sub-total lines.
c. Master data sets are single characteristic -Cost Element.d. Multi-dimension sets can have several characteristics - e.g. Cost Element and DR/CR Indicator. This is more for Report Writer than Report Painter.
e. Sets are assigned to classes. Not all set classes can be used in CO reporting. See Set Class table (SETCLS) :
- 0101 = Cost Center groups
- 0102 = Cost Element groups
- 0111 = Fund group
- 0112 = Functional Area group
f. Sets can influence the way the data is reported.
- Suppress : can be used for :
a. Reporting only one total line in a report where the set has an interval
b. Reporting only one total line in a report where the set includes lower level sets.
c. Flagging an empty set - text only, for additional headings in the report - and the Formatting à Report Layout à Rows needs to be set to "Form printout" as well.
- P/M indicator : "+" means report if Debit (positive) balance or zero, "-" means report only if a CR (negative) balance. This can be used for :
a. For one account, have the DR in one set and the CR in another set.
b. Can be used for a text element (heading) in a report, in conjunction with the "Suppress" indicator (see above).g. CCSS Groups in DV1.210 and .220
- KSH3 Cost Center by Fund : _Z_FUND_CC_
- KSH3 Cost Center Std Hier : THE ORGANIZATION
- KAH3 Cost Element : _Z_CE_ALLh. ZZSPLTT Sets in DV1.210 and .220{_}
- GS03 GL Account : _Z_ACCT_ALL_
- GS03 Fund : _Z_FUND_ALL_
- GS03 Functional Area : ZZ_FA_ALL
4.6 VARIABLES
a. Allows runtime selection of data :
- For individual characteristics or ranges
- For sets
b. Can be a formula. e.g. :
- another variable +1 like '&1GJAHLJ'-1
- a few system variables are available like '#S001'
- #S001 current fiscal year
- #S006 current period
- can use "IF xxx THEN xxxx ELSE xxxx " logic like IF '&1PERIK' < 12 THEN '&1GJAHR' - 1 ELSE '&1GJAHR' c. The formula variables are usually identified as "Internal" so that the user cannot see or amend them.
d. It is best to define a variable for the specific Table/Structure & Field/Component which the variable applies to.
- Please do not use a variable defined for another table/structure even if the field/component is the same.
e. The variable can be included in the column headings - prefix with an "&" before or after text. For numeric variables, the heading can have text and "&VAR1 - 2" to subtract 2 from the value of the variable.
f. Some variables have Parameter Ids (PID) which can be set on the individual User Master record.
g. Standard Variables available for use with CCSS - please use them if possible (or see T802G) :
- See Appendix A for a full list.
- Where the variable has a default that is inappropriate - e.g.
4.6 STANDARD LAYOUTS
a. Display & printing parameters can be default in the report, so there is no need to re-specify them in each report.
b. Different standard layouts can be assigned to different reports.
5 EXPORT / IMPORT OR TRANSPORTING
a. All of the elements of the reporting can be transported - libraries, reports, report groups, variables, sets.
b. Also, they can be copied between clients on the same system.
c. Also, they can be exported to the PC and imported from the PC across systems. Powerful, but how to control this ?
6 SAP CO-RELATED REPORTING
SAP Report naming :
1-xxx =Cost Center Accounting
5-xxx = CO/FI Reconciliation Ledger
6-xxx = Overhead Orders and Projects CCSS structure includes tables :
COSP CO Totals: External Postings
COSPP COSP Transfers from Order to Project
COSS CO Totals: Internal Postings
COSSP COSS Transfer from Order to Project
COSL Activity Type Totals
COSR Stat. Key Figure totals
COSB Variance / Results Analysis
COEJ Plan Line Items by Fiscal Year - includes Fund - value field per period
COEJL
COEJR
COEP Actual Line Items by Period - includes Fund .
COEPB
COEPL
COEPR
Note : project WBSE reports require some special settings, since is used a logical database : - Use the field OBJNR, not PSPID or POSID.
- Use the variable for OBJNR, like 6-OBJNR.
- Include the call-up report RKPEP000 to get line items.
- Include call-up transaction CJ62 for WBS Element look-up.
REPORT PAINTER & RELATED TRANSACTIONS
No labels
1 Comment
Former Member
When you use LIS and report painter or report writer, SAP generates ratio keys in T804B. You can change these entries using transaction GRCT. It's the only way I've found to add ratios in flexible analysis.
Christophe
Jun 26, 2008
Privacy
Terms of Use
Legal Disclosure
Copyright
Trademark
| GR11 | Create Standard Layout | Create Standard Layout |
|---|---|---|
| GR12 | Change Standard Layout | Change Standard Layout |
| GR13 | Display Standard Layout | Display Standard Layout |
| GR14 | Delete Standard Layout | Delete Standard Layout |
| GR17 | Export standard layouts | Export standard layouts |
| GR18 | Import standard layouts | Import standard layouts |
| GR19 | Copy standard layouts from client | Copy standard layouts from client |
| GR1L | Directory: Standard Layout | Directory: Standard Layout |
| GR21 | Library - Create | Library - Create |
| GR22 | Library - Change | Library - Change |
| GR23 | Library - Display | Library - Display |
| GR24 | Delete library | Delete library |
| GR27 | Export libraries | Export libraries |
| GR28 | Import libraries | Import libraries |
| GR29 | Copy libraries from client | Copy libraries from client |
| GR2L | Catalog: Libraries | Catalog: Libraries |
| GR31 | Create Report (Report Writer) | Create Report (Report Writer) |
| GR32 | Change Report (Report Writer) | Change Report (Report Writer) |
| GR33 | Display report (Report Writer) | Display report (Report Writer) |
| GR34 | Delete report (Report Writer) | Delete report (Report Writer) |
| GR37 | Export reports | Export reports |
| GR38 | Import reports | Import reports |
| GR39 | Copy reports from client | Copy reports from client |
| GR3L | Catalog: Reports | Catalog: Reports |
| GR51 | Report Group - Create | Report Group - Create |
| GR52 | Report Group - Change | Report Group - Change |
| GR53 | Report Group - Display | Report Group - Display |
| GR54 | Report Group - Delete | Report Group - Delete |
| GR55 | Report Group - Execute | Report Group - Execute |
| GR57 | Report Group - Export | Report Group - Export |
| GR58 | Report Group - Import | Report Group - Import |
| GR59 | Report Group - Copy from client | Report Group - Copy from client |
| GR5G | Report Group - Generate | Report Group - Generate |
| GR5L | Report Group - Directory | Report Group - Directory |
| GRCT | Report Writer: Control Tables | Report Writer: Control Tables |
| GRE0 | Report Writer: Extract Management | Report Writer: Extract Management |
| GRE1 | Report Writer: Display Extracts | Report Writer: Display Extracts |
| GRE5 | Report Writer: Delete Extracts | Report Writer: Delete Extracts |
| GRE6 | Report Writer: Print Extracts | Report Writer: Print Extracts |
| GRE7 | Report Writer: Validity of Extracts | Report Writer: Validity of Extracts |
| GRE8 | Extracts: User Settings | Extracts: User Settings |
| GRE9 | Extracts: User settings, coll.maint. | Extracts: User settings, coll.maint. |
| GRP1 | Report Writer: Display Extracts | Report Writer: Display Extracts |
| GRP5 | Report Writer: Delete Extracts | Report Writer: Delete Extracts |
| GRP6 | Report Writer: Print Extracts | Report Writer: Print Extracts |
| GRP7 | Report Writer: Validity of Extracts | |
| GRPE | Editor callup for FI/CO program | |
| GRR1 | RP Report : Create Row/Column Structure | |
| GRR2 | RP Report : Change | |
| GRR3 | RP Report : Display | |
| GRR4 | Create model | |
| GRR5 | Change model | |
| GRR6 | Display model | |
| GRR7 | Export models | |
| GRR8 | Import models | |
| GRR9 | Copy models from client | |
| GRRT | Report Painter: Translate reports | 7 APPENDIX A : REPORT PAINTER / WRITER VARIABLES FOR STRUCTURE CCSS - FROM TABLE T802G Variable Variable text Field Name Default Value Variable type Parameter ID Formula text Set class 1AUFSET Order Group AUFNR Set Variable AST 103 1BEKSET Debit/Credit Indicator BELKZ 1-S-BELKZ-AL.CCSS Set Variable 1CGJAHE Fiscal Year GJAHR 1993 GJR 1CGJAHP Plan Year GJAHR 1992 GJV 1CGJAHV Comparison Year GJAHR 1992 GJV 1CKOKRE Controlling Area KOKRS 1 CAC 1CKOSET Cost Center Group KOSTL 1C-KS1-ALL.CCSS Set Variable KSG 101 1CKSTAR Cost Element Group KSTAR 1-S-KSTAR-AL.CCSS Set Variable KAG 102 1CLSTAR Activity Type LSTAR 1C-BZ1-LSTAR.CCSS Set Variable LST 105 1CPERBL To period PERBL 365 BPE 1CPERIB To Period PERBL 13 1CPERIV From Period PERBL 1 1CVERP1 VERSN 0 KVS 1CVERP2 VERSN 0 KVS 1CVERP3 VERSN 0 KVS 1CVERPA VERSN 0 KVS 1CVERSB To Version VERSN 0 KVS 1CVERSP Plan Version VERSN 0 KV2 1CVERSV From Version VERSN 0 KVS 1CWRTTB To value type WRTTP 99 1CWRTTV From value type WRTTP 0 1GJAH-R Rolling Fiscal Year GJAHR Formula - Internal IF '&1PERIK' < 12 THEN '&1GJAHR' - 1 ELSE '&1GJAHR' 1GJAHLJ Fiscal Year GJAHR Formula '#S001' 1GJAHR Fiscal Year GJAHR Formula '#S001' 1GJAHS1 Fiscal Year Object 1 GJAHR Formula '#S001' 1GJAHS2 Fiscal Year Object 2 GJAHR Formula '#S001' 1GJAHVJ Previous Year GJAHR Formula - Internal &1GJAHLJ'-1 1GJAHVV Year Before Last GJAHR Formula - Internal '&1GJAHLJ'-2 1GJLJW Fiscal Year GJAHR Formula - Internal '#S001' 1GJSET Fiscal Year GJAHR 1-S-GJAHR-AL.CCSS Set Variable 1GJVJW Previous Year GJAHR Formula - Internal '&1GJLJW'-1 1KOKRE Controlling Area KOKRS 1 CAC 1KOSET Cost Center Group KOSTL Set Variable KSG 101 1KOSTL CostCenter KOSTL BUKRS KOS 1KSTAR Cost Element Group KSTAR Set Variable KAG 102 1KSTS1 Cost Center Group 1 KOSTL Set Variable KSG 1KSTS1 Cost Center Group 1 KOSTL Set Variable KSG 1KSTS2 Cost Center Group 2 KOSTL Set Variable KSG 1LSTAR Activity Type Group LSTAR Set Variable LSG 105 1PER-R1 Rolling Period 1 PERBL Formula - Internal IF '&1PERIK' < 12 THEN '&1PERIK' + 1 ELSE 1 1PER-R2 Rolling Period 2 PERBL Formula - Internal IF '&1PERIK' < 12 THEN 12 ELSE 1 1PER-R3 Rolling Period 3 PERBL Formula - Internal IF '&1PERIK' < 12 THEN 1 ELSE 2 1PERIB To Period PERBL 12 1PERIK Period PERBL Formula '#S006' 1PERIKV Previous Period PERBL Formula - Internal '&1PERIK'-1 1PERIL PERBL 1 1PERIV From Period PERBL 1 1PERVP Previous Period PERBL Formula - Internal IF '&1PERIK' > 1 THEN '&1PERIK'-1 ELSE 1. 1PERW Period PERBL Formula - Internal '#S006' 1PESET Period PERBL 1-S-PERBL-AL.CCSS Set Variable 1PLSTR Activity Type Group PLSTR 1-S-PLSDUMMY.CCSS Set Variable 1ROLLUP Summarization ROLLUP CRO 1STAGR Statistical Key Figure Group STAGR Set Variable SKG 104 1VALU Actual Valuation VALUTYP Formula '#S011' 1VALUTP Actual Valuation VALUTYP Formula '#S011' 1VERI Actual Version VERSN 0 KVT 1VERP Plan Version VERSN 0 KVS 1VERP-A Plan Version A VERSN 0 KVS 1VERP-B Plan Version B VERSN 1 KVS 1VERP-C Plan Version C VERSN 2 KVS 1VERSN Plan Version VERSN 0 KVS 1VKOSTL Summarization Area VKOSTL KSG 1WBSSET WBS Element Group POSID Set Variable 110 1WRTTP Value Type WRTTP 4 5J2CBRI RECIND CB 5JC-PR1 PERBL Formula - Internal IF '&1PERIK' > 1 THEN '&1PERIK' - 1 ELSE 12 5JC-PR2 PERBL Formula - Internal IF '&5JC-PR1' > 1 THEN '&5JC-PR1' - 1 ELSE 12 5JC-PR3 PERBL Formula - Internal IF '&5JC-PR2' > 1 THEN '&5JC-PR2' - 1 ELSE 12 5JC-YR1 GJAHR Formula - Internal IF '5JC-PR1' < '1PERIK' THEN '1GJAHLJ' ELSE '1GJAHLJ' - 1 5JC-YR2 GJAHR Formula - Internal IF '5JC-PR2' < '5JC-PR1' THEN '5JC-YR1' ELSE '5JC-YR1' - 1 5JC-YR3 GJAHR Formula - Internal IF '5JC-PR3' < '5JC-PR2' THEN '5JC-YR2' ELSE '5JC-YR2' - 1 5JCPOSI WBS Elements POSID Set Variable PSG 5JCPVG VERSN ? 5JCPVN VERSN ? 5JCRI Recovery indicator RECIND Set Variable 6-AUFGR Order Group AUFNR Set Variable AST 103 6-AUFNR Order AUFNR 0 ANR 6-GJAH1 Fiscal Year 1 GJAHR Formula '#S001' - 1 6-GJAH2 Fiscal Year 2 GJAHR Formula '#S001' 6-GJAHB To Fiscal Year GJAHR 9999 GJR 6-GJAHL Fiscal Year GJAHR Formula '#S001' 6-GJAHR Fiscal Year GJAHR Formula '#S001' 6-GJAHV From Fiscal Year GJAHR 1900 GJV 6-GJHVJ Previous Year GJAHR Formula - Internal '&6-GJAHL'-1 6-KOKRS Controlling Area KOKRS 1 CAC 6-KSTAR Cost Element Group KSTAR Set Variable KAG 102 6-OBJNR Object Number (Project Reps) OBJNR 6P-OBJNR-B.CCSS Set Variable 6-PERBB To Period PERBL 12 BPE 6-PERBV From Period PERBL 1 VPE 6-PERIK Period PERBL Formula '#S006' 6-STAGR Statistical Key Figure Group STAGR Set Variable SKG 104 6-VALU Actual Valuation VALUTYP Formula '#S011' 6-VERP Plan Version VERSN 0 KVS 6-WORKL Worklist OBJNR Set Variable ZYRBS Biennium Start Year GJAHR 2003 ZYRM1 Bien Start - 1 GJAHR Formula - Internal 'ZYRBS' - 1 ZYRM2 Bien Start - 2 GJAHR Formula - Internal 'ZYRBS' - 2 ZYRM3 Bien Start - 3 GJAHR Formula - Internal 'ZYRBS' - 3 ZYRM4 Bien Start - 4 GJAHR Formula - Internal 'ZYRBS' - 4 ZYRP1 Bien Start + 1 GJAHR Formula - Internal 'ZYRBS' + 1 APPENDIX B : BASIC KEY FIGURES FOR RW TABLE CCSS KEY FIGURE TABLE FIELD TABLE FIELD TABLE FIELD TABLE FIELD EAUSP Output -> LIs COEJL AUS+++ EDISP Scheduled activity -> LIs COEJL DIS+++ EKAPP Capacity -> LIs COEJL KAP+++ ELSTP Activity quantity -> LIs COEJL LST+++ EMBGI Actual qty posted -> LIs COEP MBGBTR EMEFI Actual qty fix -> LIs COEP MEFBTR EMEFP Plan fixed qty -> LIs COEJ MEF+++ EMEGI Actual quantity -> LIs COEP MEGBTR EMEGP Plan quantity -> LIs COEJ MEG+++ EMEVP Plan variable qty -> LIs CCR1S MEV+++ COEJ EPAFI Act. price variance fix -> LIs COEP PAFBTR EPAFP Plan fix price variance -> LIs COEJ PAF+++ EPAGI Actual price variance -> LIs COEP PAGBTR EPAGP Plan price variance -> LIs COEJ PAG+++ EPAVP LI: Price variance variable CCR1S PAV+++ COEJ ESMAI Max. stat. actual qty -> LIs COEPR SMABTR ESMAP Max. stat. planned qty -> LIs COEJR SMA+++ ESMEI Statistical actual qty -> LIs COEPR SMEBTR ESMEP Statistical planned qty -> LIs COEJR SME+++ EWKFI Actual costs -> LI COEP WKFBTR EWKFP Plan fix costs -> LIs COEJ WKF+++ EWKGI Actual costs -> LIs COEP WKGBTR EWKGP Plan costs -> LIs COEJ WKG+++ EWKVP LI: Variable costs plan CCR1S WKV+++ COEJ EWOFP LI: Plan fix costs in obj.crcy CCR1S WOF+++ COEJ EWOGI Tot.act.costs in obj.crcy->LIs COEP WOGBTR EWOGP Tot.plan costs in obj.crcy>LIs COEJ WOG+++ EWOVP LI: Variable costs in obj.crcy CCR1S WOV+++ COEJ EWTFP Plan fixed costs in TCrcy CCR1S WTF+++ COEJ EWTGI Actual costs in TCrcy -> LIs COEP WTGBTR EWTGP Plan costs in TCrcy -> LIs COEJ WTG+++ EWTVP LI: Variable costs in TCrcy CCR1S WTV+++ COEJ SAUS Output COSL AUS+++ SCKF Fixed costs in CO area cur. COSP WKF+++ COSS WKF+++ SCKG Costs in CO area currency COSP WKG+++ COSS WKG+++ COSPP WKG+++ COSSP WKG+++ SCKV Variable costs in CO area cur. CCR1S CKV+++ COSP COSS SDIS Scheduled activity quantity COSL DIS+++ SKAP Capacity COSL KAP+++ SLST Activity quantity COSL LST+++ SMEF Fixed quantity COSP MEF+++ COSS MEF+++ SMEG Quantity COSP MEG+++ COSS MEG+++ COSPP MEG+++ COSSP MEG+++ SMEV Variable quantity CCR1S MEV+++ COSP COSS SMLST Sender activity CCR1S SMLST+++ COSL SPAF Fixed price variance COSS PAF+++ SPAG Price variance COSP PAG+++ COSS PAG+++ SPAV Variable price variance CCR1S PAV+++ COSP COSS SSMA Maximum statistical quantity COSR SMA+++ SSME Statistical quantity COSR SME+++ SWKF Fixed costs CCR1S RKF+++ COSP COSS SWKG Costs (primary & secondary) CCR1S RKG+++ COSP COSS COSPP SWKGS Secondary costs COSS WKG+++ COSSP WKG+++ SWKV Variable costs CCR1S RKV+++ COSP COSS SWOF Fixed costs in object currency CCR1S WOF+++ COSP COSS SWOG Total costs in object currency COSP WOG+++ COSS WOG+++ COSPP WOG+++ COSSP WOG+++ SWOV Variable costs in object crcy CCR1S WOV+++ COSP COSS SWPG Costs projected in CO crcy CCR1S WPG+++ COSP COSS SWTF Fixed costs in trans. currency CCR1S WTF+++ COSP COSS SWTG Total costs in trans. currency COSP WTG+++ COSS WTG+++ COSPP WTG+++ COSSP WTG+++ SWTV Variable costs in trans. crcy CCR1S WTV+++ COSP COSS SWZG Total costs in target currency CCR1S WZG+++ COSP COSS COSPP ZKVE Vbl. act. costs LI (CO object) COVP WKGBTR |