| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZSAWA | Actual line item table | 30 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
2 | ZSAWP | Plan line items table | 110 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
3 | ZSAWT | Summary table | 109 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
4 | ZSEMBPSA | Actual line item table | 26 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
5 | ZSEMBPSP | Plan line items table | 106 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
6 | ZSEMBPST | Summary table | 105 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
7 | ZSPLITA | Isteinzelposten-Tabelle | 30 | AUNIT | Zusatzmengeneinheit | nvarchar | 3 | 0 | | |
8 | ZSPLITP | Planeinzelposten-Tabelle | 110 | AUNIT | Zusatzmengeneinheit | nvarchar | 3 | 0 | | |
9 | ZSPLITT | Summentabelle | 109 | AUNIT | Zusatzmengeneinheit | nvarchar | 3 | 0 | | |
10 | ZZ001A | Actual Line Item Table | 37 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
11 | ZZ001P | Plan Line Items Table | 117 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
12 | ZZ001T | Summary Table | 116 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
13 | ZZSL01A | Actual line item table | 39 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
14 | ZZSL01P | Plan line items table | 119 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
15 | ZZSL01T | Summary table | 118 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPBasic Functions |
16 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 39 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
17 | FILCP | FI-LC: Plan line items for object table | 118 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
18 | FILCT | FI-LC: Global totals table with 2 object tables | 118 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
19 | GGREFA | Example for Global FI-SL Line Items (Actual) | 32 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
20 | GGREFP | Example for Global FI-SL Line Items (Plan) | 112 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
21 | GGREFT | Example for Global FI-SL Summary Table | 111 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
22 | GLP0 | Local Logical General Ledger Plan Line Items | 69 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
23 | GLPO1 | Plan Line Items for Object Table | 119 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
24 | GLPO2 | Plan Line Items for Object Table Global | 127 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
25 | GLPO3 | Plan Line Items for Object Table | 119 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
26 | GLREFA | Example for Local FI-SL Line Items (Actual) | 30 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
27 | GLREFP | Example for Local FI-SL Line Items (Plan) | 110 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
28 | GLREFT | Example for Local FI-SL Summary Table | 109 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
29 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 31 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
30 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 111 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
31 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 39 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
32 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 47 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
33 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 39 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
34 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 116 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
35 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 124 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
36 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 116 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPFinancial Services Localization |
37 | /CEEIS/RUA | Actual line item table | 41 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
38 | /CEEIS/RUP | Plan line items table | 121 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
39 | /CEEIS/RUT | Totals Table | 120 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
40 | JVPO1 | JVA: Plan Line Items | 103 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
41 | JVSO1 | JV LI Table with Objects for JVTO1 | 39 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPPublic Sector |
42 | T5QPBS2A | Parameter setting for Prior Service and Leave Management | 21 | AUNIT | Accrual unit | nvarchar | 3 | 0 | | |
TOPRegulatory reporting for insurance companies |
43 | ISSRFLDEA | Actual line item table | 64 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
44 | ISSRFLDEP | Plan line items table | 144 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
45 | ISSRFLDET | Summary table | 143 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
46 | /BEV3/CHFIA | Actual line item table | 28 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
47 | /BEV3/CHFIP | Plan Line Items Table | 108 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
48 | /BEV3/CHFIT | Totals table | 107 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
49 | /BEV3/CHVGRA | Actual line item table | 30 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
50 | /BEV3/CHVGRP | Plan Line Items Table | 110 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
51 | /BEV3/CHVGRT | Totals table | 109 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPRetail Ledger |
52 | PCRRETAILA | Actual line item table | 29 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
53 | PCRRETAILP | Plan line items table | 109 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
54 | PCRRETAILT | Totals Table | 108 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPSpecial Purpose Ledger |
55 | /CCIS/PBU18A | PBU18: Actual line item table | 43 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
56 | /CCIS/PBU18P | PBU18: Plan line item table | 123 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
57 | /CCIS/PBU18T | PBU18: Summary table x | 122 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
58 | OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger | 44 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
59 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 124 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
60 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 123 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
61 | OIHSLA | TDP (excise duty) special ledger actual line item table | 48 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
62 | OIHSLT | TDP (excise duty) special ledger summary table | 90 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
63 | TRACTSLA | Actual Line Item Table | 22 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
64 | TRACTSLP | Plan Line Items Table | 102 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |
65 | TRACTSLT | Totals Table | 101 | AUNIT | Additional unit of measure | nvarchar | 3 | 0 | | |