CONTROLLING BASICS AND COST CENTER ACCOUNTING VIL (2)
CONTROLLING BASICS AND COST CENTER ACCOUNTING VIL (2)
CONTROLLING BASICS AND COST CENTER ACCOUNTING VIL (2)
AREAS TO BE COVERED:-
4) INTERNAL ORDERS
THIS IS USED TO VIEW COST FOR SPECIFIC TASKS.
Eg:- VEHICLEWISE RUNNING EXPENSES/TELEPHONEWISE EXPENSES/
PRODUCTION ORDER COSTS/EXHIBITION COST.
ORDERS ARE OF 2 TYPES:-
A) REAL ORDERS
B) STATISTICAL ORDERS
1
UPTO4.7EE(OLD) VERSION TO VIEW DIVISIONWISE PROFITABILITY
COMPANIES USED CLASSIC PROFIT CENTER ACCOUNTING.
6) PRODUCT COSTING
2
10) SALES AND DISTRIBUTION (SD) MODULE TO FINANCIALS (FI) MODULE
AND CONTROLLING (CO)MODULE INTEGRATION.
3
BASIC SETTINGS FOR CONTROLLING
1.MAINTAIN CONTROLLING AREA
CO FI
CO-Area Co Cd
Scenario:1 (1:1 relationship)
Company Code = Controlling Area
(Company code and Controlling area are in same levels or
One Company code under a Controlling area)
Scenario 2: (1:n relationship)
Company Code under the Co area(more than one Co Cd under a Co-area)
This is also called cross company code cost accounting.
CO-area Company Code
CoCd 1
Co Area1
CoCd 2
CoCd 3
Co Area2
CoCd4
4
Eg.,:-
FI ORGANIZATION OR CO-ORGANIZATION STRUCTURE OR
ENTERPRISE STRUCTURE ENTERPRISE STRUCTURE
COMPANY CODE
SEGMENTS
1ST SCENARIO
COMPANY
SEGMENTS
PROFIT CENTER
COST CENTERS
2ND SCENARIO
5
COMPANY = CONTROLLING AREA
COMPANY CODE
SEGMENTS
PROFIT CENTER
COST CENTERS
6
COMPANY CODE CONTROLLING AREA
VIL VIL
VIL VIL
HIL HIL
7
1 FI DOCUMENT 1 CO DOCUMENT ( COIN )
DOCUMENT TYPE SA COIN
| |
NUMBER RANGE 01 01
| |
NUMBER RANGE INTERVAL 1-100000 1-100000
MANUAL POSTING IN FB01L AUTOMATIC POSTING
II. REPOST CO LINE ITEMS (BUSINESS TRANSACTION –RKU3)
COMMON
DEPTN 300000
DEPTO 100000
TO BANK 800000
1 FI DOCUMENT NO FI DOCUMENT
1 CO DOCUMENT(COIN) 1 CO DOCUMENT [ RKU3]
1 FI DOCUMENT
2 CO DOCUMENTS
8
FI PERSON IN FB01L :-
COMMON
DEPTN 75000
DEPTO 25000
TO BANK 300000
1 FI DOCUMENT NO FI DOCUMENT
1 CO DOCUMENT ( COIN ) 1 CO DOCUMENT ( RKU3 )
III . REPOST COSTS ( BUSINESS TRANSACTION – RKU1)
THIS IS USED WHEN WE SPLIT THE COST CENTER INTO NUMBER OF COST
CENTERS OR WRONG COST CENTER POSTINGS.
9
WAGES
--> SAVE
10
--> SELECT ELEMENT / GROUP BUTTON
--> ENTER
--> ENTER
--> ENTER
--> ENTER
--> SAVE
3. MAINTAIN VERSIONS
11
Eg : -1
WE HAVE PLANNED FOR THE WHOLE YEAR VERSION - 0 - ORIGINAL BUDGET
Eg: - 2
12
2 TYPES OF COST ELEMENTS
A. PRIMARY COST ELEMENT
WAGES 200000
POWER 100000
SALARIES 50000
TOTAL = 350000
IN THE MONTH END ALLOCATE DEPTO COST TO DEPTM AND DEPTN BY USING
SECONDARY COST ELEMENT .
13
SECONDRY COST ELEMENTS REPRESENT THE CONSUMPTION OF PRODUCTION
FACTORS PROVIDED INTERNALLY BY THE ENTERPRISE ITSELF AND ARE
PRESENT ONLY IN CO .
THEY ARE ACTUALLY LIKE COST CARRIERS TO TRANSFER THE COST FROM
ONE COST OBJECT TO OTHER COST OBJECTS.
14
22. EXTERNAL SETTLEMENT - THIS IS USED FOR SETTLEMENT OF COST FROM
INTERNAL ORDER TO G/L ACCOUNTS OR ASSETS ( CO – FI)
FUNCTIONAL REQUIREMENTS
ALLOCATION REQUIREMENTS
PHYSICAL LOCATION
RESPONSIBILITY FOR COSTS
15
WHAT IS COST CENTER CATEGORY
1. ASSESSMENT
2.DISTRIBUTION
3.PERIODIC REPOSTING AND
4.INDIRECT ACTIVITY ALLOCATION
Eg : - FI POSTING [ FB01L ]
400100 SALARIES A/C DR 200000 COST CENTER : DEPTM
400100 SALARIES A/C DR 400000 COST CENTER : DEPTN
400300 RENT ACCOUNT DR 100000 COST CENTER : DEPTM
TO 200105 BANK 700000
FI ( RECORDS ) : -
16
400300 RENT A/C
AMOUNT 100000 DR
CO ( RECORDS ) :-
A . AT FI AREA
B . AT CO AREA
C . AUTOMATIC CREATION OF PRIMARY COST ELEMENTS AT THE TIME OF CO
IMPLEMENTATION
D . AUTOMATIC CREATION OF PRIMARY COST ELEMENTS AFTER CO
IMPLEMENTATION
8 .TO ENTER EXCHANGE RATE FOR TYPE " M " FOR INR TO EURO
9. POSTING OF TRANSACTION IN FI
17
1 A)CREATION OF PRIMARY COST ELEMENTS AT FI AREA (T/C FS00 )
18
--> COST ELEMENT CATEGORY : 1 (PRIMARY COSTS /COST REDUCING
REVENUES)
--> SAVE
1C) AUTOMATIC CREATION OF PRIMARY COST ELEMENTS AT THE TIME OF
CO IMPLEMENTATION
VIL HAS GONE FOR SAP FI IN 2010 - THEY HAVE CREATED AROUND 1000
EXPENDITURE ACCOUNTS . IN THE YEAR 2023 THEY WANT TO GO FOR CO -
NOW ALL EXPENDITURE ACCOUNTS ARE TO BE CREATED AS PRIMARY COST
ELEMENTS TO UPDATE CO RECORDS. SAP HAS GIVEN THE FACILITY TO
CREATE ALL COST ELEMENTS BY WAY OF BATCH INPUT SESSION .
PATH : SPRO --> CONTROLLING --> COST ELEMENT ACCOUNTING --> MASTER
DATA --> COST ELEMENTS --> AUTOMATIC CREATION OF PRIMARY AND
SECONDARY COST ELEMENTS--> MAKE DEFAULT SETTINGS [ OKB2 ] -->
CHART OF ACCOUNTS : VIL AND ENTER
19
1(D). AUTOMATIC CREATION OF PRIMARY COST ELEMENTS AFTER CO
IMPLEMENTATION
FOR SOME COMPANIES , WHEN EXPENDITURE ACCOUNT IS CREATED PRIMARY
COST ELEMENT SHOULD BE CREATED AUTOMATICALLY
ii) CREATION OF G/L ACCOUNT 400330 VEHICLE REPAIRS A/C [T/C FS00 ]
20
ALSO FOR 100000 EQUITY SHARE CAPITAL A/C ASSIGNED FIELD STATUS
GROUP :G001 GENERAL
IF WE MAKE COST CENTER REQUIRED FOR FIELD STATUS GROUP G001 - FOR
EQUITY SHARE CAPITAL ALSO IT WILL ASK COST CENTER.
FOR FIELD STATUS GROUP : G004 - WE MAKE COST CENTER REQUIRED AND
ASSIGN NEW FIELD STATUS GROUP IN EXPENDITURE ACCOUNTS
21
--> VALID FROM : 01.04.2023 TO 31.12.9999
--> ENTER
-->GIVE THE NAME : DEPARTMENT M
-->DESCRIPTION :COST CENTER DEPARTMENT M
--> PERSON RESPONSIBLE : MR. M
--> COST CENTER CATEGORY : SELECT 1 PRODUCTION
--> HIERARCHY AREA : SELECT VILHIER
--> CURRENCY : INR
--> PROFIT CENTER : STEEL
--> SELECT SAVE BUTTON OR CTRL+S
22
DEPTX AND DEPTY.
--> FROM THE MENU BAR SELECT EXTRAS --> SET CONTROLLING AREA
--> GIVE THE CONTROLLING AREA VIL
--> ENTER
--> GIVE THE COST CENTER GROUP NAME : VILHYDPRD AND ENTER
--> DESCRIPTION : HYDERABAD PRODUCTION COST CENTERS GROUP FOR VIL
--> SELECT INSERT COST CENTER BUTTON
--> SELECT THE COST CENTERS : DEPTM AND DEPTN
--> SAVE
REQUIREMENT IN CO :
WE WANT TO SEE DEPTM ADMINISTRATION COST
OR
DEPTN PERSONNEL COST
23
ELEMENTS 400300 - 400399
IN CO REPORT :-
OR
COST
ELEMENT
OR
--> FROM THE MENU BAR SELECT EXTRAS --> SET CONTROLLING AREA
--> GIVE CONTROLLING AREA :VIL AND ENTER
-->COST ELEMENT GROUP NAME : VILADMIN AND ENTER
--> DESCRIPTION : ADMINISTRATION COST ELEMENT GROUP FOR VIL
--> SELECT INSERT COST ELEMENT BUTTON (SHIFT+F4)
--> FROM COST ELEMENT 400300 TO COST ELEMENT 400399 AND SAVE
8. TO ENTER EXCHANGE RATE FOR TYPE M FOR INR TO EURO [T/C OB08]
24
9. POSTING OF TRANSACTION IN FI [T/C FB01L ]
-->DOCUMENT DATE : TODAY’S DATE
--> TYPE : SA
--> COMPANY CODE : VIL
--> POSTING KEY : 40
--> ACCOUNT : 400100 SALARIES ACCOUNT
--> ENTER
--> AMOUNT : 200000
--> COST CENTER : DEPTM
--> TEXT : SALARIES POSTING
--> POSTING KEY : 40
--> ACCOUNT : 400100 SALARIES ACCOUNT
--> ENTER
--> AMOUNT : 400000
--> COST CENTER : DEPTN
--> TEXT : SALARIES POSTING
--> POSTING KEY : 40
--> ACCOUNT : 400300 RENT ACCOUNT
--> ENTER
--> AMOUNT : 100000
--> COST CENTER : DEPTM
--> TEXT : RENT POSTING
--> POSTING KEY : 50
--> ACCOUNT : 200100 CASH ACCOUNT
--> ENTER
--> AMOUNT : *
--> PROFIT CENTER : STEEL
--> TEXT : EXPENDITURE POSTING
--> FROM THE MENU BAR SELECT DOCUMENT -->SIMULATE AND SAVE
25
11. TO VIEW CO DOCUMENTS [T/C KSB5 ]
PATH :UPTO LINE ITEMS THE PATH IS SAME
SUMMARY : -
1 . CREATE G/L EXPENDITURE ACCOUNTS AS PRIMARY COST ELEMENTS.
2.CREATED COST CENTERS.
3.IN FIELD STATUS GROUP SPECIFIED COST CENTER REQUIRED AND ASSIGNED
NEW FIELD STATUS GROUP IN G/L EXPENDITURE ACCOUNTS.
4.AT THE TIME OF POSTING IN FI -WE HAVE GIVEN G/L EXPENDITURE
ACCOUNTS AS WELL AS COST CENTER ( COST OBJECT )
5. IT HAS UPDATED FI RECORDS AS WELL AS CO RECORDS
26
--> PROFIT CENTER : STEEL
--> TEXT : +
--> FROM THE MENU BAR SELECT DOCUMENT--> SIMULATE AND SAVE
27
--> COST CENTER (NEW) : DEPTO
--> ENTER
--> SELECT SAVE BUTTON OR CTR+S
15 . PERIOD LOCK
FI PERIODS CO PERIODS
28
RECEIPT )
Eg : - OPENED PERIODS FROM APR ,23 TO LOCKED APR,23
MARCH,24 IN FI PERIOD IN CO
Eg:
CONTROLLING AREA VIL
COST DEPTM DEPTN DEPTO DEPTX DEPTY DEPTZ
CENTERS
COMPANY VIL VIL VIL VSL VSL VSL
CODE
29
I . SALARIES POSTING IN COMPANY CODE VIL
II . FI RECORDS
COMPANY CODE : VIL COMPANY CODE : VSL
III . CO RECORDS
COMPANY CODE VIL COMPANY CODE VSL
COST CENTER DEPTM COST CENTER DEPTX
SALARIES A/C 200000DR SALARIES NIL
V . FI RECORDS
COMPANY CODE : VIL COMPANY CODE : VSL
VI . CO RECORDS
FI DOCUMENT :
VIII . FI RECORDS
30
COMPANY CODE : VIL COMPANY CODE : VSL
IX . CO RECORDS
INTERVIEW QUESTION : -
FI CUSTOMIZATION STEPS :-
--> FROM THE MENU BAR SELECT ORGANIZATIONAL OBJECT --> COPY
ORGANIZATIONAL OBJECT
--> FROM COMPANY CODE : VIL
--> TO COMPANY CODE : VSL
--> ENTER
--> SELECT YES BUTTON
--> SELECT NO BUTTON
--> WE GET A MESSAGE CERTAIN DATA WAS NOT COPIED
--> IGNORE THE MESSAGES AND ENTER
--> SELECT YES BUTTON
31
--> SELECT CREATE REQUEST BUTTON
--> SHORT DESCRIPTION : CUSTOMIZATION FOR VSL
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
--> SELECT YES BUTTON
--> PRESS ENTER
--> GO ON PRESS ENTER
--> ENTER ONCE AGAIN
--> SELECT CANCEL BUTTON
--> SELECT COPY BUTTON
--> GO ON PRESS ENTER TILL YOU GET THE MESSAGE - COMPANY CODE VIL
COPIED TO VSL WITHOUT 1 NUMBER RANGE OBJECT
--> IGNORE THE MESSAGE PRESS ENTER
--> SELECT BACK ARROW
--> DOUBLE CLICK ON EDIT COMPANY CODE DATA
--> SELECT POSITION BUTTON
--> COMPANY CODE : VSL
--> ENTER
--> SELECT COMPANY CODE : VSL
--> SELECT DETAILS BUTTON
--> CHANGE THE COMPANY NAME TO : VARUN STEELS LIMITED
--> SELECT ADDRESS BUTTON
--> CHANGE THE NAME VARUN STEELS LTD
--> ENTER
--> SAVE AND SAVE IN YOUR REQUEST BUTTON
PATH :
SPRO --> ENTERPRISE STRUCTURE --> ASSIGNMENT -->FINANCIAL
ACCOUNTING --> ASSIGN COMPANY CODE TO COMPANY
-->SELECT POSITION BUTTON
-->COMPANY CODE : VIL
-->ENTER
-->FOR COMPANY CODE : VSL- ASSIGN COMPANY: WGP (GROUP CODE)
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
32
COMPANY CODE [ VIL ] COMPANY CODE [ VSL ]
33
--> SELECT WITH TEMPLATE BUTTON
--> GL ACCOUNT NO: 200120 INVENTORY RM
--> ENTER
--> FIELD STATUS GROUP : G067 RECONCILATION ACCOUNTS
--> SELECT TYPE/DESCRIPTION TAB
--> CHANGE SHORT TEXT AND G/L ACCOUNT LONG TEXT: VARUN STEELS
LIMITED
--> SAVE
34
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
CO - CUSTOMIZATION
1. MAINTAIN CONTROLLING AREA:[ T/C OKKP ]
35
--> DOUBLE CLICK ON DEFINE ACCOUNTS FOR AUTOMATIC POSTINGS
--> SELECT CHANGE ACCOUNT DETERMINATION BUTTON
--> SAVE
--> ACCOUNT NO.:400150 i.e., CO/FI RECONCILIATION A/C
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
ECC6 CUSTOMIZATION :-
1. DEFINE VARIANTS FOR REALTIME INTEGRATION
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
36
--> REFERENCE COST CENTER : DEPTM
--> CONTROLLING AREA : VIL
--> ENTER
--> CHANGE THE NAME TO : DEPARTMENT X
--> CHANGE THE DESCRIPTION TO COST CENTER DEPT X
--> CHANGE COMPANY CODE TO : VSL
--> SELECT SAVE BUTTON OR CTRL+S
37
WHEN WE TRANSFER COST FROM ONE COMPANY CODE DEPT TO OTHER
COMPANY CODE DEPARTMENT
NORMAL ACCOUNTING :-
38
--> TYPE : SA
--> COMPANY CODE:VIL
--> POSTING KEY : 50
--> ACCOUNT : 200100 CASH ACCOUNT
--> ENTER
--> AMOUNT : 10000
--> PROFIT CENTER : STEEL
--> TEXT : OUTSTANDING EXPENSES PAYMENT ON BEHALF OF VSL
--> POSTING KEY : 40
--> ACCOUNT : 100500 OUTSTANDING EXPENSES
--> NEW COMPANY CODE : VSL
--> ENTER
--> AMOUNT : *
--> PROFIT CENTER : STEEL
--> TEXT : +
--> FROM THE MENU BAR SELECT DOCUMENT -->SIMULATE AND SAVE
--> SELECT CONTINUE BUTTON
IT GENERATES CROSS COMPANY CODE NO. 0000000023VIL 23
FI :-
DEPTM 50000
COST CENTER
DEPTN 30000
39
COST CENTER
DEPTO 20000
TO BANK 100000
CO:
40
TOTAL VALUES: - IF WE SELECT TOTAL VALUES, WE HAVE TO ENTER VALUES
FOR EACH AND EVERY MONTH IN THE YEAR
Eg :- TELEPHONE CALLS
STEPS :-
41
PATH : ACCOUNTING --> CONTROLLING --> COST CENTER ACCOUNTING -->
MASTER DATA --> STATISTICAL KEY FIGURES --> INDIVIDUAL PROCESSING -->
CREATE (T/C : KK01)
DEPTN EMP 25
--> SAVE
42
WORKERS WELFARE 50000
-----------
TOTAL == 720000
WORKERS -100 WORKERS FOR EACH SHIFT
- WORKING FOR 3 SHIFTS
DEPTM DEPTN
43
PRODUCTION ORDER1 ORDER2 ORDER3 TOTAL
ORDER
MACHINE 25 25 25 25
HOUR RATE
44
SAP HAS GIVEN 2 METHODS-
ACTIVITY INDEPENDENT PLANNING ACTIVITY DEPENDENT PLANNING
45
--> SAVE
46
--> PLAN ACTIVITY : 72000
--> SAVE
47
1ST 2ND METHOD
METHOD
ACTIVITY INDEPENDENT ACTIVITY
DEPENDENT
FIXED FIXED VARIABLE TOTAL
PLAN 720000 144000 576000 720000
COST
PLAN 72000 72000
HOURS
PLAN 720000/72000= 144000/72000= 576000/72 720000/72000=
PRICE 10 Rs 2 Rs 000= 10 Rs
8 Rs
3RD METHOD:
ENTER ACTIVITY PRICE MANUALLY IN KP26
TO SEE ACTIVITY PRICE REPORT:
PATH : - ACCOUNTING --> CONTROLLING --> COST CENTER ACCOUNTING -->
INFORMATION SYSTEM --> REPORTS FOR COST CENTER ACCOUNTING -->
PRICES-->COST CENTERS: ACTIVITY PRICES [ KSBT ]
48
ACTUAL ACTIVITY PRICE CALCULATION
ACTUAL COST IN THE COST CENTER / ACTUAL ACTIVITY HOURS
3 METHODS AVAILABLE : -
--> PERIOD:9(DEC)
--> TO PERIOD: 9(DEC)
--> FISCAL YEAR : 2023
-->COST CENTER : DEPTO
--> ACTIVITY TYPE : VIL1 i.e., LABOUR HOURS
--> SELECT FORM- BASED RADIO BUTTON
--> SELECT OVERVIEW SCREEN BUTTON
--> FIXED ACTIVITY PRICE AREA CURRENCY : 10 Rs.
--> SAVE
ACTIVITY ALLOCATION
WE CAN ALLOCATE COST FROM ONE COST CENTER TO OTHER COST CENTERS
BASED ON ACTIVITIES.
1. DIRECT ACTIVITY ALLOCATION
2. INDIRECT ACTIVITY ALLOCATION
49
LABOUR HOURS (ACTIVITY TYPE ) AVAILABLE FOR THE MONTH =100
WORKERS *3*8HRS *30 DAYS = 72000 HRS
SALARIES 100000
POWER 200000
RENT 45600
TOTAL 345600
DEPT P CHECKS QUALITY NORMS OF PRODUCTION RECEIVED FROM
DIFFERENT PRODUCTION DEPARTMENTS.
WORKERS - 20 PER SHIFT - WORKING FOR 3 SHIFTS i.e.,: - 24 HRS
NO.OF DAYS WORKED 30 DAYS
QUALITY INSPECTION HOURS AVAILABLE =
20 WORKERS*3*8 HRS*30 DAYS = 20* 24 * 30 = 14400 HRS
QUALITY INSPECTION HOUR RATE 345600/14400 = 24 PER HOUR
ISSUE :-
WE KNOW HOW MANY QUALITY INSPECTION HOURS SPENT FOR QUALITY
CHECK. WE DO NOT KNOW HOW MANY QUALITY INSPECTION HOURS SPENT
FOR EACH DEPARTMENT PRODUCTION.
PRODUCTION COST DEPTM DEPTN
CENTERS
QUALITY INSPECTION 24 24
HOUR RATE
50
FROM DEPT P
CONCLUSION :-
2.IF WE DO NOT KNOW HOW MANY HOURS ARE SUPPLIED BY SENDER COST
CENTER TO EACH RECEIVER COST CENTER-ALLOCATE THE TOTAL HOURS OF
SENDER COST CENTER BASED ON PRODUCTION OF RECEIVER COST CENTERS-
USE INDIRECT ACTIVITY ALLOCATION
51
--> FISCAL YEAR : 2023
--> COST CENTER : DEPTO
--> ACTIVITY TYPE :VIL1 i.e., LABOUR HOURS
--> SELECT FORM- BASED RADIO BUTTON
--> SELECT OVERVIEW SCREEN BUTTON
--> FIXED ACTIVITY PRICE AREA CURRENCY : 10
--> SAVE
IV . ENTER ACTIVITY ALLOCATION FOR DEC,23
PATH :- ACCOUNTING --> CONTROLLING --> COST CENTER ACCOUNTING -->
ACTUAL POSTINGS --> ACTIVITY ALLOCATION --> ENTER [ KB21N ]
--> DOCUMENT DATE AND POSTING DATE :31.12.2023
--> SAVE
52
--> CHANGE THE NAME TO DEPARTMENT P
--> DESCRIPTION : COST CENTER DEPARTMENT P
--> SAVE
III . CREATION OF COST CENTER GROUP [ KSH1 ]
--> COST CENTER GROUP:VILPGRP
--> ENTER
--> DESCRIPTION : COST CENTER GROUP VILP GROUP
-->SELECT INSERT COST CENTER BUTTON
--> SELECT THE COST CENTER : DEPTP
--> SAVE
53
RKN - ACTUAL NON - ALLOCATION ACTIVITIES
RKIL - ACTUAL INVERSE ACTIVITY ALLOCATION
--> CO AREA :VIL
--> SELECT MAINTAIN GROUPS BUTTON
--> KEEP THE CURSOR ON RKN
--> SELECT ELEMENT / GROUP BUTTON
--> KEEP THE CURSOR ON NUMBER RANGE 01
--> ENTER
--> KEEP THE CURSOR ON RKIL
--> SELECT ELEMENT / GROUP BUTTON
--> KEEP THE CURSOR ON NUMBER RANGE 01
--> ENTER
--> SAVE
54
--> ENTER
--> NAME : PRODUCTION
--> STATISTICAL KEY FIGURE UNM- SELECT KG
--> KEY FIGIURE CATAGORY:SELECT TOTAL VALUES RADIO BUTTON
--> SAVE
55
--> SELECT EXECUTE BUTTON
--> SELECT RECEIVER BUTTON
IN THE MONTH END WE ALLOCATE COST FROM ONE COST CENTER TO OTHER
COST CENTERS.
COST CENTER DEPTO DEPTM DEPTN
( SERVICE DEPT ) ( PRODUCTION DEPARTMENTS )
SALARIES 100000}
WAGES 500000 } BASED ON STATISTICAL KEY FIGURES
1. ASSESSMENT
2. DISTRIBUTION
3. PERIODIC REPOSTING
4. INDIRECT ACTIVITY ALLOCATION
1. ASSESSEMENT : -
56
80 % -680000
ALLCN N
20 % - 170000
0 0 980000 570000
B.RECEIVER COST CENTER CAN NOT TRACK THE ORIGINAL COST ELEMENTS -
DEPTM RECEIVED FROM DEPTO RS 680000
IT WILL NOT SHOW WHAT IS SALARIES PORTION /WAGES PORTION / RENT
PORTION OF O
2. DISTRIBUTION :-
3. PERIODIC REPOSTING :-
A . WE CAN ALLOCATE ONLY PRIMARY COST POSTINGS
B. RECEIVER COST CENTER CAN TRACK ORIGINAL COST ELEMENTS
C. SENDER CAN BE A COST CENTER OR ORDER
D. DEFINE CO NUMBER RANGE INTERVAL FOR BUSINESS TRANSACTION RKIB
i.e., PERIODIC REPOSTING
57
CREATE NUMBER OF CYCLES OR CREATE NUMBER OF SEGMENTS UNDER A
CYCLE
CYCLE 2
|
SEGMENT1
( RENT ALLOCATION )
400300 RENT ACCOUNT
CYCLE 1
|
SEGMENT 1 SEGMENT 2
( SALARIES AND WAGES ALLOCATION ) ( RENT ALLOCATION )
400100 SALARIES ACCOUNT 400300 RENT ACCOUNT
400101 WAGES ACCOUNT
58
II . DEFINE CO NO. RANGE INTERVAL FOR THE BUSINESS TRANSACTION-
RKIU-i.e., : ACTUAL OVERHEAD ASSESSMENT [ KANK ]
59
SELECT ITERATIVE CHECK BOX : -
COST CENTER DEPTO
( SERVICE DEPT ) 1ST RUN 2ND RUN
SALARIES 1,00,000 DEPT M 50% 3,25,000 16,500
WAGES 5,00,000 DEPT N 30 % 1,95,000 9900
RENT 50,000 DEPT X 20 % 1,30,000 6600
TOTAL 6,50,000
( - ) LESS :- ALLCN - 6,50,000
0
ADD: -ALLCN FROM X 33,000
33,000
LESS : - ALLCN - 33,000
0
60
--> PRESS ENTER TO SAVE IN YOUR REQUEST
--> SELECT ATTACH SEGMENT BUTTON
--> SEGMENT NAME : SEGMENT2 [ RENT ALLOCATION ]
--> ASSESSMENT COST ELEMENT : 900001
--> SENDER RULE : POSTED AMOUNTS
--> SHARE IN % : 100 %
--> SELECT ACTUAL VALUE ORIGIN RADIO BUTTON
--> RECEIVER RULE : SELECT FIXED PERCENTAGES
--> SELECT SENDERS/ RECEIVERS TAB
--> SENDER COST CENTER : DEPTO
--> COST ELEMENT : 400300 (RENT )
-->RECEIVER COST CENTER : DEPTM TO DEPT N
--> SELECT RECEIVER TRACING FACTOR TAB
--> DEPTM:PORTION/PERCENT 80
--> DEPTN :PORTION/PERCENT 20
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
61
3RD METHOD - PERIODIC REPOSTING
1. DEFINE CO NUMBER RANGE INTERVAL FOR BUSINESS TRANSACTION RKIB -
ACTUAL OVERHEAD PERIODIC [ KANK ]
2. CREATION OF PERIODIC REPOSTING CYCLE [ S _ ALR _ 87005395 ]
3. POSTING OF TRANSACTION FOR FEB, 24 [ FB01L ]
4. PERIODIC REPOSTING RUN FOR FEB, 24 [ KSV5]
Eg : -
DEPTM DEPTN
PRODUCTION DEPTS
PRODUCTION IN DEC 23 1000- KGS 5000 KGS
SERVICE DEPT DEPTO
SALARIES 100000
TO ALLOCATE DEPTO COST ON STATISTICAL KEY FIGURES BASIS TO
PRODUCTION DEPARTMENT M AND DEPARTMENT N
OPTION 1 : NO SCALING
62
SKF i.e., : PRODUCTION IN DEC 1000 - 5000 4000
ALLOCATION 100000 * 1000-/4000 100000 * 5000 / 4000
= - 25000 = 125000 100000
COST 100000
COST 100000
COST 100000
0 5000 5000
=0 = 100000 = 100000
63
1. POSTING OF EXPENDITURE FOR THE MONTH OF DEC, 23 [ FB01L ]
64
--> SELECT SENDERS / RECEIVERS TAB
--> SENDER COST CENTER : DEPTO
--> SENDER COST ELEMENT : 400100 (SALARIES A/C)
--> RECEIVER COST CENTER : DEPTM TO DEPTN
--> SELECT RECEIVER TRACING FACTOR TAB
--> STATISTICAL KEY FIGURE : PROD
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
65
--> SCALE NEG TRACING FACTORS: SELECT ABSOLUTE VALUE (NEGATIVE TO
POSITIVE) ]
--> SAVE
--> PRESS ENTER TO SAVE IN YOUR REQUEST
66
--> FROM PERIOD 1 TO PERIOD 12
--> FISCAL YEAR 2023
--> COST CENTER : DEPTM
--> COST ELEMENT 400000 TO 499999
--> SELECT FORM-BASED RADIO BUTTON
--> SELECT OVERVIEW SCREEN BUTTON
--> COST ELEMENT 400100
--> PLAN FIXED COST 3600000
--> DISTRIBUTION KEY : 1 [EQUAL DISTRIBUTION]
--> SELECT COST ELEMENT 400100
--> SELECT PERIOD SCREEN BUTTON
--> SELECT BACK ARROW BUTTON
--> FOR COST ELEMENT 400300
--> PLAN FIXED COST 1200000
--> DISTRIBUTION KEY 1 [EQUAL DISTRIBUTION]
--> SAVE
2 . POSTING OF EXPENDITURE FOR THE MONTH OF DEC , 23 [ FB01L ]
1ST ENTRY:
-->DOCUMENT DATE AND POSTING DATE:31.12.2023
--> TYPE : SA
--> COMPANY CODE : VIL
--> POSTING KEY : 40
--> ACCOUNT : 400100 SALARIES ACCOUNT
--> ENTER
--> AMOUNT : 280000
--> COST CENTER : DEPTM
--> TEXT : SALARIES POSTING
--> POSTING KEY : 50
--> ACCOUNT : 200105 SBI CURRENT ACCOUNT
--> ENTER
--> AMOUNT : *
-->PROFIT CENTER : STEEL
--> TEXT : +
--> FROM THE MENU SELECT DOCUMENT -->SIMULATE AND SAVE
2ND ENTRY:
-->DOCUMENT DATE AND POSTING DATE:30.11.2023
--> TYPE : SA
--> COMPANY CODE : VIL
--> POSTING KEY : 40
--> ACCOUNT : 400300 RENT ACCOUNT
--> ENTER
--> AMOUNT : 125000
--> COST CENTER : DEPTM
67
--> TEXT : RENT POSTING
--> POSTING KEY : 50
--> ACCOUNT : 200105 SBI CURRENT ACCOUNT
--> ENTER
--> AMOUNT : *
-->PROFIT CENTER : STEEL
--> TEXT : +
--> FROM THE MENU SELECT DOCUMENT -->SIMULATE AND SAVE
DISTRIBUTION KEYS
WHEN WE PLAN FOR MORE THAN ONE MONTH WE CAN SPECIFY HOW TO
ALLOCATE FOR EACH MONTH BY USING DISTRIBUTION KEYS .
SAP HAS GIVEN FOLLOWING DISTRIBUTION KEYS:
DISTRIBUTION KEY :-
0 MANUAL DISTRIBUTION - ALLOCATE MANUALLY EACH MONTH
1 EQUAL DISTRIBUTION - ALLOCATE EQUALLY FOR EACH MONTH
2 AS BEFORE - ALLOCATE AS PER EARLIER BASIS FOR EACH MONTH
3 BY PERCENTAGE - ALLOCATE PERCENTAGE BASIS FOR EACH MONTH
68
--> SELECT FORM- BASED RADIO BUTTON
--> SELECT OVERVIEW SCREEN BUTTON
--> COST ELEMENT 400100
--> PLAN FIXED COSTS : 2400000
--> DISTRIBUTION KEY :SELECT 1[ EQUAL ]
--> SELECT COST ELEMENT 400100
--> SELECT PERIOD SCREEN BUTTON
-->SELECT BACK ARROW
--> SAVE
--> SELECT OVERVIEW SCREEN BUTTON
--> DISTRIBUTION KEY: SELECT 0 (MANUAL DISTRIBUTION)
--> SELECT COST ELEMENT 400100
--> SELECT PERIOD SCREEN BUTTON
--> APRIL PLAN FIXED COST CHANGE TO 100000
--> MARCH PLAN FIXED COST CHANGE TO 300000
--> SAVE
--> SELECT OVERVIEW SCREEN BUTTON
--> PLAN FIXED COST 4800000
--> DISTRIBUTION KEY :SELECT 2 (DISTRIBUTION AS BEFORE)
--> ENTER
--> SELECT COST ELEMENT 400100
--> SELECT PERIOD SCREEN BUTTON
--> APRIL 200000
--> MARCH 600000
--> SAVE
DISTRIBUTION BY PERCENTAGE : -
--> SELECT OVERVIEW SCREEN BUTTON
--> PLAN FIXED COST : 5
--> DISTRUBUTION KEY : 3 DISTUBUTION BY PERCENTAGE
--> SAVE
--> SELECT OVERVIEW SCREEN BUTTON
-->SELECT COST ELEMENT 400100
--> SELECT PERIOD SCREEN BUTTON
--> SAVE
SUMMARY : -
DISTRIBUTION TOTAL PLAN OTHER APR MARCH
KEYS AMOUNT MONTHS
EACH MONTH
1 EQUAL 2400000 200000 200000 200000
DISTRIBUTION
0 MANUAL 2400000 200000 100000 300000
DISTRIBUTION
69
2 AS BEFORE 4800000 400000 200000 600000
3 BY 5
PERCENTAGE 240000 20000 10000 30000
OR
1. TO SELECT COPYING ALLOWED CHECK BOX FOR THE YEAR 2023 [T/C
OKEQ ]
3. CREATE REVALUATION
70
PATH : SPRO --> CONTROLLING --> COST CENTER ACCOUNTING --> PLANNING
--> PLANNING AIDS -->DEFINE REVALUATION
--> DOUBLE CLICK ON CREATE PLAN REVALUATION
400100-SALARIES 425000
400300-RENT 60000
--> VERSION :0
71
--> FROM PERIOD : 1
--> TO PERIOD : 1
--> FISCAL YEAR : 2024
--> COST CENTER : DEPTM
--> COST ELEMENT : 400100 TO 400300
--> ENTER
--> SELECT FORM - BASED RADIO BUTTON
--> SELECT OVERVIEW SCREEN BUTTON
DEC, 23 INCREASE APRIL,24 PLAN
ACTUALS IN 10% AMOUNT
400100-SALARIES 425000 110% 467500
400300-RENT 60000 110% 66000
72
OUTSTANDING EXP DR 100000
TO BONUS 100000 COST CENTER:DEPTM
73
ORDERS
i)SOME COMPANIES WILL NOT PREPARE PROFIT & LOSS ACCOUNT AND
BALANCE SHEET EVERY MONTH. THEY WILL NOT MAKE PROVISIONS IN THE
BOOKS.
74
COST CENTER DEPT DUMMY
COST CENTER DEPT DUMMY VALUE WILL BE ZERO IN THE YEAR END .
CUSTOMIZATION :-
75
--> SELECT ELEMENT / GROUP BUTTION
--> KEEP THE CURSOR ON NUMBER RANGE 01
--> ENTER
--> SAVE
76
--> DOUBLE CLICK ON OVERHEAD STRUCTURE VIL1
--> KEEP THE CURSOR ON BASE :V1
--> FROM THE MENU BAR SELECT GOTO --> CALCULATION BASE
--> FROM COST ELEMENT : 400100 SALARIES A/C
--> SAVE
--> KEEP THE CURSOR ON OVERHEAD RATE :V2
--> FROM THE MENU BAR SELECT GOTO --> OVERHEAD RATE
--> VALID : 1
--> FROM : 2023
--> VALID TO :12 2023
--> ACTUAL OVERHEAD : 10
--> SAVE
--> KEEP THE CURSOR ON V3
--> FROM THE MENU BAR SELECT GOTO --> CREDIT
--> COMPANY CODE:VIL
--> VALID TO: 12 [ 2023 ]
--> COST ELEMENT : 400105 BONUS A/C
--> COST CENTER DEPTDUMMY
--> SAVE
77
--> SELECT EXECUTE BUTTON
--> SELECT NEXT LIST LEVEL BUTTON
78
SPLITTING STRUCTURE
79
III. ALLOCATION
AMOUNT LABOUR CLEANING MACHINE TOTAL
SALAR 500000
IES
500000*50000/ 500000*30000/ 500000
80000=312500 80000=187500
RENT 220000 220000*30000/ 220000*10000 220000
40000= 165000 /40000=55000
TOTAL 312500 352500 55000 720000
COST
CUSTOMIZATION : -
1. CREATION OF ACTIVITY TYPE [ KL01 ]
--> CONTROLLING AREA :VIL
-->ENTER
--> ACTIVITY TYPE :VIL4
-->VALID FROM :01.04.2023
--> COPY FROM ACTIVITY TYPE :VIL1 LABOUR HOURS
--> CONTROLLING AREA :VIL
--> ENTER
--> CHANGE THE NAME AND DESCRIPTION : CLEANING HOURS
--> SAVE
--> ACTIVITY TYPE :VIL5
--> ENTER
--> CHANGE THE NAME AND DESCRIPTION : MACHINE HOURS
--> SAVE
80
--> SELECT ACTIVITY TYPE VIL4 AND VIL5
--> SAVE
81
--> SELECT ASSIGNMENT 1
--> DOUBLE CLICK ON SELECTION FOR ASSIGNMENT FOLDER
--> SELECT NEW ENTRIES BUTTON
--> COST ELEMENT FROM VALUE : 400100 SALARIES
--> ACTIVITY TYPE GROUP :SELECT VIL14GRP
--> SAVE
--> SELECT BACK ARROW
--> SELECT ASSIGNMENT 2
--> DOUBLE CLICK ON SELECTION FOR ASSIGNMENT FOLDER
--> SELECT NEW ENTRIES BUTTON
--> COST ELEMENT FROM VALUE : 400300 RENT
--> ACTIVITY TYPE GROUP SELECT :VIL45GRP
--> SAVE
82
-->VIL5 PLAN ACTIVITY : 10000
--> SAVE
3. COST CENTER SPLITTING [ KSV4 ]
PATH : ACCOUNTING --> CONTROLLING --> COST CENTER ACCOUNTING -->
PLANNING --> ALLOCATIONS --> SPLITTING
--> COST CENTER : DEPTQ
--> SELECT EXECUTE BUTTON
--> KEEP THE CURSOR ON COST CENTER DEPTQ
--> SELECT COST ELEMENTS BUTTON
--> SELECT BACK ARROW 2 TIMES
--> IGNORE THE MESSAGE AND PRESS YES BUTTON
--> DESELECT TEST RUN CHECK BOX
--> SELECT EXECUTE BUTTON
83
SUMMARY : -
1. TO UPDATE CO RECORDS COST ELEMENTS ARE REQUIRED
A . CATEGORY : 42 ASSESSEMENT
PRIMARY COST POSTINGS AND SECONDARY COST ALLOCATIONS
B . CATEGORY : 43 INTERNAL ACTIVITY ALLOCATION - ALLOCATION OF
ACTIVITY HOURS
6. REPOST CO LINE ITEM -AT THE TIME OF POSTING FI PERSON DOES NOT
KNOW WHICH COST CENTER TO POST. POST TO COMMON COST CENTER. CO
PERSON WILL TRANSFER FROM COMMON COST CENTER TO RESPECTIVE COST
CENTERS. TRANSFER DOCUMENTWISE / LINE ITEMWISE
84
13. DIRECT ACTIVITY ALLOCATION
ALLOCATION OF SENDER COST CENTER COST BASED ON HOURS SUPPLIED BY
SENDER COST CENTER TO RECEIVER COST CENTERS.
B. ALLOCATION METHODS
I . ASSESSMENT - TRANSFER PRIMARY COST POSTINGS AND SECONDARY COST
ALLOCATIONS
II . DISTRIBUTION - TRANSFER ONLY PRIMARY COST POSTINGS -SENDER
SHOULD BE A COST CENTER
III . PERIODIC REPOSTING - TRANSFER ONLY PRIMARY COST POSTINGS-
SENDER CAN BE A COST CENTER OR ORDER
IV. INDIRECT ACTIVITY ALLOCATION - TRANSFER QUANTITIES AS WELL AS
VALUES
85