PA – Profitability analysis
This is used to view profitability for number of parameters at a time. If the client want to view profitability
Product wise/customer wise/sales order wise/plant wise/sales organization wise - This is called data cube
- This is a reporting tool
- Product costing is based on the based on data flown from MM, PP, FI, CO
Here we have
- Account based/costing based/both wise profitability analysis
- Here we create operating concern
Operating concern can be
- equal to controlling area (or) above controlling area
We are using called data structure
Data structure
| |
Characteristics value fields
↓ ↓
Sales order Customer
Product Sales
Sales organization Cost of goods sold
Plant Net profit
Sales employee Industry
Profitability segment:
In consist of system defaulted characteristics
Client required characteristics
Example of client required characteristics:
1. Sales employee wise profitability 2. Industry wise profitability
Data flow in profitability analysis SD to FI
a) Enquiry & quotation
b) Sale order: customer, product plant, sales organization, quantity, price, delivery
terms & payment terms
c) Delivery: with out post goods issue/with post goods issue
d) Billing
Define operating concern:
SPRO controlling profitability analysis structures define operating concern Maintain operating concern.
Operating concern: 1234 (It should be 4) Select create button
Ignore the warning message, press enter
Select costing based check box, actual based check box Select attributes tab
Give the operating concern currency: INR Select company code currency check box Fiscal year variant: V3
Save
Select data structure tab
Select create button under data structure
Select the characteristic: KNVTNR (Sales employee) Select left arrow
Select value fields tab Select: VV010 (Revenues)
Select: VV140 (Cost of goods sold) Select left arrow
From the menu select data structure save 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
Define profitability segment characteristics: (In segment level characteristics) Path: same path (T. Code: KUQ3)
Give the operating concern: 1234 Enter
Save
Save in your request
Assign controlling area: to operating concern:
Path: SPRO enterprises structure assignment controlling assign controlling
area to operating concern Select position button
Give the controlling area: AML
Enter: for controlling area: AML, assign operating concern: 1234 Save
Ignore the warning message, press enter
Define No. ranges for actual postings:
SPRO controlling profitability analysis flows of actual values initial steps define number ranges for actual postings (T. Code: KEN1)
Give the operating concern: 1234 Select maintain groups’ button Select generated groups check box
From the menu select interval maintain Give the No from: 1 to 999999999
Save
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
Double click on maintain assignment of SD conditions to CO-PA value fields (T. Code:
KE41)
Select new entries button
Path: SPRO controlling profitability analysis structures set operating
concern
Give the operating concern: IDEA Enter
Use the transaction code: KE41
Come to the 1st session
Give the condition type: PR00 (Rice) Select value fields – VV010 (Revenues) Select VPRS (Costs)
Select value fields – VV140 (Cost of goods sols) Save
Maintain PA (Profitability analysis) structure for direct postings:
SPRO controlling profitability analysis flows of actual values direct postings from FI/MM maintain PA transfer structure for direct postings (T. code: KET2) Select the structure: FI (Financial accounting to CO – PA)
Double click on assignment lines folder Select: 20 (Direct revenues from FI) Double click on source folder
Give the cost element: from 300000 to 399999 Double click on value fields’ folder
Select new entries button Qty/value select value field
Fixed variable select 1 (Fixed amounts) Value fields select VV010 (Revenue) Save
Double click on assignment lines folder Select assignment: 10 (Direct costs from FI) Give the cost element: from 400000 to 499999 Double click on value fields’ folder
Select new entries button Qty/value select value field
Fixed variable select 1 (Fixed amounts)
Value fields select VV140 (Cost of goods sold) Save
Activate profitability analysis: Path: same path (T. Code: KEKE)
Select position button
Give the controlling area: AML Enter
For controlling area: DRL – Active status select a4 (Component active For both types of profitability analysis)
Save
Save in your request
Sale order creation:
Path: Logistics sales & distribution sales order create (T. Code: VA01)
Give the sales organization: AMLH Distribution channel: AD
Division: A1
Enter
Sold to party: VBC Industries Pvt. Ltd Give the P. O. order: 5678
Required delivery date: 03.12.2006 Delivery plant: AMLP
Payment terms: 0001 Item: 10;
Material No: AMLFG Order qty: 1 kg Enter
Ignore the messages, press enter Select item 10
From the menu select go to item condition Select: Shipping tab
From the menu select edit Incompletion log Save (or) (ctrl + s)
Note: Sales order No: 8209
Production receipt with out production order:
Path: Logistics Materials management Inventory management Goods
movement goods receipt Other (MB1C) Give the movement type: 521
Plant: AMLP
Enter
Give the material type: AMLFG Qty: 20 Kegs
Save
Ignore the warning message, press enter
From the menu select other goods receipts display Enter
Select accounting documents button Select accounting document No:
Account No Description INR
200122 Inventory FG 10000 – DRLFG1 – DRL1 (BSX)
300201 Inc/Dec in stock FG 10000 – DRLFG1 – DRL1 –(GBBZAX) ↓
Qty & standard price
Delivery:
Logistics sales & Distribution sales order subsequent functions outbound delivery (VL01N)
Give the shipping point: AMLS
Give the sales order number: 8209 (What it is created in sales order) Enter
Actual GI date (Goods issue date): 03.12.2006 Select item: 10
Select picking tab Pick quantity: Enter 1
From the Menu select out bound delivery display Enter
From the Menu select environment Document flow Keep the cursor on goods issue
Select display document button Select accounting documents button Select accounting document No:
200122 Inventory FG 500 DRLFG1 DRL1 – (BSX) 300201 Inc/dec in stock FG 500 DRLFG1 DRL1 – GBBVAY
Billing document: Same path: (VF02)
Select the delivery document No: 11341 Enter
Save
From the menu select billing document display Select accounting button
Select accounting document No
Report generation through report painter Define forms
SPRO Controlling Profitability analysis information system report components define forms define forms for profitability reports
Double click on create form Give the form name: AML
Select two axes (Matrix) radio button Select create button
Select operating concern currency radio button Enter
Double click on: Row 1
Select value field with characteristics radio button Enter
Value field select: VV01 (Revenue) Select: Confirm button
Double click on: Row2
Select value field with characteristics radio button Enter
Value field select: VV140 (Cost of goods sold) Select: Confirm button
Double click on: Row3 Select formula radio button Enter
Select Y001 (Revenue) Select Minus (-) button
Select Y002 (Cost of goods sold button) Enter
Short description: Net profit Select copy short text button
Enter
Double click on column1
Select characteristics radio button Enter
Select from the available characteristics plan/actual indicator Select left arrow
For plant/actual indicator: Select 0 (Actual data) Select confirm button
Save
From the menu select edit General data selection General data selection From the available characteristics select record type, select period/year
Select left arrow
For record type: select from column B to column select F (Billing data)
For period/year
For from column: Select variable on/off check box Local variable: enter1
Enter
For to column: Select variable on/off check box Give the local variable: 2
Enter
Select confirm button
From the menu select extras Variables variables of definition 1- description: From period/year
Enter & Save
Create profitability report:
Same path
Double click on create profitability report
Transaction code: KE31
Give the report name: AML Profit Description: AML Profitability Select: Report with form radio button Give the form name: AML
Select create button
Select customer, product, plant, select sales organization from characteristics list Select left arrow
Select output type tab
Select: Class drill down radio button
Select available on selection screen check box Save
Select execute button
Give from period/year: 01.2006 To period/year: 12.2006
Execute
Ignore the message, select ‘yes’ button
To view product wise:
Double click on product