| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OEE/MPH_KPITARG | Plant Hierarchy KPI Target Details | 10 | TARGET3 | OEE KPI Target | decimal | 31 | 14 | | |
TOPFunds Management |
2 | FMDERIVE002 | Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/ | 11 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
3 | FMDERIVE004 | Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F | 9 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
4 | FMDERIVE005 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 7 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
5 | FMDERIVE006 | Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/ | 9 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
6 | FMDERIVE008 | Profit Ctr/CE to Commit Item/Funds Center/Fund/Function | 9 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
7 | FMDERIVE009 | Derivation rule:Profit Center to Commitment Item/Funds Ctr/F | 7 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
8 | FMDT_CHANGEDOC | Empty table for change document on DRULE derivation tables | 6 | TARGET3 | Target value from Derivation table | nvarchar | 60 | 0 | | |
TOPGeneral Application Functions |
9 | FMFMOAID38000016 | Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func | 7 | TARGET3 | Fund | nvarchar | 10 | 0 | | |
10 | FMFMOAID38000042 | Derivation rule:Cost Center to all | 9 | TARGET3 | Funds Center | nvarchar | 16 | 0 | | |
TOPProfitability Analysis |
11 | K9RID34000025 | Derivation rule:Template determination for sales processes | 9 | TARGET3 | Additional update characteristic | nvarchar | 30 | 0 | | |
12 | K9RID34000026 | Derivation rule:Template determination for sales processes | 9 | TARGET3 | Additional update characteristic | nvarchar | 30 | 0 | | |
13 | K9RID38000012 | Derivation Rule: Procedure Determination for Sales Processes | 9 | TARGET3 | Additional update characteristic | nvarchar | 30 | 0 | | |
14 | K9RID38000023 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 13 | TARGET3 | Type of error handling | nvarchar | 1 | 0 | | |
15 | K9RID38000026 | Derivation Rule: Assignment at Material Type / Plant Level | 15 | TARGET3 | Third costing key (CO-PA) | nvarchar | 3 | 0 | | |
16 | K9RID38000028 | Derivation Rule: Access to Material Type Level | 13 | TARGET3 | Third costing key (CO-PA) | nvarchar | 3 | 0 | | |
17 | K9RID38000030 | Derivation Rule: Access to Cost Estimate for Transfer Prices | 13 | TARGET3 | Third costing key (CO-PA) | nvarchar | 3 | 0 | | |
18 | K9RID38000043 | Ableitungsregel: | 7 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |
19 | K9RID38000044 | Ableitungsregel:Foreign Exchange | 9 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |
20 | K9RID38000045 | Ableitungsregel:Loans | 7 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |
21 | K9RID38000046 | Ableitungsregel:Money Market | 7 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |
22 | K9RID38000047 | Ableitungsregel:Depot-Gattungsbestand | 7 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |
23 | K9RID38000048 | Ableitungsregel:Risikoträger | 7 | TARGET3 | Limitproduktgruppe ohne und mit Rahmenzusage | nvarchar | 3 | 0 | | |