| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLPCA_CT | Profit Center Documents | 101 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
2 | GLPCA_T_CT | Profit Center Documents | 117 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
3 | ZSAWA | Actual line item table | 38 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
4 | ZSAWP | Plan line items table | 118 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
5 | ZSEMBPSA | Actual line item table | 34 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
6 | ZSEMBPSP | Plan line items table | 114 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
7 | ZSPLITA | Isteinzelposten-Tabelle | 38 | REFDOCLN | Sechsstellige Nummer der Referenz-Buchungszeile | nvarchar | 6 | 0 | | |
8 | ZSPLITP | Planeinzelposten-Tabelle | 118 | REFDOCLN | Sechsstellige Nummer der Referenz-Buchungszeile | nvarchar | 6 | 0 | | |
9 | ZZ001A | Actual Line Item Table | 45 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
10 | ZZ001P | Plan Line Items Table | 125 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
11 | ZZLINEA | Actual line item table | 39 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
12 | ZZLINEP | Plan line items table | 103 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
13 | ZZSL01A | Actual line item table | 47 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
14 | ZZSL01P | Plan line items table | 127 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
15 | ZZSPECA | Actual line item table | 38 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
16 | ZZSPECP | Plan line item table | 102 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPAvailability Control |
17 | FMAVCA | Actual line item table | 37 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
18 | FMAVCP | Plan line items table | 85 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPBasic Functions |
19 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 48 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
20 | FILCP | FI-LC: Plan line items for object table | 126 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
21 | GGREFA | Example for Global FI-SL Line Items (Actual) | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
22 | GGREFP | Example for Global FI-SL Line Items (Plan) | 120 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
23 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 38 | REFDOCLN | Reference posting line within the accounting document | nvarchar | 3 | 0 | | |
24 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 102 | REFDOCLN | Reference posting line within the accounting document | nvarchar | 3 | 0 | | |
25 | GLFUNCU | Rollup line item tables with function area for IDES | 38 | REFDOCLN | Reference posting line within the accounting document | nvarchar | 3 | 0 | | |
26 | GLFUNCV | Rollup plan line items table with function area for IDES | 102 | REFDOCLN | Reference posting line within the accounting document | nvarchar | 3 | 0 | | |
27 | GLP0 | Local Logical General Ledger Plan Line Items | 76 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
28 | GLPO1 | Plan Line Items for Object Table | 128 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
29 | GLPO2 | Plan Line Items for Object Table Global | 136 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
30 | GLPO3 | Plan Line Items for Object Table | 128 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
31 | GLREFA | Example for Local FI-SL Line Items (Actual) | 38 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
32 | GLREFP | Example for Local FI-SL Line Items (Plan) | 118 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
33 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
34 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 120 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
35 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 49 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
36 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 57 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
37 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 49 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPBudgeting |
38 | FMBDA | Actual line item table | 38 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
39 | FMBDP | FM Budget change line items table | 86 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
40 | FMRBA | Actual line item table | 36 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
41 | FMRBP | Plan line items table | 84 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPCollectionsDisbursements |
42 | GLISDEA | Actual Line Item Tables for Insurance (DE) | 50 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
43 | GLISDEP | Plan Line Item Table for Insurance (DE) | 114 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
44 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 50 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
45 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 114 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPConsolidation |
46 | ECMCA | SAP Cons.: Journal Entry Table (Actual) | 47 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
TOPCost Element Accounting |
47 | COFIP | Single plan items for reconciliation ledger | 114 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
48 | COFIS | Actual line items for reconciliation ledger | 51 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
49 | FBICRC001A | ICRC: Open Items GL Accounts: Documents | 28 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
50 | FBICRC001P | Not in use | 43 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
51 | FBICRC002A | ICRC: GL Accounts: Documents | 28 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
52 | FBICRC002P | Not in use | 43 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
53 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 29 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
54 | FBICRC003P | Not in use | 44 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPFinancial Services Localization |
55 | /CEEIS/RUA | Actual line item table | 49 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
56 | /CEEIS/RUP | Plan line items table | 129 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPFlexible Real Estate Management |
57 | VIPRLEDTAGRA | Isteinzelposten-Tabelle | 28 | REFDOCLN | Sechsstellige Nummer der Referenz-Buchungszeile | nvarchar | 6 | 0 | | |
58 | VIPRLEDTAGRP | Planeinzelposten-Tabelle | 92 | REFDOCLN | Sechsstellige Nummer der Referenz-Buchungszeile | nvarchar | 6 | 0 | | |
TOPFund Accounting |
59 | FMCCAVCA | Actual line item table | 34 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
60 | FMCCAVCP | Plan line items table | 82 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
61 | FMGLFLEXP | General Ledger: Plan Line Items | 119 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
62 | PSGLFLEXP | General Ledger: Plan Line Items | 123 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPFunds Management |
63 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
64 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 44 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
65 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
66 | FMIA | Actual Line Item Table for Funds Management | 41 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
67 | FMIP | Plan Line Items Table for Funds Management | 73 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
68 | FMSPLITA | Actual line item table | 42 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
69 | FMSPLITP | Plan line items table | 74 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
70 | FMUSFGA | Actual line item table for US Federal Government. | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
71 | FMUSFGFACTS1A | 4Actual line item table | 40 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
72 | FMUSFGFACTS1P | Plan line items table | 71 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
73 | FMUSFGFACTS2A | Actual line item table | 44 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
74 | FMUSFGFACTS2P | Plan line items table | 75 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
75 | FMUSFGP | Plan line items table | 71 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
76 | PSBM_EVENT | PS Budget Monitoring Events | 8 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPGeneral Ledger Accounting |
77 | FAGLFLEXP | General Ledger: Plan Line Items | 121 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
78 | GLFLEXA | Flexible general ledger: Actual line items | 42 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
79 | GLFLEXP | Flexible G/L: Plan line items | 120 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPGrantee Management |
80 | GMAVCA | Actual line item table | 37 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
81 | GMAVCP | Plan line items table | 101 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
82 | GMIA | Actual Line Item Table | 35 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
83 | GMIP | Plan line items table | 83 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
84 | JVGLFLEXP | General Ledger: Plan Line Items | 123 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
85 | JVPO1 | JVA: Plan Line Items | 113 | REFDOCLN | Line Item in Joint Venture Reference Doc | nvarchar | 5 | 0 | | |
86 | JVPSC01A | Actual line item table | 48 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
87 | JVPSC01P | Plan line item table | 112 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
88 | JVSO1 | JV LI Table with Objects for JVTO1 | 49 | REFDOCLN | Line Item in Joint Venture Reference Doc | nvarchar | 5 | 0 | | |
89 | JVSO2 | JV Billing FI-SL Line Item | 33 | REFDOCLN | Line Item in Joint Venture Reference Doc | nvarchar | 5 | 0 | | |
90 | T8J_JVEC | JVA equity change document relationship | 14 | REFDOCLN | Line Item in Joint Venture Reference Doc | nvarchar | 5 | 0 | | |
TOPLocalization |
91 | J_3RFTAXRA | Tax Accounting: Actual line item table | 49 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
92 | J_3RFTAXRP | Tax Accounting: Plan line item table | 97 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
93 | J_3RFTAXRVA | Tax Accounting: Actual line item table | 49 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
94 | J_3RFTAXRVP | Tax Accounting: Plan line item table | 97 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
TOPProfit Center Accounting |
95 | GLPCA | EC-PCA: Actual Line Items | 45 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
96 | GLPCP | EC-PCA: Plan Line Items | 106 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPRegulatory reporting for insurance companies |
97 | ISSRFLDEA | Actual line item table | 72 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
98 | ISSRFLDEP | Plan line items table | 152 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
99 | /BEV3/CHFIA | Actual line item table | 36 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
100 | /BEV3/CHFIP | Plan Line Items Table | 116 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
101 | /BEV3/CHVGRA | Actual line item table | 38 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
102 | /BEV3/CHVGRP | Plan Line Items Table | 118 | REFDOCLN | Six-figure number of line item | nvarchar | 6 | 0 | | |
TOPRetail Ledger |
103 | PCRRETAILA | Actual line item table | 37 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
104 | PCRRETAILP | Plan line items table | 117 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPRevenues and Earnings |
105 | AD01DLI | Dynamic items (DI) | 58 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPSpecial Purpose Ledger |
106 | /CCIS/PBU18A | PBU18: Actual line item table | 51 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
107 | /CCIS/PBU18P | PBU18: Plan line item table | 131 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
108 | /CCIS/PROFTAXP | Plan Line Items Table for General Ledger | 131 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
TOPTariffs, Duties and Permits |
109 | OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger | 52 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
110 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 132 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
111 | OIHSLA | TDP (excise duty) special ledger actual line item table | 57 | REFDOCLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
112 | TRACTSLA | Actual Line Item Table | 30 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |
113 | TRACTSLP | Plan Line Items Table | 110 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | | |