Hi Friends!
This is the continuation of a blog I wrote some time ago related to Transportation Management and its integration with Material Ledger - Cost component split.
There is the link to the original blog:
Tm-raw-material-material-ledger-ccs
If you noticed, this is my new SDN account
😃
In resume, this old blog show:
- a purchasing flow of a raw material.
- Transportation costs added with TM module
- In what way this could be reflected in the cost component split CCS in the material ledger.
The previous blog covered the end to end process, that includes: the creation of a freight unit, then the freight order, post the Service entry Sheet SES to the accountancy and finally update the material cost and reflect in the cost component split of the material.
A lot of people asked me questions here and there about this topic, in particular "How to map a CCS element in Material ledger posting from TM?"
The short response is: mostly in the same way as you do in MM or LE-TRA. Here in this blog i'll put the details to keep in mind when you build this scenario in your system. Let's start!
1: You must first identify the condition that will be used on Settlement Management to post the freight cost!. I use the standard condition WTF1 in TM to post the Invoice on my example. Important to consider, we are talking about the Settlement Management condition, not the service entry sheet condition.
>>> The next screen is a new example i just build, here you see the condition WF01, and the value of 90k COP. You can use transaction WLFLTM2 - Overview Freight Cost Distribution to find the settlement document.
In the Pricing Elements, you can see the condition.
2: Then, you need to assign this condition to an Origin Group. As you know, originh groups are the link to a CCS element in product costing and material ledger. This is the KEY to the configuracion! Here is an example of the assignment of Origin group FR01 to TM condition WTF1, you do it for specific company codes. In the next example, i include our example CO01 company code, and PE01.By the way, I'm preparing a scenario of TM on intercompany sales that will consider this 2 company codes!!
3. In order to allocate to an element in the CCS, you need to know the GBB-VBR account of the material you are purchasing. The easiest way to do this is on table T030 that is the heart of the OBYC configuration.
4. In the CCS definition on OKTZ, insert the combination of the account and the origin group you assigned to the condition. In this example, CCS is R2, the chart of account is INT that comes in the best practices, the account, origin group, and the cost component element id.
That's is! Simple, short and direct.
The result is the following: When you post additive cost from TM, this cost will be reflected on the ML Kardex, in a specific element: in my Example, "Transportation". See the next screen.
Here you see the GR of the purchase order is under the category "Purchase Order", and the TM Settlement document is under the category Procurement, in the Colum "Transportation".
Wish this help you in your projects. Have you ever worked with TM? Please don't forget to comment if you like this post .
Arturo.
PS. Im preparing more HOW-TO guides related to the integration between Material Ledger and other modules.
--------------------------------------------------------------------------------------------------------------------------------------
@ The images and the model be created by me, Arturo Senosain on a demo client. Material ZROH, CCS R2 (Ar-Two), and account &71xx where created by me to show the flow!