SAP FM configuration on ECC 6.0

(1)

EHP3 for SAP ERP

6.0 June 2009

English

Funds Management-Basic

Settings (951)

SAP AG Dietmar-Hopp-Allee 16 69190 Walldorf Germany

(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, Excel, Outlook, and PowerPoint 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, System i, System i5, System p, System p5, System x, System z, System z9, z/OS, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, Informix, i5/OS, POWER, POWER5, POWER5+, OpenPower and PowerPC are trademarks or registered trademarks of IBM Corporation.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States 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, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML, and W3C 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, R/3, xApps, xApp, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, 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. All other product and service names mentioned are the trademarks of their respective companies. Data

contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group 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.

(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)

Funds Management-Basic Settings (951)

1 Purpose

This configuration guide provides the information you need to set up the configuration of this building block manually.

If you do not want to configure manually and prefer an automated installation process using BC Sets and other tools, refer to the Quick Guide of your SAP Best Practices version, which you can find on this solution's SAP Note.

2 Preparation

2.1 Prerequisites

Building Blocks

Before you start installing this building block, review the Prerequisite Matrix for this solution, which is available on the Documentation DVD via the Site map page.

3 Configuration

3.1 Public Sector Management Configuration

3.1.1 Maintain FM Area

Use

The Funds Management Area (FM Area) is the primary structural component that is required to be maintained to implant Public Sector Funds management solution.

Procedure

1. Access the activity using one of the following navigation options:

IMG Menu Enterprise Structure → Definition → Financial Accounting → Maintain FM Area.

Transaction Code

SPRO

2. Choose the New Entries button. 3. Make the following entries:

Field Name Description User Action and Values Comment

FIKRS FM Area 1000

FITXT FM Areas text FM Area 1000

(8)

4. Save your entries.

Result

The required FM Area is created and is now available for assignments.

3.1.2 Assign Company code to FM Area

Use

The Funds Management area must be assigned in the enterprise structure.

Procedure

IMG Menu Enterprise Structure → Assignment → Financial Accounting → Assign Company code to Financial Management area

SPRO

BUKRS Company code 1000

FIKRS FM Area FM Area 1000

FITXT FM area Text FM Area 1000

Result

(9)

3.1.3 Assign Fiscal Year variant to FM Area

Use

A Fiscal Year variant is needed to define the accounting year and posting periods for the company.

Prerequisites

The Fiscal Year Variant is defined.

Procedure

IMG Menu Public Sector management → Funds Management Government → Basic Settings→ Fiscal Year variant → Assign Fiscal Year variant to FM Area

SPRO

FIKRS FM Area FM Area 1000

CA_PERIV Fiscal Year Variant K4 4. Save your entries.

Result

The Company code and the FM Area now has a Fiscal year Variant available to control posting periods as needed.

(10)

3.1.4 Activate Account Assignment Elements

Use

This task activates the accounts assignment elements (Fund, Functional Area, Grant, and Funded Program) for use in Fund Management.

Prerequisites

Field Statuses available for data entry through different application paths must be reviewed carefully to insure that the FM account assignments requirements are met correctly. In addition, the integration start date with HR will need to be coordinated with the HR implementation team.

Procedure

IMG Menu Public Sector management → General settings for Public Sector Management → Basic settings: Account assignment Elements → Activate Account Assignment Elements

SPRO

Result

Field Name Description User Action

and Values

Comment

FUND_ACTIVE Fund Selected Enter date for assignment of

integration with HR FUNCTION_ACTIVE Functional

Area

Selected Enter date for assignment of integration with HR

GRANT Active Grant Selected Enter date for assignment of integration with HR

MEASURE Active Funded Program

(11)

The selected FM account assignment objects are now active in Funds Management.

3.1.5 Activate Global Funds

Use

This task activates Public Sector Management functions in the system. This activation will be required in order to utilize the FMGLFLEXT/A tables in FI.

Procedure

IMG Menu Public Sector management → Funds Management Government → Basic Settings → Activate Global Funds Management Functions (PSM-FM)

SPRO

2. Select the checkbox. 3. Save your entries

Result

Public Sector Management functions are now active in the system.

3.1.6 Define Business Area

Use

This task creates Business Areas in the system. Business Areas are used as on

organizational unit that represents a separate area of operational responsibility. A general guideline is to create a business area for each organization unit that will require P&L and Balance sheet reporting.

(12)

Procedure

IMG Menu Enterprise Structure → Definition → Financial Accounting → Define Business Area

SPRO

2. Choose the New Entries button. 3. Make the following entries.

Business Area Description

9998 Payroll Constant

9999 Treasurer’s Constant

Result

The following business areas have now been created for your system.

3.2 Financial Accounting Configuration

After activating Global Funds Management functions, log out and log back in.

3.2.1 Define Ledgers for General Ledger Accounting

Use

This activity defines the leading ledger that is updated for all the activities and company codes.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings → (New) → Ledgers → Ledger → Define Ledgers for General Ledger Accounting

(13)

SPRO

Field Name

Description User Action and Values

Comment

RLDNR Ledger FA

TAB Totals table FMGLFLEXT XLEADING Leading

Ledger

Selected At least one ledger to be defined as the Leading Ledger that is updated for all the activities / company codes. 4. Save your entries.

Result

The Leading ledger now defined for further assignments.

3.2.2 Define Currencies of Leading Ledger

Use

The leading ledger must be defined as the Leading ledger that is updated for all the activities and company codes.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings (New) → Ledgers → Ledger → Define Currencies of Leading Ledger

SPRO

2. Double-click the entry for the company code (1000).

3. The system populates the Company Code with default values from the global settings for Company Code. Make any changes (for example, to the second and third currencies) as needed.

Result

(14)

3.2.3 Include Fields in Totals Table

Use

This activity adds additional fields to the Totals Table FMGLFLEXT. Adding additional fields to the totals tables facilitates reporting and derivation of account assignment elements.

Prerequisites

The fields must be available. Create them if necessary.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings (New) → Ledgers → Fields → Customer Fields → Include Fields in Totals Table

SPRO

2. In the Totals Table field, enter FMGLFLEXT and choose the Change button 3. Make the following entries:

Cost Center ZZKOSTL

Order Number ZZAUFNR

WBS Breakdown Structure ZZPS_PSP_PNR

Result

(15)

3.2.4 Include Fields-Master Data Check

Use

This activity adds additional fields for master data checking to the Totals Table FMGLFLEXT and FMGLFLEXR.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings (New) → Ledgers → Fields → Customer Fields → Define Master Data Check

SPRO

Totals table FMGLFLEXT

Field Name ZZAUFNR

Exit/Table =13

Additional Info 1

Superior Fields RBUKRS

4. Save your entries. 5. Choose Back.

6. Repeat steps 2 to 5 for the following information:

Field Name Totals Table

Master data table (validation) Indicator: May field be used Necessary field for master Ind.: Exit for additional

(16)

in planning set? data calculation values or additional information

ZZKOSTL FMGLFLEXT =06 X RBUKRS

ZZPS_PSP_PNR FMGLFLEXT =27 X RBUKRS #1

Result

The added fields to the totals table have now been defined for master data checks during planning and allocations.

3.2.5 Assign Scenarios and Customer Fields to Ledger

Use

The system is delivered with eight scenarios, each of which include a set of fields and tables that are updated to meet a given business requirement. .

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings (New) → Ledgers → Ledger → Assign Scenarios and Customer Fields to Ledgers

(17)

2. From the Ledger field, select FA.

3. From the left pane, double-click Scenarios. 4. Choose the New Entries button.

5. Make the following entries:

Scenario for General Ledger Accounting Long Text

PSM_FAC Fund Accounting

PSM_GM Grants management

6. Click Enter

7. From the Scenarios table, select the scenario PSM_FAC 8. From the left pane, double-click Customer Fields 9. Choose the New Entries button

10. Add the custom fields: ZZAUFNR, ZZKOSTL, ZZPS_PSP_PNR 11. Press Enter

12. From the left pane, double-click Scenarios

13. From the Scenarios table, select the scenario PSM_GM 14. From the left pane, double-click Customer Fields 15. Choose the New Entries button

16. Add the custom fields: ZZAUFNR, ZZKOSTL, ZZPS_PSP_PNR 17. Save your entries.

Result

The Funds management and Grants management Scenarios are now assigned to the Leading Ledger.

(18)

3.2.6 Define Variants for Real time Integration CO

→→→→

FI

Use

This activity defines variants for the real-time integration of Controlling with Financial Accounting.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings → (New) → Ledger → Real-time Integration of Controlling with Financial Accounting → Define variants for Real-time Integration

SPRO

Field Name Description User Action and

Values

Comment

XACTIVE R-Time Integration

Active

Select

XACCDET Acct. Determination

Active

Select

BLART Document Type SA

TEXT Description Standard variant for

real-time Int. XUSE_FLAGS

(Select check marks for fields)

Cross company code Cross Business Area Cross Functional Area Cross Fund

Cross Grant

Select

Result

(19)

3.2.7 Enter Global Parameters

Use

In this activity, you can make various global specifications for the company code. .

Prerequisites

The organizational unit Company Code, should have been created in the “Enterprise Structure” section of the IMG.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings (New) → Global Parameters for Company Code → Enter Global Parameters

SPRO

2. Double-click the entry for Company Code 1000. 3. Choose the New Entries button.

Chart of Accounts 0010

Credit Control Area 1000

FM Area 1000

Fiscal Year Variant K4

Document entry Screen variant 2

Field Status variant 0010

Posting Period Variant 0010

Max Exch. Rate Variance 10%

Workflow variant 1000

Define default value date Selected

Propose Fiscal Year Selected

Tax Base is Net value Selected

Activate CM Selected

Result

(20)

3.2.8 Define Document Number Ranges for Entry View

Use

Number Ranges must be set up for Entry View of the New General Ledger.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings → (New) → Document → Document Number Ranges → Documents in Entry View → Define Document Number Ranges for Entry View

SPRO

(21)

Company Code 1000

3. Choose the Change Intervals button. 4. Choose the + button to add a number range.

5. Create Number ranges for 01, 02, 03, 04, 05, 06, 07, 08, 09, and so on.

6. Enter a number range value for each number range object created [e.g. 01 = 100000000 to 199999999].

Result

The Number ranges are created for Entry View documents.

3.2.9 Define Document Types for Entry View

Use

Number Ranges must be set up for Entry View of the New General Ledger.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings → (New) → Document → Document Types → Define Document Types for Entry View

(22)

You may wish to view the existing document types. To do so, select the Document type dropdown.

Field Name Description User Action and Values

Comment

Document type ZV Choose a two character code for

a new document type

Number range 20

Reverse Document Type

ZV

Select Account Types

Asset Selected

Customer Selected

Vendor Selected

Material Selected

GL Account Selected

Result

(23)

3.2.10 Define Posting Keys

Use

Posting keys are used to define how a line item is to be entered and processed during a transaction. For each posting key, you define whether it is a debit or credit posting, which accounts can be posted to, and which fields are displayed or are required for entry. As a guideline, the posting keys delivered with the system are generally sufficient to address all transactional scenarios for most organizations. Creating new posting keys is usually not required. A more standard activity is to review the field status settings of a given posting key to ensure that it does not conflict with the field status settings for a given general ledger account.

Procedure

IMG Menu Financial Accounting (New) → Financial Accounting Global Settings → (New) → Document → Document Number ranges → Define Posting

(24)

Keys

SPRO

2. To create new postings keys, make the following entries:

Field Name Description User Action and Values Comment

Posting Key <posting key> Two character

posting key Debit / Credit

Indicator

Account Types <Choose the Account Types applicable>

Number range 20

Select Account Types:

Asset Selected

Customer Selected

Vendor Selected

Material Selected

GL Account Selected

Result

(25)

3.2.11 Define Retained Earnings Account

Use

You assign a fund balance account to each P&L account by specifying a P&L statement account type in the chart of accounts area of each P&L account. In this activity, you create those P&L statement account types and map them to their fund balance account.

Prerequisites

The accounts to be mapped to a P&L Statement Type as fund balance accounts are already created.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Master Data → GL Accounts → Preparations → Define Retained Earnings Account

SPRO

2. In the Chart of Accounts field, enter 0010 and choose Continue. 3. Choose the New Entries button.

(26)

P&L Stmt Type Account Number

A1 330005

A2 330005

5. Create additional P&L Statement Types and map them to your fund balance accounts as required.

Result

The P&L Statement Types are now defined to your fund balance accounts.

3.3 Financials Documents

3.3.1 Classify G/L Accounts for Document Splitting

Use

Each business transaction that is entered is analyzed during the document splitting

procedure. In this analysis, the system determines for each line item whether it is an item that remains unchanged or an item that should be split.

So that document splitting recognizes how the individual document items are to be handled, you must classify them.

Prerequisites

The Chart of Accounts is defined and all the required accounts are created.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Classify G/L Accounts for Document Splitting

(27)

Code

Account from 100000 Account to 100000 Item Category 0400 Account from 111000 Account to 114999 Item Category 0400 Account from 410000 Account to 459999 Item Category 30000 Account from 670000 Account to 670000 Item Category 20000

All the accounts in the Chart of Accounts must be assigned to an Item Category. The Item Categories cannot be changed. Every newly created account must be maintained in this table on an ongoing basis.

Result

The classification of accounts based on Item Categories is completed for further definition of Document Splitting.

(28)

3.3.2 Define Zero-Balance Clearing Account

Use

For account assignment objects for which you want to have a zero balance setting, the system checks whether the balance of account assignment object is zero after document splitting. If this is not the case, the system generates additional clearing items. In this activity, you must create a clearing account for these additional clearing items.

Prerequisites

The account to be assigned as Zero-balance Clearing Account, must have created before its assignment.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Define Zero-Balance Clearing Account

(29)

2. Select the row for Item Category 01001 – Account Key and Posting Keys used for zero-balancing, then in the Dialog Structure pane, double-click Accounts.

Account for zero balancing 100000

Result

A zero-balancing account is created for use in the document splitting.

3.3.3 Define Business Transaction Variant

Use

Business transaction variants help define document splitting rules and narrowly define the process of document splitting to meet specific requirements.

Prerequisites

A custom Splitting method is defined.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Extended Document Splitting → Define Business Transaction Variants

(30)

Code

2. Select Transaction 0000 and in the Dialog Structure pane, double-click Accounting Transaction Variant.

BT Variant YPAY Payroll Constant

6. Select the newly-created entry YPAY and in the Dialog Structure pane, double-click Assigned Item categories.

Item Category 01000 Item Category 01100 Item Category 01300 Item Category 02000 Item Category 02100 Item Category 03000 Item Category 03100 Item Category 04000 Item Category 05100 Item Category 05200 Item Category 06000 Item Category 07000 Item Category 20000 Item Category 30000 Item Category 40100 Item Category 40200 Item Category 80000

10. The BTV YPAY is now defined.

11. To define another Business transaction variant (YTRS) with respect to Business Transaction 1000 (Payments), repeat steps 2 to 9 with the following information: Transaction 1000

BT Variant YTRS

Item Category 01000

(31)

Field Name Description User Action and Values Comment Item Category 01300 Item Category 02000 Item Category 02100 Item Category 03000 Item Category 03100 Item Category 04000 Item Category 05100 Item Category 05200 Item Category 20000 Item Category 30000 Item Category 40100 Item Category 40200 Item Category 80000

Result

Business Transaction variants YPAY and YTRS are now defined.

3.3.4 Classify Document Types for Document Splitting

Use

Every business transaction that is entered is analyzed during the document splitting process. In this process, the system determines which splitting rule is applied to the document. In order that the system can determine the splitting rule, you must assign a business transaction variant to each document type.

Procedure

(32)

Business Transactions → Document Splitting → Classify Document Types for Document Splitting

SPRO

Type Transactn Variant

AP #0000 #0001 DV #0200 #0001 DZ #1000 #YTRS KZ #1000 #YTRS RK #0300 #0001 SK #1000 #YTRS Y1 #0300 #0001 Y2 #0000 #YPAY Y3 #0000 #YPAY Y4 #0000 #YPAY ZP #1000 #YTRS ZR #1000 #YTRS

Result

(33)

3.3.5 Define Document Splitting Characteristics for General

Ledger

Use

In this IMG activity, you specify for which characteristics you want to perform document splitting in General Ledger Accounting.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Define Document Splitting Characteristics for General Ledger Accounting

SPRO

Field Create zero balance

for account assignment object

Partner field of account assignment object for doc. splittng

Mandatory Field

(34)

GEBER/Fund X PGEBER X

GRANT_NBR/Grant X PGRANT_NBR X

GSBER/Business Area

X PARGB X

Result

The characteristics are specified.

3.3.6 Define Document Splitting Characteristics for

Controlling

Use

In this IMG activity, you specify on which additional characteristics you intend to apply document splitting. The additional characteristics are not relevant for General Ledger Accounting. Instead, they are relevant for other application components (such as subcomponents in Controlling) that use documents transferred from General Ledger Accounting.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Define Document Splitting Characteristics for Controlling

SPRO

Field

AUFNR/Order KOSTL/Cost Center

PS_PSP_PNR/WBS Element 4. Save your entries.

Result

(35)

3.3.7 Define Field Status Variants – Field Status Groups

Use

In this activity you can define and edit field status variants and groups. You group several field status groups together in one field status variant. You assign the field status variants to a company code in the activity Assign Company Code to Field Status Variants. This allows you to work with the same field status groups in any number of company codes.

Procedure

IMG Menu Financial Accounting (New) → Accounts Receivable and Accounts Payable → Business Transactions → Outgoing Invoices / Credit Memos

→ Make and Check Document Settings → Define Field Status Variants

SPRO

2. Choose the Create icon. 3. Make the following entries:

FStV Field Status Name

0010 Field Status BP

5. Select the newly-created row, then in the Dialog Structure pane, double-click Field Status Groups.

Field status group Name of the field status definition group

Y001 General Accounts

Y002 Reconciliation Accounts (AR, AP)

Y003 Expense Acct with Cost Center & Order Y005 Travel P&L Accts (with Personnel No.)

Y006 Travel BS Accounts (with Personal No.)

Y007 Fixed Assets (Reconciliation Accounts)

Y008 Accounts for Fixed Asset Retirement

Y009 Fixed Assets Procurement Accounts

Y010 Material Accounts

(36)

Y012 Inventory Adjustment Accounts

Y013 Revenue Accounts

Y014 GR/IR Reconciliation Account

Y015 General Cash Accounts (Value Date Opt.)

Y016 Inventory - Project make to order

Y031 Accounts for Down Payments Received

9. Select the first row Y001, then choose the Edit Field Status button.

10. For more information, see the external variant file SMBA0_V_T004F_B11P_J0A_951.txt to determine how to configure the field statuses.

Result

The field status grouping is configured.

3.3.8 Define Extended Document Splitting Method

Use

In this activity, you can define your own method for document splitting. A splitting method contains the rules governing how the individual item categories are dealt with.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Extended Document Splitting → Define Document Splitting Method

SPRO

(37)

Z000000111 Splitting for US Fund Accounting (Follow-Up Costs Online) 4. Save your entries.

Result

The extended method is defined.

3.3.9 Activate Document Splitting

Use

In this IMG activity, you activate document splitting. The splitting method used is that delivered by SAP as standard, which contains the splitting rules for the different business transactions. If this splitting method does not meet your requirements, you can first define and then select your own method in Customizing for document splitting.

Prerequisites

The custom Splitting Method is defined.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Activate Document Splitting

SPRO

6. Select the Document Splitting checkbox.

7. Select the line below Inheritance – Level of Detail. 8. Save your entries.

Result

(38)

3.3.10 Assign Document Splitting Method

Use

In this activity, you can replace the splitting method provided in the SAP standard delivery (containing the splitting rules for the different business transactions) with a user-defined splitting method.

Prerequisites

You have defined your own splitting method.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Extended Document Splitting → Assign Document Splitting Method

SPRO

2. Select the Document Splitting checkbox

3. Select the checkbox in the line below Inheritance – Level of Detail. 4. In the Box Method field, enter Z000000111.

(39)

Result

The custom Document Splitting Method is now assigned.

3.3.11 Define Document Splitting Rule

Use

In this activity, you can define the rules for document splitting based on your own Splitting method, Business transaction Variants.

Prerequisites

You have defined your own splitting method.

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Extended Document Splitting → Define Document Splitting Rule

SPRO

Splitting method Z000000111

Business Transaction 1000

BT Variant YTRS

Account key 000

(40)

Further Divide Document Select No

5. Select the newly-created entry, then double-click Item Categories to be edited. 6. Choose the New Entries button.

Item category Dependence on Leading Item Processing Category

01100 1 1

01100 2 1

04000 BLANK 0

05100 BLANK 1

9. Repeat steps 2 to 8 for transaction variant YPAY, using Business transaction 0000 and splitting method Z000000111.

Result

The custom splitting rules are now created for document splitting and activated.

3.4 New GL for Treasury and Payroll Constants

3.4.1 Edit Constant for Nonassigned Processes

Use

In this IMG activity, you define default account assignments (for example, a default Fund, or a Business Area) for specific line items in processes.

Prerequisites

(41)

Procedure

IMG Menu Financial Accounting (New) → General Ledger Accounting (New) → Business Transactions → Document Splitting → Edit Constants for non-assigned Processes

SPRO

Constant Name

YTRS Treasurers Constant

4. Choose Enter. 5. Save your entries.

6. Select the new entry and in the Dialog structure pane, double-click Assigned Values. 7. Choose the New Entries button.

Fund 99999999

Grant NON_RELEVANT

Business Area 9999

9. Choose Enter. 10. Save your entries.

11. Repeat steps 2 to 10 for the following information:

Constant Name

YPAY Payroll Constant

Fund 99999998

Grant NON_RELEVANT

Business Area 9998

Result

(42)

3.5 Grants Management

3.5.1 Define NON_RELEVANT Grant

Use

The leading ledger must be defined as the Leading ledger that is updated for all the activities and company codes.

Procedure

IMG Menu Public sector Management → Grants Management → Grantee Management → Global Settings → Set Grant as Not Relevant for Grants Management

SPRO

2. Make the following entries in the Setup:

Field Name Values

Not-Relevant Grant NOT-RELEVANT

Name NOT-RELEVANT

Description Not-Relevant Grant

3. Click Execute. 4. Save your entries

(43)

3.6 Funds Management Basic Settings

3.6.1 Activate Global Functions of BCS

Use

In this IMG activity, you activate the Budget Control System (BCS) as an operative budgeting tool of the component Funds Management Government.

Prerequisites

The Global Funds management (PSM – FM) should be active before BCS may be activated.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Basic settings → > Activate Global Functions for Budget Control System (BCS)

SPRO

Field Name User Action and Values Comment

FM Area 1000

Year Active from 2000 4. Save your entries.

Result

(44)

3.7 Funds Management Master Data

3.7.1 Create / Change Hierarchy Variant – Fund Center

Use

You create new hierarchy variants in this section. These are then used to define a funds center hierarchy in master data.

Procedure

IMG Menu Public sector management → Funds Management Government → Master Data → Account Assignment Elements → Fund center → Hierarchy Variant → Create / Change Hierarchy variant

SPRO

2. In the FM Area field, enter 1000. 3. Choose the New Entries button. 4. Make the following entries:

Hierarchy. Variant 000

Name Public Sector 1000

Result

(45)

3.7.2 Assign Hierarchy Variant to FM Area

Use

In this section, you determine which hierarchy variants are to be assigned to the FM area and fiscal year as the current valid funds center hierarchy.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Master Data → Account Assignment Elements → Funds center → Hierarchy Variant → Assign Hierarchy Variant to FM Area

SPRO

2. In the FM Area field, enter 1000. 3. Choose the New Entries button. 4. Make the following entries:

Fiscal year <leave blank>

Hierarchy Variant 000

Result

(46)

3.7.3 Create FM Fund Type

Use

You create fund types in this step. You can classify and group a fund by defining fund types in the funds master records.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Master Data → Account Assignment Elements → Fund → Create FM Fund Types

FM Area Fund Type Fund Type Text Budget Scope

1000 CP Capital Project Fund Annual Budget

1000 DS Debt Service Fund Annual Budget

1000 FS Fiduciary Funds Annual Budget

1000 GF General Fund Annual Budget

1000 IS Internal Service Funds Annual Budget

1000 SR Special Revenue Funds Annual Budget

1000 SRG Special Revenue Fund (Grant) Annual Budget

1000 TA Trust & Agency Funds Annual Budget

1000 TF Technical Funds Annual Budget

1000 WE Water Enterprise Annual Budget

(47)

Result

The FM Fund Types have now been created.

3.7.4 Create and Maintain Funded Program Type

Use

In this IMG activity, you create the funded program types you require and maintain them.

Procedure

IMG Menu Public sector management → Funds Management Government → Master Data → Account Assignment Elements → Funded Program → Create and Maintain Funded Program Type

SPRO

Funded Program Type Name

CAP Capital Funded Program

OTH Other Funded Program

Result

(48)

3.8 BCS Setup - Budgeting

3.8.1 Activate Account Assignment Elements in BCS

Use

In this IMG activity, you select and activate the FM Account Assignment Categories you want to work with to control the budgeting in BCS.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System → Budgeting → Basic settings → Use of Master Data → Activate Account Assignment Elements in Budget Control System (BCS)

SPRO

FM Area 1000

Fund Mandatory

Fund Center Mandatory

Commitment Item Mandatory

Functional Area Mandatory

Grant Mandatory

Funded Program Optional

Result

(49)

3.8.2 Define Budget Category

Use

In this IMG activity, you determine the budget categories you want to use for an FM area in your organization.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Basic Settings → Definition of Budget Data → Define Budget Category

SPRO

FM Area Budget Category Time Horizon Start Next Year

1000 Payment <leave blank> unchecked

Result

(50)

3.8.3 Define Budget Type

Use

In this IMG activity, you define the BCS budget types that you want to use in your organization. When setting up your budgeting procedures, you can define several budget types for your organization. The combination of budget type and budgeting process represents a customer-specific definition of budget values.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Basic Settings → Definition of Budget Data → Budget Types → Define Budget Types

SPRO

2. In the FM Area field, enter 1000 and choose Continue. 3. Choose the New Entries button.

Budget Type Description Description (M) Description (L)

A1 A1 Budget Adjustment Budget Adjustment

BI BI Budget Initial Budget Initial

CF CF Carried Forward Carried Forward

PR PR Preparation Preparation

7. Select the A1 row, then in the Dialog Structure pane, double-click Assign Processes. 8. In the Assign Processes pane, for the first four rows, select Receive, Return, Send, and

Supplement respectively. 9. Choose Enter.

10. Save your entries. 11. Choose Back.

12. Repeat steps 7 to 11 for the remaining budget types (A2, A3, BI, CF, PR). For A2 and A3, use the same values as A1.

For BI, select only the Enter value. For PR, select only the Prepare value.

Result

(51)

3.8.4 Define Budget Type Groups

Use

In this IMG activity you can bundle different budget types in a budget type group. Budget type groups enable you to define multiple budget types to be used for consumption.

Prerequisites

Budget Types to be grouped should already be created.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Basic Settings → Definition of Budget Data → Budget Types → Define Budget Type for Consumable Budget → Define Budget Type Groups

SPRO

FM Area Budget Type Group Description

1000 CY Current Year Budget

1000 PY Prior Year Budget

6. Select the newly-created entry CY and in the Dialog Structure pane, double-click Edit Budget Type Group.

7. Choose the New Entries button.

8. In the next five rows, select budget types A1, A2, A3, BI, and CF. 9. Save your entries.

10. Choose Back.

11. Select the newly-created entry PY and in the Dialog Structure pane, double-click Edit Budget Type Group.

(52)

13. Select budget type CF. 14. Save your entries.

Result

The Budget Type Groups are created.

3.8.5 Edit Versions

Use

In this IMG activity you can bundle different budget types in a budget type group. Budget type groups enable you to define multiple budget types to be used for consumption.

Prerequisites

Budget Types needed should have created.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Basic Settings → Definition of Budget Data → Edit Versions

Version BP1

Plan Selected

Result

(53)

3.8.6 Define Document Types

Use

In this IMG activity, you define the document types you want to use for budget postings in Funds Management. You can use different document types to classify your budget entry documents. By using different document types, you can classify budget entry documents according to your user-specific criteria, by assigning meaningful names to the individual document types used within your organization.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Document definition → Define Document Types

SPRO

Doc Type

Text N Range

Selected

Workflow Scenario for Value Type

Carry Over Scenario 0001 Document

Type 0001

01 Blank Statistical Balancing per

CI Category 002 Document

Type 0002

02 Blank Statistical Balancing per

CI Category BADJ Budget

Adjustment

02 Blank Budget Balancing per

CI Category

BPCF Budget C/Fwd 06 Blank Budget Balancing per

CI Category

BUDG Budget Entry 01 Blank Budget Balancing per

CI Category WF01 Workflow01 01 Selected Statistical Balancing per

CI Category 4. Choose Enter.

Result

(54)

The Budget Document Types are created.

3.8.7 Maintain Number Range Intervals for Entry

Documents

Use

In this IMG activity, you define the number range interval for budget entry documents of an FM area for each fiscal year for the industry-specific component Funds Management.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Document definition → Maintain Number range Interval for Entry Documents

SPRO

2. In the FM Area field, enter 1000 and choose the Create button. 3. Choose the Change Intervals button.

4. Choose the Insert Interval button 5. Make the following entries:

Number Range Year valid to Range starting from Range ending with

01 9999 0100000000 199999999

6. Choose Enter.

7. Choose the Insert Interval button

02 9999 0200000000 299999999

Result

(55)

3.8.8 Maintain Number Range Intervals for Budget Change

Documents

Use

In this IMG activity, you define the number range interval of budget change documents in an FM area for each fiscal year in the component Funds Management.

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Document definition → Maintain Number range Interval for Budget Change Documents

SPRO

4. Choose the Insert Interval button 5. Make the following entries:

01 9999 0300000000 399999999

Result

(56)

3.8.9 Maintain Number Range Intervals for Document

Family

Use

In this IMG activity, you define the number range interval to assign document family numbers. Several budget entry documents are grouped together under one document family that is created at the same time in a mass activity. .

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Document definition → Maintain Number range Interval for Document family

SPRO

4. Choose the Insert Intervals button 5. Make the following entries:

01 9999 0400000000 499999999

Result

(57)

3.8.10 Define Layout for Budget Workbench

Use

In the budgeting workbench, you can define whether a specific input field appears in the header area of the budgeting workbench or in the BWB table area of the screen. The table area contains the document lines of a budget entry document. Whether an input field is placed in the header area or as a column of the table affects how the user makes entries:

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Document definition → Define Layout for Budget Workbench

SPRO

Field Name Description User Action and Values Column Position

Comment

Layout Variant YP0001

Description / Text

Public Sector 1000 Budget Layout

Year of Cash Effectivity

Header

Budget Type Header

Grant No Display

(58)

Field Name Description User Action and Values Column Position

Comment

Fund Center Column 2

Commitment Item Column 3 Functional Area Column 4 Funded Program Column 5 Period Header Distribution Key 1 4. Choose Enter. 5. Save your entries.

Result

The Layout YP0001 is now created.

3.8.11 Define Editing Options for Budget Amounts

Use

In the budgeting workbench, you can define whether a specific input field appears in the header area of the budgeting workbench or in the BWB table area of the screen. The table area contains the document lines of a budget entry document. Whether an input field is placed in the header area or as a column of the table affects how the user makes entries:

Procedure

IMG Menu Public Sector Management → Funds Management Government → Budget Control System (BCS) → Budgeting → Budget entry → Budget entry Documents → Define Editing Options for Budget Amounts

SAP FM configuration on ECC 6.0

EHP3 for SAP ERP

6.0

June 2009

English

Funds Management-Basic

Settings (951)

Copyright

Icons

Typographic Conventions

Contents

Funds Management-Basic Settings (951)

1 Purpose

2 Preparation

2.1 Prerequisites

Building Blocks

3 Configuration

3.1 Public Sector Management Configuration

3.1.1

Maintain FM Area

Use

Procedure

Result

3.1.2

Assign Company code to FM Area

Use

Procedure

Result

3.1.3

Assign Fiscal Year variant to FM Area

Use

Prerequisites

Procedure

Result

3.1.4

Activate Account Assignment Elements

Use

Prerequisites

Procedure

Result

3.1.5

Activate Global Funds

Use

Procedure

Result

3.1.6

Define Business Area

Use

Procedure

Result

3.2 Financial Accounting Configuration

3.2.1

Define Ledgers for General Ledger Accounting

Use

Procedure

Result

3.2.2

Define Currencies of Leading Ledger

Use

Procedure

Result

3.2.3

Include Fields in Totals Table

Use

Prerequisites

Procedure

Result

3.2.4

Include Fields-Master Data Check

Use

Procedure

Result

3.2.5

Assign Scenarios and Customer Fields to Ledger

Use

Procedure

Result

3.2.6

Define Variants for Real time Integration CO

FI