| 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 | 25 | RASSC | | nvarchar | 6 | 0 | | |
2 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 26 | RASSC | | nvarchar | 6 | 0 | | |
3 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 28 | RASSC | | nvarchar | 6 | 0 | | |
4 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 28 | RASSC | | nvarchar | 6 | 0 | | |
5 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 35 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
6 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 37 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
7 | FAGLFLEXT_BAK | General Ledger: Totals | 37 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
8 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 37 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
9 | GLPCA_CT | Profit Center Documents | 97 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
10 | GLPCA_T_CT | Profit Center Documents | 113 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
11 | T868 | Elimination of IC profit and loss | 7 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
12 | TSTGC | Consolidation test data | 9 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPBasic Functions |
13 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
14 | FILCP | FI-LC: Plan line items for object table | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
15 | FILCT | FI-LC: Global totals table with 2 object tables | 16 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
16 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
17 | GLFUNCC | Object Table 2 for Cost of Sales Accounting | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
18 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
19 | GLFUNCT | Totals Table for Cost of Sales Accounting | 20 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
20 | GLFUNCU | Rollup line item tables with function area for IDES | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
21 | GLFUNCV | Rollup plan line items table with function area for IDES | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
22 | GLPO1 | Plan Line Items for Object Table | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
23 | GLPO2 | Plan Line Items for Object Table Global | 25 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
24 | GLPO3 | Plan Line Items for Object Table | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
25 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
26 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 25 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
27 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
28 | GLT3 | Summary Data Preparations for Consolidation | 10 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
29 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 18 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
30 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 22 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
31 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 18 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
32 | T851 | Changes in Investments | 5 | RASSC | Investee | nvarchar | 6 | 0 | | |
33 | T864 | Reclassifications | 7 | RASSC | Trading partner (reclassifications) | nvarchar | 6 | 0 | | |
34 | T868B | Elimination of IC profit/loss: Inventory management co.s | 8 | RASSC | Supplying company | nvarchar | 6 | 0 | | |
35 | T868L | Elimination of IC profit/loss: Vendor data | 3 | RASSC | Supplying company | nvarchar | 6 | 0 | | |
36 | T872 | Equity Holdings Adjustments | 4 | RASSC | Company ID of the investee | nvarchar | 6 | 0 | | |
37 | T872I | Periodic entry for affiliated companies | 3 | RASSC | Company ID of the investee | nvarchar | 6 | 0 | | |
38 | T874 | Elimination of hidden reserves | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
39 | T875 | Asset transfers within the group | 7 | RASSC | Acquiring company | nvarchar | 6 | 0 | | |
40 | T875C | Changes in depreciation | 10 | RASSC | Acquiring company | nvarchar | 6 | 0 | | |
41 | T875D | Asset transfers | 5 | RASSC | Acquiring company | nvarchar | 6 | 0 | | |
42 | T875E | Change in depreciation of asset transfers | 5 | RASSC | Acquiring company | nvarchar | 6 | 0 | | |
TOPCollectionsDisbursements |
43 | GLISDEA | Actual Line Item Tables for Insurance (DE) | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
44 | GLISDEP | Plan Line Item Table for Insurance (DE) | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
45 | GLISDET | Summary Table for Insurance (DE) | 20 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
46 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
47 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
48 | GRISDET | Summary Table for Insurance (DE) - Rollup | 20 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
49 | FBICRC001A | ICRC: Open Items GL Accounts: Documents | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
50 | FBICRC001P | Not in use | 16 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
51 | FBICRC001T | ICRC: Open Items GL Accounts: Totals | 16 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
52 | FBICRC002A | ICRC: GL Accounts: Documents | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
53 | FBICRC002P | Not in use | 16 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
54 | FBICRC002T | ICRC: GL Accounts: Totals | 16 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
55 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 18 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
56 | FBICRC003P | Not in use | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
57 | FBICRC003T | ICRC: Open Items Customers/Vendors: Totals | 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
58 | FBICRC01021 | Not in use | 4 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
59 | FBICRC01026 | Not in use | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
60 | FBICRC01028 | Reconciliation Process 003: Lock Table for Company Pairs | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
61 | FBICRC01045 | IC Reconciliation: Lock Table for Company Pairs | 7 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
62 | FBICRC01050 | Differences per Company Pair and Display Category | 7 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPFund Accounting |
63 | FMGLFLEX06 | General ledger: Sender SAP additional account assignment | 4 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
64 | FMGLFLEXA | General Ledger: Actual Line Items | 22 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
65 | FMGLFLEXP | General Ledger: Plan Line Items | 24 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
66 | FMGLFLEXT | General Ledger Public Sector: Total | 31 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
67 | PSGLFLEX06 | General ledger: Sender SAP additional account assignment | 4 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
68 | PSGLFLEXA | General Ledger: Actual Line Items | 24 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
69 | PSGLFLEXP | General Ledger: Plan Line Items | 26 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
70 | PSGLFLEXT | General Ledger Public Sector: Total | 33 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPGeneral Ledger Accounting |
71 | FAGLFLEX06 | General ledger: Sender SAP additional account assignment | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
72 | FAGLFLEXA | General Ledger: Actual Line Items | 28 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
73 | FAGLFLEXP | General Ledger: Plan Line Items | 30 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
74 | FAGLFLEXT | General Ledger: Totals | 37 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
75 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 29 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
76 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 27 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
77 | GLFLEX06 | General ledger: Sender SAP additional account assignment | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
78 | GLFLEXA | Flexible general ledger: Actual line items | 23 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
79 | GLFLEXP | Flexible G/L: Plan line items | 23 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
80 | GLFLEXT | Flexible G/L: Totals | 29 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPInventory Accounting |
81 | CFIOCONSI0C | FIN Objects for Consignment | 13 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
82 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 13 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
83 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 14 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
84 | CFIOSENTR0C | FIN Objects for Services | 13 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
85 | JVGLFLEX06 | General ledger: Sender SAP additional account assignment | 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
86 | JVGLFLEXA | General Ledger: Actual Line Items | 27 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
87 | JVGLFLEXP | General Ledger: Plan Line Items | 29 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
88 | JVGLFLEXT | General Ledger: Totals | 36 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPProfit Center Accounting |
89 | GLPCA | EC-PCA: Actual Line Items | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
90 | GLPCC | EC-PCA: Transaction Attributes | 12 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
91 | GLPCP | EC-PCA: Plan Line Items | 21 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
92 | GLPCT | EC-PCA: Totals Table | 20 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
93 | T8A50 | Acct determination of P+L acct for chrg off valuation diff. | 3 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
94 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 22 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |