Sap Erp Financials
Sap Erp Financials
Sap Erp Financials
Shivesh Sharma
Controlling Implementation
Bonn � Boston
Contents at a Glance
PART I Foundation
1 SAP ERP Implementation . ........................................................ 25
2 Controlling: An Introduction . ................................................... 49
3 Choosing the Optimal Controlling Enterprise Structure .............. 61
PART V Reporting
9 ptimizing Profitability Reporting Using Profitability
O
Analysis (CO-PA) ....................................................................... 367
10 Reporting in Financials and Controlling . .................................... 403
11 Concluding Remarks .................................................................. 445
Appendices
A Glossary and SAP Abbreviations ........................................................... 449
B Bibliography.......................................................................................... 453
C The Author............................................................................................ 455
Acknowledgments ........................................................................................ 15
Preface .......................................................................................................... 17
PART I Foundation
2.1 Key Requirements for the SAP ERP Financials Solution ................... 49
2.2 SAP ERP Financials Direction: A Historical Perspective ................... 52
2.3 SAP ERP Financials: A Snapshot View ............................................ 54
2.3.1 SAP ERP Financials Solution Stack: The Big Picture .............. 54
2.3.2 SAP Easy Access for SAP ERP Financials/Controlling
Components ........................................................................ 56
10
11
12
PART V Reporting
13
14
In this chapter, you will learn how to configure and implement cost element account-
ing, cost center accounting, profit center accounting, and internal order accounting. We
will clarify some of the key features of each of these components so that you
can standardize and optimize your existing Controlling processes. It is extremely
important for you to think through and map the overall structure of your orga-
nization into these four components. This allows you to launch yourself into a
learning cycle where you can get increased benefits from implementing additional
components.
You will proceed from defining your cost center and profit center hierarchies along
with the cost element and internal order definition, to performing planning in
cost center accounting that can be replicated across other components because
the overall architecture of planning remains the same. You will also learn how
to implement budgeting in cost center accounting and internal order accounting
with availability control setup. The concept of funds commitment is also high-
lighted, which allows you to map out your future commitments. This helps tre-
mendously in analyzing the overall risk that your organization has in terms of
future liabilities.
119
Secondary Cost
Cost Element Primary Cost
Cost Element
Accounting Element
Element Group
Assignments
Profit Center Periodic
Master Data of Profit Planning
Accounting Postings
Centers
Budgeting &
Internal Order Master Data Planning Settlement Availability
Accounting Control
The basic question that cost element accounting answers is the detailed under-
standing of what costs have been incurred. Cost element accounting is not a typical
accounting system but a mechanism to record data from Financial Accounting that
forms the basis of cost accounting. In this component, no routine transactions are
recorded. So the most important aspect in cost element accounting is the master
data that should be created when the relevant GL account is created. Let’s tackle
cost element master data first.
120
Figure 5.2 illustrates how a primary cost element can be changed. Let’s review
these steps:
1. Enter the Cost Element “610100”, the Controlling Area, which is seen as US01,
and a Valid From and to date.
2. On the Basic Data tab, to enter a Name and Description.
121
The cost element category allows you to distinguish between primary and second-
ary cost elements. These can be used to distinguish within the primary cost ele-
ments whether it is a cost element (expense account) or revenue element (revenue
account):
EE Attribute mix
This can be used to further distinguish the cost elements per your
requirements.
EE Functional Area
This allows you to represent your departments as functional areas such as pro-
duction, sales, marketing, administration and so on. This allows you to create
P&L accounting per cost of sales accounting. The functional area entered in the
corresponding GL master flows to the cost element master data as well and can-
not be entered from this screen.
In Figure 5.3, you can see the indicators for recording quantity, where the unit of
measure can also be entered.
122
EE Record qty
This flag allows you to record quantities against the cost element.
EE Unit of Measure
This identifies the unit of measure for posted activities.
EE Selecting the Default Acct Assgnmt tab brings you to the screen shown in Fig-
ure 5.4.
This is where you can define the default cost center or order for a particular cost
element. This setting is useful only if cost elements map to the same cost center
across all company codes. Remember, you learned about defaulting cost centers
and orders by valuation area and cost element earlier in Chapter 4. The History
tab records all the changes made on the cost element.
The cost element groups are broken into these headings: Manufacturing, Operat-
ing Expenses, Other Expenses, and Secondary Cost Elements. Manufacturing is
then broken up into SAP Manufacturing Clearing Accounts, Inventory Reserves,
and Manufacturing Variances. Primary cost elements (510000 to 510099) are
then assigned to SAP Manufacturing Clearing Accounts.
123
To change an existing cost element group, assign new cost elements or change the
assignment of cost elements to a different level. The Same Level and Lower Level
buttons help create a cost element group at the same level or creates a new lower
level below the same level, respectively. The other two buttons for Cost Element
allow you to insert a cost element or to display a cost element attached to a cost
element group.
124
Cost center accounting focuses only on costs allowing you to detail out the costs
and makes the managers responsible for the costs incurred by their departments.
Note
Cost center accounting is typically one of the earliest components that an organization
implements.
Figure 5.6 shows you the process involved. Let’s examine master data first.
125
Budget Budget
Management Profile
Commitment
Document Number
and Funds Activate Field Control
Commitments Types Ranges
Costing
Costing
Overhead Sheets
Sheet
Components
Activity
Allocations Assessment Distribution
Allocation
126
Cost Center
Cost centers are the organizational units where costs are incurred. These can be
created from a variety of perspectives such as responsibility, physical location,
and functional area. The structure of the cost center is heavily dependent on each
organization and mimics the organization structure.
Before creating a cost center, you should outline the standard hierarchy to guide
the overall structure and set of the cost centers. Each cost center needs to be
assigned to the standard hierarchy. Standard hierarchy needs represent a grouping
of all the cost centers for a particular Controlling area. This allows you to visualize
your organization from the Controlling perspective. The menu path to follow for
creating, changing, displaying change is SAP Menu • Accounting • Controlling •
Cost center accounting • Master data • Cost Center • Individual Processing • Cre-
ate/Change/Display/Delete/Display Change. The Transactions are KS01/KS02/
KS03/KS04/KS05.
To understand more about a cost center, let’s take a look at how a cost center looks
in cost center accounting. Figure 5.7 shows you the Basic data tab of the cost cen-
ter screen where you can change the Cost Center 10100. All the cost centers are
created for a Controlling Area US01 with Valid From and to dates.
127
You need to maintain the following parameters identifying the cost center:
EE Name and Description
This identifies the name and description of the cost center.
EE User Responsible
This is the SAP user ID of the responsible person.
EE Person Responsible
This is free form text with which you can maintain the responsible person even
if you have not created a SAP user ID.
EE Department
This can be used to capture the department of your organization and is used for
reporting purposes.
EE Cost Center Category
This identifies the category of the cost center and can be used to build addi-
tional logic for activity types. Typical examples for a cost center category are
production, sales, and administration.
EE Hierarchy area
This can be used to map the cost center to the standard hierarchy components.
You have to choose a predefined hierarchy area for your cost center.
EE Business Area
This can be used to link the business area to the cost center.
EE Functional Area
This can be used to establish the link between the cost center and the functional
area.
EE Currency
This identifies the currency of the cost center.
EE Profit Center
This can be used to assign profit centers to the cost center.
Figure 5.8 displays the screen for maintaining the control parameters. You can
choose to record quantity by flagging the Record Quantity. You can choose to
lock the parameters for data entry for the cost center. For example, in this case,
we have chosen to not record any Actual revenues or Plan revenues for the iden-
tified cost center.
128
Figure 5.9 shows you a view of the Templates tab and the information you will
need to populate it with.
This is where you can maintain the various cost models that are relevant for the
formula planning, activity and business process allocation, and overhead rates. You
will learn more about these in the planning Section 5.2.2. On the Address tab,
you need to maintain the correspondence address details. The Communication
tab has the data related to telephone numbers, fax number, and printer destina-
tion. The History tab has the details pertaining to any changes that were made in
the cost center. Now that you understand the cost center, let’s take a look at the
cost center group.
129
play the cost center group is SAP Menu • Accounting • Controlling • Cost center
accounting • Master data • Cost Center Group • Create/Change/Display. The
Transactions are KSH1/KSH2/KSH3.
Figure 5.10 shows you the cost center group US01 that has been set up. You have
the broad classification of Sales, Marketing, Manufacturing, General & Admin-
istration, and Assessments. Within General & Administration, you can have
further cost center groups of G & A Finance, G & A- Human Resources, and G & A-
Legal. The cost center is ultimately assigned to a cost center group because 10100,
defined in the previous step, is assigned to Sales cost center group 101.
130
131
You can drag and drop the cost centers that you find in your search list into the
overview pane. As you can see, this is similar to the cost center group structure
that you saw in the previous step. However, the distinction is that every cost cen-
ter should be part of the standard hierarchy, which is not the case with the cost
center group.
Activity Type
This allows you to enter the different activities in cost center accounting for your
Controlling area. You can also record quantities that are measured in activities. You
can then use activities to set up your rules for allocation cycles. Activity types can
be directly tied to a cost center also. The menu path is SAP Menu • Accounting •
Controlling • Cost center accounting • Master data • Activity Type • Individual
Processing • Create/Change/Display/Delete/Display changes. The Transactions
are KL01/KL02/KL03/KL04/KL05.
Figure 5.12 shows you how to create an Activity Type KWH by Controlling Area.
On the Basic Data tab, the Name and Description of activity type KWH is Power
KwH and Power Units consumed per month, respectively. The activity unit is
identified as KWH, whereas the cost center category is marked as W, which rep-
resents administration. You can also set Allocation default values for the activity
type, which is used when you are running your allocation cycles. Let’s take a look
at the various types now:
EE ATyp category identifies the method of activity quantity planning and activity
allocation.
EE Allocation cost elem is the secondary cost element that is used to allocate the
activity type.
EE Actual qty set allows you to manually enter the quantity that you want to
receive in the receiver.
EE The Average price flag means that the activity process for the activity remains
the same throughout the year.
EE Plan quantity set sets the plan quantity and prevents you from changing it dur-
ing planning.
132
You can lock this activity by marking the Lock indicator in the Indicators tab. Out-
put unit and Output factor can be maintained in the Output tab. The History tab
records any changes that happen for the activity type.
133
The statistical key figure can be defined as either Fxd val. (fixed value) or Tot. val-
ues (totals values). Fixed values are constant and are applied through the rest of the
fiscal year. On the other hand, totals values are applied only for the fiscal period
in which the allocation cycle is run.
134
Resources
Resources are goods and services that are used in various business processes.
Resources can be used to generate detailed planning activities for cost center plan-
ning, orders, and WBS elements. These provide you with one more layer of report-
ing other than cost elements. The menu path is SAP Menu • Accounting • Control-
ling • Cost center accounting • Master data • Resources group• Create/Change/
Display, and the Transactions are KPR2/KPR2/KPR3.
Figure 5.16 shows how to add a resource by CO Area (Controlling area). You need
an identifier for Resource Machine1 with Valid From and Valid To dates. The unit
of measure also needs to be maintained. In the Name field, you can enter a gen-
eral description of the resource. Cost ele.. refers to the cost element for which the
resource can be planned. If nothing is entered then the resource can be used across
all the primary and secondary cost elements. Plnt specifies the logistics plant for
which the resource can be planned.
Note
Resource cannot be used for actual costs. It can only be used for planning. All other
objects can be used for planning and actuals
135
Cost center planning allows you to monitor, control, and plan the Controlling
business structure by clearly outlining the goals and targets and then measuring
them against it. Here you will learn to define the parameters for manual planning,
resource planning, and formula planning and to recognize when you will use each
type of planning.
Note
It is very important that the planning done in cost center planning lead to actionable
items. If it is just a report spat out by the system and nobody does anything about it,
then it is merely an academic exercise, carried out as a chore every month by accoun-
tants. Take action based on what you see.
In this section, you will learn about the key settings of manual cost center plan-
ning that can be used to plan statistical key figures, activity types, primary costs,
secondary costs, budget planning, and so on. You can integrate manual planning
with internal orders and PS as well. It is also possible to interface manual planning
via the manager’s desktop. Even though manager’s desktop is primarily meant for
administrative and organizational management tasks, you can use it to support
manual planning functions in Controlling. You can customize the planning profiles
and planning layouts per the manager’s requirements, which allows them to per-
form routine manual planning tasks directly from the manager’s desktop.
Let’s see how we can perform manual planning using primary costs as a simple
example.
136
Costing Variants
Defining costing variants is the first step towards enabling you to plan at a level
below the cost element. For example, if you want to track the cost at each cost
center by material rather than by the cost element, you need to define a costing
variant. You can follow the menu path IMG • Controlling • Cost center accounting
• Planning • Manual Planning • Detailed Planning of Primary Cost Elements•
Figure 5.17 shows a costing variant comprised of Costing Type and Valuation
Variant. In our example, Costing Type has been chosen as Primary Cost Element,
whereas the Valuation Variant is also chosen as Vltn-Primary Cost Element. These
get defaulted and cannot be changed for Costing Variant PP. You can define a new
costing variant to choose a different combination.
Tip
Don‘t create two costing variants with the same costing type and valuation variant
because results of the detailed planning execution for one of the variants can override
the other. It is recommended that you use different valuation variants to each costing
variant that you save.
Valuation Variant
This contains a strategy sequence for selecting prices from the material master. The
menu path is IMG • Controlling • Cost center accounting • Planning • Manual
Planning • Detailed Planning of Primary Cost Elements• Define Valuation Vari-
ants, and the Transaction is OKY8. Figure 5.18 shows you the valuation variants
137
that can be selected for a costing variant. For our example, 013: Vltn-Primary Cost
Elem has been selected.
By double-clicking on this, you will reach the screen shown in Figure 5.19 where
you can maintain the Strategy Sequence in which the material price will be deter-
mined. The identified sequence is shown under Strategy Sequence, which is the
sequence in which the system searches for prices in the accounting view of the
material master.
138
Now that you understand how you can set up an additional layer of reporting for
cost center planning, let’s take a look at resource planning, which can be used to
support the cost center planning.
After defining your table, you need to configure your access sequence (AS) for
resource planning.
(AS) K001: Cost Center Resources that can be used for resource planning.
139
If you select K001 and click on Accesses, you reach the next screen shown in Fig-
ure 5.21. Let’s look at the tables that can be used for entering the resources by
cost centers:
EE 132: Price per Cost Center
EE 137: Price per Country/Region
EE 136: Price per Controlling Area
As you can see, the AS moves from more specific prices (By Cost Center) to general
prices (By Controlling Area). The Exclusive indicator stops any further searching
if the correct combination of resource per prices has been found.
By selecting Table 132 and clicking on Fields you reach the screen shown in Figure
5.22. This identifies the parameters by which you can enter the resource prices.
For our example, you can enter the resource prices by Controlling area, version,
resource, and cost center.
140
Condition Types
Condition types control how you enter the prices of resources: an absolute amount,
percentage, manually specified price, or derived from the material master. Each
condition type requires you to maintain the AS that allows you to search the sys-
tem per your requirements. The menu path is IMG • Controlling • Cost center
accounting • Planning • Resource Planning • Define Condition Types and the
Transaction is KPR4. Figure 5.23 shows how to maintain the condition type for
maintaining the resource prices. It ties the condition type (CEl..) CQ01 with access
sequence (AcSq) K001.
By selecting the condition type CQ01 and selecting Condition records, the popup
shown in Figure 5.24 appears. Here you can need to choose an appropriate access
from the AS. In our example, we chose Price per Cost Center.
141
On pressing Enter, you reach the next screen shown in Figure 5.25, where you will
choose the Controlling Area “US01”. If you want, you can further narrow it down
with Version and Fiscal Year. Application and Usage get defaulted as CQ and A,
respectively, and cannot be changed.
Upon pressing Enter, you can maintain the resource prices in the next screen as
shown in Figure 5.26. Here you need to maintain the Resource, FrP (Fiscal Period
from which the Price is effective), Cost Ctr (Relevant Cost Center), Amount, Curr.
(Currency of resource price), and PrUn. (Price unit).
142
Costing Sheets
Costing sheets is the equivalent of the pricing procedure in purchasing and SD in
cost center accounting. You specify the selected condition types you will be using
and identify the sequence in which the condition types will be used for resource
planning. The menu path is IMG • Controlling • Cost center accounting • Plan-
ning • Resource Planning • Define Costing Sheets. The Transaction is KPRC. Fig-
ure 5.27 shows you the RES1: CO Resource Prices costing sheet.
By selecting RES1: CO Resource Prices and clicking on Costing Sheet Rows you
will reach the next screen as shown in Figure 5.28 where you can choose the steps
of Costing sheet Rows. Here the condition type Resource prices is maintained as
shown earlier in the condition type definition.
143
Valuation Variant:
You learned earlier about valuation variant in 5.2.2. In this step, you will learn
to define the valuation variant from the resource planning perspective. Valuation
variant essentially houses the costing sheets. This is where it all comes together as
far as resource planning is concerned. Valuation variant determines the processing
sequence of the costing sheets. You can follow this menu path IMG • Controlling •
Cost center accounting • Planning • Resource Planning • Define Valuation vari-
ants. The Transaction is KPR8. Figure 5.29 shows you the valuation variant for
resource planning. The valuation variant needs to be defined by Controlling area.
C.Analysis allows you to test whether your condition types are working properly.
These should not be flagged in normal operations.
5.30 shows how you can assign the costing sheet (Proc.) RES1 to the valuation
variant (Var) 100.
144
Budget Profile
The budget profile allows you to establish the structure of budgeting in cost center
accounting. The menu path to follow: IMG • Controlling • Cost center account-
ing • Budget Management • Define Budget Planning Profiles. The Transaction
is OKF1. Figure 5.31 shows you the standard cost center budget profiles that are
available. You can copy these to create your own profile that meets your unique
requirements.
Let’s take a look at the COST00 by double-clicking on the profile. This takes you to
the Figure 5.32 where you can maintain the properties for the budget profile.
145
Decimal factors and Scaling factors control how the data will be shown when
you output the data. After setting the budget profile, you can enter the cost center
budgets using the transaction described next.
146
Figure 5.34 shows how you can enter the budget for Cost Center 10100, Control-
ling Area US01, and current year 2007 Period 1 as 10,000.00 USD.
This can then be compared against the actual values, and you can monitor if the
budget is within the limits.
147
can be used to reserve the budget for cost centers, internal orders, and projects.
In this subsection, you will learn about the configuration setting of commitments
and funds commitments. Figure 5.35 shows the process by which commitments
and funds commitments are configured.
Activate
Commitments
and Funds
Commitment
(OK01)
Assign Assign
Assign
Assign Field
Define Field
Status Variant
Selection String
to Company
(FMU7)
Code (FMU5)
148
OK01.
screen for maintaining the document types for funds commitment. This shows the
broad heading of Document Types for Earmarked Funds.
149
150
for defining the field status variant: IMG • Controlling • Cost center accounting •
Commitments and Funds Management • Field Control for Funds Commitment •
Define field status variant. You can also use Transaction FMU3. Figure 5.38 shows
the field status variant FMRE that has been defined for funds reservations.
151
Field Control for Funds Commitment • Define field selection string. The Trans-
action to be used is FMU7. Figure 5.40 shows you the screen for maintaining the
Field sel. (field selection string) MITTELRESER: Funds Reservations.
By selecting MITTELRESER and then clicking on Maintain Field Status for Field
Selection String, you will see the screen shown in Figure 5.41. In this screen, you
can maintain the individual fields such as Fund as Opt. entry; whereas Funds
Center is a Req. Entry.
152
the screen where you can assign Field selctn string (field selection string) MITTEL-
RESER to the Field Status Variant FMRE and Field Status group G001.
153
If you select the costing sheet (Costin) A00000:Standard in the right pane and
click on Costing sheet rows on the left pane, then you will reach the next screen
shown in Figure 5.44. As you can see, basic Material cost and Material OH (mate-
rial overhead) have been maintained. These options are then added to Wages and
Salaries along with the Manufacturing OH (manufacturing overhead) to give you
the Cost of goods manufactured. This when added with Administration OH and
Sales OH gives you the Cost of goods sold.
You can maintain each of these components separately by identifying which cost
elements pertain to which type of calculation Base. You have to click on Base to
maintain these, which will take you to next screen as shown Figure 5.45. This
154
screen shows you the Calculation base of B000: Material. Here the range of Cost
Elements 510000 and 510040 are maintained as pertaining to material costs.
Clicking on Overhead rate (Figure 5.45) brings up the screen seen in Figure 5.46,
which is where the overhead rates can be maintained.
The O/H rate C000: Material OH has been maintained as 25 % for Ovrhd type 1.
You can maintain the following overhead types:
EE 1: Actual overhead rate.
EE 2: Planned overhead rate.
EE 3: Commitment overhead rate.
155
If you click on Credit, you can maintain the Cost Element and Cost Center for the
credit element in the costing sheet as shown in Figure 5.47. Here the Cost Elem.
840000 and Cost Center 30100 have been maintained for the Credit E01: Credit
Material.
5.2.7 Allocations
The allocation process in cost center accounting allows you to transfer costs across
your organization according to predefined business rules. Allocations allow you
to transfer costs collected in a cost center to receivers per a predefined rule and
allow you to record costs as they occur. Then on the basis of business rules you
can allocate them at period end to get an accurate picture.
Example
If you treat finance as administrative overhead, then you will want to record the em-
ployee wages and salaries initially in the finance cost centers because it would be highly
inefficient to record this transaction when it actually occurs. However, at month end,
you need to allocate the costs to business units per predefined rule such as number of
employees in each department or number of financial transactions recorded for each
department.
Allocation methods simplify data entry and are easy to use because these rules are
defined only once and then the allocations are run at month end. There are two
types of allocations:
EE Assessment, which is used in allocating primary and secondary costs in cost
center accounting and activity-based costing
156
Table 5.2 highlights the difference between distribution and assessment allocation
processes per important parameters. This will allow you to distinguish between
these two processes.
157
After you execute this transaction, the commitment will show up in the period 1
of the new fiscal year. You can execute this in Test run before you run it for real.
If you want to reverse the commitment carryforward, you can check the Reversal
flag and execute the transaction.
158
Figure 5.49 shows you the process for profit center accounting.
PP & CO
Cost Business Fixed
Materials Production Projects
Centers Processes Assets
Orders
Assignment
Monitor
Process Maintenance Internal Sales Real Estate
Cost Object
Orders Orders Orders Orders Object
Number
Periodic Choose
Basic Ranges and
Additional B/S
Activities Settings Document and P&L
Types
159
Figure 5.50 shows you the Basic data for profit center maintenance. Profit center is
always created for a Controlling Area US01. You need to maintain the Name, Long
Text, and Analysis Period. Initially, the Status will be Inactive: Create when you
are first creating your profit center. You need to maintain the User Responsible,
Person Respons., Department, and Profit Ctr Group. Profit center group should
be the part that conceptually is similar to the standard cost center hierarchy.
Note
With the introduction of the new GL, you can also maintain the Segment for a profit
center.
160
Clicking on the Indicators tab brings you to the screen shown in Figure 5.51.
Here you can check Lock Indicator if you do not want any postings to happen to
this profit center. You can also maintain the Formula Planning Template (Form.
Planning Temp.). If you click on the Company codes tab, you will see all the CoCd
(company codes) assigned automatically to the profit center, which belong to the
Controlling area as shown in Figure 5.52 You can choose to dis-associate some
company codes from the profit center if desired.
161
is KE59.
Tips
E Do not use the dummy profit center as a dumping ground for your postings to be allo-
cated later. It can create a major month-end close headache, and it is never advisable
to run allocation cycles from the dummy profit center.
E Dummy profit centers need to be thoroughly analyzed at month end and should be
cleaned up every month. Otherwise, you will not get a true picture of your profit-
ability by responsibility area.
Figure 5.53 shows how you can create a DUMMY profit center.
162
This covers all of the crucial aspects of master data in profit center accounting.
Note
This assignment is an important event of discovery that allows you to understand how
your organization is split up. It allows you to visualize your organization from the re-
sponsibility perspective at a granular level.
Assignment Monitor allows you to track and manage your assignments of profit
center to other cost objects. The menu path is SAP Menu • Accounting • Enter-
prise Controlling • Profit center accounting • Master data • Current Settings •
Assignment Monitor. The Transaction is 1KE4. Figure 5.54 shows you the Assign-
ment Monitor. You can use this to find the cost centers that are not assigned to
any profit center, cost centers that are assigned to profit centers, and profit centers
that are not assigned to a cost center. You can do a similar exercise for all other
cost objects.
163
Table 5.4 shows the transaction codes that allow you to assign profit centers to
different cost objects.
In the next subsection, you will learn about the number ranges and document types
for local documents that need to be created only in profit center accounting.
164
Table 5.5 Defining Document Types and Number Ranges for Local Postings in Profit Center
Accounting
In the next subsection, we will cover how you can map additional balance
sheet and P&L accounts that cannot be mapped via a cost object to profit center
accounting.
165
Figure 5.55 shows you the screen where you can maintain the range of accounts
(Account from) 100000 and (Account to) 20000 and the default profit center (Def.
PrCtr) 10101, which will get populated after you make this entry. This setting
needs to be made for CO Area US01.
However, as you can see, that this is a very simplistic setting that might not be use-
ful to organizations that have more complex rules for determining the profit center
than just a direct GL assignment. You can use the derivation rules functionality to
map the profit center in much more flexible fashion. The menu path IMG• Enter-
prise Controlling • Profit center accounting • Actual Posting • Choose Addi-
tional Balance Sheet and P&L account • Derivation Rules for Finding the Profit
Center, or use Transaction 3KEI.
Figure 5.56 shows how you can set up default determination for the profit center.
Based on your requirement, you need to identify the Source Fields as “RACCT:
Account Number” and the Target Fields as “PRCTR: profit Center”. If you want,
you can add more source fields to this to make the determination more specific
such as company code, plant, and so on.
166
After you define the source fields, you can maintain the conditions that must be
fulfilled for the system to determine the profit center on the Condition tab as
shown in Figure 5.57.
After defining the conditions, you can maintain the Attributes as shown in Figure
5.58 where you can Issue error message if no value found. You can also branch
to additional steps if required.
167
After you have set up the derivation rule, you can maintain the rule values by
clicking on Maintain Rule Values button shown in Figure 5.56. This will allow
you to enter the values for the profit center by the source fields as shown in Fig-
ure 5.59.
Figure 5.60 shows you the parameters for carrying forward actual balances in
profit center accounting to the new fiscal year. You need to enter the Company
Code and Carry Forward to Fiscal Year and then execute the transaction. This will
carry forward all of the balances to the new fiscal year for the company code.
The menu path is SAP Menu • Accounting • Enterprise Controlling • Profit center
accounting • Actual Posting • Period End Closing • Transfer Payables/receiv-
ables, and the Transaction is 1KEK. Except for receivables and payables, all the
transactions in profit center accounting are transferred in real time. However, you
168
need to transfer payables and receivables periodically at the end of each period.
This allows you to generate balance sheet on a profit center basis. Figure 5.61
shows you the screen that you can use to carryforward the payables and receiv-
ables to the profit center accounting for a fiscal period. You need to enter the
Period and Fiscal year. The system automatically picks up all the company codes
assigned to the Controlling area. You can choose to transfer all the Line items or
just the balances.
Figure 5.62 shows you the process that underpins the discussion in this section.
Internal order accounting is primarily used for managing small projects that need
to be budgeted and managed independently, for example, setting up a marketing
kiosk in a cultural event. “Internal orders” is a general term that can be used for
overhead cost orders, capital investment orders, internal orders with revenues,
accrual orders, and so on. Internal order accounting allows you to plan, collect,
169
and settle the costs associated with a mini project in a process-oriented fashion, so
it mimics exactly the way business operates. You can, however, use internal orders
for multiple Controlling-oriented activities as listed here:
EE Orders for transient activities
These are one-off mini projects that are not regular and occur for a limited time-
frame, for example, sales kiosks at a SAP Financials conference.
EE Long-term cost monitoring activities
You can also set up long-term internal orders that occur at regular intervals and
allow you to establish a pattern, such as quarterly maintenance activities.
EE Statistical internal orders
These are not true cost objects, and you cannot settle these to any other cost
object. However, these allow you to track and report specific parameters of
costs recorded. In this case, you need a real cost object, but you can use internal
orders to provide an additional layer of reporting.
Internal Order
Master Data Master
Order Group
Budgeting &
Budget Tolerance
Availability
Profile Limits
Control
170
Internal Order
In this step, you will learn the key attributes of internal orders and the process of
creating an internal order. The menu path to follow is SAP Menu • Accounting •
Controlling • Internal Orders • Master data • Order manager • Special Functions
• Order • Create/Change/Display, and the Transactions are KO04/KO01/KO02/
In the order manager transaction, you can find your internal orders by maintaining
the Selection Variant in the left pane and maintaining your Personal worklist that
allows you to maintain your own range of internal orders. The various assignments
that can be maintained are Company Code, Business Area, Plant, Functional
171
Area, Object Class, Profit Center, WBS Element, Sales Order, Tax Jurisdiction,
and External Order no. Other fields that are not so obvious are explained here:
EE Responsible CCtr (cost center) and Requesting Co. Code
This is integrated with investment management, and the cost center and com-
pany code that you enter here will get transferred to the AuC.
EE Requesting Order
This is the order to which other orders can be assigned.
Figure 5.64 shows you the screen for maintaining the Control data for an internal
order. While you are creating, the internal order, system will automatically set the
System status as CRTD. The system status essentially controls which transactions
are allowed for the internal order.
Note
From SAP ERP 5.0 onward, you can also define your User status, which you can change
as desired.
172
EE Statistical order
This flag marks the internal order as statistical.
EE Actual posted CCtr
If you mark the cost center as statistical, then you can also specify which cost
center will receive the real postings.
EE Plan-integrated order
This flag is only checked if you are using integrated planning for internal
orders.
EE Revenue postings
This flag controls whether the internal order will allow revenue postings.
Figure 5.65 shows you the screen for maintaining the period-end closing activities.
The following parameters can be maintained in this screen:
EE Results Analysis Key
This is used to define the valuation of the internal order. For sales orders, you
can use results analysis to valuate nonvaluated stock at month end and the
stock that has been delivered but not invoiced yet. For projects, you can use the
results analysis key to valuate work in progress.
EE Costing Sheet and Overhead Key
These can be maintained for calculating the overhead, and the Interest Profile
allows you to define the rules for calculating interest.
You can also define one receiver for the internal order by identifying the settle-
ment cost element, cost center, and GL account. Figure 5.66 shows you the screen
of general data related to administrative details pertaining to internal orders, such
as estimated costs, processing group, work start, end of work, and so on.
173
Figure 5.67 shows you the Investments tab for maintaining the investment-related
data for an investment order.
Using this screen, you can tie the internal order to investment management, which
will be discussed in more detail in Chapter 6. Here you can maintain the follow-
ing parameters:
EE Investment profile
This allows you to automatically create an AuC when creating an internal order and
can help you default the asset class for the AuC and the depreciation simulation.
EE Scale
This can be used to categorize your investments from the amount of capital
required.
EE Investment program/Position ID
This allows you to define the investment program and position ID within the
investment program to which the internal order should be assigned.
You can define the Asset class and Capitalization date for assets that will be cre-
ated from the settlement of this internal order.
174
Now that you have learned to define an internal order, you will next learn about
creating an order group.
Figure 5.69 shows you the different order types that come predefined in the sys-
tem. You can copy these to create your own order type. The ones that we are more
interested in for internal order accounting range from 0100 to 0400.
175
Order types need to be assigned to an order category that allows you to define the
multitude of attributes for an order type. The following order categories can be
defined for an order type that is relevant for internal order accounting:
EE 01 Internal Order (Controlling)
EE 02 Accrual Calculation Order (Controlling)
EE 03 Model Order (Controlling)
If you double-click on order type 0100: Internal orders: Development in Figure
5.69, you can maintain the characteristics of the order type as shown in Figure
5.70. You can maintain the following parameters:
EE Number range interval
Here you can choose the number range by clicking on the pencil icon.
EE Settlement profile
This allows you to define the parameters that can be used for controlling the
settlement process of internal orders. You will learn more about the settlement
process in subsequent sections.
EE Planning profile/Execution profile/Budget profile
This can be used to default the internal order planning, execution services, and
budgeting parameters.
176
EE Object Class
This allows you to classify the cost objects as overhead, production, production,
or profitability.
EE CO Partner Update
This allows you to reduce the number of totals records by setting the indicator
as Semi-active or Not Active.
EE Commit. Management
This flag activates commitment management in Controlling for the internal
order type.
EE Revenue postings
This allows you to post revenues.
EE Integrated planning
This flag activates integrated planning for the order type.
177
EE Status Profile
This allows you to choose an appropriate status profile for an order type.
EE Release immediately
If you check this indicator, then the internal order is released automatically.
EE Master data display
If you click on Field selection Change (pencil icon) you will reach the next
screen shown in Figure 5.71. Here you can maintain how the various fields will
look when you are trying to create an internal order. Using this setting, you can
get rid of useless fields and make the most important fields a required entry
(Req. entry).
178
After the order is created, you need to release the internal order for it to start
receiving actual postings. This is done by setting the status as REL. When the order
is in REL status, then most of the business transactions are allowed. After the inter-
nal order is done, you can mark it technically complete (TECO), which means that
now you cannot perform actual postings on the internal order because the order
has been completed. After you have settled the order, then you can mark it as set-
tled and closed (SETC). This prohibits any further postings to the internal order.
You can achieve all this by maintaining the status profile, which allows you to
define a status profile, assign it to a user status, and then control the transactions
based on the user status. As you learned earlier in Section 5.4.2, status profile is
assigned to the order type, which is maintained in the internal order master.
So let’s discuss how to create a status profile. The menu path you can follow is
IMG • Controlling • Internal Orders • Order Master data • Status Management •
Define Status Profiles. The Transaction is OK02. Figure 5.72 shows you the screen
where you can maintain the status profiles. It is best to create your own status pro-
file by copying an existing status profile.
179
If you double-click on Status Profi.. 00000002: Internal Orders, then you will
reach the next screen as shown in Figure 5.73. This has two statuses LKD: Locked
and PLIM: Write Plan Line Items. The following parameters can be maintained:
EE Status
This is the status number that determines the sequence in which user statuses
are determined. The lower the number, the earlier the status gets activated. The
status numbers need to be arranged in an ascending order.
EE Status/Short Text
This is the identifier with the details for the status of the internal order as it
completes its lifecycle.
EE Init. St
If you set this indicator, then the internal order will get created with this status
initially.
EE Lowest
This lowest status number determines the status number that the next status
should have.
EE Highest
This helps you in checking whether the old statuses can be deactivated after
you have moved to a new status number. The system compares the new status
number against the number in the field, and if it is less than that, then it deac-
tivates the previous status.
EE Posit
This identifies the line in which the allowed status will get displayed.
EE Priority
This identifies the status display priority at a particular position.
180
If you double-click on LKD, you will reach the next screen shown in Figure 5.74.
Here you can maintain which Business Transactions do not have any influence
(No influ..), which are Allowed, which will give you a Warning, and which are For-
bidden (Forbidd). So this is essentially the field status group for statuses. However,
you can maintain the following subsequent actions for each business transaction:
EE No acti …
This ensures that the transaction does not have any impact on the status.
EE Set
This ensures that if this transaction is executed on an internal order, then the
corresponding status (LKD, PLIM, etc.) will be set up.
EE Delete
If you indicate this indicator for any business transaction, then the correspond-
ing status to which the business transaction is tied is deleted.
181
Figure 5.75 Define Status Profile: Status = Write Plan Line Items
This allows you to configure that if the Release business transaction occurs, then
you can write plan line items because PLIM will become active.
Note
Business transactions are tied to user status, which is tied to status profile, which is tied
to order type, which needs to be maintained in the internal order master.
Now that you understand the integrated master data and business transaction
mapping of internal orders, you will learn about the internal order settlement
process.
In this section, you will also learn to maintain the settlement profiles that are again
assigned to the order type, which is then assigned to the internal order master.
182
183
EE Other Parameters
Here you can specify the document type, the maximum number of distribu-
tion rules, and the archiving time before you archive the posted settlement
documents.
EE Indicators
This lets you define the various indicators for the settlement profile.
EE 100 %-validation: The system checks whether the cumulative percentage
against all the receivers total to 100 %.
EE % Settlement: This allows you to use percentages in the settlement distribu-
tion rules.
EE Equivalence numbers: You can use equivalence numbers (e.g., 2:3:3) to dis-
tribute the settlement amount to receivers.
EE Amount settlement: This allows you to directly enter amounts to receivers.
EE Variances to Costing-Based PA: This indicator allows you to transfer the vari-
ances to costing-based profitability analysis during the settlement process.
184
Figure 5.77 shows you the screen for maintaining a budget profile. The following
parameters can be maintained in a budget profile:
EE Time Frame
Here you can maintain the number of years you can go back in the Past and for-
ward in the Future. The field Start allows you to specify how many years from
the current year the budgeting process should start. Total values and Annual
values allow you to plan/budget total and annual values, respectively.
EE Program type budget
This allows you to specify the program position. If you enter a program posi-
tion here, then the internal order need to be assigned to one of the program
positions for it to be relevant for budgeting.
EE Activation Type
This setting forms the core of the availability control by specifying the follow-
ing activation types:
EE 0: Cannot be activated.
EE 1: Automatic activation with budget allocation.
EE 2: Background activation.
185
EE Usage
Here you can enter tolerance in % of Assigned to Budgeted value, which if
exceeded will trigger the automatic background activation if option 1 was
selected as the Activation Type.
EE Overall
This counts the overall budget rather than just the annual values.
EE Object currency
This forces the system to check the budget in the internal order currency.
EE Budgeting currency
You can specify your budgeting currency as the Controlling area currency, object
currency, or transaction currency.
EE Currency Translation: Overall Budget
Here you can maintain the exchange rate type and the value date that will be
used to translate the internal order transactions to compare against the bud-
geted value.
After you have defined the availability control, you need to define the tolerance
limits, which will tell the system what to do in case the budget is exceeded.
186
EE Act
This identifies the action that needs to be taken on the basis of the three
parameters:
EE 1: Warning.
EE 2: Warning with mail to responsible person.
EE 3: Error message.
EE Usag.
Here you can specify the tolerance levels, which if crossed, trigger the action
identified in the previous step.
EE Abs. Variance
This allows you to specify the maximum permissible absolute variance beyond
which the action will be triggered regardless of the usage percentage defined
in Usag….
5.5 Summary
In this chapter, you were introduced to the basic methods of budgeting, such as
cost center budgeting and internal order budgeting. Cost element accounting, cost
center accounting, profit center accounting, and internal order accounting are typi-
cally the Controlling components that are easiest to implement and which also give
you the maximum value out of implementing SAP ERP. This is because you can
tailor your Controlling processes in more detail as you build on these to determine
your optimal Controlling structure.
In this chapter you also learned about setting up primary and secondary cost ele-
ments and cost element groups in cost element accounting. Then you were intro-
duced to cost centers, cost center groups, cost center standard hierarchies, activity
187
types and groups, statistical key figures, and groups and resources definition. These
form the basis of performing cost center planning manually, and were followed
by a detailed explanation of the resource planning concept in cost center account-
ing. These planning tools will get you rolling quickly to get your planning process
ironed out. The various features and functionalities that make your planning exer-
cise faster and more customized to your needs were also discussed.
From learning about budgeting in cost center accounting to learning about cost
center planning and implementing funds commitment, you gained an understand-
ing of capturing future funds being locked up, providing you with an overall com-
mitment exposure for your organization.
You also learned about the overhead costing sheets that can be set up in cost cen-
ter accounting to calculate the cost of goods manufactured. Cost center accounting
was followed by profit center accounting where you learned about profit center,
profit center group, and the assignment of profit centers to other cost objects. You
also learned about some of the key settings that allow you to create a balance sheet
by profit centers. We then proceeded to key period-end and fiscal year-end closing
activities for profit center accounting.
Internal order accounting allows you to track short-term projects that need to be
capitalized or transferred to other cost objects. You learned about the internal
order master and internal order group. This was followed by an explanation of
order types and how this relates to status management and the settlement process
in internal order accounting. Finally you learned about activating budgeting and
availability control.
188
457
458
459
460
H L
HCM Payroll Ledger
Integration with Controlling, 103 Reconciliation, 107
Hierarchy variant, 243 Legacy data transfer, 334
History, 417 Line Item Reports, 424
How this book is organized, 18 Line Items, 408, 420, 422, 428
Human resources, 247 List-Oriented Reports, 423
Long-term cost monitoring activities, 170
I
M
IBM Websphere, 27
Implementation, 37 Maintain Table TVARC with appropriate
Individual Asset, 414 variables, 435
Inheritance principal, 69 Maintenance order, 98
Integration perspective, 46 Management accounting, 55
461
462
463
464
Y
V
Year-dependent master data, 235
Valuation
area, 116
method, 336
variant, 137, 144
465