| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 64 | BRAN1 | IS-M: Industry Sector for Advertiser | nvarchar | 10 | 0 | | |
| 2 | JHTVBPO | IS-M/AM: Contract Requirement Element | 41 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| 3 | JJTBB | IS-M/AM: Requirement Element of Media Sales Agent Contract | 10 | BRAN1 | IS-M: Industry Sector for Advertiser | nvarchar | 10 | 0 | | |
| 4 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 20 | BRAN1 | IS-M: Industry Sector for Advertiser | nvarchar | 10 | 0 | | |
| TOPCross-Application Components |
| 5 | BC490KKNA1 | General data in customer master | 71 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| 6 | KKNA1 | General Data in Customer Master | 71 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| 7 | SKNA1 | Customer Master table for BC417 Course | 71 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| TOPCustomer Master |
| 8 | KNA1 | General Data in Customer Master | 71 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| TOPData Collection |
| 9 | S018 | SIS: Address list for sales promotion | 14 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| 10 | S018E | S018 - Structural Information | 9 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| TOPMaster Data |
| 11 | JGTGPNR | IS-M: Central Business Partner Table | 18 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
| TOPSales Promotions |
| 12 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 59 | BRAN1 | Industry Code 1 | nvarchar | 10 | 0 | | |
