Linkage between various Finance & Controlling Master Data
This gives linkage between various masters of FI and CO
This could be handy for Certification / interviews / refreshing the basics.
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||
| Sl. | Particulars | GL | AP | AR | BANK | HOUSE BANK | COST ELEMENT | COST CENTER | ACTIVITY TYPE | SKF | INTERNAL ORDER | PROFIT CENTER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | Highest Object | CHART OF ACCOUNTS | CLIENT | CLIENT | COUNTRY | COMPANY CODE | CO AREA | CO AREA | CO AREA | CO AREA | CO AREA | CO AREA |
| B | Second Level | ACCOUNT GROUP | ACCOUNT GROUP | ACCOUNT GROUP | N/A | BANK KEY | PRIMARY/SECONDARY | STANDARD HIREARCHY | N/A | N/A | ORDER TYPE | STANDARD HIREARCHY |
| C | Any Type / Category | P&L AND BAL.SHEET | ONE TIME & REGULAR | ONE TIME & REGULAR | NIL | NIL | External / Settlement / Reducing Costs / Revenues | Cost Center Category | Activity Type Category | NIL | Statistical / Real | NIL |
| D | Number Ranges | Account Group (External) | Account Group (Int / Ext) | Account Group (Int / Ext) | NIL | NIL | Primary – GL A/c Secondary – Nil | NIL | NIL | NIL | Order Type | NIL |
| E | Link To | |||||||||||
| Single Company Code | YES | YES | YES | NO | YES | N/A | YES | NA | NA | YES | YES | |
| Multiple Company Code | YES | YES | YES | NO | NO | N/A | NO | NA | NA | NO | YES | |
| F | Field Status | Account Group | Account Group / Activity Type / Company Code level |
Account Group / Activity Type / Company Code level |
NIL | NIL | Time Bounded Tr.Cd = okek | Time Bounded Tr.Cd = okeg | Time Bounded Tr.Cd = okei | NIL | Order Type | Time Bounded Tr.Cd = 0ke7 |
| G | No. of Segments | a) Chart of A/cs b) Company Code Seg | a) Gen. Segment b) Company Code C) Purchasing Org. Seg. | a) Gen. Segment b) Company Code C) Sales Area Seg | NIL | NIL | NIL | NIL | NIL | NIL | NIL | NIL |
| H | Business Area | |||||||||||
| Direct | NO | NO | NO |
NO |
YES |
YES |
YES |
NO |
N/A | YES |
N/A |
|
| Indirect | YES | YES | YES | NO | YES | YES | YES | YES | N/A | YES | N/A | |
| I | Block | a) Company Code b) COA | Company Code Level | Company Code Level | NO | NO | NO | NO | NO | NO | NO | NO |
| J | Lock | NO | YES | YES | NO | NO | NO | YES | YES | YES | YES | YES |
| K | Planning | YES Transaction Code = fse5n | NO | NO | NO | NO | YES | YES | YES | YES | YES | YES |
| L | Currency Control | YES | NO | NO | NO | YES | NO | NO | NO | NO | YES | YES |
| M | Link to Masters | |||||||||||
| Direct |
2,3,5,6 |
1,3,4,5 | 1,2,4,5 | 2,3,5 | 1,2,3,4 | 1,7,10,11 – P 7,8,10(*) -S | 6,11,10(+) | 6 | ‘– | 6,7,11 | 6,7,10 | |
| Indirect | 7,10,11 | 7(/),11 | 11(=) | ‘– | ‘– | 11 | 1,2,8 | 11,7 | ‘– | 1 | 1,2,3,6,8 | |
| N | Link to Transactions | |||||||||||
| Direct | 2,3,5,6,7,10,11 | 1,3,4,5 | 1,2,4,5 | 2,3,5 | 1,2,3,4 | 1,7,10,11 – P 7,8,10(*) -S | 6,11,10(+) | 6 | ‘– | 6,7,11 | 6,7,10 | |
| Indirect | 7,10,11 (Determination) | 11 | 11 | ‘– | ‘– | 8,11 | 1,11 | 6,11 | ‘– | 1 | 1,2,3,6,7,8 | |
| O | Currency | Local Currency, Parallel Currency, Transaction Currency, Group Currency for Company Only | Local Currency, Parallel Currency, Transaction Currency | Local Currency, Parallel Currency, Transaction Currency | ‘– | Local Currency | Local Currency, Transaction Currency, Controlling Area Currency | Local Currency, Transaction Currency, Controlling Area Currency, Cost Center Currency | Any Currency for Planning OR Controlling Currency | ‘– | Any Currency for Planning OR Internal Order Currency | Local Currency, Transaction Currency, Profit Center Currency |
| P | Restriction of Currency | YES | YES | YES | ‘– | ‘– | NO | NO | NO | NO | NO | NO |
FI Masters Delete: Can be deleted through IMG Only. This is possible only in case if there are no entries exists. If there is a single entry posted, you cannot delete these Masters for life time
CO Masters Delete: You may delete if there are no entries during the year. You cannot delete these Master in case if there is any entry during the year. However, in the later case you may delete in next Fiscal year
10(*) – Statistical – Yes, Real – No
10(+) – For Internal Order
7(/) – Through HR Module
11(=) – Through Sales Order
Hi Mr. Ravi,
Thank you Very much and should be appreciated for the information. It is Very useful.
Waiting for next blog from you.
Best Regards
Prathap KV Reddy
Thanks Prathap. 🙂
Glad to know you liked my blog and hope it will be useful to you.
Kind Regards,
Ravi
Very helpful information...Many Thanks.
Best Regards,
Naresh K.
Thank you Naresh. 🙂
Best Regards,
Ravi
useful information, everything in a single matrix , wonderful work , best regards . n.selvakumar
Thanks Natarajan. 🙂
Hi Ravi,
Information can be available if we spend some time on google. But the way you presented is awesome!!! Really smart work....
BR, Srinivas Salpala
Thanks Srinivas, much appreciated your comments.
Kind Regards,
Ravi
Hi Ravi,
Save as your previous blogs,this one was also a cracker!
Thanks for the help extended to the FI fraternity
Regards,
Gaurav
Thanks Gaurav, much appreciated your comments.
Kind Regards,
Ravi
I like your amazing presentation skills Ravi 🙂 . We can always learn something from your blogs/articles. If the topic is known to us, we learn how to present the topic and catch the pulse of audience. If the topic is unknown, we learn both topic and presentation. Keep going buddy. Now, I started reading all your old articles and blogs 😉
Ha ha ha ha, thanks Vinod for your cheering comments.
Glad that you liked the content, hope they are useful to you.
Kind Regards,
Ravi
Hi Ravi,
Again a masterpiece with perfection.
Superb blog with very good information. 🙂
Waiting for the next Blog. 😉
Thanks for sharing. 🙂
Best of Luck.
Regards
Eugene
Thanks Eugene, much appreciated your encouragement and comments. 🙂
Kind Regards,
Ravi
Hi Ravi
Nice Blog... and informative . One small addition in Internal Order in serial C along with type of order real and statistical below category also could be inculded CO-Production Order (04), PPC-Production Order (10), Maintenance Order (30).
Regards
Parth Bhatt
Hi Parth,
Thanks for your comments. The details you mentioned are order categories. There are many categories in the system. You can add further columns and rows to this matrix to gain more and more information.
Regards,
Ravi
Hello Ravi
Nice docs and presented it nice way
Thanks lot for sharing
Thanks & Regards
Sampath
Thanks Sampath, much appreciated your comments.
Regards,
Ravi
Hello Ravi,
Thanks much! Valuable summary.
Regards,
Leelendra
Thank you Leelendra 🙂
Kind Regards,
Ravi
Hi Ravi,
Am not able to view the last column very clearly, some text gets cut off, could you remove the Sl no. and re-post the content, may be reducing the size by one notch or so
Instead of Chart of accounts, use COA, instead of Yes, use Y, & N, Co code, a/c group, there by the table keeps getting smaller and compact, which is fitable, the work however is impressive buddy, keep it coming
thx
Arvind Leo Pereira
Hi Arvind,
I do not see any problem.
There is a scroll bar to the right side. You will find the the scroll bar at the end of the table. if you move that scroll bar towards right, you should be able to see the full table. The whole table can be copied and pasted in excel.
Best Regards,
Ravi
Hi Ravi,
Great work. Good refreshment for interview point of view.
Thanks for sharing this valuable information.
Regards,
Balaji Bharath. N
Thanks Balaji, hope it would help you.
Best Regards,
Ravi
its really useful correlation .....for my present nature of work...
Great consolidation...
Thank you
Thanks Thiyagarajan. 🙂
That's really something owsom !!!
Good one Ravi...:)
Thanks Manu 🙂
Thanks Ravi SIR for innovative thing..
its very useful document ..
With regards,
Ganesh
Thanks Ganesh, this is the document that we have prepared after our training at Genovate in 2003. Fortunate that I still preserved that document. Hope that it is useful to you 🙂
Best Regards,
Ravi
Great job Ravi. Very useful information. Thanks for sharing
Thanks Raman
As usual, super blog ! 🙂
Thanks,
Ankur
Thanks Ankur 🙂
Hi Ravi,
Very good analysis and useful information in single matrix.
Regards,
Umamageshwaran.S
Thanks Uma, hope it would be useful to you.
Best Regards,
Ravi
Hi Ravi,
Very good analysis and useful information in single matrix.
Regards,
Umamageshwaran.S
Hi Ravi,
Simply Superb nothing to say more than this 🙂
Thanks & Regards,
Lakshmi S
Hi Ravi garu ,
Thank you for sharing Valuable information ..
Regards
Sada Bandla
Hello,
Master!
Excellent and perfect. ➕ 🙂 ➕
Thank you for sharing your knowledge.
all the best Erwin
Hi Ravi Sir,
Great & Smart work !!!!!!! 🙂
it's very useful Document.
Thanks a lot RAVI Sir...
Bala