Skip to Content
0
May 02, 2012 at 07:01 AM

How to manage master data correctly direct to DB of Financial Consolidation?

21 Views

Hello!

We have installed SAP BO Financial Consolidation 10.

There is a dimension called CONTRACT with db table ct_0100_contract.

When I insert new rows with the SQL INSERT operator to this table They don't appear in Financial Consolidation thick client.

All of the following fields are filled as if I would insert the row manually in Financial Consolidation thick client.

ID - filled by autoincrement

OWNER_SITE = -1

OWNER_WORKGROUP_ID = 0

ACCESS_MODE = 0

CREATION_DATE = UPDATE_DATE = current system datetime

AUTHOR_ID = UPDATE_AUTHOR_ID = id of user ADMIN

What's wrong?