| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Retention Tool |
1 | TXW_S_COEP | Retrieve COEP from archive | 25 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPFinancial Accounting |
2 | FERC_F3 | Totals per source object, transaction type, and CO element | 8 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPLocal Currency Changeover |
3 | EWUCOK | Exception table for TWAER conversion | 14 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPOrders for Projects |
4 | COSSP | Transfer of the Order COSS Table to the Project | 12 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPOverhead Cost Controlling |
5 | COEJ | CO Object: Line Items (by Fiscal Year) | 176 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
6 | COEP | CO Object: Line Items (by Period) | 26 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
7 | COKS | CO Object: Control Data for Secondary Planning | 11 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
8 | COSS | CO Object: Cost Totals for Internal Postings | 11 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
9 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 28 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPOverhead Cost Orders |
10 | COSSD | CO Object: Settled Secondary Cost Totals | 11 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPPegging, Grouping, and Distribution |
11 | DIS_TOBJS | Distribution: cost objects posted to per group | 9 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
12 | DIS_TOBJS_COSS | Distribution: Objects distributed to per Group WBS (Cost) | 10 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPProfitability Analysis |
13 | CECOEJ | CO-PA Account Based Line Items | 178 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
14 | CECOEP | CO-PA Account Based Line Items | 28 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
TOPStatistical Key Figures |
15 | ANLE | Asset Origin by Line Item | 18 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |
16 | ANLK | Asset Origin by Cost Element | 9 | USPOB | Source Object (Cost Center/Activity Type) | nvarchar | 22 | 0 | | |