| 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 | 7 | RMVCT | | nvarchar | 3 | 0 | | |
2 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 7 | RMVCT | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 7 | RMVCT | | nvarchar | 3 | 0 | | |
4 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 7 | RMVCT | | nvarchar | 3 | 0 | | |
5 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 16 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
6 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 18 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
7 | FAGLFLEXT_BAK | General Ledger: Totals | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
8 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
9 | GLPCA_CT | Profit Center Documents | 108 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
10 | GLPCA_T_CT | Profit Center Documents | 124 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
11 | TSTGC | Consolidation test data | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
12 | ZZLINEA | Actual line item table | 21 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
13 | ZZLINEC | Object table 2 | 4 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
14 | ZZLINEP | Plan line items table | 21 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
15 | ZZLINET | Summary table | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
16 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 152 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
17 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 152 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPBasic Functions |
18 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 22 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
19 | FILCC | FI-LC: Transaction-related fields for table FILCT | 6 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
20 | FILCP | FI-LC: Plan line items for object table | 22 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
21 | FILCT | FI-LC: Global totals table with 2 object tables | 21 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
22 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
23 | GLFUNCC | Object Table 2 for Cost of Sales Accounting | 5 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
24 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
25 | GLFUNCT | Totals Table for Cost of Sales Accounting | 19 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
26 | GLFUNCU | Rollup line item tables with function area for IDES | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
27 | GLFUNCV | Rollup plan line items table with function area for IDES | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
28 | GLPO1 | Plan Line Items for Object Table | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
29 | GLPO2 | Plan Line Items for Object Table Global | 22 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
30 | GLPO3 | Plan Line Items for Object Table | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
31 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
32 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 22 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
33 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 20 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
34 | GLT3 | Summary Data Preparations for Consolidation | 9 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
35 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 17 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
36 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 19 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
37 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 17 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
38 | T851 | Changes in Investments | 10 | RMVCT | Transaction type: Investments | nvarchar | 3 | 0 | | |
39 | T854S | Selected FS items | 7 | RMVCT | Transaction type for the selected item | nvarchar | 3 | 0 | | |
40 | T863B | Report groups | 9 | RMVCT | Transaction type group for the standard report | nvarchar | 3 | 0 | | |
41 | T865 | Intercompany Elimination | 14 | RMVCT | Indicator: Document per transaction type | nvarchar | 1 | 0 | | |
42 | T866 | Elimination of IC profit/loss: FS items | 10 | RMVCT | Transaction type for elimination of intercompany profit/loss | nvarchar | 3 | 0 | | |
43 | T866Z | Elimination of IC P/L: Assignment of additional fields | 3 | RMVCT | Transaction type for elimination of intercompany profit/loss | nvarchar | 3 | 0 | | |
44 | T871 | Changes in investee equity | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPCollectionsDisbursements |
45 | GLISDEA | Actual Line Item Tables for Insurance (DE) | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
46 | GLISDEC | Object Table 2 for Insurance (DE) | 4 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
47 | GLISDEP | Plan Line Item Table for Insurance (DE) | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
48 | GLISDET | Summary Table for Insurance (DE) | 24 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
49 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
50 | GRISDEC | Object Table 2 for Insurance (DE) - Rollup | 4 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
51 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
52 | GRISDET | Summary Table for Insurance (DE) - Rollup | 24 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPConsolidation |
53 | TFMIG05 | Allocation: Transaction Type -> Subitem | 2 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPElectronic Bank Statement |
54 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 19 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
55 | FEB_ACT | Acct Assignment Templates | 19 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
56 | ACCTIT | Compressed Data from FI/CO Document | 46 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
57 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 29 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPFund Accounting |
58 | FMGLFLEX00 | General ledger: Transaction attributes | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
59 | FMGLFLEXA | General Ledger: Actual Line Items | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
60 | FMGLFLEXP | General Ledger: Plan Line Items | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
61 | FMGLFLEXT | General Ledger Public Sector: Total | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
62 | PSGLFLEX00 | General ledger: Transaction attributes | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
63 | PSGLFLEXA | General Ledger: Actual Line Items | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
64 | PSGLFLEXP | General Ledger: Plan Line Items | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
65 | PSGLFLEXT | General Ledger Public Sector: Total | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
66 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 30 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
67 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 29 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
68 | FAGLFLEX00 | General ledger: Transaction attributes | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
69 | FAGLFLEXA | General Ledger: Actual Line Items | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
70 | FAGLFLEXP | General Ledger: Plan Line Items | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
71 | FAGLFLEXT | General Ledger: Totals | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
72 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
73 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 6 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
74 | FAGL_RMAP_SAP | Reorganization: Object Number of the Signature Values | 4 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
75 | FAGL_RSNAPSHOT | Reorganization: Snapshot | 27 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
76 | GLFLEX07 | General ledger: Transaction attributes | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
77 | GLFLEXA | Flexible general ledger: Actual line items | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
78 | GLFLEXP | Flexible G/L: Plan line items | 25 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
79 | GLFLEXT | Flexible G/L: Totals | 31 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Reorganization |
80 | FAGL_R_BLNCE | Reorganization: Balances to Be Transferred | 24 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
81 | FAGL_R_MAP_SAP | Reorganization: Object Number of the Included SAP Fields | 4 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPGL Account Posting |
82 | TCJ_POSITIONS | Cash Journal Document Items | 26 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPInformation System |
83 | BWPOS | Valuations for Open Items | 55 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPInventory Management |
84 | MWZDM07M2 | ZDM07M2 | 82 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
85 | JVGLFLEX00 | General ledger: Transaction attributes | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
86 | JVGLFLEXA | General Ledger: Actual Line Items | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
87 | JVGLFLEXP | General Ledger: Plan Line Items | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
88 | JVGLFLEXT | General Ledger: Totals | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPProfit Center Accounting |
89 | GLPCA | EC-PCA: Actual Line Items | 64 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
90 | GLPCC | EC-PCA: Transaction Attributes | 16 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
91 | GLPCP | EC-PCA: Plan Line Items | 124 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
92 | GLPCT | EC-PCA: Totals Table | 105 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
93 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 104 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPSpecial Purpose Ledger |
94 | /CCIS/PROFTAX00 | Object Table Number:00 | 3 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
95 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 8 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
96 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 10 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
97 | /CCIS/PROFTAXT | Totals Table for General Ledger | 15 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
98 | TRACT_ACCITEM | Accounting Items | 39 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | |