| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLPCA_CT | Profit Center Documents | 114 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
2 | GLPCA_T_CT | Profit Center Documents | 130 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
3 | T243A | Set TR-CM Subsystems and Company Codes | 3 | SBUKRS | Sending company code | nvarchar | 4 | 0 | | |
4 | ZSAWA | Actual line item table | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
5 | ZSAWP | Plan line items table | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
6 | ZSAWT | Summary table | 19 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
7 | ZSPLITA | Isteinzelposten-Tabelle | 20 | SBUKRS | Buchungskreis des Partners | nvarchar | 4 | 0 | | |
8 | ZSPLITP | Planeinzelposten-Tabelle | 20 | SBUKRS | Buchungskreis des Partners | nvarchar | 4 | 0 | | |
9 | ZSPLITT | Summentabelle | 19 | SBUKRS | Buchungskreis des Partners | nvarchar | 4 | 0 | | |
10 | ZZ001A | Actual Line Item Table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
11 | ZZ001P | Plan Line Items Table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
12 | ZZ001T | Summary Table | 26 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
13 | ZZLINEA | Actual line item table | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
14 | ZZLINEP | Plan line items table | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
15 | ZZLINET | Summary table | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
16 | ZZSL01A | Actual line item table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
17 | ZZSL01P | Plan line items table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
18 | ZZSL01T | Summary table | 24 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
19 | ZZSPECA | Actual line item table | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
20 | ZZSPECP | Plan line item table | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
21 | ZZSPECT | Summary table | 18 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPBasic Functions |
22 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
23 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
24 | GLFUNCT | Totals Table for Cost of Sales Accounting | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
25 | GLFUNCU | Rollup line item tables with function area for IDES | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
26 | GLFUNCV | Rollup plan line items table with function area for IDES | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
27 | GLPO1 | Plan Line Items for Object Table | 25 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
28 | GLPO3 | Plan Line Items for Object Table | 25 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
29 | GLREFA | Example for Local FI-SL Line Items (Actual) | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
30 | GLREFP | Example for Local FI-SL Line Items (Plan) | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
31 | GLREFT | Example for Local FI-SL Summary Table | 19 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
32 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
33 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
34 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 25 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
35 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 25 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
36 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 22 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
37 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 22 | SBUKRS | Company Code | nvarchar | 4 | 0 | | |
TOPCost Element Accounting |
38 | COFIP | Single plan items for reconciliation ledger | 24 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
39 | COFIS | Actual line items for reconciliation ledger | 24 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
40 | COFIT | Totals Records for Reconciliation Ledger | 23 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
41 | TXW_S_COFI | Retrieve COFIS from archive | 14 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
42 | /CEEIS/RUA | Actual line item table | 28 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
43 | /CEEIS/RUP | Plan line items table | 28 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
44 | /CEEIS/RUT | Totals Table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPFund Accounting |
45 | FMCCAVCA | Actual line item table | 23 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
46 | FMCCAVCP | Plan line items table | 23 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
47 | FMCCAVCT | Totals Table | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPFunds Management |
48 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
49 | FMSPLITA | Actual line item table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
50 | FMSPLITP | Plan line items table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
51 | FMSPLITT | Summary table | 26 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
52 | FMUSFGFACTS1A | 4Actual line item table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
53 | FMUSFGFACTS1P | Plan line items table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
54 | FMUSFGFACTS1T | Summary table | 28 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPGrantee Management |
55 | GMAVCA | Actual line item table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
56 | GMAVCP | Plan line items table | 25 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
57 | GMAVCT | Summary table | 24 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPLocalization |
58 | J_3RFTAXRA | Tax Accounting: Actual line item table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
59 | J_3RFTAXRP | Tax Accounting: Plan line item table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
60 | J_3RFTAXRT | Tax Accounting: Summary table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
61 | J_3RFTAXRVA | Tax Accounting: Actual line item table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
62 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 29 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
63 | J_3RFTAXRVT | Tax Accounting: Summary table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
64 | GLPCA | EC-PCA: Actual Line Items | 26 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
65 | GLPCP | EC-PCA: Plan Line Items | 26 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
66 | GLPCT | EC-PCA: Totals Table | 26 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
67 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 28 | SBUKRS | Sender company code | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
68 | ISSRFLDEA | Actual line item table | 44 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
69 | ISSRFLDEP | Plan line items table | 44 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
70 | ISSRFLDET | Summary table | 43 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
71 | /BEV3/CHFIA | Actual line item table | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
72 | /BEV3/CHFIP | Plan Line Items Table | 21 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
73 | /BEV3/CHFIT | Totals table | 20 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
74 | /BEV3/CHVGRA | Actual line item table | 23 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
75 | /BEV3/CHVGRP | Plan Line Items Table | 23 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
76 | /BEV3/CHVGRT | Totals table | 22 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPSpecial Purpose Ledger |
77 | /CCIS/PBU18A | PBU18: Actual line item table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
78 | /CCIS/PBU18P | PBU18: Plan line item table | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
79 | /CCIS/PBU18T | PBU18: Summary table x | 26 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
80 | /CCIS/PROFTAX06 | Object Table Number:06 | 2 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
81 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 30 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
82 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 32 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
83 | /CCIS/PROFTAXT | Totals Table for General Ledger | 39 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
84 | OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
85 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 27 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |
86 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 26 | SBUKRS | Company code of partner | nvarchar | 4 | 0 | | |