| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /ATL/HOLIDAYS | Holidays Administration | 2 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| 2 | T028A | Bank Statement Table | 4 | JAHR | Bank statement year | nvarchar | 4 | 0 | | |
| 3 | ZAC99000 | Senderstruktur AC99000 | 4 | JAHR | | nvarchar | 4 | 0 | | |
| 4 | ZARTJ | RT Article Table for Data Generation | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 5 | ZDG00 | Data generation time control | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 6 | ZDG10 | MM data generation table | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 7 | ZDG20 | SD data generation table | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 8 | ZDG30 | SD data generation table | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 9 | ZDG40 | Table for Data Generation (Repetitive Manufacturing) | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 10 | ZDG50 | Table ZDG50 for Data Gen. in RT Area (Monthly via ZARTJ) | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 11 | ZDG60 | Table ZDG60 for Data Gen. in RT Area (Monthly via ZARTJ) | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 12 | ZMAMM | MM-Material Table for Data Generation | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 13 | ZMAPP | SD-Material Table for Data Generation | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| 14 | ZMASD | SD-Material Table for Data Generation | 3 | JAHR | Year for which levy is to be carried out | nvarchar | 4 | 0 | | |
| TOPArchiving Engine |
| 15 | TARESTAT02 | Archiving Monitor: InfoCube Dimension Time | 5 | JAHR | Year | nvarchar | 4 | 0 | | |
| 16 | TARESTAT03 | Archiving Monitor: InfoCube Dimension Rejection Reasons | 5 | JAHR | Year | nvarchar | 4 | 0 | | |
| TOPAustria |
| 17 | P03_KSJ_ADM | Administration of Municipal Tax Returns to FinanzOnline | 5 | JAHR | Year | nvarchar | 4 | 0 | | |
| TOPBasic Data |
| 18 | NLSU | IS-H: Totals File for Service Statistics | 4 | JAHR | IS-H: Year to be evaluated in statistics | nvarchar | 4 | 0 | | |
| TOPClaims Management |
| 19 | TICL128 | Building Insurance: Sliding Replacement Cost Factor | 2 | JAHR | Calendar Year | nvarchar | 4 | 0 | | |
| TOPCompany Pension Scheme Germany |
| 20 | P01RBM_STAT | Notification Status: Pension Receipt Notifications | 6 | JAHR | Year of Inflow/Outflow of Benefit | nvarchar | 4 | 0 | | |
| 21 | P01RBM_STAT_R | Status of Confirmations (Pension Receipt Notifications) | 6 | JAHR | Year of Inflow/Outflow of Benefit | nvarchar | 4 | 0 | | |
| TOPData Collection |
| 22 | S117 | Receipt/article | 44 | JAHR | Year | nvarchar | 4 | 0 | | |
| 23 | S119 | Transaction Number (Till Receipt) | 38 | JAHR | Year | nvarchar | 4 | 0 | | |
| 24 | S953 | BW Vorl.für BON/Artikel S117 | 44 | JAHR | Jahr | nvarchar | 4 | 0 | | |
| 25 | S954 | BW Vorl.für BON S119 | 38 | JAHR | Jahr | nvarchar | 4 | 0 | | |
| TOPDenmark |
| 26 | T5M6A | Assignment of Leave Types to Wage Types | 4 | JAHR | Year for Which Leave Accumulation is to Be Accumulated | nvarchar | 1 | 0 | | |
| TOPExcise Duty |
| 27 | /BEV2/EDARCDOCID | Index Table for Archive Documents | 8 | JAHR | Year-End Settlement Period Excise Duty | nvarchar | 4 | 0 | | |
| 28 | /BEV2/EDARCMDID | Excise Duty: IDs for Objects to Be Archived | 4 | JAHR | Year-End Settlement Period Excise Duty | nvarchar | 4 | 0 | | |
| TOPGeneral Ledger Accounting |
| 29 | FMPEB_ASSIGN | Assign Org. Units to Partially Exempt Organizations | 2 | JAHR | Fiscal Year | nvarchar | 4 | 0 | | |
| 30 | FMPEB_ASSIGN_H | Assignment of Org. Units to Partially Exempt Organizations | 2 | JAHR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPGermany |
| 31 | PD3DBAN | HR-DDU: Address Data Module | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 32 | PD3DBEU | HR-DDU: Data Module - European Insurance Number | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 33 | PD3DBGB | HR-DDU: Data Module - Birth Details | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 34 | PD3DBKS | HR-DDU: Data Module - Miners'/Sailors' Insurance | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 35 | PD3DBME | HR-DDU: Reporting Facts Data Module | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 36 | PD3DBNA | HR-DDU: Name Data Module | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 37 | PD3DBSO | HR-DDU: Immediate Notification Data Module | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 38 | PD3DBSV | HR-DDU: Social Insurance Card Data Module | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 39 | PD3DBUV | DEUEV: Data Module DBUV - Accident Insurance | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 40 | PD3DBUV_DAT | DEUEV AI Data for Module DBUV - Accident Insurance | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 41 | PD3DSAP | HR-DDU: Administration Record for Notifications | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 42 | PD3DSME | HR-DDU: Data Record Notfication | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 43 | PD3FLAG | HR-DDU: Notifications Indicator | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
| 44 | TFACS | Factory calendar (display) | 2 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| 45 | TFAIN | Calendar: Intervals for company holidays, special shifts | 2 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| 46 | TFAIT | Calendar: Text for factory calendar intervals | 3 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| 47 | THOCS | Public holiday calendar (display) | 2 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| 48 | THOLU | Dates of movable public holidays | 2 | JAHR | Year stored | nvarchar | 4 | 0 | | |
| TOPPendulum List Indirect Sales |
| 49 | /BEV4/PLDANFKON | Converted Request Table with Reporting Period | 13 | JAHR | Reporting Year | nvarchar | 4 | 0 | | |
| 50 | /BEV4/PLDANFMEL | Request Table with Reporting Period | 10 | JAHR | Reporting Year | nvarchar | 4 | 0 | | |
| 51 | /BEV4/PLDANFZEIT | Requirement Update | 8 | JAHR | Reporting Year | nvarchar | 4 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 52 | JLTPSTAUFL | IS-M/SD: Average Postal Circulation of an Edition | 4 | JAHR | Year of Publication | nvarchar | 4 | 0 | | |
| TOPPlant Maintenance |
| 53 | Z9I_STK_KOMPLEX | Komplexstillstände | 2 | JAHR | Jahr, für das eine Erhebung durchgeführt werden soll | nvarchar | 4 | 0 | | |
| TOPPublic Sector |
| 54 | PDPBSZV363 | Estimated Tax-Free Contributions (Acc. to Sec.3 No.63) | 4 | JAHR | Payroll year for determining time period | nvarchar | 4 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 55 | /BEV3/CHKATMABUM | Customer Evaluation Table: Sales per Date | 6 | JAHR | Year | nvarchar | 4 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 56 | NWATAGBA | IS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 57 | NWATAGBE | IS-H AT: Ambulanzgebühren - Erfassungsdaten | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 58 | NWATAGBF | IS-H AT: Ambulanzgebühren - Fakturapositionen | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 59 | NWATALS | IS-H AT: Ambulante Leistungsstatistik | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 60 | NWATALSE | IS-H AT: Amb. Leistungsstatistik - Ergebnisse | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 61 | NWATALSF | IS-H AT: Amb. Leistungsstatistik - Fakturen | 4 | JAHR | IS-H AT: Jahr für amb. Leistungsstatistik/Ambulanzgeb. | nvarchar | 4 | 0 | | |
| 62 | NWATSCOPD | IS-H AT: Scoring - Laufende Nummer pro Periode | 3 | JAHR | IS-H AT: Scoring Berichtsjahr (vierstellig) | nvarchar | 4 | 0 | | |
| 63 | TNWATSCD | IS-H AT: Systeminformationen für EDI-Scoring | 2 | JAHR | IS-H AT: Scoring Berichtsjahr (vierstellig) | nvarchar | 4 | 0 | | |
| TOPSocial Insurance |
| 64 | P01BM_STAT | Control Records for PPO DEUEV Notifications | 4 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 65 | P01D3_DSAP | DEUEV Confirmation: Control Record for Notifications | 17 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 66 | P01DS_STAT | Control Records for DEUEV Immediate Notifications | 4 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 67 | PD3DBKV | DEUEV: Data Module Health Insurance | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| 68 | PD3HIST | Status History Management for DEUEV Notifications | 3 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | |
| TOPTax |
| 69 | T5D2I | StADUEV Notifications: Transfer Numbers | 8 | JAHR | StADUEV: Year of Registration | nvarchar | 4 | 0 | | |
