| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 32 | VALUTYP | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 35 | VALUTYP | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 37 | VALUTYP | | nvarchar | 1 | 0 | | |
4 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 37 | VALUTYP | | nvarchar | 1 | 0 | | |
5 | /BIC/B0000218000 | PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs | 17 | VALUTYP | | nvarchar | 1 | 0 | | |
6 | /BIC/B0000222000 | PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections | 14 | VALUTYP | | nvarchar | 1 | 0 | | |
7 | /BIC/B0000223000 | PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta | 16 | VALUTYP | | nvarchar | 1 | 0 | | |
8 | TCVAL | Currency and Valuation Types | 3 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
9 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 447 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
10 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 447 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPBasic Functions |
11 | T881 | Ledger Master | 35 | VALUTYP | Valuation | nvarchar | 1 | 0 | | |
TOPBasic Settings |
12 | TCVPROFD | Currency and Valuation Profiles - Detail | 5 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPCost Object |
13 | TKKAP | Results Analysis Versions for Results Analysis | 43 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
14 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 60 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
15 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 38 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
16 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 37 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPInterest |
17 | TZIN2 | Interest Document:Segment Int.Indicator & Valuation Category | 4 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
18 | TZIN3 | Interest Document: Currency Type Segment | 4 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPOverhead Cost Controlling |
19 | TKA09 | Basic Settings for Versions | 9 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPPortfolio and Project Management |
20 | RPM_COA_VV | CO Area valuation view mapping for PPM Integration | 3 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPProduct Cost Planning |
21 | TCK33 | Assignment of Condition Types to Origin Group | 3 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPProfit Center Accounting |
22 | TTP_COND | Control: Conversion of Condition Values for TP | 4 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
TOPProfitability Analysis Basic Functions |
23 | K840001 | Summarization level KT: 800 KK 01 KKROBJ 000001 | 23 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
24 | K840003 | Summarization level KT: 800 KK 01 KKROBJ 000002 | 18 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
25 | K840005 | Summarization level KT: 800 KK 01 KKROBJ 000003 | 20 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
26 | K840007 | Summarization level KT: 800 KK 01 KKROBJ 000004 | 15 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
27 | K840009 | Summarization level KT: 800 KK 01 KKROBJ 000005 | 21 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |
28 | K840011 | Summarization level KT: 800 KK 01 KKROBJ 000006 | 16 | VALUTYP | Valuation View | nvarchar | 1 | 0 | | |