| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OEE/MPH_KPITARG | Plant Hierarchy KPI Target Details | 11 | TARGET4 | OEE KPI Target | decimal | 31 | 14 | | |
TOPFunds Management |
2 | FMDERIVE002 | Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/ | 12 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
3 | FMDERIVE004 | Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F | 10 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
4 | FMDERIVE005 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 8 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
5 | FMDERIVE006 | Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/ | 10 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
6 | FMDERIVE008 | Profit Ctr/CE to Commit Item/Funds Center/Fund/Function | 10 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
7 | FMDERIVE009 | Derivation rule:Profit Center to Commitment Item/Funds Ctr/F | 8 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
8 | FMDT_CHANGEDOC | Empty table for change document on DRULE derivation tables | 7 | TARGET4 | Target value from Derivation table | nvarchar | 60 | 0 | | |
TOPGeneral Application Functions |
9 | FMFMOAID38000016 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 8 | TARGET4 | Functional Area | nvarchar | 16 | 0 | | |
10 | FMFMOAID38000042 | Derivation rule:Cost Center to all | 10 | TARGET4 | Grant | nvarchar | 20 | 0 | | |
TOPProfitability Analysis |
11 | K9RID38000026 | Derivation Rule: Assignment at Material Type / Plant Level | 16 | TARGET4 | Plant used for reading cost estimate | nvarchar | 4 | 0 | | |
12 | K9RID38000030 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 14 | TARGET4 | Type of error handling | nvarchar | 1 | 0 | | |