| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPActual CostingMaterial Ledger |
| 1 | CKMLMV005 | Consumption alternatives | 10 | VTYP | Process category for consumption | nvarchar | 4 | 0 | | |
| TOPAdvertising Management |
| 2 | JHAKPV | IS-M/AM: OPM Header Sales Agent / Item Sales Agent | 9 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| 3 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 37 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| 4 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 34 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| 5 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 105 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| 6 | JJTVV | IS-M/AM: Media Sales Agent Contract | 3 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| 7 | TJH99 | IS-M/AM: Commission Related Billing Type Determination | 3 | VTYP | IS-M: Contract Category for Media Sales Agent Contract | nvarchar | 1 | 0 | | |
| TOPContract Billing |
| 8 | ETTIF | Instln Facts | 32 | VTYP | Contract category for heating installations | nvarchar | 4 | 0 | | |
| 9 | ETTIFB | Installation Facts (Reference Values) | 25 | VTYP | Contract category for heating installations | nvarchar | 4 | 0 | | |
| TOPMaster Data |
| 10 | TE687 | Contract Cat. of Heat. Install. | 2 | VTYP | Contract category for heating installations | nvarchar | 4 | 0 | | |
| 11 | TE687T | Texts: Contract Cat. of Heat. Installation | 3 | VTYP | Contract category for heating installations | nvarchar | 4 | 0 | | |
| TOPSAP Business Workflow |
| 12 | SWFVGO | General Object Visualization | 5 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 13 | SWFVGOP | General Object-Visualization Parameters | 5 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 14 | SWFVGT | General Task Visualization | 3 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 15 | SWFVGTP | General Task-Visualization Parameters | 3 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 16 | SWFVGVTP | General Visualization-Type Parameters | 2 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 17 | SWFVO | Object Visualization | 4 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 18 | SWFVOV | Object Visualization Parameter | 4 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 19 | SWFVT | Task Visualization | 2 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 20 | SWFVTV | Task Visualization Parameter | 2 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 21 | SWFVVTP | Visualization Type Parameter | 1 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
| 22 | SWFVWVT | WLC - Visualization Type | 2 | VTYP | Visualization Type | nvarchar | 10 | 0 | | |
