| Table sharing for financial integration mappingSpecific rules apply to sharing of the mapping scheme and
reconciliation tables in a multicompany structure. General rules In LN,
the mapping scheme must always be centralized in such a way that all financial
companies that share the Companies (tcemm170) table must share the mapping
scheme. If a specific financial company needs to use a different mapping
for specific transactions, to set up the mapping for that company, you must
enter the financial company number in, for example, the Ledger Mapping (tfgld4569m000) session rather than leave the Financial Company field blank. In a multicompany structure, the financial companies must
share many of the financial tables while other tables must not be shared. The
following general rules apply: Financial integration tables All the companies must share all the tables of the Finance/Logistics module. Integration ledger accounts The companies of a multicompany structure must use the same
integration ledger accounts. To achieve this, you can share the Chart of
Accounts (tfgld008) table or define exactly the same integration ledger
accounts in the individual companies. In addition, the companies must either
share the Dimensions (tfgld010) table or define the same dimensions in every
company to use the same dimensions. Transaction types and series The companies of a multicompany structure must also use the
same transaction types and series. To achieve this, you can either define
exactly the same transaction types in every company or share the Transaction
Types (tfgld011) table. The Series (tfgld017) table must not be shared.
However, the series used in the Mapping Scheme (tfgld477) table must be defined
in each financial company. Exceptions Exceptions to these rules are permitted. In the financial
company in which a common integration account or a dimension does not exist,
you must map the elements to another ledger account or dimensions specifically
for that company, in the Ledger Mapping (tfgld4569m000) session or the Dimension Mapping (tfgld4571m000) session. If a common transaction type does not exist,
you must define a specific transaction type for the integration document types
for the financial company, on the Document Numbering and Compression tab of the Mapping Scheme (tfgld4573m000) session. Transactions table Sharing the Integration Transaction (tfgld482) table and the
Reconciliation Transactions (tfgld495) table is not compulsory. Due to the
large amount of data that each company stores in the Reconciliation Data
(tfgld482) table, LN does not recommend that you share this table. However, the decision of whether
or not to share this table also depends on the specific system and database
features, as well as the reconciliation needs.
Table Sharing Modeler You can use the Table Sharing Modeler to set up the required
table sharing structure. All financial companies that share the Companies
(tcemm170) table must share the tables of the Central Integration Mapping
(R10100) table set. | |