| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____003K | SID-Tabelle fuer Trading Partner | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
2 | /SMD/MD_____00IQ | SID-Tabelle fuer Company ID | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
3 | /SMD/MD_____00PL | SID-Tabelle fuer Trading Partner | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
4 | CNV_20100_T001 | CNV backup copy for T001 | 24 | RCOMP | Company | nvarchar | 6 | 0 | | |
5 | CNV_20200_T001AD | Original settings of company codes (additional fields) | 8 | RCOMP | Company | nvarchar | 6 | 0 | | |
6 | CNV_20200_T880 | Original list of companies | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
7 | CNV_20305_T001 | backup table of T001 (certain fields only) | 11 | RCOMP | Company | nvarchar | 6 | 0 | | |
8 | EPIDXC | | 6 | RCOMP | | nvarchar | 6 | 0 | | |
9 | FBICRC_C_CONF | ICR: Customizing Table for Assign Confirm Dialog | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
10 | FBICRC_C_OV | ICR: Overview Chart with Single Company Displayed | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
11 | FSBPCC_T880 | Company with Description | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
12 | GLIDXC | Line Item Index for FI-SL Global Company | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
13 | T868 | Elimination of IC profit and loss | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
14 | T887C | Activity/Ledger/Company Information | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
15 | T891C | Validation for Special Purpose Ledger / Global Company | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
16 | T892C | Substitution for Special Purpose Ledger / Global Company | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
17 | T895C | Global Fiscal Year-Dependent Version Parameters | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
18 | TSTGC | Consolidation test data | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPBasic Functions |
19 | ARC_IDX_IT | Archive index table for FI-SL line items | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
20 | EWULC03 | FI-LC: Companies for conversion | 3 | RCOMP | Company for conversion | nvarchar | 6 | 0 | | |
21 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 14 | RCOMP | Company | nvarchar | 6 | 0 | | |
22 | FILCP | FI-LC: Plan line items for object table | 14 | RCOMP | Company | nvarchar | 6 | 0 | | |
23 | FILCT | FI-LC: Global totals table with 2 object tables | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
24 | GGREFA | Example for Global FI-SL Line Items (Actual) | 14 | RCOMP | Company | nvarchar | 6 | 0 | | |
25 | GGREFP | Example for Global FI-SL Line Items (Plan) | 14 | RCOMP | Company | nvarchar | 6 | 0 | | |
26 | GGREFT | Example for Global FI-SL Summary Table | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
27 | GLIDXA | Index to Find FI-SL Documents Based on AWKEY | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
28 | GLPO2 | Plan Line Items for Object Table Global | 16 | RCOMP | Company | nvarchar | 6 | 0 | | |
29 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 16 | RCOMP | Company | nvarchar | 6 | 0 | | |
30 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
31 | SMFISL | Spec. FI-SL Data in Monitor (See Schedman_specific_fisl) | 9 | RCOMP | Company | nvarchar | 6 | 0 | | |
32 | T001C | Valid Posting Periods for Global Companies | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
33 | T807R | FI-SL Rollup: History of Executions | 11 | RCOMP | Company | nvarchar | 6 | 0 | | |
34 | T850 | Company data for Consolidation | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
35 | T850D | Assignment of business segment | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
36 | T850I | Version-dependent assignment: Company/data import + validtn | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
37 | T850K | Company correspondence data | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
38 | T850S | Tax rates | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
39 | T851 | Changes in Investments | 4 | RCOMP | Investor | nvarchar | 6 | 0 | | |
40 | T852G | Subgroup companies | 5 | RCOMP | Company belonging to the subgroup | nvarchar | 6 | 0 | | |
41 | T852U | Subgroup companies | 5 | RCOMP | Company belonging to the subgroup | nvarchar | 6 | 0 | | |
42 | T853 | Company status | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
43 | T863B | Report groups | 7 | RCOMP | Company | nvarchar | 6 | 0 | | |
44 | T868B | Elimination of IC profit/loss: Inventory management co.s | 5 | RCOMP | Inventory managing company | nvarchar | 6 | 0 | | |
45 | T868L | Elimination of IC profit/loss: Vendor data | 6 | RCOMP | Inventory managing company | nvarchar | 6 | 0 | | |
46 | T870 | Consolidation method assignment | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
47 | T871 | Changes in investee equity | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
48 | T872 | Equity Holdings Adjustments | 5 | RCOMP | Parent company ID | nvarchar | 6 | 0 | | |
49 | T872I | Periodic entry for affiliated companies | 4 | RCOMP | Parent company ID | nvarchar | 6 | 0 | | |
50 | T873 | Hidden reserves | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
51 | T874 | Elimination of hidden reserves | 5 | RCOMP | Company | nvarchar | 6 | 0 | | |
52 | T875 | Asset transfers within the group | 4 | RCOMP | Company ID of retiring company | nvarchar | 6 | 0 | | |
53 | T875C | Changes in depreciation | 4 | RCOMP | Company ID of retiring company | nvarchar | 6 | 0 | | |
54 | T875D | Asset transfers | 4 | RCOMP | Company ID of retiring company | nvarchar | 6 | 0 | | |
55 | T875E | Change in depreciation of asset transfers | 4 | RCOMP | Company ID of retiring company | nvarchar | 6 | 0 | | |
56 | T880B | Valuation methods | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
57 | T880G | Consolidation companies | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
58 | T882C | Global Company-Ledger Assignment in FI-SL | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
59 | T886C | Activity/Ledger/Company Information | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPBasis Components |
60 | ZDS400_T001 | Buchungskreise | 23 | RCOMP | Gesellschaft | nvarchar | 6 | 0 | | |
TOPBudgeting |
61 | FMBH | Funds management budget header (entry documents) | 35 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
62 | FMHBH | Funds management budget header (held documents) | 27 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
63 | FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP | 23 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPConsolidation |
64 | ECMCA | SAP Cons.: Journal Entry Table (Actual) | 14 | RCOMP | Company | nvarchar | 6 | 0 | | |
65 | ECMCT | SAP Cons.: Totals Table | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
66 | TFIN010 | Consolidation Unit Integration | 8 | RCOMP | Company | nvarchar | 6 | 0 | | |
67 | TFMIG02 | Allocation: Company -> Consolidation Unit | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
68 | TFK880 | Global Company Data (for KONS Ledger) | 3 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPData Transfer |
69 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 43 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
70 | FBICRC001A | ICRC: Open Items GL Accounts: Documents | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
71 | FBICRC001P | Not in use | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
72 | FBICRC001T | ICRC: Open Items GL Accounts: Totals | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
73 | FBICRC002A | ICRC: GL Accounts: Documents | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
74 | FBICRC002P | Not in use | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
75 | FBICRC002T | ICRC: GL Accounts: Totals | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
76 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
77 | FBICRC003P | Not in use | 13 | RCOMP | Company | nvarchar | 6 | 0 | | |
78 | FBICRC003T | ICRC: Open Items Customers/Vendors: Totals | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
79 | FBICRC01010 | Reconciliation Processes: Attributes per Company | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
80 | FBICRC01020 | Not in use | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
81 | FBICRC01021 | Not in use | 3 | RCOMP | Company | nvarchar | 6 | 0 | | |
82 | FBICRC01025 | Not in use | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
83 | FBICRC01026 | Not in use | 5 | RCOMP | Company | nvarchar | 6 | 0 | | |
84 | FBICRC01027 | Reconciliation: Current Status per Company | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
85 | FBICRC01028 | Reconciliation Process 003: Lock Table for Company Pairs | 5 | RCOMP | Company | nvarchar | 6 | 0 | | |
86 | FBICRC01040 | IC Reconciliation: Current Status per Company | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
87 | FBICRC01045 | IC Reconciliation: Lock Table for Company Pairs | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
88 | FBICRC01050 | Differences per Company Pair and Display Category | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
89 | ICRC01 | Document Table for G/L Account Reconciliation | 11 | RCOMP | Company ID of trading partner | nvarchar | 6 | 0 | | |
90 | ICRCA | ICRC: Items to be Reconciled | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
91 | ICRCLOG | ICRC: Log Numbers of Automatic Reconciliation | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
92 | ICRCS | ICRC: Status of Data Procurement | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
93 | ICRCU | ICRC: Potentially Differing Document Groups | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
94 | ICRCZ | ICRC: Reconciled, Completed Items | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
95 | T001 | Company Codes | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
96 | TICRC1 | RFC Destination and Contact Person in Company | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPFunds Management |
97 | FMFG_SAV_GLIDXA | Saved GLIDXA data for docs excluded from SL Repost for 600 | 12 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPGeneral Ledger Accounting |
98 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 47 | RCOMP | Company | nvarchar | 6 | 0 | | |
99 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 48 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPIntegrated Product and Process Engineering |
100 | CRPTYPE | Type of Reporting Point | 4 | RCOMP | Post Goods Movements and Production Activities | nvarchar | 1 | 0 | | |
TOPInvestment Programs |
101 | IMPR | Investment Program Positions | 32 | RCOMP | Company | nvarchar | 6 | 0 | | |
102 | TAI11 | Group shares in Inv. Program Info System | 4 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPLocal Currency Changeover |
103 | EUROFISL | EMU: Information on record level for FI-SL | 5 | RCOMP | Company | nvarchar | 6 | 0 | | |
104 | EWUSL | EMU: Currencies from special ledger | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
105 | EWUTSL | EMU: Combinations for TSL fields to be converted in FI-SL | 5 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPProfit Center Accounting |
106 | ARC_IPC_IT | Archive index table for FI-SL line items | 6 | RCOMP | Company | nvarchar | 6 | 0 | | |
TOPSchedule Manager |
107 | T880 | Global Company Data (for KONS Ledger) | 2 | RCOMP | Company | nvarchar | 6 | 0 | | |