Customization and Data flow of CO-PA in sap CO

Co for Controlling

PA for Profitability Analysis

This is used to view profitability for  number of parameters at a time:

Eg: Customerwise /Productiwise /Sales order wise plant wise, Sales organization  profitability.

Account based profitability /costing based profitability analysis / both (in India we use both)

PP Module

MM Module

FI Module à product costing à SD module à CO-PA

CO Module

Define an operating concert

Operating concern can be equal to controlling area or above controlling area

Controlling area can be equal to our company code or above company code

Company code =controlling area =operating concern

Data structure

Characteristics                                                 Value fields

Customer                        ------

Product                                   |

Sales order                              |

Plant                                        |-à                  Sales cost of goods sold net profit

Sales organization                   |

Sales employee                        |

Country                                   |

                                           ----

Profitability segment à It consists of

A)    System defaulted characteristics

Eg: customer / Product / Sales order /Plant /Sales organization

B)    Client required characteristics

Eg: Sales employee / Industry

Data flow in SD module:

1. Inquiry and quotation
2. Sales order –customer /product /plant sales organization /quantity /rate delivery terms payment terms.
3. Delivery with reference to sales order.

A)    without posting goods issue (without PGI)

B)    with post goods issue (with PG1)

4. Sales billing with reference to delivery

Data flow in Co-PA

                  SD condition types                             CO-PA value fields

PR00         Price                                                    VV 010 – Revenues

VPRS        Costs                                                   VV 140 – Cost of goods sold

(Product costs)

(up to COGM level)                                              CO - +FI

                                                                              COGM Admin & SD Exp.

(Both –costing based and account based)

We are going to MAP:

PR00 =VV010

VPRS=W140

Product cost :                          BILFG1

Cost sheet:                              BILFG

Raw materials                         xxx

Raw material overheads          xxx

Production costs                     xxx

-----      Production valuation will be at COGM level or COGM+ admin exp. Level

Cost of goods manufactured   xxx

(COGM)

Administration                        xxx

Sales & Distribution                xxx

                                                -----

Cost of goods sold (COGS)   xxx

In client 800 –for company code 10001 controlling area -1000 operating concern IDEA

In IDEA –All SD condition types and equivalent CO-PA value fields

We check IDEA and do customization the same way for our operating concern also IDEA is a references to all the CO consultants

CUSTOMIZATION :

Maintain operating concern

Path :SPRO-Controlling –Profitability analysis –Structures –Define operating concern –Maintain operating concern (Tr code is KEA0)

Give the operating concern                 :BIL1 (It is a text field)

Select create button

Ignore the warning message press enter

Description      :Operating concern for BIL

Select costing based check box

Select account based check box

select attributes tab

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 KMVTNR sales employee

select left arrow

select value fields tab

select VV010 revenue

select VV140 cost of goods sold

select left arrow

select save button

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

Save

Define profitability segment characteristics (Segment –level characteristics)

Path: Up to structures the path is same -Define profitability segment Characteristics (Tr code is KEQ3)

Give the operating concern     :BIL1

Enter

For product and customer

Select costing base and account base radio button

Save

Press enter to save in your request

Assign controlling area to operating concern:

Path :SPRO-Enterprise structure –Assignment –Controlling –Assign controlling area to operating concern.

Select position button

Give the controlling area                     :BIL

Enter

For controlling area                             :BIL

Assign operating concern                    :BIL1

Save

Press enter to save in your request

Define no.range for actual postings

Path :SPRO-Controlling –Profitability analysis –Flows of actual values –Initial steps –Define no.range for actual postings (Tr code is KEN1)

Operating concern                   :BIL1

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 :Up to flows of actual values the path is same –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

 Open one more session with  SPRO-Controlling-Profitability analysis –Structures –Set operating concern

Give the operating concern

Select operating concern                     :IDEA

Enter

User the Tr code is KE4I

Come to the first session

Condition type                        :PR00

Value field                  :VV010 (Revenues)

Condition type                        :VPRS (cost)

Value field                  :VV140 (Cost of goods/ Sold)

Save

Press enter to save in your request

Notes :Direct posting from FI/MM

PR00 price                  :VV010 Revenues

Scrap sales/waste sales –Posting only in FI, only FI-No Co account base , if we post manually in FI

If we post directly in FI-for account no.300000-399999 up date VV010 revenues

VPRS costs                 :VV140 cost of goods sold

If we post directly in FI for account no.400000-499999 up date VV140 cost of goods sold

Up to flows of actual value the path is same

(Through path )

Direct posting from FI/MM:Maintain PA transfer structure for direct postings

Tr code is KEI2

Select structure FI (Financial accounting à COPA)

Double click assignment lines folder

Give the controlling area                     :BIL

Enter

Enter once again

Select assignment :20 (Direct revenues from FI)

Double click on source folder

From                            :300000

To                                :399999

Double click on value fields folder

Select new entries button

Quality /value              :Select value filed

Fixed /variable            :Select 1 fixed amounts

Value field                  :select VV010                                    

Save

Press enter to save in your request

Double click on assignment lines folder

Assignment select       :10 Direct cost from FI

Double click on source folder

From                            :400000

To                                :499999

Double click on value fields folder

Select new entries button

Quantity /value           :select value field

Fixed /variable            :select 1 fixed amount

Value field                  :VV140

Save

Activate profitability analysis 

Path :Up to flows of actual values the path is same  à Activate profitability analysis (KEKE)

Select position button

Give the controlling area                     :BIL

Enter

For controlling area                             :BIL

Activate status                                    :select  4 (component activate for both types of profitability analysis)

Save, press enter to save in your request

SD END USER AREA

1. Creation of sales order

Path: Logistics –Sales and Distribution – Sales –Order –Create (Tr code is VA01)

Order type                   :select OR (Standard Order)

Sales organization       :BILS

Distribution Channel   :BD

Division                       :BS

Enter

Sold to party               :200101

P.O.No.                       :1

P.O.Date                     :To days date

Required delivery date :Today’s date

Delivery plant                         :BILP

Payment terms                        :0001

Item                             :10

Material                       :BILFG

Order quantity            :10 kg

Enter

Ignore the message press enter

Select item                  :10

From the menu select Goto 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

Production receipt :

There are two types of production receipt.

1. Production receipt without production order         2. Production receipt with production order

MVT Type:521                                                           MVT Type:101

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                            :BILP

Storage location          :HYD

Enter

Give the material         :BILFG

Quantity                      :50

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 20000 BILFG             BIL2

                                                GBB   

300200 INC/DEC in stocks FG 20000-BILFG BIL2 ZOF

Qty *Standard Price

50*400

Delivery: 

Path : Logistics –Sales & Distribution –Sales –Order –Sub request functions –Outbound delivery (Tr code is VL01N)

Shipping post              :BILH

Give the order no.       :11764

Enter

Actual goods issue date          :Today’s 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

Select accounting document no.

Double click on accounting document no.

200122 Inventory FG 4000-BILFG   BSX is assign this A/c BIL2

300200 INC/DEC in stocks FG 4000 BILFG GBB VAY assigned to BIL2

Qty delivered *Standard price

10*400

Sales billing

Path :Up to sub sequent functions the path is same –Billing  document(Tr code is  VF01)

(Through path)

Select Delivery document no.

Execute

Save

From the menu select Billing document-Display-Select accounting button

Double click on accounting document no.

200100 DLF Industries Limited 6000 customer no.is taken from sales order

300005 Sales local own goods 6000-ERL

Qty sold *Sale price

10*600