| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 115 | LDGRP | | nvarchar | 4 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 115 | LDGRP | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 162 | LDGRP | | nvarchar | 4 | 0 | | |
4 | CNVA_PCREA_AA_R | LT PC Reorg Analysis: Asset Reconciliation results (Level 1) | 9 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
5 | CNV_20000_CBKPF | Data collected from BKPF for item tables coversion in FY | 7 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
6 | CNV_20000_CCLED | Company code and Ledger Combination Particiaption in New G/L | 5 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
7 | CNV_20000_MAPP | Mapping for the errneous table | 13 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
8 | CNV_20200_TABA | Copy of table TABA (before conversion) | 7 | LDGRP | | nvarchar | 4 | 0 | | |
9 | CNV_40305_POST_A | Aggregated amount to be reposted | 15 | LDGRP | Ledger group of new G/L | nvarchar | 4 | 0 | | |
10 | CNV_40305_SIM_PA | Aggregated amount to be reposted | 16 | LDGRP | Ledger group of new G/L | nvarchar | 4 | 0 | | |
11 | DFKKFWKORRN | Cumul. Table for Adjustment and Inverse Postings (New) | 13 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
12 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 76 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
13 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 76 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
14 | FIEUD_FIDOC_H | SAFT: FI Transaction Document Header | 42 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
15 | FUDT_VDOCBKPF | Verification Document Header | 72 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
16 | FUDT_VDOCBKPFH | Verification Document Header(History) | 72 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
17 | GLPOS_C_CT | FI Document: Entry View | 160 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
18 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 160 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
19 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 160 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
20 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 160 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
21 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 162 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
22 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 162 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
23 | TKKV_LDGRP | Alternative Ledger Groups | 4 | LDGRP | Alternative Ledger Group | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 23 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 23 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPAsset Accounting |
26 | APERB_PROT | Log Table for Periodic Posting | 13 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPBasic Functions |
27 | ANEK | Document Header Asset Posting | 49 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
28 | TABA | Depreciation posting documents | 3 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
29 | TLDGRP | Ledger Group FI-SL | 2 | LDGRP | Ledger Group (FI-SL) | nvarchar | 4 | 0 | | |
30 | TLDGRPT | Ledger Group Texts (FI-SL) | 3 | LDGRP | Ledger Group (FI-SL) | nvarchar | 4 | 0 | | |
31 | TLDGRP_MAP | Assignment of Ledgers to Ledger Groups | 2 | LDGRP | Ledger Group (FI-SL) | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
32 | VVSCPOS | Payment Plan Item | 82 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
33 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 33 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
34 | DFKKFWBEW | Management Data for Foreign Currency Valuations | 13 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
35 | DFKKFWBEW_LD | Management Data for Ledger-Specific Foreign Crcy Valuations | 14 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
36 | DFKKFWKORR | Cumulation Table for Adjustment and Inverse Postings | 10 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
37 | DFKKMOPK | Items in contract account document | 61 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
38 | DFKKOPK | Items in contract account document | 61 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
39 | DFKKSUM | Posting totals from FI-CA | 43 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
40 | TFK044 | FI-CA Valuation Area | 4 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
41 | TXW_S_BKPF | Retrieve BKPF from archive | 39 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
42 | BKPF | Accounting Document Header | 72 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
43 | VBKPF | Document Header for Document Parking | 68 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
44 | EWUFI_SPLIT | EMU Implementation: Table of FAGL_SPLINFO* to Be Corrected | 8 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
45 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 76 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
46 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 76 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
47 | FAGLCOFIVARC | Variants for Real-Time Integration CO->FI | 7 | LDGRP | Ledger Group into which Document Is Posted in FI | nvarchar | 4 | 0 | | |
48 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 11 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
49 | FAGL_HST_T095 | Old Acct Determin. for Asset Value Adjustment and Portfolio | 6 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
50 | FAGL_MIG_RPITEMS | Migration in New G/L: Objects To Be Posted Subsequently | 9 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
51 | FAGL_TLDGRP | Ledger Group | 2 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
52 | FAGL_TLDGRPT | Ledger Group Texts | 3 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
53 | FAGL_TLDGRP_MAP | Assignment of Ledgers to Ledger Groups | 2 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
54 | FAGL_VAL_LEDGR | Assignment to Ledger Group | 6 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Reorganization |
55 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 36 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
TOPLocal Currency Changeover |
56 | EWUFIAASUM | EWU conversion: Table for asset totals at account level | 9 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |
57 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 40 | LDGRP | Ledger Group | nvarchar | 4 | 0 | | |