| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TTS_HOT_SUB | Table Control Data for Hot Sub Screen | 4 | ITEMNO | Item Number | nvarchar | 4 | 0 | | |
| TOPContract Billing |
| 2 | EMDUSDRQEXCL | Exception Days for Subrequest | 4 | ITEMNO | Sequence Number for Exception Periods | nvarchar | 8 | 0 | | |
| TOPDistributor-Reseller-Management |
| 3 | /SAPHT/DRMSDRJN | Rejections reasons for a staging record | 3 | ITEMNO | Rejection items for staging record | nvarchar | 6 | 0 | | |
| TOPFlexible Real Estate Management |
| 4 | TIVXCMSSPOSCE | Item in Schema: Assignment to Cost Element | 2 | ITEMNO | Unique Key of Data Record | nvarchar | 10 | 0 | | |
| 5 | VIXCRAESRREFI | Assignment of ISR Ref./Cash Flow Plan (Item) | 15 | ITEMNO | Accounting Document Line Item Number | nvarchar | 10 | 0 | | |
| TOPInput Tax Treatment |
| 6 | VIITTAXDSBASE | Tax Document Item to Be Broken Down (VIITTAXDSBASE) | 3 | ITEMNO | Internal Item Number for Tax Document Item | nvarchar | 10 | 0 | | |
| 7 | VIITTAXDSITEM | Distributed Tax Document Item (VIITTAXDSITEM) | 4 | ITEMNO | Internal Item Number for Tax Document Item | nvarchar | 10 | 0 | | |
| TOPInterface to Terminal Automation System |
| 8 | OIK01 | IS-OIL/TAS: LID Document Data | 4 | ITEMNO | SAP document item for TAS | nvarchar | 10 | 0 | | |
| 9 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 4 | ITEMNO | SAP document item for TAS | nvarchar | 10 | 0 | | |
| 10 | OIK02A | IS-OIL/TAS: Status of processed functions | 13 | ITEMNO | SAP document item for TAS | nvarchar | 10 | 0 | | |
| 11 | OIKLIDR | TD - TAS Reference Table | 8 | ITEMNO | SAP document item for TAS | nvarchar | 10 | 0 | | |
| TOPLease Accounting |
| 12 | /LSIERP/WLI_IL | Item List of Work Item | 15 | ITEMNO | Item Number | nvarchar | 10 | 0 | | |
| 13 | FILA_GF_ITEMDATA | Process Data | 9 | ITEMNO | Item Number | nvarchar | 10 | 0 | | |
| 14 | FILA_MIG_SYNC | Synchronization of CRM and LAE Legacy Data | 4 | ITEMNO | Item Number | nvarchar | 10 | 0 | | |
| 15 | FILA_RE_TR_I | Tranche Item: Selection Result for Refinancing | 8 | ITEMNO | Item Number | nvarchar | 10 | 0 | | |
| 16 | LAE_CRM_ITEMS | LAE: Contract Items | 8 | ITEMNO | Item Number | nvarchar | 10 | 0 | | |
| TOPLocalization |
| 17 | TIVXCFRSBA | Obsolete - To be deleted!!! | 7 | ITEMNO | Sequence number for sales amount and percentage | nvarchar | 3 | 0 | | |
| TOPMarketing, Accounting and Pricing |
| 18 | OIC_FO_ITM_MIGR | Formula Structure Pattern - Term Item Pattern | 4 | ITEMNO | Formula term item number | nvarchar | 5 | 0 | | |
| TOPRental Accounting |
| 19 | TIVRAOPACTI | Settings for Line Item | 4 | ITEMNO | Sequence Number of Line Item | nvarchar | 10 | 0 | | |
| 20 | VIEXFIWTITEM | Term: Withholding Tax Item | 6 | ITEMNO | Number of the Withholding Tax Item | nvarchar | 4 | 0 | | |
| 21 | VIRADOCITEM | RE Document Item | 3 | ITEMNO | Accounting Document Line Item Number | nvarchar | 10 | 0 | | |
| 22 | VIRAINVITEM | RE Invoice Item | 3 | ITEMNO | Item Number in RE Invoice | nvarchar | 10 | 0 | | |
| TOPRoom Reservations and Seating Arrangements |
| 23 | VIORRSCOST | Reservation - Costs | 21 | ITEMNO | Accounting Document Line Item Number | nvarchar | 10 | 0 | | |
| TOPSales-Based Rent and Settlement |
| 24 | VISRCALCDETAIL | Results of Sales Grading Calculation | 3 | ITEMNO | Sequence number for sales amount and percentage | nvarchar | 3 | 0 | | |
| 25 | VISRTMSBRPI | Assignment of Reporting Rule to Sales Rule (Grading) | 6 | ITEMNO | Sequence number for sales amount and percentage | nvarchar | 3 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 26 | NWCHEXTREF | IS-H CH: Referenzschlüssel zur Leistung aus externem System | 2 | ITEMNO | IS-H CH: XML - chiave di rif. prestazione da sistema esterno | nvarchar | 64 | 0 | | |
| 27 | NWCHLS_RNLRZE | IS-H CH: ALIS-Fehlerhandlung - externes System (RNLRZE_CH) | 9 | ITEMNO | IS-H CH: XML - chiave di rif. prestazione da sistema esterno | nvarchar | 64 | 0 | | |
