Skip to Content
Actions

Linkage between various Finance & Controlling Master Data

September 9, 2013 | 128 Views |
 enterprise resource planningsap erp financials
Follow

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

To report this post you need to login first.

42 Comments

You must be Logged on to comment or reply to a post.

  6. 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 😉

    (0) 
  7. 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

    (0) 
  8. PARTH BHATT

    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

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
  11. 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

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
    1. Ravi Sankar Venna 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

      (0) 

Leave a Reply