Co
Co
Co
[Meghanath Reddy]
2011
CONTROLLING (CO)
CONTROLLING (CO)
This is used for internal reporting in Co organizational Hierarchy - Highest node is controlling
area. In FI Highest node is company, Company code
Areas to be covered:
1) Basic settings for controlling area
2) Cost element accounting
To update Co records / sub modules cost elements are required. There are two types of cost
elements
1.
2.
3.
Cost Center Accounting: This is used to view department wise costs. In organizations
we have no of cost centers.
Eg: Production cost center/ Service cost center / administrative cost centers
4.
5.
Profit center accounting: This is used to view profitability product wise / Division wise /
Location wise if business area is not used in FI
Page 2
8
9
10
11
12
13
Company
|
Company code
|
Business area
Controlling
|
|
|
Cost Center
Scenario - 1
Company
|
Company code
|
Business area
=
---
Controlling Area
|
Cost Center
(a)Controlling area at company code level, b) Business area will be assigned in cost centers.)
Scenario -2
Company
|
Company code
|
Business area
---
Controlling Area
|
|
|
Cost Center
Page 3
(a )Controlling area at company (group) level no. of company codes will have one
controlling area; b) Business area will be assigned in cost centers.
1) When management wants to view number of company codes cost centers data at a
time i)
It is not possible in 1st Scenario
ii)
It is possible 2nd scenario.
In report it will ask only one controlling area and not multiple controlling area.
2) When management wants to view number of cost centers data of company code i)
Directly it is possible in 1st scenario.
ii)
Also it is possible in 2nd Scenario - By creating cost center groups.
It means 2nd Scenario is more flexible.
3) When company codes activates are different it is better to go for 1st scenario
Controlling area
Name
Company code to controlling area
Currency type
:
:
:
:
FSL
controlling area for FSL
Select controlling area same as company code
select 10 company code currencies.
Once we select currency type10 currency field / Chart of Accounts filed / Fiscal year variant filed
will be updated automatically.
Cost Center standard hierarchy
[email protected]
: FSLHIER
Page 4
Save
Select yes button for the message system to create as a standard hierarchy
Select create request button
Short description
: Co customization for FSL
Press enter
Press enter once again to save in the request.
Cost centers
Dept. A
VSLHIER
|
Dept.B
Dept.C
In reports:
We want to see only cost enter dept a we give Dept A
We want to see only cost center dept B data we give dept B
We want to see all cost centers data we give FSLHIER
MAINTAIN NUMBER RANGES FOR CONTROLLING DOCUMENTS: (KANK)
1. CO through posting from FI (Business transaction - COIN
In fi
Salaries a/c dr 200000
cost center dept A
To bank
200000
[email protected]
Page 5
IN Co
Document type
No range
No. range intervals
SA
|
01
|
1-100000
Automatic posting
Dr
500000
300000
150000 Dept.B
50000Dept C
To bank
500000
No Fi document
1 Co document - RKU3
FI Document
CO Documents
Page 6
Salaries A/c
Dept.A
Dr
500000
300000
150000 Dept.B
50000Dept C
Rent A/c
Dr
To bank
100000
600000
Dept A
30/04/2011
31/05/2011
30/06/2011
Dept X
400100 Salaries 100000
400100 Salaries 125000
400100 Salaries 150000
---------400100 total 375000
30-6-2011
400100
Salaries
30-6-2011
400101
wages
100000
30/04/2011
31/05/2011
30/06/2011
125000
30/04/2011
400300
Rent
150000
Page 7
31/05/2011
30/06/2011
400300
400300
Rent 150000
Rent 150000
-------400300 Total 450000
30/6/2011
400300
Rent
40000
COIN
RKU3
RKU1
RKP1
MAINTAIN VERSIONS:
Versions are nothing but budgets
We have planned for the whole year
version 0
After one month revise planned figure version 1
After 2 month revise planned figure
version 2
Page 8
Path: SPRO
Organization
Original budgets
Revised budget
Re revised budget
Version 0
version 1
Version 2
--------- >
Internal settlement (Settlement from CO to CO) This is used for allocation of internal
costs to cost centers. (Co to Co)
Order/ Project Results analysis: This is used for work in process calculations is product
costing.
Overheads rates: This is used for calculation of raw material overhead rate /
Production overhead rate in product costing.
Assessment: This is used for allocation of primary cost element posing and secondary
cost allocations from one cost center to other cost centers.
Internal Activity Allocation: This is used for calculation of activity types rate in product
costing in production cost.
Eg: Machine hours rate / labor hour rate
21-7-2011
COST CENTER ACCOUNTING
This is used to view department wise costs we use cost center accounting.
In organizations there will be no.of cost centers
Eg: Production cost centers / service / administration cost centers
When we create cost centers we have to specify the cost center category i.e. whether it is a
production dept or service dept.
When we want to see no. of cost centers data at a time we create cost center group and assign
the respective cost centers
In the month end we allocate costs from one cost center to other cost centers the basis of
allocation may be amount basis / percentage basis / statistical key figures basis / activity type
basis
[email protected]
Page 10
|
|- Co Area
|
Page 11
Page 12
Page 13
: Dept B
: 01.04.2011
: Dept A
: FSL
to
31.12.9999
: Dept B
: Cost center Dept B
Page 14
Person responsible
: Mr. B
Other fields are common
Select save button
Ignore the warning message press enter
Cost center
: Dept C
Valid from
: 01.04.2011 to
31.12.9999
Reference cost center
: Dept A
Controlling area
: FSL
Enter
Change the name to
: Dept C
Description
: Cost center Dept C
Person responsible
: Mr. C
Cost center category
: Select to 2 (service cost center)
Select save button or Ctrl+s
Ignore the warning message press enter
Creation cost center groups:
Cost center area:
Cost centers
Category
Business Area
Dept A
Pro
HYD
FSL
I
Dept B Dept C Dept X
Prod
Service Produ
HYD
HYD
BGL
Dept Y
Produ
BGL
Dept Z
Service
BGL
If we want to see all cost centers data at a time we give Hierarchy - FSLHIER
If we want to see only production cost centers data - Create a cost center group and assign
Dept A . Dept B, Dept X and Dept Y.
If we want to see only HYD cost centers data - create a cost center group and assign Dept A,
Dept b and Dept C
If we want see only HYD production cost centers data
assign Dept A and Dept B
Path: Accounting
--------- > Controlling
--------- > Cost center accounting
Master data --------- > Cost center group --------- > Create (Tr.code is KSH1)
--------- >
Page 15
400100 salaries
400101 Wages
Personnel cost
Create cost element group personnel and
assign cost elements
400100-400199 create cost element group
400102 Bonus
400103 Insentives
In Co Report:
Cost center
Or
Cost center group
Cost element
Or
Cost element group
Dept A
ADMIN
Dept B
Personnel
FSLHIER
FSLHIER
ADMIN
Blank
Path: Accounting --------- > Controlling --------- > Cost center accounting --------- > Master
data --------- > Cost element group --------- > Create (Transaction code: KAH1)
Cost element group name : FSLADMIN
Enter
Description
: Administration cost for FSL
Select insert cost element button (Shift+F4) (Edit -Cost element -Insert cost element)
From cost element
: 400300
To
: 400399
Save
To enter exchange rate for type M for INR to EUR (Tr.Code is OB08)
Select new entries button
[email protected]
Page 16
:
:
:
:
:
Todays date
SA
FSL
40
400100 salaries account
: 500000
: Dept A select
: Salaries posting
: select Dept A
Page 17
: 1 to 100000
transfer
150000 Dept B
50000 Dept C
: 42
: FSL
: 2011
: 150000
: Dept B
: 50000
: Dept C
Page 18
Save
To view cost center report KSB1
Give the cost center
Select execute button
Select change layout button
Active business transactions
Enter
To cost center element wise total
Select cost element column
Select subtotal button
: Dept A
:
:
:
:
:
:
:
:
Dept A
400100 Salaries
100000
Dept C
Dept A
400300 Rent
25000
Dept C
FI
A) Transaction which effect To open
FI and CO eg: Expenditure
posting COIN
B) Transaction which effect No check
only CO Eg: Repost co line
item RKU3, repost cost
RKU1
[email protected]
CO
To open
To open
Page 19
--------- >
Controlling area
: VSL
Fiscal year
: 2011
Select actual button
To lock April period Select period: 01
Select lock period button
Save
Out Set controlling area : (OKKS):
Path: Accounting
--------- > Controlling
Environment --------- > Set controlling area
--------- >
--------- >
Form Bsed
If we select form based radio button
Page 20
At the time of entry no cost element will On screen the cost element list is available
appear on screen we have to select from plant against cost elements
drop down list the cost element and plan
against the cost elements
Select form based radio button
Select overview screen button
For cost element 400100 Plan Fixed cost 3000000
Distribution key 1 Equal distribution
Select cost element 400100
From the menu select Goto -Period screen
Select back arrow
For 400300 Rent a/c Plan fixed cost 720000
Distribution key 1
To plan for Dept B
Select next combination button
To go back to Dept A select previous combination button
Save
Page 21
Cost centers:
Company code
Dept A
FSL
Dr 200000
200000
Dept Y
FSL
Dept A
ledger
Page 22
FCL a/c dr
40000
To salaries a/c 40000
To View company code FSL ledger
Salaries a/c
200000 Dr 40000 Cr
To view cost center report:
Company code FSL Cost center
Dept A
Salaries a/c
200000 Dr
Less transfer
40000 Cr
To x
160000 Dr
Fi Customization:
To copy company code FSL customization including accounts to company code FCL
Path: SPRO
accounting
Page 23
2) Fennar cement limited, current assets, 2 Fennar cement limited, current assets,
Loans & Advances 200160 Fennar cement Loans & Advances 200160 Fennar cement
Limited
Limited
When we follow same chart of accounts, for number of company code account number and
description should be same if we create account 200160 in company code FCL it takes
description Fennar cemnts limited we cant create our account in our books if we create 200161
[email protected]
Page 24
in company code FSL it takes description Fennar steels ltd. We cant create our account in our
books.
Page 25
Company code 1
: FSL
Company code2
: FCL
Enter
Postedin
:
cleared against
: FCL
Debit posting key
: 40
Account debit
: 200160 ( Birla Steel Limited)
Credit posting key
: 50
Account credit
: 200160
Posted in
: FCL
Cleared against
: FSL
Debit posting key
: 40
Account debit
: 200161 Bilra Industries Limited
Credit posting key
: 50
Account credit
: 200161
Save
Press enter to save in your request
FSL
Page 26
--------- >
Page 27
To make text filed optional for field status group G004 cost accounts (Tr.code is OBC4)
Select field status variant FSL
Double click on field status groups folder
Double click field status G004
Double click on General data
Text select optional entry field
Save
Press enter to save in our request
Creation of cost center for company code FCL (KS01)
Give the cost center : Detp X
Valid from
: 01.04.2011 to
31-12-9999
Reference cost center: Dept A
Controlling area
: FSL
Enter
Change the name to : Dept X
Description
: Cost center dept X
Person responsibility : MR X
Company code
: FCL
Select save button or Ctrl+s
Ignore the warning message press enter
Repost costs (F-02)
Cost center old
Cost element
Amount
Cost center new
Save
:
:
:
:
Dept A
400100 Salaries
40000
Dept X
Page 28
FCL
50000
50000
Page 29
Business area
: FSLH
Text
: +
Save
Select continue buttons
FSL
44
FCL
2
If FSL posts the entry
Company code will be 000000000044 FSL11
If FCL posts the entry
Cross company code no. will be 0000000002 FCL11
Accrual orders (Imputed cost calculation)
This is used for irregular expenses like Bonus/Gratuity etc--This is used for month end provision only in CO
This Cost element category should be 3 Accrual/ Deferral per surcharge
Define CO.No.range interval for business Transaction: KAZ1 - Actual cost center accrual
FI Month end provision
1. Accrual / Deferral document
i) Bonus provision 30-4-2011
Bonus A/c
Dr. 10000 Cost center Dept A
To Outstanding exp.
10000
ii) Cost center Dept A expenditure will be allocated to production order stock valuation is
correct
iii) Reversal of provision on 1-5-2011
Outstanding Exp. Dr. 10000
To Bonus A/c
10000 Cost center Dept A
iv) Bonus provision on 31-5-2011
Bonus A/c
Dr
20000 cost center Dept A
To Outstanding exp
20000
2. Open item management
i) Bonus A/c
Dr. 10000 Cost center Dept A
To Outstanding exp.
10000
ii)Cost center Dept A expenditure will be allocated to production order- stock valuation is
correct
iii) Bonus provision on 31-5-2011
Bonus a/c Dr
10000 Cost center Dept A
To outstanding exp
10000
In Co: Accrual orders:
3rd Method:
Page 30
i)
Number of companies will not prepare profit and Loss account every month they will
not make provision in accounts every month
Expenditure from April to Feb will be less
ii) Companies follow accrual basis of accounting in the year end provision are to made in
accounts expenditure for March will be more.
iii) In SAP when we take production - production entry will be passed automatically based on
production cost for the month stock/production valuation from Apr to Feb will be less stock
/ production valuation for March will be heigh
iv) SAP has given accrual order it is similar to cost sheet create over head structure.
Salaries a/c
100000
Bonus 10%
10000 debit to cost center dept A
Credit to cost center dummy
No Fi document
Cost center Dept A
30-4-2011 bonus 10000
30-4-2011 allocation to production order 10000
Stock valuation is correct
Cost center dept dummy
30-4-2011 Bonus
10000
V) Every month end we follow the same procedure
Cost center dept dummy
30-4-2011
bonus
10000
31-5-2011
bonus
10000
I
I
31-3-2012
bonus
10000
120000
v) In the yearend bonus provision in accounts
31-3-2012
Bonus
a/c Dr
120000 Cost center dept dummy
To outstanding exp
120000
Cost center dept dummy
31-3-2012
120000
30-4-2011
bonus
10000
30-5-2011
bonus
10000
I
I
31-3-2012
bonus
10000
120000
120000
Dept dummy will be zero
3-8-2011
Creation of GL master bonus account - personnel cost (FS00) group: Give the GL Account No.
[email protected]
: 400105
Page 31
Company code
: FSL
Select with template button
Give the GL account no.
: 400100 (salaries)
Company code
: FSL
Enter
Change short
: Bonus account
GL account long text
: Bonus account
Save
Select edit cost element button (F8)
Valid from date
: 01.04.2011 to 31.12.9999
Enter
Cost element category
: Select 3 accrual deferral per surcharge
Save
Creation of cost center - Dept dummy (KS01)
Give the cost center
: Dept dummy
Reference cost center
: Dept A
Controlling area
: FSL
Enter
Change name
: Dept dummy
Description
: Cost center Department dummy
Select save button
Ignore the warning message press enter
Define CO.no range interval
Transaction KAZ1-Actual cost Center accrual
Transaction Code KANK
Give the controlling area
: FSL
Select maintain group button
Double click on KAZ1- Actual cost center accrual
Select CO.No range interval for FSL check box
From the menu select Edit ------- > Assigned element group
Save
Ignore the warning message press enter
Page 32
Page 33
Cost element
Cost center
Save
END USER AREA
: 400105
: Dept Dummy
: Dept A
: 01.04.2011 to 31.04.2011
Page 34
: Dept dummy
: Dept dummy
: 01.04.2011 to 31.03.2012
Page 35
No.of Employees
April
May
June
July
Aug
Sep
Oct
Nov
Dec
Jan
Feb
March
Dept A
200 200
|
|
|
|
|
|
|
|
|
|
|
I
I
I
200 250
|
|
|
|
|
|
Total values
If we select total values radio button every
month we have to enter values
Eg: Telephone calls
Dept A
1000
1500
800
Define co.no range interval for the business transaction RKS-Enter Statistical key figures
Transaction Code is (KANK )
Give the controlling area
: FSL
Select maintain groups button
Double click on RKS
Select Co.No.range interval for FSL check box
From the menu select Edit ------- > Assignment element group.
Save
Ignore the warning message press enter.
Page 36
:
:
:
:
:
:
--------- >
--------- >
--------- >
Dept A
EMP
200
Dept B
EMP
50
Dept A
Dept B
(Production departments)
200000
300000
100000
600000
No. of employee
Percentage basis
Basis of allocation can be percentage basis /amount /statistical key figures basis /activity type
basis
SAP has given 4 allocation methods
Allocation methods:
i) Assessment :
ii) We can transfer primary cost postings and secondary cost allocations
Dpt X
Dept C
Dept A
Dept B
Page 37
wages
500000
Allcn
75000
Less:
Allcn A 90% -675000
Allcn B 10% -75000
0
0
1075000
575000
In dept C we have
Direct postings primary cost postings salaries / wages / rent transfer from X - secondary cost
allocation
iii) Receiving cost center cannot track the original cost elements
Dept A received from C 675000 it will not show how much is salaries portion of C/ allocation
to C from X portion
iv) Define Co no. Range interval for the business transaction RKIU actual overhead assessment
v) Sender should be only cost center
2. Distribution
i) We can Transfer only primary cost postings
ii) Receiving cost center can track original cost elements.
iii) Sender should be only cost center
iv) Define Co.No.range interval for the business transaction RKIV actual overhead
distribution.
3. Periodic reposting:
i) We can Transfer only primary cost postings
ii) Receiving cost center can track original cost elements.
iii) Sender can be a cost center or order.
iv) Define Co.No.range interval for the business truncation.
RKIB periodic reposting.
4. Indirect activity allocation.
i) We can Transfer only primary cost postings.
ii) Receiving cost center can track original cost elements.
iii) Sender should be only cost center.
iv) We can Transfer quantities as well as values.
v) Define Co.No.range interval for the business truncation.
RKIL Indirect activity allocation.
Whichever method we follow, we have to create cycles.
Page 38
Where the basis of allocation of cost elements in the cost center is different we have to create
number of cycles or number of segments under a cycle.
Create no. of segments under a cycle:
Eg:
Cost center Dept C
Dept A
Dept B
(Service Department)
(Production departments)
Salaries
Wages
Rent
200000
300000
100000
600000
Option 1:
Create no of cyles:
Cycle 1
(Assessment cycle)
|
Segment 1
(Salaries and wages allocation)
400100 salaries account
400101 wages
Option 2
Cycle 12
(Assessment cycle)
|
Segment 1
(Rent allocation)
400300 Rent
Option 2:
Create no.of segments under a cycle
Cycle 1
(Assessment cycle)
|
---------------------------------------------|
|
Segment1
Segment2
(Salaries and wages allocation)
(Rent allocation)
40100 salaries account
400300 Rent
400101 wages account
Page 39
ASSESSEMENT Method
1. Creation secondary cost element : i.e (that is) assessment cost element :
Path: Accounting
--------- > Controlling
--------- > Cost element accounting --------- >
Mater data --------- > Cost element
--------- > Individual processing
--------- > Create
secondary (KA06)
Give the controlling area
Enter
Cost element
Valid from
Enter
Name and description
Cost element category
Save
: FSL
: 1000000
: 01.04.2011 to 31.12.9999
: Assessment cost element.
: 42 (Assessment )
Dept A
Less : Allocation
200000
0
Add: Allocation
Less: Allocation
14000
14000
0
Dept X
Salaries
Add: Allocation
Less : Allocation
Add allocation
100000
40000
Dept B
Dept Z
Dept Y
Dept Z
Dept C
40%
50%
20%
56000
70000
14000
140000
140000
0
2800
We have to run number of items till both cost center values become zero. If we select
interactive check box, system will automatically no. of times till they become zero.
Select attach segment button.
Segment name
: Segment 1
Description
: Salaries allocation
Assessment cost element
: select 1000000
Sender rule
: select posted amounts
Share in %
: 100
Select actual value origin radio button
Receiver rule
: Select variable portions
Variable portion type
: Select actual statistical key figures
Select sender / receivers tab
Sender cost center
: Dept C
Cost element
: 400100 (Salaries a/c)
Under Receiver cost center group : BILHYDPRD
Select receiver tracing factor tab
Statistical key figure
: EMP
Select receiver weight factors tab
Select save button or Crl+S
Press enter to save in your request
Select attach segment button
Segment name
: Segment 2
Description
: Rent allocation
Assessment cost element
: 1000000
Sender rules
: Posted amount
Sharing in %
: 100%
[email protected]
Page 41
Rent
A
1500000
25000
B
No.of employees(skf)
200 EMP
120000
Percentage basis
40%
10000
50 EMP
30000
60%
15000
175000
Assessment Run:
Path: Accounting
--------- > Controlling
--------- > Cost center accounting
--------- >
Period end closing --------- > Single functions --------- > Allocations
--------- > Assessment
(KSU5)
Give the period
: 4 (July)
Fiscal year
: 2011
Deselect text run check box
Select details list check box
Cycle select
: FSL1 (select)
Execute
Select receiver button
Page 42
INTERNAL ORDERS
This is used to view costs for a specific task.
Eg.1) Vehicle wise running expenses
In an organization they have 10 vehicles the Management has to decide whether to sell a
particular vehicle (or) keep the vehicle in company
A) petrol expenses for the vehicle
In FI -we will not create each vehicle wise separate expenditure accounts we will not get
vehicle wise total running expenses.
In CO cost centers - all vehicles will be under administration cost center here also we will not
get vehicle wise total running expenses in administration cost center we get other
administration expenses along with vehicle expeses.
Creating vehicle order and get the costs.
2. Telephone expenses:
In a company they have 50 telephones they give reimbursement to some employees
management wants to know telephone wise expenses.
In Fi we will not create telephone wise separate expenditure accounts we will not get
telephone wise expenses
In Co cost centers: all telephones will be under administration cost center here also we will
not get telephone wise expenses.
Create telephone order and capture the cost.
Page 43
2) Statistical orders
i) Incase of statistical orders settlement not possible
ii) Used for information / reporting purpose.
Dr
Statistical order:
Telephone order we create as statistical order.
Telephone expense
To Bank
Dr 20000
20000
Page 44
20000
Page 45
Creation of filed status group by making cost center and order required entry fields (OBC4)
Select field status variant FSL
Double click on field status group folder
Select field status group G004 cost accounts
Select copy as button
Change the field status group to G002
Change the text
: cost accounts (CC & IO required) IO =Internal order
Enter
Save
CC=Cost Center
Press enter to save in your request
Double click on G002
Double click on additional account assignment
CO / PP order select required entry field.
Save
Creation of GL master telephone expense (FS00)
Give the GL account no
: 400305
Company code
: FSL
Select with template button
GL account
: 400300 Rent account
Company code
: FSL
Enter
Change short text
: Telephone expenses
GL a/c long text
: Telephone expenses
Select crate / Bank/Interest tab
Change the field status group: G002
Save
Select edit cost element button
Valid from date
: 01.04.2011
Enter
Cost element category
: Select 1
Save
Creation of Internal orders:
Path: Accounting --------- > Controlling --------- > Internal orders --------- > Master data -------- > Special functions --------- > Order --------- > Create (Tr code is KO01)
Order type
Enter
Order no.
Description
[email protected]
: FSLT
: FSL 66611983 (Telephone no.)
: Telephone order no.66611983
Page 46
Company code
: FSL
Business area
: FSLH
Select control data tab
Select statistical order check box
Save
Creation order group
Path: Accounting --------- > Controlling --------- > Internal orders --------- > master data the
path is same --------- > Order group --------- > Create (Tr code is KOH1)
Give the order group
: FSLHYDTEL
Enter
Description
: FSL Hyderabad order group
Select insert order button
Select to orders
: FSL66611983
: FSL66626246
Save
Posting of transaction in FI (F-02)
Document date
Type
Company code
Posting key
Account no.
Enter
Give the amount
Cost center
Order
Text
Posting key
Account no.
Enter
Amount
Business area
Text
From the menu select -Document
:
:
:
:
:
Todays date
SA
FSL
40
400305 Telephone exp
:
:
:
:
:
:
20000
Dept A
FSL66611983
Telephone expenses
50
200105 (SBI current account )
: *
: FSLH
: +
- ----- > Simulate and save
Page 47
--
:
:
:
:
:
:
FSL
2011
5 (Current month)
5
0
FSL66611983
Real orders:
Vehicle order we create as real order
Petrol expenses
To Bank
Dr
Page 48
Order No AP9Z1234
Petrol expenses
10000
------10000
====
Dept A
Dept B
Dept C
5000
3000
2000
-----10000
====
Dr 10000
10000
10000
--------10000
====
Creation of filed status group by making only order required entry filed (OBC4)
Select filed status variant
: FSL
Double click on filed status group folder
Select field status group
: G002
Select copy as button
Change field status group
: G010
Change the text
: Cost accounts (IO required )
Enter and save
Press enter to save in your request
[email protected]
Page 49
: 400310
: FSL
: 400300 Rent account
: FSL
: Petrol expenses
: Petrol expenses
: G010
: 01.04.2011
: 01
: 1000001
: settlement cost element
: Select 21 internal settlement
--------- >
Page 50
Page 51
5000
3000
2000
40%
50%
10%
3:
5:
2
Page 52
Define co.no.range interval for the business truncation K0A0-Actual settlement. Use the
transactions code (KANK)
Give the controlling area
: FSL
Select maintain groups button
Double click on KOAO actual settlement
Select co.no.range interval for FSL check box
From the menu select Edit --- --------- > Assign element group.
Save
Ignore the warning message press enter
END USER AREA:
Creation of internal order (KO01)
Give the order type
: FSLV
Enter
Give the order
: AP9Z1234
Description
: Vehicle no.AP9Z1234
Company code
: FSL
Business area
: FSLH
Select control data tab
Deselect statistical order check box
Select settlement rule button
Category
: CTR cost center
Settlement receiver
: Dept A
Give the percentage %
: 50
One more
Category
: CTR
Settlement receiver
: Dept B
Percentage
%
: 30
Category
: CTR
Settlement receiver
: Dept C
Percentage
%
: 20
Save
Ignore the warning message press enter
Posting of petrol exp F-02
Give the document date
Type
Company code
Posting key
Account no.
[email protected]
: Todays date
: SA
: FSL
: 40
: 400310 petrol exp.
Page 53
Enter
Give the amount
: 10000
Give the order no.
: AP9Z1234
Text
: Petrol exp.
Posting key
: 50
Account no.
: 200105 SBI current account
Enter
Amount
:*
Business area
: FSLH
Text
:+
From the menu select menu document ------- > Simulate and save
Actual settlement :
Path: Accounting --------- > Controlling --------- > Internal order --------- > Period end closing
--------- > Single functions --------- > Settlement --------- > Individual processing (K088)
Give the order
: AP9Z1234
Settlement period
: 5 (current month)
Fiscal year
: 2011
Deselect test run check box
Select check transaction date check box
Select execute button
Select details list button
We have posted to order AP9Z1234
I
Create order with FSKV and in the oreder
Specified
10000
to Dept A
B
C
50%
30%
20%
I
In order type FSLV given settlement profile FSL1
I
In settlement profile FSL1 kept the options open percentage/ Ratio / Amount specified receiver
will be cost center assigned allocation structure F1
I
In allocation structure F1 specified vehicle expenses 400310 cost to be allocated to cost centre
by using secondary cost element 1000001
Page 54
Budgeting
i) Budget will be made order wise
ii) Budget will be made year wise
iii) Macro level
For budgeting SAP has given
availability control
Order AP9Z1234
For year 2011 budget amount 100000
Option :1 Option: 2
Option: 3
Message
Message to Error
to user
user and
message
inform to
budget
manager
Page 55
Page 56
Page 57
2nd scenario
HYD
|
Steel
Division
BGL
|
Cement
Division
MOM
|
Pharma
Division
Business area
or
profit center
The advantage of profit center accounting is it derives profit center automatically though
derivation rules.
A) In case of expenditure
Tough cost centers
B) IN case revenues
Automatic account assignment
C) In case of balance sheet itmes
for sundry debtors and creditors balance sheet
adjustment to run other accounts at the time of
posting we can select.
Eg: cost centre dept A
Cost centre dept A is working for profit center steel assign steel profit center in cost center dept
A
At the time of posting to salaries in dept A
Salaries a/c Dr
200000
cost center dept A
To Bank
200000
Page 58
Once we save cost center dept A will be updated with 200000 also profit center steel will be
updated with 200000 due to derivation rule.
We have to create dunning profit center. At the time of posting, if there is no derivation rule for
any transaction, system automatically updates dummy profit center. Then we transfer form
dummy profit center to respective center also Create derivation rule so that future transactions
will go to respective profit center and not go to dummy profit center.
Set controlling area (OKKS)
Path: SPRO --------- > Controlling
--------- > Set controlling area
Give the controlling area
Enter
Page 59
Page 60
: Steel
: 01.04.2011 to 31.12.9999
Page 61
Name
Long text
Person responsible
Profit center group
select activate button (Shift+F1)
: Steel
: Profit center steel
: Mr A
:FSL
: Cement
: Cement
: Profit center cement
: Mr B
: FSL
: BSITEMS
: Balance sheet accounts for FSL
: 100000
: 299999
: Dept A
Page 62
: Steel
: Dept B
: Cement
Page 63
Business area
or
Profit center
300000
Sales account
HYD - --------- > Steel
BGL - --------- > Cement
Mum - --------- > Pharma
Business area
Profit center
Business area
Profit center
Save
:
:
:
:
FSLH
Steel
FSLB
Cement
Page 64
Business area
Profit center
Account no
To account no.
Business area
profit center
Save
: FSLH
: Steel
: 100000
: 299999
: FSLB
: Cement
--------- >
Profit center
Reporting currency
500000 - (minus sign)
400000
Planning profit center wise for balance sheet items (Only for second scenario)
Path: Accounting
--------- > Controlling
--------- > Profit center accounting
Planning --------- > Balance sheet accounts change (Tr code is 7KE3)
Version
From period
To period
Fiscal year
Company code
--------- >
:0
:5
:5
: 2011
:FSL
Page 65
Profit center
:steel
select next page or page down button
Account group
: BSITEMS
Select form based radio button
Select overview screen button
Text
For Account no.
SBI RT/loan
100300
SBI ca a/c
200105
Save
Profit center
Reporting currency
200000 - (minus sign)
200000
RECEIVABLES
Sales invoice Posting (F-22)
Give the document date
: Todays date
Type
: DR
Company code
: FSL
Posting key
: 01
Account no.
: 3000401
Enter
Amount
: 475000
Business area
: FSLH
Text
: sales invoice posting
Posting key
: 50
Account no.
: 300000 (Sales a/c)
Enter
Amount
:*
Business area
: FSLH
Text
:+
Form the menu selects Document -Simulate and saves
01 customer account dr 470000
50 to sales account
475000
If we post to 300000 sales a/c with B.area FSLH
It updates profit center steel
Calculate balance sheet adjustment in the month end
Path: Accounting --------- > Financial Accounting -------- > General Ledger --------- > Periodic
processing --------- > Closing --------- > Reclassify --------- > Balance sheet adjustment --------> Calculate TR.code F.5D
Company code
: FSL
Select execute button
It takes first line item of 3(i) customer profit center steel based on 2nd line item sales a/c
[email protected]
Page 66
Page 67
Path: Accounting
--------- > Controlling
--------- > Profit center accounting --------- >
Information system --------- > Repost for profit center accounting --------- > Interactive
reporting
--------- > Profit center group: Plan /actual /variance (Tr code is
S_ALR_87013326)
From period
To period
Fiscal year
Plan version
Profit center values
Profit / loss account groups
Select execute button
To view variance report profit center wise for balance sheet items:
Path: Accounting
--------- > Controlling
--------- > Profit center accounting --------- >
Information system --------- > Repost for profit center accounting --------- > Interactive
reporting --------- > Profit center group: Balance sheet accounts plant / Actual /Variance
(Tr code S_ALR_87013336)
From period
To period
Fiscal year
Plan version
Profit center values
Balance sheet account group
Execute
: 5 (Running month)
:5
: 2011
:0
: Steel
: BSITEMS
Page 68
: FSL
: Steel
: 400100 Salaries
: 100000 -(with minus sign)
: Cement
: 400100 Salaries
: 100000 (without minus sign)
INTEGRATION
Organization structure:
FI: Business area
Company
|
Company code
MM: Business area Plant
: Factory
I
: Branch
I
: Port
Storage locations: Raw material
: Packing material
: Finished goods
: Stores
SD:
Sales organization
|
|
Distribution->
Channel
|
Divisions - >
Page 69
In SD module, combination of sales organization, distribution channel and division they call it as
One sales area.
Sales Area 1
Hyd location (sales Org)
|
Direct sales
|
Steel
Sales Area 2
Hyd location (Sales org)
|
Through agents
|
Steel
Dept A
Production order 1
Production order 2
Production order 3
Dept B
Dept C
Page 70
b) WRX
c) PRD
d) GBB
VBR
Valuation class:
Valuation class determines the GL accounts to be posted automatically.
A) Raw materials: 4 valuation classes
Local purchase
Imported purchase
Inter unit transfer
Inter company purchases
B) Stores
: 2 valuation class
Local purchase
Imported purchase
FSL
FCL
FIL
FSL (all co. Codes are using same chart of accounts)
HYD-BGL
HYD-MUM
BGL-MUM
RM1- RM2
RM2-RM1
RM3-RM1
When we purchase raw material we use only one a/c 200121 -Inventory raw material local
[email protected]
Page 71
When we use same chart of accounts for numbers of company codes, Instead of assigning
accounts number of times, assign only one time by using valuation grouping code.
Valuation
Areas Plants
Chat of accounts
HYD
BGL
BGL
MUM
HYD
MUM
FSL
FSL
FSL
FSL
FSL
FSL
Company code
Valuation
Grouping
FSL
FSL
FCL
FCL
FIL
FIL
X
X
X
X
X
X
Chat of accounts
HYD
BGL
HYD
MUM
BGL
MUM
FSL
FSL
FSL
FSL
FSL
FSL
Company code
Valuation
Grouping
FSL
FSL
FCL
FCL
FIL
FIL
X
Y
X
Y
X
Y
For inventory raw material local for plant HYD X -200121 inventory RM. Local
For plant BGL Y - 200121 Inventory RM Local
Price controls
Material types
Raw materials
Stores & spares
Packing & material
Finishing goods
Semi finished goods
Purchased
Produced
Trading goods
ROH
ERSA
VERP
FERT
purchase cost
purchase cost
purchase cost
RM cost + Overheads
HALB
V-Moving average price
HALB
S-Standard price
HAWA V-Moving average price
Purchase cost
RM cost + Overheads
Purchase cost
Page 72
Services
DIEN
Differences between semi finished goods, purchased and produced
Issue RM cycle time 15 days finished goods
1 semi finished goods purchased:
marketing dept got an order, customer wants material with in 3 days
purchase a material where processing of A,B,C completed do only dept B processing
and take finished goods
2 Semi finished goods produced:
Dept A
Semi finished goods purchased
Dept A
Dept B
Dept C
Dept D
Marketing dept got an order customer wants material after B processing
Take production after B processing and sell
Trading goods:
Marketing dept got an order customer wants material today it self
Buy finished goods in the market and sell the finished goods to customer without doing any
processing
Services:
Page 73
Material management:
MM Flow
A) Material requisition
By production Dept inform Stores dept
B) Purchases requisition
By stores to purchases
C) Purchase dept Call for enquiries, By purchase Dept.
Get quotations and do price comparisons
D) Create purchase order
Vendor number, Material
Quality, Rate, Plant, Company code
Delivery terms, payment terms,
Purchase organization
E) Release purchase ordre
It is optional
It will work through work flow
Eg:
If P.O value is less than Rs.10000
BSX
WRX
WRX
party no is taken From PO,
DR
20
20
P & L Debit
BS CA
Page 74
K) Production Receipt:
At product cost
Inventory FG
DR
To INC/DEC in stocks FG
120
120
BS C/A BSX
P & L Credit GBB
M) Sales billing:
Customer A/c DR
150 BS
C/A
customer number is taken from sales order
To Sales
150
P & L credit ERL
( Qty sold * selling price) kg * 150 Rs
Profit & Loss account
H) RM consmn local
Wages
Net profit
100 L)Sales
20
J)INC/DEC STK FG 120
30
K)INC DEC STK FG -120
------150
===
150
0
----150
===
Balance Sheet
Surplus in P & L Account
Sundry creditors RM
GR/IR CLRG RM LCL 100
GR/IR CLG RM LCL - 100
0
30
100
0
130
Bank
Sundry debtors
INV RM LCL 100
INV RM LCL -100
INV FG
120
INV FG
-120
-20
150
0
0
130
Page 75
Integration steps:
A) In material master we specify valuation class
B) For valuation class we assign GL accounts based on the nature of transaction
C) At the time of material receipt/Issue stores person enters movement types/ material
number / quantity. Our accounts will be up dated automatically based on accounts
assignment to valuation class which is specified in material master
Eg: Material no. Valuation
Inventory postings
RM1 (local)
200121-INV-RM
3000 RM
local
3001 RM
imported
RM 2
GR/IR
Clearing
100520-GR/IR
Consumption
400000-RM
(GBB VBR)
400001 RM con IMP
Local purchase:
1. Purchase order:
Save
Vendor -1234
Material -RM1
Qty-1000 Kgs
Rate 5 Rs
P.O.No.1
2. Goods receipt:
against-P.O No.1
Movement Type: 101
Debit BSX
Credit WRX
Material
RM1
3000
Qty
400 kgs
Save
Debit 200121 Inv RM LCL
2000
Credit 100520 GR/IR CLRG RM LCL 2000
(Qty IN GR *Rate as per P.O)
(400kgs * 5 Rs = 2000)
Here generated 2 documents
Material document 500001
FI document
100001
3.Raw material consumption:
Movement type
Material
Qty
201/261
RM1
100 Kgs
Debit GBB
Credit BSX
VBR
3000
Page 76
save
400000
RM Consumption LCL
200121
Inventory RM Local
(Qty issued * Moving average rate)
(100kgs * 5 Rs)
Material document 500002
FI document
100002
DR
500
500
Vendor -5678
Material -RM2
Qty-1Kg
Rate -200
Save PO No.2
DR
200
200
Material returns:
Material doc no.500003
Movement
Type
102/122
Debit WRX
Credit BSX
3001
Material
RM2
Qty
1 Kg
Save
100521
GR/IR CLRG RM
IMP
200122
Inventory RM
IMP
(Qty returned * Moving AVG price)
1kg * 200 Rs
Here generated 2 documents
Material document 500004
FI document
100004
[email protected]
DR
200
200
Page 77
Price differences
Batch method: moving AVG Method
1 stocks full available
2 stocks partly available
3 stocks not available
1 batch method: purchase order price 10 rs
Material RM 1
Lot Qty Rate Amount
1 Rawmaterial receipt
1
100 10
1000
Dr INV RM LCL
To GR/IR/CLRG RM LCL
2 Rawmaterial receipt
2
50
40
2000
Dr INV RM LCL
150
3000
To GR/IR/CLRG RM LCL
10
300
3
30
120
2700
3 Material consumption
RM consmn LCL Dr
____
140
120
2840
To INV.RM.LCL
Break up:
1
70
2
50
12
40
840
2000
4 Invoice verification
GR/IR/CLRG RM LCL Dr
Inv RM LCL Dr
Price difference RM LCL Dr
To Party a/c
1000 BSX
1000 WRX
2000 BSX
2000 WRX
300
300
GBB VBR
BSX
1000 WRX
140 BSX (70x2)
60 PRD (30x2)
1200 (vendor no.is take
From P.O)
Presentation in accounts
RM consumption
RM consumption Local
+/- price difference RM LCL
300
60
360
Some consultants for PRD assign a/c price difference RM LCL others assign for PRD RM
consumption Local a/c
Moving average method: stock fully available
Material - RM1
Bill qty
PO Price : 10
1000 BSX
1000 WRX
Page 78
150
30
---Average bill 120
qty
---120
20
3000
Inv RM local DR
2000 BSX
600
To GR/IR CLRG RM LCL
2000 WRX
----2400 3. Raw material consumption
200
RM consumption LCL Dr 600 GBB VBR
----To Inventory RM LCL
600 BSX
2600 4. Invoice verification
GR/IR CLRG RM LCL DR
1000 WRX
Inv RM LCL Dr
200 BSX
To Party
1200 vendor is taken from PO
Consumption rate:
Value / Qty 3000/150=20
Next consumption Avg
Value / Qty 2800/120=21.67
method moving average method Stocks partly available
Material - RM1
PO Price : 10
Qty rate amount
Bill qty
100 10
1000
50
40
2000
--------150
3000
110
20
2200
-------Average bill 40
800
qty
80
-------40
880
1000 BSX
1000 WRX
2000 BSX
2000 WRX
Consumption rate
Value / Qty 3000/150=20
Next consumption rate:
Value qty 880/40=22.00
In batch method -It has checked batch wise for the material.
In this method -it has checked material wise.
Page 79
1000 BSX
1000 WRX
2000 BSX
2000 WRX
Consumption rate
Value / Qty 3000/150=20
Other options available:
1.along with material receipt bill comes, before taking GR change price in purchase order when
we take goods receipt at new price it takes no price difference
2.in the latest version SAP has given the facility when we do invoice verification we have the
option to add to material or change to accounts the price difference.
Page 80
A) Delivery without post goods issue (Delivery without PGI) ownership is not
transferred.
Eg. Export sales -Terms of delivery -FOB (Free on board)
Hyderabad Factory
Delivery without PGI
Chennai Port
No FI document
Only material document
Customer
Delivery with PGI
FI document
Material document
IN SD Module-Pricing procedure
Eg: local billing
Basic price (A)
X
Excise (B)
% on A
Basic+Excise(A+B)=C
X
Sale tax (D)
% on C
Customer Debit (C+D)`
X
Eg: Export billing
Basic price (A)
X
FI consultant job: Assignment of accounts
Condition type:
Page 81
Assignment of accounts
1
Application
area
2
3
Conditio Chat
n type
of
accou
nts
V-Sales & KOFI
FSL
Distribution
4
Sales
originatio
n
HYD
5
Account
assignment
group for
customers
01
FSL
HYD
01
FSL
HYD
02
FSL
HYD
01
01Domestic
revenues
02-Foreign
revenues
03Affliated
company
revenues
6
Account
assignment
group for
materials
03
7
8
Accou GL account
nt keys
ERL
300005
Sales Local
own goods
01
ERL
300006Sales local
trade goods
03
ERF
300007
Sales export
goods
03
ERL
400320
Sales
Freight
revenu Local own
e
goods
01 Traded ERF
goods
Freight
Reven
ues
02 Services ERBRebate
s
/Tradi
ng
Discou
nts
03 Finished ERS
goods
Sales
Deduct
ions
Page 82
MM CUSTOMIZATION
MM consultant job
1. Define Plants
Path: SPRO --------- > Enterprise structure --------- > Definition
general --------- > Define copy, delete check plant.
: FSLP
Page 83
Page 84
: FSL
: 2011
: 4 (July)
Note: This period enter carefully, if you once enter not modified
Select ABP check box (ABP stands for Allow Back Period Posting)
Save
Ignore the warning message press enter
Press enter to save in your request
[email protected]
Page 85
--------- >
--------- >
Page 86
Page 87
Page 88
FI consultants job:
1. Creation of GL masters FS00
A) Inventory RM local
B) Inventory finished goods
C) GR/IR clearing RM local
D) RM consumption local
E) INC/DEC in stocks FG
Give the GL account no
Company code
Select with template button
Give the GL account no
Company code
[email protected]
: 200121
: FSL
: 200120 Inventory RM
: FSL
Page 89
Enter
Change the short text
: Inventory RM local
Change the GL a/c long text : Inventory RM local
Select control data tab
Tax category
: select * (All tax allowed)
Select posting without tax allowed check box
Select create/Bank/Interest tab
Field status group change
: G006 Material accounts
Select post automatically only check box
Save
All BSX account assignments we have to select post automatically only check box
GL account no.
: 200122
Company code
: FSL
Select with template button
Give the GL a/c
: 200121
Company code
: FSL
Enter
Change short text
: Inventory FG
GL a/c long text
: Inventory FG
Save
GL account
: 100520
Company code
: FSL
Select with template button
GL account
: 100500 outstanding exp.
Company code
: FSL
Enter
Change short text
: GR/IR clearing RM local
GL account and long text
: GR/IR clearing RM local
Select control data tab
Tax category
:*
Select posting without tax allowed check
Sort key
: 014 Purchase order
Select create /bank /interest tab
Field status group change to G045 (goods/Invoice received clearing accounts)
Save
G/L account
: 400000
Company code
: FSL
Select with template button
Give the GL account
: 400100 Salaries a/c
Company code
: FSL
Enter
Select type/description tab
Change the account group to RM consumption
Change short text
: RM consumption local
[email protected]
Page 90
Valuation class
Account
Page 91
X
FSL1 RM local
200121 Inventory RM local
X
FSL2 Finished products
200122 Inventory FG
Save
Press enter to save in your request
Select back arrow
Double click on transaction WRX GR/IR clearing account
Select valuation modifier check box
Select valuation class check box
Save
Valuation modifier
:X
Valuation class
: FSL1 RM local
Account no.
: 100520 GR/IR clearing local
Save
Press enter to save in your request
Select back arrow
Double click on transaction GBB offsetting entry for Inventory posting
Select General modification check box
Select Valuation modifier check box
Select Valuation class check box
Save
Valuation General modification
modifier
X
VBR (consumption)
X
X
X
ZOF (Production
receipt
without production order)
AUF production receipt with
production order
VAY (Delivery where sales
account is created as revenue
element
Co implemented)
VAX Delivery where is sales
account is not created as
revenue element
CO not implemented
Save
Press enter to save in your request
Valuation class
FSL1 RM local
FSL2
products
FSL2
Account
400000
RM
consumption local
Finished 300200 Increase /
Decrease stocks FG
300200
FSL2
300200
FSL2
300200
Page 92
Type
WE
WA
RE
: Goods receipt
: Goods issue
: Grass invoice receipt
No.Range
50
49
51
Select type
WE
Select details button
Select number range information button
Company code
: FSL
Select change intervals button
Select interval button
No. range
: 50
Year
: 2011
From no.
: 900001
To no.
: 1000000
Enter and save
Ignore the warning message press enter
Select interval button
Select back arrow 3 times
Select type WA Goods issue
Select details button
Number range
: 49
Select no.range information button
Company code
: FSL
Select change intervals button
Select interval button
No.range
: 49
Year
: 2011
From no.
: 1000001
To no.
: 1100000
Enter and save
Ignore the warning message press enter
Select back arrow 3 times
Select RE gross invoice receipt
Select details button
Select no.range information button
Company code
: FSL
Select change intervals button
Select interval button
No.range
: 51
Year
: 2011
From no.
: 1100001
To no.
: 1200000
[email protected]
Page 93
Page 94
Page 95
100000
FSLRM1
BSX
FSL1
FSLRM1
WRX
FSL1
Invoice verification:
To assign FSL tax to country India
Path: SPRO -------- > Financial Accounting --------- > Financial accounting global settings -------- > Tax on sales/ purchase --------- > Basic settings --------- > Assign country to
calculation procedure
For country IN assign FSL TAX
Save
Save in your request.
Invoice verification:
Path: Logistics
--------- > Materials management
--------- > Logistics --------- >
Invoice verification
--------- > Document entry --------- > Enter invoice (Transaction
code is MIRO)
Compay code
: FSL
enter
Give the invoice date
: Todays date
Reference
: Party bill no. 2345
Text
: Invoice verification
Purchase order
: 4500017094
Enter
Select calculate tax check box
Tax code
: VO (0% input tax)
[email protected]
Page 96
Enter
Amount
: 100000
Enter
Select save button or Ctrl+s
From the menu select invoice document - --------- > Display
Select follow on document button
4000101 FSL MM Vendor
: FSLRM1
: FSL
: FSLP
: 01.04.2011 to 31.03.2012
Page 97
SD INTEGRATION
SD consultants job
1. Define region: (State)
Path: SPRO --------- > SAP net weaver
countries --------- > Insert regions
Page 98
Description
: Andhra Pradesh
Save
Select create request button(F8)
Short description SD customization for FSL
Enter
Save in your request
Define sales organization:
Path: SPRO --------- > Enterprise structure
--------- > Definition
--------- > Sales
and distribution --------- > Define, Copy, Delete, Check, Sales organization
Double click on sales organization
Select new entries button
Sales organization
: FSLS
Description
: FSL HYD
Sales organization
Statistics currency
: INR
Save,
Ignore the warning message press enter
Give the name
: FSL HYD sales organization
country
: IN
Enter
To save in your request
Define distribution channel :
Path: SPRO --------- > Enterprise structure
--------- > Definition
--------- > Sales
& distribution --------- > Define, copy, delete, check distribution channel
Double click on define distribution channel
Select new entries button
Distribution channel
: FD
Name
: Direct sales
Save
Press enter to save in your request
Define shipping point:
Path: SPRO --------- > Enterprise structure --------- > Definition --------- > Logistic
execution --------- > Define, copy, delete, check shipping point
Double click define shipping point
Select new entries button
Shipping point
: FSSH
[email protected]
Page 99
Description
: FSL HYD shipping point
Save
Name
: FSL HYD shipping point
Country
: IN
Enter
Press enter once again to save in the request
Assign sales organization to company code:
Path: SPRO --------- > Enterprise structure --------- > Assignment --------- > Sales
& Distribution --------- > Assign sales organization to company code
Select position button
Sales organization
: FSLS
Enter
For FSLS assign company code FSLS
Save
Press enter to save in your request.
Assign distribution channel to sales organization :
Path: SPRO --------- > Enterprise structure --------- > Assignment --------- > Sales
& Distribution --------- > Assign distribution channel to sales organization
Select new entries button
Sales organization
: FSLS
Distribution channel
: FD
Save
Press enter to save in your request
Assign division to sales organization
Path: SPRO --------- > Enterprise structure --------- > Assignment
& Distribution --------- > Assign division to sales organization
Page 100
Path: SPRO --------- > Enterprise structure --------- > Assignment --------- > Sales
& Distribution
--------- > Assign sales organization
--------- > distribution
channel --------- > plant
Select new entries button
Sales organization
: FSLS
distribution channel
: FD
Plant
: FSLP
Save
Press enter to save in your request
Define rules by sales area:
Path: SPRO --------- > Enterprise structure --------- > Assignment --------- > Sales
& Distribution
--------- > Business area account assignment
--------- > Define
rules by sales area
Select position button
Sales organization
: FSLS
enter
For FSL select rule
: 001 (Business area determination from plant / division)
Save
Press enter to save in your request
Assign shipping point to plant:
Path: SPRO --------- > Enterprise structure
--------- > Assignment
logistic execution --------- > Assign shipping point to plant
--------- >
Page 101
Save
Press enter to save in your request
Define common distribution channels:
Path: SPRO --------- > Sales & Distribution
Define common distribution channels
Select position button
Give the sales organization
: FSLS
Enter
For FSLS Distribution channels for condition
Distribution channels customer master
Save
Press enter to save in your request
--------- >
: FD
: select FD
--------- >
Page 102
Path: SPRO --------- > Sales and distribution --------- > Basic functions --------- >
pricing
--------- > Pricing control
--------- >
Define pricing procedure
determination
Double click on define pricing procedure determination
Select new entries button
Sales organization
: FSLS
Distribution channel
: FD
Division
: FS
Document pricing procedure
: select A standard
Customer pricing procedure
: select 1 standard
Pricing procedure
: select RVAA01 standard
Condition type
: select PR00 price
Save
Press enter to save in your request
Define tax determination rules:
Path: SPRO --------- > Sales and distribution
--------- > Basic functions --------- >
Taxes --------- > Define tax determination rules
Select position button
Tax country
: IN for India
Enter
For tax country In for sequence 1 tax category UTXJ
Select tax country IN sequence 2
From the menu bar select Edit -- --------- > Delete
Save
Save in your request.
Setup partner determination:
Partner functions
SP Sold to Party
SH Ship to party
BP Bill to party
PY Payer
Customer No.
1
1
1
1
Customer No.
1 Not modifiable
2 Modifiable
2. Modifiable
2 Modifiable
Page 103
Page 104
FI consultant job:
Creation of GL master sales local own goods -FS00
Give the GL a/c no.
: 300005
Company code
: FSL
Select with template button
Give the GL a/c no.
: 300000 sales account
Company code
: FSL
Enter
Change short text
: Sales local own goods
GL a/c long text
: Sales local own goods
Select create /Bank /Interest tab
Field status group
: G029 revenue accounts
Save
Select edit cost element button
Valid from
: 01.04.2011
Enter
Cost element category : 11 Revenues
Save
Assignment of account for automatic postings:
Path: SPRO --------- > Sales and Distribution
--------- > Basic function --------- >
Account assignment/costing --------- > Revenue account determination
--------> Assign GL accounts (Transaction code is VKOA)
Note: This is Important Tr code
Page 105
:
:
:
:
:
:
:
:
Page 106
Page 107
Path: Logistics --------- > Sales & Distribution --------- > Master data --------- >
Conditions
--------- > Select using conditions type --------- > create (Transaction
code is VK11)
Condition type
: PR00 price
Select key combination button: Select material with release status radio button
Enter
Sales organization
: FSLS
Distribution channel
: FD
Material
: FSLFG
Amount
: 400
Valid from
: 01.04.2011
Valid to
: 31.12.9999
Save
Select back arrow
Condition type
: select UTXJ tax Jurisdiction code
Select key combination button
Select domestic taxes radio button
Enter
Country
: IN for India
Tax classification for customer : 1
Tax classification for material
: 1
Valid from
: 01.04.2011
Valid to
: 31.12.9999
Tax code
: A0 (0% output tax)
Save
Ignore the message press enter
Page 108
Flow
From MM Module
PP Module product costing SD module CO-PA
CO Module
FI Module
Define an operating concern
Operating concern can be equal to controlling area or above controlling area
Controlling area can be equal to company code or above company code
Company code =controlling area =operating concern
Value fields
-----|
|
|-
|
|
|
----
Page 109
SD condition types
PR00
Price
VPRS
Costs
(Product costs)
(up to COGM level)
from FI
Admin & SD Exp.
Page 110
Save
Select data structure tab
Select create button under data structure
Select characteristic BRSCH Industry
Select left arrow
Select value fields tab
Select value fields VV010 revenue
Select VV140 cost of goods sold
Select left arrow
Select save button
From the menu select data structure ----- > Activate
Select back arrow
Select yes button for the message to generate the operating concern environment.
Ignore the message press enter
Save
Assign controlling area to operating concern:
Path: SPRO --------- > Enterprise structure --------- > Assignment
-------- > Assign controlling area to operating concern.
Page 111
Operating concern
: FSL1
Select maintain groups button
Select generated groups check box
From the menu select interval ------- > Maintain
Select interval button
From no.
: 1
To no.
: 9999999999 (10 times)
Save
Ignore the message press enter
Maintain assignment of SD conditions to CO-PA value fields:
Path: SPRO --------- > Controlling --------- > Profitability analysis --------- > Flows of actual
values
--------- >
--------- > Transfer of billing documents
--------- > Assign value fields.
(TR code is KE4I)
Double click on maintain assignment of SD conditions to CO-PA value fields
Select new entries button
Condition type
: PR00
price
Value field
: VV010 (Revenues)
Condition type
: VPRS (cost)
Value field
: VV140 (Cost of goods/ Sold)
Save
Press enter to save in your request
Direct posting from FI/MM
If we post to account numbers 300000-399999 directly up date value field VV010 revenues
If we post to account numbers 400000-499999 directly up date value field VV140 cost of goods
sold
Path: SPRO --------- > Controlling --------- > Profitability analysis --------- > Flows of actual
values ------- > Direct posting from Fi/MM --------- > Maintain PA transfer structure for direct
postings (tr- code KEI2)
Select structure FI (Financial accounting CO - PA)
Double click assignment lines folder
[email protected]
Page 112
Page 113
--------
Order type
: select OR (Standard Order)
Sales organization
: FSLS
Distribution Channel : FD
Division
: FS
Enter
Sold to party
: 3000501
P.O.No.
: 1
P.O.Date
: To days date
Required delivery date: Todays date
Delivery plant
: FSLP
Item
: 10
Material
: FSLFG
Order quantity
: 10 kg
Enter
Ignore the message press enter
Select item
: 10
From the menu select Go to Item - --------- > Conditions
Select shipping tab
From the menu select Edit -------- > In complication log
We get a message document is complete, no errors
Select save button or Ctrl+S
Note the order no.11764
To open Material period for September(MMPV)
From co. code
: FSL
Period
: 6
Fiscal year
: 2011
Select check and close period radio button
Execute.
Production receipt :
There are two types of production receipt.
1. Production receipt without production order
MVT Type: 521
Page 114
Path: Logistics --------- > Materials Management --------- > Inventory management -------- > Goods movement
--------- > Goods --------- > receipt
--------- > other (Tr code is
MB1C)
Moment type
: 521 (Receipt w/o production order into unrest -use stock)
Plant
: FSLP
Storage location
: HYD
Enter
Give the material
: FSLFG
Quantity
: 2000
Save
Ignore the warning message press enter
Note: Check it GL A/c 200122 Inventory, select automatic posting check box
From the menu select other goods receipts --------- > Display
Enter
Select accounting documents button
Select accounting document no.
BSX
200122 Inventory FG 100000 FSLFG
FSL2
GBB ZOF
300200 INC/DEC in stocks FG 100000-FSLFG
FSL2
Qty produced * Standard Price
2000 Kgs*500 Rs
Delivery with reference to sales oreder:
Path: Logistics --------- > Sales & Distribution --------- > Sales --------- > Order
Sub request functions --------- > Outbound delivery (Tr code is VL01N)
--------- >
Shipping post
: FSSH
Give the order no.
: 11764
Enter
Actual goods issue date
: Todays date
Select item 10
Select picking tab
Picked quantity
: 10
Select post goods issue button
From the menu select outbound delivery - --------- > display
Enter
From the menu select Environment --- --------- > Document flow
keep the cursor on goods issue delivery document no. (Down side in document column)
Select display document button
Select accounting documents button
[email protected]
Page 115
BSX
FSL2
GBB VAY
300200 INC/DEC in stocks FG 5000 FSLFG FSL2
Qty delivered *Standard price
10kgs * 500
Sales billing
Path: Logistics --------- > Sales & Distribution --------- > Sales --------- > Order
Sub request functions --------- > Billing document (Tr code is VF01)
--------- >
REPORT PAINTER
Report to view customer wise/product wise /Sales organization wise /plant wise profitability
Create form:
Path: SPRO --------- > Controlling
--------- > Profitability analysis
--------- > Information
system --------- > report components --------- > Define forms --------- > Define forms for
profitability reports-(The Tr code is KE34)
Double click on create Form
Operation concern f
: FSL 1
Enter
From
: FSL Form des: FSL Form
Select two axes (matrix) radio button
Select create button
Select operating concern currency radio button
Enter
Double click on row 1
[email protected]
Page 116
Page 117
Page 118
CUSTOMIZATION
Activate new general ledger accounting:
Path: SPRO --------- > Financial accounting
--------- > Financial accounting global settings
--------- > Activate new general ledger accounting
Select new general ledger active check box
Save
(This is one time job work at client place)
Define ledgers for general ledger accounting
Page 119
Page 120
Ledger group
: F3
Description
: Ledger group F3 for FSL
Save
Save request
Double click on ledger assignment folder
Select new entries button
Select Ledger
: OL
Deselect representative ledger check box
Ledger
: F1
Deselect representative ledger check box
Save
Define document types for entry view in a ledger
Path: SPRO --------- > Financial accounting (new) --------- > Financial accounting global
settings (new)
--------- > Document
--------- > Document types
--------- > Define
document types for entry view in a ledger.
Give the ledger
: F1
Enter
Select new entries button
Type
Number range
SA
70 (give it any number range)
KR
70
DR
70
AA
70
WE
70
WA
70
WL
70
RE
70
RV
70
Save
Press enter to save in your request
Select back arrow
Give the ledger
: F2
Enter
Select new entries button
Type
SA
KR
DR
AA
Number range
71 (give it any number range)
71
71
71
Page 121
WE
WA
WL
RE
RV
71
71
71
71
71
Save
Define document types for general ledger view
Path: SPRO --------- > Financial accounting (new) --------- > Financial accounting global
settings (new)
--------- > Document
--------- > Document types
--------- > Define
document types for general ledger view
Give the ledger
: F1
Enter
Select new entries button
Type
Number range
SA
72 (give it any number range)
KR
72
DR
72
AA
72
WE
72
WA
72
WL
72
RE
72
RV
72
Save
Press enter to save in your request
Select back arrow
Ledger
: F2
Enter
Select new entries button
Type
SA
KR
DR
AA
WE
WA
WL
Number range
73 (give it any number range)
73
73
73
73
73
73
Page 122
RE
RV
73
73
Save
Define document number ranges for entry view:
Path: SPRO --------- > Financial accounting (new) --------- > Financial accounting global
settings (new)
--------- > Document
--------- > Document number rages
--------- >
Documents in entry view --------- > Define document number ranges for entry view
Give the company code
: FSL
Select change intervals button
Select interval button
No.range
: 70
Year
: 2011
From no.
: 800001
To no.
: 900000
Enter
Select interval button
No.range
: 71
Year
: 2011
From no.
: 900001
To no.
: 1000000
Enter and save
Ignore the warning message press enter
Define document no.range for general ledger view:
Path: SPRO --------- > Financial accounting (new) --------- > Financial accounting global
settings (new) --------- > Document --------- > Document no.rages --------- > Documents in
general ledger view --------- > Define document no.range for general ledger view
Give the company code
: FSL
Select change intervals button
Select interval button
No.range
: 72
Year
: 2011
Form number
: 1000001
To number
: 1100000
Enter
Select interval button
No.range
: 73
Year
: 2011
[email protected]
Page 123
From number
: 1100001
To number
: 1200000
Enter & save
Ignore the warning message press enter
--------- >
Page 124
Enter
Amount
: *
Business area
: FSLH
Text
: +
Document --------- > Simulate & Save
--------- >
Account number
: 100000
Company code
: FSL
Fiscal year
: 2011
Ledger
: 0L
Execute
Double click on cumulative balance 125000
Double click on document no
Select document no.check box
Select display document button
Select call up document overview button
Select back arrow 3 times
Select choose ledger button
Change the ledger
: F1
Enter
Execute
Select back arrow
Select choose ledger button
Change the ledger
: F2
Enter
Execute
Segments Creation
In profit centre accounting
1st Scenario
HYD Location
I
I
Steel
Cement
Pharma
business
1st scenario
HYD Location
I
I
Steel
Cement
Segment
and
Pharma
Profit
Page 125
Division
Division
Division
area and
Profit
center
2nd Scenario
HYD
BGL
LOC
LOC
I
I
Steel Cement
Division Division
Division
Division
Division
center
2nd scenario
MUM
LOC
I
Pharma
Division
Business
area
or
Profit
Center
HYD
BGL
LOC
LOC
I
I
Steel Cement
Division Division
MUM
LOC
I
Pharma
Division
Segment
or
Profit
Centre
The disadvantage in business area is it will not pick up business area for automatically
generated line items
Eg: central excise and sales tax business area
Trail balance will not match we have to run business area clearing
Instead of business area go for segments
In profit center segment will be assigned once we update profit centre automatically segment
will be updated
SAP Note: no future developments for business area
Define segment:
Path: SPRO --------- > Enterprise structure
accounting --------- > Define segment
: FSL
: select Steel
: select HYD
Page 126
Enter
Select activate button (Shift +F1)
One more profit centre
Profit center
Enter
Segment
Select activate button
: Cement
: select HYD
DOCUMENT SPLITTING
In document splitting, the line items are split according to selected dimensions Eg: Profit Center wise, Segment wise
We can prepare Balance sheet and profit and loss account for the selected dimensions.
Eg: Sales of steel and cement to one customer
Sales
Customre X Account Dr
To Sales Steel
To Sales cement
200000
150000 Steel profit center
50000 Cement profit center
HYD segment
HYD segment
200000
150000 Steel profit center
50000 Cement profit center
HYD segment
HYD segment
A) Sales -Steel
B) Sales -Cement
C) Zero balance clearing a/c
Sales
HYD segment
HYD segment
HYD segment
HYD segment
Sales
Current liabilities & provisions
FS00
GL Account no.
: 300010
Page 127
Company code
: FSL
Select with template button
Give the Gl A/c No. : 300005 Sales local own goods
Company code
: FSL
Enter
Change short text
: sales Steel
GL account long text
: sales Steel
Select Create/Bank/Interest tab
Field status group
: G029 (revenue)
Save
Select edit cost element button
Valid from
: 01.04.2011
Enter
Cost element category
: 11 Revenues
Save
Give the GL A/c No.
Company code
Select with template button
Give the GL A/c
Company code
Enter
Change short text
GL account long text
Save
: 300011
: FSL
: 300010
: FSL
: sales Cement
: sales Cement
Page 128
Category
01000
30000
20000
Description
Balance sheet account
Revenue
Expense
Page 129
Page 130
Page 131
ENDUSER AREA
Creation of capital work in progress asset master (AS01):
Give the asset class FSL4000 capital work in progress general
Company code
: FSL
Enter
Description
: CWIP -General
Capitalized on
: 01.09.2011
Select time dependent tab
Business area
: FSLH
Select depreciation areas tab
Depreciation key
: 0000 (no depreciation)
Select no depreciation and no entries
Save
Note down the asset no.500001-0
Machinery purchase posting (F-90)
Give the doc .Date & Posting date : 01.09.2011
Type
: KR
Company code
: FSL
Posting key
: 31
Vendor account
: 3900501
Give the amount
: 400000
Business area
: FSLH
Text
: Machinery purchase posting
Posting key
: 70
Account no.
: 500001-0
Transaction type
: 100 External acquisition
Enter
Amount
:*
Text
:+
Document --------- > Simulate & Save
Freight payment (F-02)
Give the Doc date
Posting date
Type
Company code
Posting key
Account
[email protected]
: 5-9-2011
: 5.09.2011
: SA
: FSL
: 70
: 500001-0
Page 132
Transaction type
: 100
Enter
Give the amount
: 25000
Text
: Freight payment
Posting key
: 50
Account no.
: 200105 SBI current a/c
Enter
Amount
:*
Business area
: FSLH
Text
:+
Document --------- > Simulate & Save
Creation of machinery master (AS01):
Give the asset class
: FSL 2000 Dept A
Company code
: FSL
Enter
Description
: Machine no.5
Capitalized on
: To days date
Select time dependent tab
Business area
: FSLH
Select depreciation area tab
Depreciation key
: FSL1 5%SLM
Useful life
: 15 years
Period
: 6 months
Ordinary depreciation start date : Todays date
Save
Note: the asset no.200002-0
Settlement of CWIP to machine no.5
Path: Accounting --------- > Financial accounting --------- > Fixed assets --------- > Posting
--------- > Capitalized asset under construction --------- > distribute (Tr code is A1AB)
Company code
: FSL
Asset
: 500001
Sub number
:0
Execute
From the menu select Edit --------- > select --------- > select all (F5)
Select enter button
Category
: select FXA asset
Settlement receiver
: 200002-0
Give the percentage
: 100
Select back arrow
[email protected]
Page 133
Save
Select settlement button (Shift +F8)
Give the asset value date
: 07.09.2011 (Todays date)
Text
: CWIP settlement
Deselect text run check box
Execute
Select simulate button
Go and see the document (FB03)
Enter
Note : In live environment you take a purchase of machinery dont enter directly Asset account,
first enter in Capital Work in Progress after commissioning added all charged convert to asset
accounting.
PRODUCT COSTING
This is used for valuation of inventories i.e. finished goods and Work in progress
PP Module
MM Module
FI Module
CO Module
|
|
|
Product costing
Product costing
I
Cost element with
Quantity structure
(PP Module is implemented)
Product cost
By order
[email protected]
Product cost
By period
Page 134
Production budget
xx
xx
xx
xx
xx
xx
---xx
Page 135
Raw material standard cost =(Quantity in BOM - PP Module) * (Price from material master MM module)
(1kg * 75.27) + (1kg * 100)= 175.27
Raw material overheads
Freight charges - where the cost is high when we receive the material it will be added to
material - when we consume automatically proportionate cost is charged.
Expenses like loading and unloading charges where the cost is normal charge to P&L account
and It will be added to material.
Clients will tell us take 5% raw material cost as RM over heads
RM over heads cost =175.25 x 5%=8.76
Production costs:
In co module we have cost centers - in PP module we have work centers - in cost centers we
have planned the costs.
PP work centers
Dept A
Dept B
Dept C
Dept D
Work centers
Dept A
Dept B
Issue RM 1
routing
Issue RM 2
(process flow)
In co cost centers Dept A Dept B Dept C Dept D
Dept D
FSLFG1
Salaries
Wages
Power
400000
200000
120000
------Planned cost
720000
=====
Machineries
100
Working for 3 shifts for 30 days
Machines hours
100 machines * 30 days * 3 shifts (24 Hours )
(activity type)
72000 Hrs.
Machine hour rate 720000/72000=10 Rs
To Produce FSLFG1
5Hrs.
Hours required
Production cost : (Hours required in Dept A * Machine hour rate)+(Hours required in Dept B*
Machine hour rate )+ (Hours required in Dept D * Machine hour rate)
5Hrs * 10 Rs=50 Rs
Eg: allocation of over heads.
[email protected]
Page 136
FSLFG1
FSLFG2
Production Qty
71999Kgs
1 Kg
---------72000
Hrs Req
1
71999
--------72000
Cost
---------720000
720000*71999/72000=71999
720000*1/72000=
10
-------720000
=====
If we allocate cost based on hours
FSLFG1
FSLFG 2
720000*1/72000
=
10
720000*71999/72000=71999
----------720000
========
Active based costing.
Stock expected
cost
Raw material over heads
175527
8.76
Co -Consultants job:
Standard cost (preliminary costing)
1. Creation of 2 secondary cost elements (Use Tr.code is KA06)
A) RM overhead rate
B) Activity allocation
Controlling area
Enter
Give the cost element
Valid from
Enter
Give the name
Description
Cost element category
Save
Cost element
[email protected]
: FSL
: 1100000
: 01.04.2011 to 31.12.9999
: RM Overhead rate
: RM Overhead rate
: Select 41 overhead rates
: 1100001
Page 137
Enter
Name and
Description
Cost element category
Save
: Activity allocation
: Activity allocation
: select 43 Interval activity allocation
: Dept G
: Dept A
: FSL
Cost center
Reference cost center
Controlling area
Enter
Name
Description
Cost center category
Save
: Dept H
: Dept A
: FSL
: Dept G
: Dept G
: Dept H
: Dept H
: select 9(Allocation cost center)
: FSLPRODN
Page 138
Enter
Description
Select insert cost center button
Select cost center Dept G
Save
Page 139
Select Base F1
Double click on details folder
Controlling area
: FSL
Enter
Select new entries button
From cost element : 400000
To cost element
: 400099 RM consumption
Save
Select back arrow
Select base F2 Production cost
Double click on details folder
Controlling area
: FSL
Enter
Select new entries button
From cost element : 400100
To cost element
: 400199 Personnel & Manufacturing group
From cost element
To cost element
: 400200
: 400299 manufacturing cost
: 400500
: 400599 Depreciation a/c
Page 140
Valid from
To
Controlling area
Percentage
01.04.2011 31.03.2011
FSL
Select 2
FSL1
01.04.2011 31.03.2011
FSL
FSL1
10
Dr
500000
500000
Page 141
4000 Dept H
4000
3. FSLRM 2 Receipt
Inventory RM local DR
To GR/IR clearing RM local
800000
800000
6000
6000
40000 Order 1
30000 Order 1
40000
30000
10000 Order 2
20000 Order 2
10000
20000
100000
10000
10% actual overhead rate
7000
3000
FSLRM1
FSLRM2
RM over head rate 10%
(Actual 10%)
40000
30000
10000
20000
70000
7000
30000
3000
Page 142
Indirectly we are allocating loading and unloading charges to production orders based on
Raw material consumption values.
Base
10
20
30
40
Save
F1
Overhead
F3
F2
Description
Raw materials
FSLRM over head rate
Product cost
Cost of goods Mfg
From To Row
Credit
10
10
F4
10
30
Page 144
: 400100
: 400299
: select 50 production machine
One more
Cost component structure
Chat of Accounts
From cost center
To cost center
Cost component
: 01
: FSL
: 400500
: 400599
: 50
One more
Cost component structure
: 01
Chat of Accounts
: FSL
From cost element
: 1100001
Cost component
: 50
Save
Double click on cost component structure folder
For cost component structure 01 select active check box
Save
Note: The above procedure is to be followed to 02 also
PP CONSULTANT JOB:
Define MRP controller:
Path: SPRO --------- > Production
--------- > material requirements Planning
Master data --------- > Define MRP controllers
--------- >
12.09.2011
13.09.2011
14.09.2011
24.09.2011
2 days
2 days
2 days
2 days
Page 145
: FSLP
: FSL
: 2 days
: 2 days
: 2 days
: 2 days
--------- >
:0
: 6 (September)
: 6 (September)
: 2011
Page 146
--------- >
Version
:0
From period
:6
To period
:6
Fiscal year
: 2011
Cost center
: Dept G
Activity type
: FSL
Select form based radio button
Select overview screen button
Plant activity
: 72000
Save
--------- >
: FSLRM2
Page 147
Industry sector
: Mechanical Engineering
Material type
: Raw material
Press select view button
Select basic data1, Select purchasing Select general plant data /storage1/Accounting1,Costing1
Select organization levels button
Plant
: FSLP
Storage location
: Hyderabad
Enter
Give the description : Raw material 2
Base unit of measurement : KG
Division
: FS
Material group
: FSLC
Select purchasing tab
Purchasing group
: FSL
Select accounting 1 tab
Valuation class
: FSL1
Price control
: select V moving
Moving price
: 100
Select costing 1 tab
Select material origin check box
Save
One more material : FSLFG1
Industry section
: Mechanical engineering
Material type
: Finished product
Press select view button
Select basic data1, MRP1, MRP2,MRP3, Work scheduling, general plant data /storage1,
accounting , Costing 1
Enter
Plant
: FSLP
Storage location
: Hyderabad
Enter
Description
: Finished product 1
Base unit measurement : KG
Division
: FS
Select MRP1 tab
MRP type
: select PD (MRP)
MRP controller
:A
Lot size
: select EX lot for - lot order quantity
Select MRP 2 tab
In -house production : 0 days
[email protected]
Page 148
----
Plant
: FSLP
Work center
: Dept G
Work center category
: select 0001 Machine
Select basic data button
Give the description
: Dept G
Person responsible
: Mr.C
Usage
: 009
Under standard value maintenance
[email protected]
Page 149
Create routings
Path: Logistics --------- > Production --------- > Master data --------- > Routings
> Routings --------- > Standard routings --------- > Create (Tr code is CA01)
Give the material
Plant
Enter
Usage
Status
Select operation button
For operation tab work center
Control key
Double click on operation 10
Machine standard value
Unit
Save
---------
: FSLFG1
: FSLP
: select 1 production
: select 4 (released (general))
: Dept G
: select PP01 in hour production
:5
: H (Hour)
: FSLFG1
: FSLP
: select PPC1 (standard cost estimate for material )
: Todays date
: 30.09.2011(month end)
Page 150
Page 151
Path: SPRO --------- > Controlling --- --------- > General controlling -- --------- > Organization ------ --------- > Maintain version
Select version 0
Double click on settings for each fiscal year
Controlling area
: FSL
Enter
Select year 2011
Select details button
Exchange rate type
:M
Select price calculation tab
Plan method
: Periodic price
Actual methods
: Periodic Price
Revaluation
: Original business transactions
Cost component structure : 01 product costing
Save
Ignore the warning message press enter
Save in your request
Assign costing sheet to plan order and actual order:
Path: SPRO --------- > Controlling
--------- > Product cost controlling --------- > Cost object
controlling
--------- > product cost by order
--------- > Manufacturing orders
--------- >
Check costing variants for manufacturing orders (PP) (Tr.code is 0PL1)
Select costing variant PPP1 Production order plan
Select details button
Select valuation variant button
Select create button beside valuation variant /plant
Select new entries button
In plant
: FSLP
Save
Press enter to save in your request
Select back arrow
Select valuation variant
: 006 with plant FSLP
Select details button
Select overhead tab
Give the costing sheet
: FSL costing sheet
Save
Select back arrow
Select costing variant PPP2 production Order Actual
Select details button
Select valuation variant button
Select create button beside valuation variant/plant
Select new entries button
[email protected]
Page 152
In plant
: FSLP
Save
Press enter to save in your request
Select back arrow
Select valuation variant 007 with plant : FSLP
Select details button
Select overhead tab
Costing sheet
: select FSL costing sheet
Save
Define goods received valuation for order delivery:
Path: SPRO --------- > Controlling
--------- > Product cost controlling --------- > Cost object
controlling
--------- > product cost by order
--------- > Manufacturing orders
--------- >
Define goods received valuation for order delivery
Select new entries button
Valuation area
: FSLP
Valuation variant
: 007 production order -Actual
Save
Press enter to save in your request
Work in process customization
Dept A Dept B Dept D
Issue RM1
Issue RM2
issue Rm incurred
Over heads
we get FGFSLFG1
production not received during the month
RM consumption
Expenditure
P&L a/c
Debit
Debit
No Profit / No Loss
Creation of GL Masters (FS00):
GL account
: 200123
Page 153
: 1200000
: 01.04.2011
: Order /Project result analysis
: select 31 (order /project results analysis)
: 1200001
: 1200000
: FSL
: 1200002
: 1200000
: FSL
: 1200003
: 1200000
: FSL
: 1200004
: 1200000
: FSL
: 1200005
: 1200000
: FSL
Page 154
Save
Cost element
Reference cost element
Controlling area
Enter
Save
: 1200006
: 1200000
: FSL
: FERT
: WIP calculation for production orders
Page 155
assign 00003+++++
assign 00004000++
assign 0001100000
Personnel
400100 - 400199
assign 00004001++
Manufacturing
400200 - 400299
assign 00004002++
Depreciation
400500 - 400599
assign 00004005++
Activity allocation
1100001
assign 0001100001
For ABR i.e. Settled cost 1000001
assign 0001000001
Select line ID EL i.e. Revenues for Co.area 1000
Select copy as button
Change the Co.area to FSL
Change masked cost element to 00003+++++ (5 times plus)
Enter & Save
The same procedure is to be followed by copying all IDs
Define update; (Tr.code is OKGA)
Path: SPRO --------- > Controlling
--------- > Product cost controlling
--------- > Cost object
controlling --------- > Product cost by order --------- > Period end closing --------- > Work
in process --------- > Define update
Select new entries button
Controlling area
: FSL
[email protected]
Page 156
Version
:0
Result analysis key : FERT
Line ID
: select EL revenues
Category
: select N (costs not to be included)
Controlling area
: FSL
Version
:0
Result analysis key : FERT
Line ID
: Select EK (Direct cost)
Category
: select K cost
WIP
: 1200001
Revenues
: 1200002
Controlling area
: FSL
Version
:0
Revenues analysis key : FERT
Line ID
: GK over head
Category
: select K cost
WIP creation
: 1200003
Reserves creation
: 1200004
Select page down button
One more controlling area : FSL
Version
:0
Result analysis key : FERT
Line ID
: FK
Category
: select A (Settled cost )
WIP creation
: 1200005
Reserves creation
: 1200006
Controlling area
: FSL
Version
:0
RA Key
: FERT
LID
: ABR
Category
: A settled cost
Save
Press enter to save in your request
Define posting result for setting work in process:
Path: SPRO --------- > Controlling
--------- > Product cost controlling
--------- > Cost object
controlling --------- > Product cost by order --------- > Period end closing --------- > Work
in process --------- > Define posting results for setting work in process (OKG8)
Select new entries button
Controlling area
: FSL
Company code
: FSL
Result analysis version
: select 0
Result analysis category
: WIPR (Work in Process with requirement to Capitalized)
[email protected]
Page 157
P & L A/c
: 300201
Balance sheet
: 200123
Save
Press enter to save in your request
Define results analysis version (OKG9)
Path: SPRO --------- > Controlling
--------- > Product cost controlling
--------- > Cost object
controlling --------- > Product cost by order --------- > Period end closing --------- > Work
in process --------- > Define results analysis version
Select controlling area FSL
select details button
Select transfer to Financial accounting check box
Save
Ignore the warning message press enter
Press enter to save in your request
Variance calculation
Define variance keys:
Path: SPRO --------- > Controlling
--------- > Product cost controlling
--------- > Cost object
controlling
--------- > Product cost by order
--------- > Period end closing
--------- >
Variance calculation --------- > Define variance keys (OKV1)
Select variance key 00001 Production order
Select copy as button
Change the variance key to FSL1
Change the name also variance key for FSL
Enter & Save
Define default variance keys for plants (OKVW)
Path: SPRO --------- > Controlling
--------- > Product cost controlling
--------- > Cost object
controlling
--------- > Product cost by order
--------- > Period end closing
--------- >
Variance calculation --------- > Define default variance keys for plants
Select position button
Give the plant
: FSLP
Enter
Assign variance key : FSL1
Save
Press enter to save in your request
Define target cost version: (OKV6)
[email protected]
Page 158
Notes:
Budgeted cost =Budgeted production Qty
Standard price
standard price
actual price
Path: SPRO-Controlling --------- > Product cost controlling --------- > Cost object controlling
--------- > Product cost by order --------- > Period end closing --------- > Variance calculation
--------- > Define target cost version
Select controlling area 1000 with target cost version 0
Select copy as button
Change the controlling area to FSL
Change the description to target cost version for FSL
Enter & Save
Press enter to save in your request
Assign variance key in Material master:
Path: Logistics
--------- > Material management --------- > Material master
Material --------- > Change --------- > Immediately (MM02)
Give the material no
Press select views button
Select costing 1 view
Enter
Give the plant
Enter
Variance key
Save
--------- >
: FSLFG1
: FSLP
: select FSL1
Settlement customization:
Creation of cost element group (KAH1)
Give the cost element group : FSLPRODN
Enter
Description
: Production cost element for FSL
Select Edit-Cost element -Select insert cost element button
From C.E
To C.E
400000
400099
[email protected]
Page 159
400100
400500
1100000
Save
400199
400599
1100001
Page 160
Page 161
: 400201
Page 162
Company code
: FSL
Select with template button
Give the GL A/c No : 400100
Company code
: FSL
Enter
Account group
: Manufacturing cost
Select type /Description tab
Change short text and GL account long text to production order differences
Select create /bank /interest tab
Field status group change to G014 MM adjustment account
Save
Give the GL account no
: 300200 INC/DEC stock in FG
Company code
: FSL
Select edit cost element button
Cost element category
: select 22 external settlement
Save
Assignment of account for automatic postings (OBYC)
Double click on transaction PRD Cost (Price) differences
Give the Chart of Accounts : FSL
Enter
Select valuation class check box
Select valuation modifier check box
Save
Press enter to save in your request
Valuation modifier : X
Valuation class
: FSL2
Account no.
: 400201
Save
Press enter to save in your request
Select back arrow
Double click on transaction GBB offsetting entry for Inventory posting
Valuation modifier : X
General modification : AUA production
Valuation class
: FSL2
Account
: 300200
Valuation modifier : X
General modification : BSA
Account no.
: 100599
Save
Press enter to save in your request
[email protected]
Page 163
PP CONSULTANTS AREA
To check order type
Path: SPRO --------- > Production --------- > Shop floor control --------- > Master data
--- > Order --------- > Define order type
Select order type PP01 standard production order
Select details button
Settlement profile
: PP01
Save
Ignore the warning message press enter
Define order type dependent parameters:
Path: SPRO --------- > Production --------- > Shop floor control --------- > Master data
--- > Order --------- > Define order type dependent parameters (Tr code is OPL8)
------
------
Page 164
------
---------
-------
: 561
: FSLP
: HYD
Page 165
Enter
Give the material no.
: FSLRM2
Quantity
: 1000 kgs
Select save button or Ctrl+S
From the menu select other goods receipts - --------- > display
Enter
Select accounting documents button
Inventory RM LCL 100000 FSLRM2
FSL1 BSX
Stock taking
100000 FSLRM2
FSL1 GBB BSA
Qty * material
1000*100 rs
Raw material issue to production order: (Tr code is MB1A)
Select to order button
Order
: 60003245
Enter
FSL RM1
Qty
: 15
FSL RM2
Qty
: 15
Save
From the menu select goods issue - --------- > display
Select accounting documents button
Double click on accounting document no.
200121
Inventory RM local
400000
200121
400000
1129.03 FSLRM1
BSX
FSL1
GBB
FSL1
BSX
FSL1
GBB
FSL1
VBR
VBR
Page 166
--------- > Controlling --------- > Product cost controlling --------- > Cost
--------- > Product cost by order --------- > Information system ---------
Page 167
: FSLP
: FSLFG1
: 01
2011
:6
2011
: 60003245
: 10 kg
: select final confirmation
: 10 kg
: 60 Qty
: H (Hour)
Production receipt
Path: Logistics
--------- > Production
--------- > shop floor control
movement --------- > Goods receipt (Tr code is MB31)
Page 168
200122
Inventory FG
2337.50
FSLFG1
FSL2
300200
FSLFG1
GBB
FSL2
AUF
Fi enduser area
Salaries posting(F-02):
Document date
: 30-9-2011
Posting date
: 30-9-2011
Type
: SA
Company code
: FSL
Account
: 400100
Enter
Amount
: 9000
Cost center
: Dept G
Text
: Salaries posting
PSTKY
: 50
Account
: 200105
Enter
Amount
:*
Business area
: FSLH
Text
:+
Document --------- > Simulate and Save.
Acutual activity price calculation: (co end user area)
Path: Accounting --------- > Controlling --------- > Cost Center accounting --------- > Period end
closing -------- > Single functions --------- > Price calculations (KSII)
Cost center group
: FSLPRODN
Execute
Save
Ignore the warning message press enter
Revaluation at actual price: (co end user area)
Path: SPRO ------- > Controlling --------- > Product cost controlling --------- > Cost object
controlling --------- > Product cost by order ---------- > Period --------- > End closing --------- >
single functions ----------- > Revaluation at actual prices --------- > Individual processing (MFN1)
Order
: 60003245
Period
:6
[email protected]
Page 169
Year
: 2011
Deselect test run check box
Execute
Select next list level button
To make order technically complete: (PP end user area) (TECO)
Tr code C002
Order
: 60003245
Enter
From the menu bar select Functions ---------- > Restrict processing ---------- > Technically
complete
Save
Calculation of variances
Path: Accounting
--------- > Controlling --------- > Product cost controlling
--------- > Cost
object controlling --------- > Product cost by order --------- > period ending closing --------> single functions --------- > Variances --------- > Individual processing (Tr code is KKS2)
Give the order no
: 60003245
Period
:6
Fiscal year
: 2011
Deselect test run check box
Select execute button
Double click on variance amount
Open one more session with (CO03)
Give the order no
: 60003245
Enter
From the menu select go to - --------- > cost --------- > analysis
Press select layout button
Select layout 1 SAP02 cost trend
Settlement of variance to accounts: (co end user area)
In SEP we have taken WIP
In SEP also we have taken production
i) Calculation work in process once again KKAX work in process will be zero
ii) Settlement of work in process to accounts KO88
a) Work in process entry will be reversed
b) Variance will be settled to accounts
Page 170
400201
300201
200123
GBB
FSL2
PRD
FSL2
AUA
Page 171