on 05-30-2011 12:41 PM
Dear Experts,
We have created Plant and Profit Center at State Level and we have storage location in MM side and Sales group in SD side from where the Sales and Purchase both will happen.
the formula for calculating Profitability is = Sales - purchase- Overheads
I want to know that If I create Sales group as my Charecteristic Field what will be my Value field and how do we map so that we can get Profitability Report Sales group wise.
We have Product Costing in Place, Profit Centers are at Plant level and Cost centers are at Storage Location Wise.
Please advise..
Regards,
Vivek Srivastava
Hi Vivek
Value Fields will be based on what values you wanna see in COPA... i.e Revenues, COGS, Overheads
Revenue wil come from SD Billing (KE4I)
COGS - From SD Billing (KE4I)
Overheads - Assessment cycle (KEu5)
br, Ajay M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
First for revenue, you need to map the SD Condition Types to value fields in COPA. You need to create Value Fields, such as Revenue, COGS, Taxes etc. These will be linked to SD Condition Types
There after, you need to transfer costs booked through FI against a Cost Center by Assesement Rule KEU5. If you are using IO, you can settle it to COPA through CO88/KO88
There after, define a report as per your requirements
Regards
Sanil Bhandari
For Product Costing, only the variances will be settled to COPA. The Material cost will come from your billing invoice when you assign the material cost condition type (Generally VPRS) to your Value Field for COGS.
Regarding your other query, it all depeneds on how you want to see the profitability. One you maintain the required config for Billing, FI-MM Posting, Order Settlement, your data flow to COPA. This needs to be presented as per your requirements.
Regards
Sanil
Solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to map the SD conditions to the value fields via KE4I to get the required values in COPA. Then you can calculate the profitability in the KE30 reports as per your requirement by the relevant formulas.
Creating sales group as a characteristic should not have any effect on the KE4I mapping. Its just that reporting will be more consolidated when reporting at the sales group level.
regards
Waman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.