Dear reader,
For background on Results Analysis, you may refer to my previous blog, “Calculating Results Analysis for Internal Orders“, where we took a deep dive into the business requirement & the configuration required for performing Results Analysis and calculating the WIP amount.
In order to have an idea of the whole life of an Internal Order which is used for managing the costs & revenues posted over a couple of months, please take a look at the flow below:
What kind of G/L Accounts are posted to when WIP is posted to FI?
Ans. : Two types of G/L Accounts, a P&L Account, and a Balance Sheet Account.
Why?
Well, let us first try to understand what the WIP amount is and why it is posted to FI.
WIP amount can be considered as an expense which is yet to generate a Revenue.
Since an expense posting is done but the corresponding Revenues are not recorded yet, the Income Statement (or P&L statement) would give an impression that expenses are more as compared to the Revenue.
So, in order to display a more correct picture of a company’s financial situation, the burden on P&L statement is knocked-off by posting the WIP to a BS Account.
Hence, when WIP is posted, the accounting document will have 2 line items,
Debit: A BS Account
Credit: A P&L Account
What is the configuration required for posting WIP, and reporting Cost of Sales & Revenue to CO-PA?
Please note that no matter which method you use for results analysis, the configuration required for the settlement of the calculated amounts to COPA, FI & EC-PCA remains the same.
A) Configuration steps required for posting WIP Amounts to FI & EC-PCA:
Step A1. Create two G/L Accounts, a P&L Account, and a Balance Sheet Account.
(The purpose of having these two G/L Accounts has already been explained earlier.)
‘License Costs Transfer (P&L Acc.)’ – 40000900
(This G/L Acc. must not be created as a Cost Element)
‘License Costs WIP (BS Acc.)’ – 22000900
Step A2. Assign these two G/L Accounts to RA Category ‘WIPR’.
IMG Path – Controlling>Product Cost Controlling>Cost Object Controlling>Product Cost by Sales Order>Period-End Closing>Results Analysis>Define Posting Rules for Settlement to Financial Accounting
B) Configuration steps required for the settlement of Cost of Sales & Revenue to CO-PA:
Step B1. Create an Allocation structure.
The settlement of data to Profitability Analysis is controlled by an Allocation structure.
It is a set-up, which links Sender Cost elements to Receiver Cost Elements.
The below illustration tries to visualize the purpose & constituents of an Allocation structure.
Create an Allocation structure N1. (T-code OKOA)
Now, we need to create two ‘Assignments’,
N11 – For the settlement of Revenue Affecting Net Income
N12 – For the settlement of Cost of Sales (or Costs Affecting Net Income)
Here, the ‘Source’ of Assignment N11 is the Cost Element in CE Group ZCEGRP01.
We have only one Cost element in this group.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31) – (After Results Analysis, ‘Revenue Affecting Net Income’ is stored in this CE.)
Next, we need to define the Cost element to which the costs will be settled.
We use a Cost Element of Category 21 (Internal Settlement) for this purpose.
License Revenue Settlement Acc. (92100202)
For a settlement to CO-PA, the settlement category must be ‘PSG’ (Profitability Segment).
This completes the setup of Assignment N11.
Next, we set up Assignment N12 with the same underlying concept.
Here, the ‘Source’ of Assignment N12 is the Cost Element in CE Group ZCEGRP02.
We have only one Cost element in this group.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31)
(After Results Analysis, Cost of Sales is stored in this CE.)
Step B2. Create a PA Transfer structure.
A PA Transfer structure is a rule or a set-up, which will link Cost elements to CO-PA Value fields.
The below illustration tries to visualize the purpose & constituents of a PA Transfer structure.
Create a PA Transfer structure ‘N1’. (T-code OKOA)
Create two Assignment lines each for License Revenues & License costs.
The ‘Source’ of Assignment Line N11 contains the below Cost Element in CE Group ZCEGRP01.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31)
(After Results Analysis, Revenue Affecting Net Income is stored in this CE.)
We assign the above Cost element to a Value field called ‘License Revenues’ (VVA04).
Similarly, create another Assignment Line ‘N12’ for License Costs.
The ‘Source’ of Assignment Line N12 contains the below Cost Element in CE Group ZCEGRP02.
‘COGS Revenue for License’ – 93120003 (Sec. CE of CE Category 31)
(After Results Analysis, Cost of Sales is stored in this CE.)
We assign the above Cost element to a Value field called ‘License Costs’ (VVC05).
Step B3. Create a settlement profile.
Default the above created Allocation Structure and PA Transfer Structure to this settlement profile.
IMG path –> Controlling> Product Cost Controlling> Cost Object Controlling> Product Cost by Sales Order> Period End Closing> Settlement> Create Settlement Profile
Step B4. Assign the above settlement profile to your Order type.
T-code KOT2_OPA.
This defaults the settlement profile when you create an Internal Order master data.
However, please note that unlike the settlement profile, the ‘Results Analysis key’ cannot be set as default through Order type.
You need to create a Model order for that purpose.
With this last step, the configuration required for settlement is over, and we are ready to execute an order settlement.
Let us take the same business scenario as in my previous blog, say for a certain Internal order which captures the costs and revenues of License, below was the Results Analysis at a certain period end.
(RA Method Used in this example = (01) Revenue-Based Method with Profit Realization)
Perform RA for the Order and save it. (T-code KKA1)
Let us do a little bit of calculation here.
For the Internal Order in this example,
Total Costs planned = 80,000
Total Revenue planned = 100,000
Actual costs = 60,000
Actual Revenue = 50,000
So, Cost of Sales is calculated as
C(PA) = PoC * C(p)
= R(a)/R(p) * C(p)
= 50,000/100,000*80,000
= 40,000
Revenue Affecting Net Income = PoC * R(p) = R(a) = 50,000
WIP = Actual costs – Cost of Sales
= 60,000 – 40,000 = 20,000
Once the RA Analysis is saved, the below entries are created in Table COSB.
Finally, perform settlement of the Internal Order. (T-code KO88)
Settlement Results:
Observe that the Sender is Internal Order (ORD LTEST01) & Receiver is a Profitability Segment (PSG).
However, please note that the PSG is only posted statistically.
As a result of this settlement, the below types of documents are posted:
Accounting Document generated for WIP posting to FI:
As we can observe from the below document, the WIP Amount is Credited from P&L Account and Debited to the BS Account.
Profit Center Document generated as a result of posting to EC-PCA:
CO-PA Document line item showing that Value fields are updated with Revenue and Cost of Sales.
Controlling Document generated on account of statistical posting from Internal Order to Profitability Segment:
Accounting Document generated with reference to CO document posted for transferring Cost of Sales & Revenue to CO-PA.
A few important observations:
If EC-PCA is active in the system, and the WIP BS Account and P&L Account is maintained in 3KEH (or FAGL3KEH), then a Profit Center Document will be posted automatically.
I hope this blog was able to explain not only the configuration required for an order settlement, but also the concepts behind WIP posting to FI; as well as Cost of Sales & Revenue posting to CO-PA.
Okumaya devam et...
For background on Results Analysis, you may refer to my previous blog, “Calculating Results Analysis for Internal Orders“, where we took a deep dive into the business requirement & the configuration required for performing Results Analysis and calculating the WIP amount.
In order to have an idea of the whole life of an Internal Order which is used for managing the costs & revenues posted over a couple of months, please take a look at the flow below:
Life of an Order
What kind of G/L Accounts are posted to when WIP is posted to FI?
Ans. : Two types of G/L Accounts, a P&L Account, and a Balance Sheet Account.
Why?
Well, let us first try to understand what the WIP amount is and why it is posted to FI.
WIP amount can be considered as an expense which is yet to generate a Revenue.
Since an expense posting is done but the corresponding Revenues are not recorded yet, the Income Statement (or P&L statement) would give an impression that expenses are more as compared to the Revenue.
So, in order to display a more correct picture of a company’s financial situation, the burden on P&L statement is knocked-off by posting the WIP to a BS Account.
Hence, when WIP is posted, the accounting document will have 2 line items,
Debit: A BS Account
Credit: A P&L Account
What is the configuration required for posting WIP, and reporting Cost of Sales & Revenue to CO-PA?
Please note that no matter which method you use for results analysis, the configuration required for the settlement of the calculated amounts to COPA, FI & EC-PCA remains the same.
A) Configuration steps required for posting WIP Amounts to FI & EC-PCA:
Step A1. Create two G/L Accounts, a P&L Account, and a Balance Sheet Account.
(The purpose of having these two G/L Accounts has already been explained earlier.)
‘License Costs Transfer (P&L Acc.)’ – 40000900
(This G/L Acc. must not be created as a Cost Element)
‘License Costs WIP (BS Acc.)’ – 22000900
Step A2. Assign these two G/L Accounts to RA Category ‘WIPR’.
IMG Path – Controlling>Product Cost Controlling>Cost Object Controlling>Product Cost by Sales Order>Period-End Closing>Results Analysis>Define Posting Rules for Settlement to Financial Accounting
B) Configuration steps required for the settlement of Cost of Sales & Revenue to CO-PA:
Step B1. Create an Allocation structure.
The settlement of data to Profitability Analysis is controlled by an Allocation structure.
It is a set-up, which links Sender Cost elements to Receiver Cost Elements.
The below illustration tries to visualize the purpose & constituents of an Allocation structure.
Allocation Structure
Create an Allocation structure N1. (T-code OKOA)
Now, we need to create two ‘Assignments’,
N11 – For the settlement of Revenue Affecting Net Income
N12 – For the settlement of Cost of Sales (or Costs Affecting Net Income)
Here, the ‘Source’ of Assignment N11 is the Cost Element in CE Group ZCEGRP01.
We have only one Cost element in this group.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31) – (After Results Analysis, ‘Revenue Affecting Net Income’ is stored in this CE.)
Next, we need to define the Cost element to which the costs will be settled.
We use a Cost Element of Category 21 (Internal Settlement) for this purpose.
License Revenue Settlement Acc. (92100202)
For a settlement to CO-PA, the settlement category must be ‘PSG’ (Profitability Segment).
This completes the setup of Assignment N11.
Next, we set up Assignment N12 with the same underlying concept.
Here, the ‘Source’ of Assignment N12 is the Cost Element in CE Group ZCEGRP02.
We have only one Cost element in this group.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31)
(After Results Analysis, Cost of Sales is stored in this CE.)
Step B2. Create a PA Transfer structure.
A PA Transfer structure is a rule or a set-up, which will link Cost elements to CO-PA Value fields.
The below illustration tries to visualize the purpose & constituents of a PA Transfer structure.
PA Transfer Structure
Create a PA Transfer structure ‘N1’. (T-code OKOA)
Create two Assignment lines each for License Revenues & License costs.
The ‘Source’ of Assignment Line N11 contains the below Cost Element in CE Group ZCEGRP01.
‘COGS Revenue for License’ – 93120007 (Sec. CE of CE Category 31)
(After Results Analysis, Revenue Affecting Net Income is stored in this CE.)
We assign the above Cost element to a Value field called ‘License Revenues’ (VVA04).
Similarly, create another Assignment Line ‘N12’ for License Costs.
The ‘Source’ of Assignment Line N12 contains the below Cost Element in CE Group ZCEGRP02.
‘COGS Revenue for License’ – 93120003 (Sec. CE of CE Category 31)
(After Results Analysis, Cost of Sales is stored in this CE.)
We assign the above Cost element to a Value field called ‘License Costs’ (VVC05).
Step B3. Create a settlement profile.
Default the above created Allocation Structure and PA Transfer Structure to this settlement profile.
IMG path –> Controlling> Product Cost Controlling> Cost Object Controlling> Product Cost by Sales Order> Period End Closing> Settlement> Create Settlement Profile
Step B4. Assign the above settlement profile to your Order type.
T-code KOT2_OPA.
This defaults the settlement profile when you create an Internal Order master data.
However, please note that unlike the settlement profile, the ‘Results Analysis key’ cannot be set as default through Order type.
You need to create a Model order for that purpose.
With this last step, the configuration required for settlement is over, and we are ready to execute an order settlement.
Let us take the same business scenario as in my previous blog, say for a certain Internal order which captures the costs and revenues of License, below was the Results Analysis at a certain period end.
(RA Method Used in this example = (01) Revenue-Based Method with Profit Realization)
Perform RA for the Order and save it. (T-code KKA1)
Let us do a little bit of calculation here.
For the Internal Order in this example,
Total Costs planned = 80,000
Total Revenue planned = 100,000
Actual costs = 60,000
Actual Revenue = 50,000
So, Cost of Sales is calculated as
C(PA) = PoC * C(p)
= R(a)/R(p) * C(p)
= 50,000/100,000*80,000
= 40,000
Revenue Affecting Net Income = PoC * R(p) = R(a) = 50,000
WIP = Actual costs – Cost of Sales
= 60,000 – 40,000 = 20,000
Once the RA Analysis is saved, the below entries are created in Table COSB.
| Category for Variance/Results Analysis | Short Description |
| WIPR | Work in Process with Requirement to Capitalize |
| CAPP | Capitalized Profit |
| COSR | Cost of Sales with Requirement to Capitalize |
| CLCO | Calculated Costs |
| CLRV | Calculated Revenue |
| VLCO | Valuated Costs |
| VLRV | Valuated Actual Revenue/Revenue Affecting Net Income |
Finally, perform settlement of the Internal Order. (T-code KO88)
Settlement Results:
Observe that the Sender is Internal Order (ORD LTEST01) & Receiver is a Profitability Segment (PSG).
However, please note that the PSG is only posted statistically.
As a result of this settlement, the below types of documents are posted:
- Accounting (FI) Document. (2 No. of Docs.)
- Profit Center Account (PCA) Document.
- Controlling (CO) Document.
- Profitability Analysis (PA) Document.
Accounting Document generated for WIP posting to FI:
As we can observe from the below document, the WIP Amount is Credited from P&L Account and Debited to the BS Account.
Profit Center Document generated as a result of posting to EC-PCA:
CO-PA Document line item showing that Value fields are updated with Revenue and Cost of Sales.
Controlling Document generated on account of statistical posting from Internal Order to Profitability Segment:
Accounting Document generated with reference to CO document posted for transferring Cost of Sales & Revenue to CO-PA.
A few important observations:
- Since the settlement to CO-PA is a statistical transfer of costs, the Internal Order is not credited during this settlement. (PSG here is a statistical cost object)
- No Special Configuration is required for posting WIP to EC-PCA.
If EC-PCA is active in the system, and the WIP BS Account and P&L Account is maintained in 3KEH (or FAGL3KEH), then a Profit Center Document will be posted automatically.
I hope this blog was able to explain not only the configuration required for an order settlement, but also the concepts behind WIP posting to FI; as well as Cost of Sales & Revenue posting to CO-PA.
Okumaya devam et...