Skip to Content
Author's profile photo Ravi Sankar Venna

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

Assigned Tags

      42 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Prathap. 🙂

      Glad to know you liked my blog and hope it will be useful to you.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Very helpful information...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Naresh. 🙂

      Best Regards,

      Ravi

      Author's profile photo Selvakumar Natarajan
      Selvakumar Natarajan

      useful information, everything in a single matrix , wonderful work , best regards . n.selvakumar

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Natarajan. 🙂

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Srinivas, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Save as your previous blogs,this one was also a cracker!

      Thanks for the help extended to the FI fraternity

      Regards,

      Gaurav

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Gaurav, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Vinod Vemuru
      Vinod Vemuru

      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 😉

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Ranu Eugene
      Ranu Eugene

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Eugene, much appreciated your encouragement and comments. 🙂

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hello Ravi

      Nice docs and presented it nice way

      Thanks lot for sharing

      Thanks & Regards

      Sampath

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Sampath, much appreciated your comments.

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hello Ravi,

      Thanks much! Valuable summary.

      Regards,

      Leelendra

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Leelendra 🙂

      Kind Regards,

      Ravi

      Author's profile photo Arvind Pereira
      Arvind Pereira

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Great work.  Good refreshment for interview point of view.

      Thanks for sharing this valuable information.

      Regards,

      Balaji Bharath. N

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Balaji, hope it would help you.

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      its really useful correlation .....for my present nature of work...

      Great consolidation...

      Thank you

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Thiyagarajan. 🙂

      Author's profile photo Dawood Khalid
      Dawood Khalid

      That's really something owsom !!!

      Author's profile photo manu m
      manu m

      Good one Ravi...:)

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Manu 🙂

      Author's profile photo Ganesh Sadula
      Ganesh Sadula

      Thanks Ravi SIR for innovative thing..

      its  very useful document ..

      With regards,

      Ganesh

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo CH Raman
      CH Raman

      Great job Ravi. Very useful information. Thanks for sharing

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Raman

      Author's profile photo Former Member
      Former Member

      As usual, super blog ! 🙂

      Thanks,

      Ankur

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Ankur 🙂

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Very good analysis and useful information in single matrix.

      Regards,

      Umamageshwaran.S

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Uma, hope it would be useful to you.

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Very good analysis and useful information in single matrix.

      Regards,

      Umamageshwaran.S

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Ravi,

      Simply Superb nothing to say more than this 🙂

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi Ravi garu ,

      Thank you for sharing Valuable information ..

      Regards

      Sada Bandla

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Master!

      Excellent and perfect. ➕ 🙂 ➕

      Thank you for sharing your knowledge.

      all the best Erwin

      Author's profile photo Balakrishna Naidu
      Balakrishna Naidu

      Hi Ravi Sir,

      Great & Smart work !!!!!!! 🙂      

      it's very useful Document.

      Thanks a lot RAVI Sir...

      Bala