| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JJTPRDH_DACHPR | IS-M/AM Product Hierarchy (S&P): Umbrella Products | 15 | MODKZ | IS-M/AM: Modification Indicator | nvarchar | 1 | 0 | | |
| 2 | JJTPRDH_PRFAM | IS-M/AM Product Hierarchy (S&P): Product Families | 14 | MODKZ | IS-M/AM: Modification Indicator | nvarchar | 1 | 0 | | |
| 3 | JJTPRDH_PRGR | IS-M/AM Product Hierarchy (S&P): Product Groups | 13 | MODKZ | IS-M/AM: Modification Indicator | nvarchar | 1 | 0 | | |
| 4 | JJTPRDH_PROD | IS-M/AM: Products (S&P Product Hierarchy) | 18 | MODKZ | IS-M/AM: Modification Indicator | nvarchar | 1 | 0 | | |
| 5 | JJTPRDH_WB | IS-M/AM (S&P Product Hierarchy): Economic Sectors | 12 | MODKZ | IS-M/AM: Modification Indicator | nvarchar | 1 | 0 | | |
| TOPGeneral status management |
| 6 | TJ07 | Influence of system status on transactions | 4 | MODKZ | Modification flag | nvarchar | 1 | 0 | | |
| 7 | TJ31 | Process control (user status) | 5 | MODKZ | Modification flag | nvarchar | 1 | 0 | | |
| TOPPatient Management |
| 8 | NPEZ | IS-H: Assignment of postal code to geographical area | 9 | MODKZ | IS-H: Indicator Source of NPLZ/NPEZ Record | nvarchar | 1 | 0 | | |
| 9 | NPLZ | IS-H: Postal code catalog | 14 | MODKZ | IS-H: Indicator Source of NPLZ/NPEZ Record | nvarchar | 1 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 10 | JYTDYNM | IS-M/SD: Settings for Screen Field Modification | 6 | MODKZ | Screen field modification indicator | nvarchar | 1 | 0 | | |
| TOPRetail Pricing |
| 11 | WPFGR | Family Pricing: Defintion of Family Groups | 6 | MODKZ | Price Family: Indicator for Permitted Price Change | nvarchar | 1 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 12 | /ISHFR/TJ07 | Influence of system status on transactions | 6 | MODKZ | Modification flag | nvarchar | 1 | 0 | | |
