| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/6111_CONV | Convert Financial Key/Functional Area to Form 6111 Code | 3 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
2 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 17 | RFAREA | | nvarchar | 16 | 0 | | |
3 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 18 | RFAREA | | nvarchar | 16 | 0 | | |
4 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 20 | RFAREA | | nvarchar | 16 | 0 | | |
5 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 20 | RFAREA | | nvarchar | 16 | 0 | | |
6 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 26 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
7 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 28 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
8 | FAGLFLEXT_BAK | General Ledger: Totals | 28 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
9 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 28 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
10 | GLPCA_CT | Profit Center Documents | 105 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
11 | GLPCA_T_CT | Profit Center Documents | 121 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
12 | ZSAWA | Actual line item table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
13 | ZSAWP | Plan line items table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
14 | ZSAWT | Summary table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
15 | ZSPLITA | Isteinzelposten-Tabelle | 17 | RFAREA | Funktionsbereich | nvarchar | 16 | 0 | | |
16 | ZSPLITP | Planeinzelposten-Tabelle | 17 | RFAREA | Funktionsbereich | nvarchar | 16 | 0 | | |
17 | ZSPLITT | Summentabelle | 16 | RFAREA | Funktionsbereich | nvarchar | 16 | 0 | | |
18 | ZZ001A | Actual Line Item Table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
19 | ZZ001P | Plan Line Items Table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
20 | ZZ001T | Summary Table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
21 | ZZLINEA | Actual line item table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
22 | ZZLINEP | Plan line items table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
23 | ZZLINET | Summary table | 16 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
24 | ZZSPECA | Actual line item table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
25 | ZZSPECP | Plan line item table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
26 | ZZSPECT | Summary table | 15 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPBasic Functions |
27 | GGREFA | Example for Global FI-SL Line Items (Actual) | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
28 | GGREFP | Example for Global FI-SL Line Items (Plan) | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
29 | GGREFT | Example for Global FI-SL Summary Table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
30 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
31 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
32 | GLFUNCT | Totals Table for Cost of Sales Accounting | 16 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
33 | GLFUNCU | Rollup line item tables with function area for IDES | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
34 | GLFUNCV | Rollup plan line items table with function area for IDES | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
35 | GLREFA | Example for Local FI-SL Line Items (Actual) | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
36 | GLREFP | Example for Local FI-SL Line Items (Plan) | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
37 | GLREFT | Example for Local FI-SL Summary Table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
38 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
39 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPCost Element Accounting |
40 | COFIP | Single plan items for reconciliation ledger | 20 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
41 | COFIS | Actual line items for reconciliation ledger | 20 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
42 | COFIT | Totals Records for Reconciliation Ledger | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPData Retention Tool |
43 | TXW_S_COFI | Retrieve COFIS from archive | 13 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPFinancial Services Localization |
44 | /CEEIS/RUA | Actual line item table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
45 | /CEEIS/RUP | Plan line items table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
46 | /CEEIS/RUT | Totals Table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPFund Accounting |
47 | FMCCAVCA | Actual line item table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
48 | FMCCAVCP | Plan line items table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
49 | FMCCAVCT | Totals Table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
50 | FMGLFLEX07 | General Ledger: Reserve Table 1 | 4 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
51 | FMGLFLEXA | General Ledger: Actual Line Items | 27 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
52 | FMGLFLEXP | General Ledger: Plan Line Items | 29 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
53 | FMGLFLEXT | General Ledger Public Sector: Total | 36 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
54 | PSGLFLEX07 | General Ledger: Reserve Table 1 | 4 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
55 | PSGLFLEXA | General Ledger: Actual Line Items | 30 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
56 | PSGLFLEXP | General Ledger: Plan Line Items | 32 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
57 | PSGLFLEXT | General Ledger Public Sector: Total | 39 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPFunds Management |
58 | FMCCFD | Fiscal Year Change Documents (FM) | 32 | RFAREA | Receiver Functional Area (Fiscal Year Change FM) | nvarchar | 16 | 0 | | |
59 | FMCCFLOT | Commitment Carryforward of Held Documents (Approval Proc.) | 27 | RFAREA | Receiver Functional Area (Fiscal Year Change FM) | nvarchar | 16 | 0 | | |
60 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 26 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
61 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
62 | FMIA | Actual Line Item Table for Funds Management | 26 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
63 | FMIP | Plan Line Items Table for Funds Management | 25 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
64 | FMIT | Totals Table for Funds Management | 24 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
65 | FMRPREL | Assignment of Expenditure Objects to Revenue Cover Pool | 6 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
66 | FMSPLITA | Actual line item table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
67 | FMSPLITP | Plan line items table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
68 | FMSPLITT | Summary table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
69 | FMUDBSEGH | Addtl Info on Revenues Increasing Budget for Recovery Order | 9 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
70 | FMUDBSEGP | Part.Payt Item for Customer Invoice of a Rev. Incr. the Bgt | 15 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
71 | FMUDKBLPH | Addtl Info re Revenues Increasing Budget for Fcst of Revenue | 7 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
72 | FMUDKBLPP | Item Revenues Increasing Budget for Forecast of Revenue | 10 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
73 | FMUDREL | Assignment of Expenditure Objs.to Revenue Objs Incr.Budget | 9 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
74 | FMUDRELC | Assignment of Expenditure Objs.to Revenue Objs Incr.Budget | 9 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
75 | FMUSFGA | Actual line item table for US Federal Government. | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
76 | FMUSFGFACTS1A | 4Actual line item table | 26 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
77 | FMUSFGFACTS1P | Plan line items table | 26 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
78 | FMUSFGFACTS1T | Summary table | 25 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
79 | FMUSFGP | Plan line items table | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
80 | FMUSFGT | Summary table for US Federal Government | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPGeneral Ledger Accounting |
81 | FAGLFLEX03 | General ledger: SAP additional account assignment | 5 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
82 | FAGLFLEXA | General Ledger: Actual Line Items | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
83 | FAGLFLEXP | General Ledger: Plan Line Items | 21 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
84 | FAGLFLEXT | General Ledger: Totals | 28 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
85 | FAGLSKF | General Ledger: Statistical Key Figures (Current Values) | 8 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
86 | FAGLSKF_PN | General Ledger; Statistical Key Figures (Source Document) | 10 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
87 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 21 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
88 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
89 | GLFLEX03 | General ledger: SAP additional account assignment | 4 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
90 | GLFLEXA | Flexible general ledger: Actual line items | 15 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
91 | GLFLEXP | Flexible G/L: Plan line items | 15 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
92 | GLFLEXT | Flexible G/L: Totals | 21 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
93 | JVGLFLEX03 | General ledger: SAP additional account assignment | 5 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
94 | JVGLFLEXA | General Ledger: Actual Line Items | 19 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
95 | JVGLFLEXP | General Ledger: Plan Line Items | 21 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
96 | JVGLFLEXT | General Ledger: Totals | 28 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPProfit Center Accounting |
97 | GLPCA | EC-PCA: Actual Line Items | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
98 | GLPCP | EC-PCA: Plan Line Items | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
99 | GLPCT | EC-PCA: Totals Table | 16 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
100 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPRetail Ledger |
101 | PCRRETAILA | Actual line item table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
102 | PCRRETAILP | Plan line items table | 18 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
103 | PCRRETAILT | Totals Table | 17 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
TOPTariffs, Duties and Permits |
104 | OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger | 25 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
105 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 25 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |
106 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 24 | RFAREA | Functional Area | nvarchar | 16 | 0 | | |