| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNFM_FMBL | Extension table for table FMBL (localization PSM China) | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
2 | CNFM_FMHBL | Extension table for table FMHBL (localization PSM China) | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
3 | FAGLFLEXT_BAK | General Ledger: Totals | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
4 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
5 | GLT0_BAK | G/L Account Master Record Transaction Figures | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
6 | ZSAWP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
7 | ZSAWT | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
8 | ZSEMBPSP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
9 | ZSEMBPST | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
10 | ZSPLITP | Planeinzelposten-Tabelle | 10 | RPMAX | Periode | nvarchar | 3 | 0 | | |
11 | ZSPLITT | Summentabelle | 12 | RPMAX | Periode | nvarchar | 3 | 0 | | |
12 | ZZ001P | Plan Line Items Table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
13 | ZZ001T | Summary Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
14 | ZZLINEP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
15 | ZZLINET | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
16 | ZZSL01P | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
17 | ZZSL01T | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
18 | ZZSPECP | Plan line item table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
19 | ZZSPECT | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPAvailability Control |
20 | FMAVCP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
21 | FMAVCT | AVC Summary Table (BCS) | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPBasic Functions |
22 | FILCP | FI-LC: Plan line items for object table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
23 | FILCT | FI-LC: Global totals table with 2 object tables | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
24 | GGREFP | Example for Global FI-SL Line Items (Plan) | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
25 | GGREFT | Example for Global FI-SL Summary Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
26 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
27 | GLFUNCT | Totals Table for Cost of Sales Accounting | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
28 | GLFUNCV | Rollup plan line items table with function area for IDES | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
29 | GLP0 | Local Logical General Ledger Plan Line Items | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
30 | GLPO1 | Plan Line Items for Object Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
31 | GLPO2 | Plan Line Items for Object Table Global | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
32 | GLPO3 | Plan Line Items for Object Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
33 | GLREFP | Example for Local FI-SL Line Items (Plan) | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
34 | GLREFT | Example for Local FI-SL Summary Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
35 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
36 | GLT0 | G/L account master record transaction figures | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
37 | GLT3 | Summary Data Preparations for Consolidation | 16 | RPMAX | Period | nvarchar | 3 | 0 | | |
38 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
39 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
40 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPBudgeting |
41 | FMBDP | FM Budget change line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
42 | FMBDT | FM budget totals table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
43 | FMBL | Funds management budget document lines (entry documents) | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
44 | FMCY_COPI | For CO plan data transfer | 14 | RPMAX | Period | nvarchar | 3 | 0 | | |
45 | FMHBL | Funds management budget document lines (held documents) | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
46 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 6 | RPMAX | Period | nvarchar | 3 | 0 | | |
47 | FMRBP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
48 | FMRBT | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPCollectionsDisbursements |
49 | GLISDEP | Plan Line Item Table for Insurance (DE) | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
50 | GLISDET | Summary Table for Insurance (DE) | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
51 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
52 | GRISDET | Summary Table for Insurance (DE) - Rollup | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPConsolidation |
53 | ECMCT | SAP Cons.: Totals Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPCost Element Accounting |
54 | COFIP | Single plan items for reconciliation ledger | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
55 | COFIT | Totals Records for Reconciliation Ledger | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPData Retention Tool |
56 | TXW_S_GLT0 | Retrieve archived GLT0 data | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
57 | FBICRC001P | Not in use | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
58 | FBICRC001T | ICRC: Open Items GL Accounts: Totals | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
59 | FBICRC002P | Not in use | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
60 | FBICRC002T | ICRC: GL Accounts: Totals | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
61 | FBICRC003P | Not in use | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
62 | FBICRC003T | ICRC: Open Items Customers/Vendors: Totals | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPFinancial Services Localization |
63 | /CEEIS/RUP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
64 | /CEEIS/RUT | Totals Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPFlexible Real Estate Management |
65 | VIPRLEDTAGRP | Planeinzelposten-Tabelle | 10 | RPMAX | Periode | nvarchar | 3 | 0 | | |
66 | VIPRLEDTAGRT | Summentabelle Ledger 7A Mandate | 11 | RPMAX | Periode | nvarchar | 3 | 0 | | |
TOPFund Accounting |
67 | FMCCAVCP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
68 | FMCCAVCT | Totals Table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
69 | FMGLFLEXP | General Ledger: Plan Line Items | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
70 | FMGLFLEXT | General Ledger Public Sector: Total | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
71 | PSGLFLEXP | General Ledger: Plan Line Items | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
72 | PSGLFLEXT | General Ledger Public Sector: Total | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPFunds Management |
73 | FMIP | Plan Line Items Table for Funds Management | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
74 | FMIT | Totals Table for Funds Management | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
75 | FMSPLITP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
76 | FMSPLITT | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
77 | FMUSFGFACTS1P | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
78 | FMUSFGFACTS1T | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
79 | FMUSFGFACTS2P | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
80 | FMUSFGFACTS2T | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
81 | FMUSFGP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
82 | FMUSFGT | Summary table for US Federal Government | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
83 | FAGLFLEXP | General Ledger: Plan Line Items | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
84 | FAGLFLEXT | General Ledger: Totals | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
85 | GLFLEXP | Flexible G/L: Plan line items | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
86 | GLFLEXT | Flexible G/L: Totals | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPGrantee Management |
87 | GMAVCP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
88 | GMAVCT | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
89 | GMIP | Plan line items table | 9 | RPMAX | Period | nvarchar | 3 | 0 | | |
90 | GMIT | Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
91 | JVGLFLEXP | General Ledger: Plan Line Items | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
92 | JVGLFLEXT | General Ledger: Totals | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
93 | JVPO1 | JVA: Plan Line Items | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
94 | JVPSC01P | Plan line item table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
95 | JVPSC01T | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
96 | JVT1 | JV Summary Table | 16 | RPMAX | Period | nvarchar | 3 | 0 | | |
97 | JVTO1 | JV Summary Table with Objects | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
98 | JVTO2 | JV Billing FI-SL Summary Table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPLocalization |
99 | J_3RFTAXRP | Tax Accounting: Plan line item table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
100 | J_3RFTAXRT | Tax Accounting: Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
101 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
102 | J_3RFTAXRVT | Tax Accounting: Summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPProfit Center Accounting |
103 | GLPCP | EC-PCA: Plan Line Items | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
104 | GLPCT | EC-PCA: Totals Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
105 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPProfitability Analysis |
106 | GLTPC | Profit Center Accounting | 14 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPRegulatory reporting for insurance companies |
107 | ISSRFLDEP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
108 | ISSRFLDET | Summary table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
109 | /BEV3/CHFIP | Plan Line Items Table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
110 | /BEV3/CHFIT | Totals table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
111 | /BEV3/CHVGRP | Plan Line Items Table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
112 | /BEV3/CHVGRT | Totals table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPRetail Ledger |
113 | PCRRETAILP | Plan line items table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
114 | PCRRETAILT | Totals Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPSpecial Purpose Ledger |
115 | /CCIS/PBU18P | PBU18: Plan line item table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
116 | /CCIS/PBU18T | PBU18: Summary table x | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
117 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 8 | RPMAX | Period | nvarchar | 3 | 0 | | |
118 | /CCIS/PROFTAXT | Totals Table for General Ledger | 13 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
119 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
120 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |
121 | OIHSLT | TDP (excise duty) special ledger summary table | 11 | RPMAX | Period | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
122 | TRACTSLP | Plan Line Items Table | 10 | RPMAX | Period | nvarchar | 3 | 0 | | |
123 | TRACTSLT | Totals Table | 12 | RPMAX | Period | nvarchar | 3 | 0 | | |