| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHTVGPZ | IS-M/AM: Business Partner Assignment to the Contract | 9 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 2 | JJTBEBVTP | IS-M: Distribution BU Planned Quantities Assignment | 4 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 3 | JJTBEVARI | IS-M/AM: Ad Insert BU Variants | 4 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 4 | JJTBEWSIN | IS-M/AM: Booking Unit Content for Commercial | 12 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 5 | JJTFPLZOLZUO | IS-M/AM: Online Fixed Spaces Grouping | 4 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 6 | JJTFPLZONL | IS-M/AM: Online Fixed Spaces | 7 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 7 | JJTKNTKTZHL | IS-M: Online Planned Gross Impressions | 6 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 8 | JJTOBJIN | IS-M/AM: Planned Production Unit - Content | 8 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 9 | JJTWSIN | IS-M/AM: Assignment of Content Components to a BU | 7 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 10 | JJTZKI | IS-M/AM: Content of Date Combination BU | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 11 | TJHVAAA | IS-M/AM: Structure of Scale Access for Contract Settlement | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 12 | TJJKAMP | IS-M/AM: Campaign (Customer) | 6 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 13 | JDTPVAWGRP | IS-M/SD: Edition Plant Assignment to Bundle Group | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 14 | JKAMOPLAN | IS-M/SD: Amortization Plan for Billing Cycle | 10 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 15 | JKAP | Sales Order - Item Data | 4 | GUELTIGVON | Valid-From Date of Sales Order Item | nvarchar | 8 | 0 | | |
| 16 | JKAP_INACTIVE | Publishing Sales Order: Inactive Item Data | 5 | GUELTIGVON | Valid-From Date of Sales Order Item | nvarchar | 8 | 0 | | |
| 17 | JKEP | Sales Order: Schedule Line Data | 5 | GUELTIGVON | Date from Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 18 | JKPA | Sales Order: Partner | 6 | GUELTIGVON | Date from Which Partner Data in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 19 | JKPAUNV | IS-M/SD: Sales Order, Incompletion Status | 4 | GUELTIGVON | Date from Which Partner Data in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 20 | JKPAZ | Sales Order Item: Additional Planning Data | 7 | GUELTIGVON | Valid From Date of Order-Del.Via.Assgmt for Sales Ord.Item | nvarchar | 8 | 0 | | |
| 21 | JKPROM | Sales Order: Introduction Data | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 22 | JKWERB | Publishing Sales Order: Promotion Data | 6 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 23 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 24 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 63 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 25 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 26 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 27 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 48 | GUELTIGVON | Valid-From Date of Sales Order Item | nvarchar | 8 | 0 | | |
| 28 | JKWWWTEMP_SUSP | IS-M: Temporary Internet Table: Suspension Data | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 29 | JKWWWTEMP_TRNSF | IS-M: Internet Temporary Table: Transfer Data | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 30 | JKWWW_PROTOCOL | IS-M: Table for Logging Creation/Changes made with IACs | 12 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 31 | JLRP | IS-M/SD: Item Data for Settlement | 150 | GUELTIGVON | IS-M: Start of delivery of sales order item | nvarchar | 8 | 0 | | |
| 32 | JRTBEABST | IS-M/SD: Unloading Point | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 33 | JRTRVERT | IS-M/SD: Truck Route Contract | 4 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 34 | JRTRVPOS | IS-M/SD: Item in Truck Route Contract | 6 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 35 | JVTBEZPOT | IS-M: Carrier Route, Time-Dependent Planned Circulation | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 36 | JVTFRGLART | IS-M/SD: Determination of Postal Packing Rule | 8 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 37 | JVTGEOPOT | IS-M: Geographical Unit, Time-Dependent Planned Circulation | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 38 | JVTMC_HH_SUSPEND | IS-M: TMC - Explicit Exclusion of Households | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 39 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 7 | GUELTIGVON | Valid From Date of Order-Del.Via.Assgmt for Sales Ord.Item | nvarchar | 8 | 0 | | |
| 40 | JVTNCT5 | IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.) | 8 | GUELTIGVON | Date from Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 41 | JVTPSHFIND | IS-M/SD: Production Procedure Determination | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 42 | JVTVARTIME | IS-M/SD: Time Slice Variant | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 43 | JVTVERPLAN | IS-M/SD: Shipping Schedule | 13 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 44 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 8 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 45 | JWAUART | IS-M/SD: Campaign Framework Proposal for Sales Document Type | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 46 | JWBASI | IS-M/SD: Campaign Framework | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 47 | JWEVENT | IS-M/SD: Events for Campaign Framework Proposal | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 48 | JWPROV | IS-M/SD: Allowed Commission Recipients for Camp.Framework | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 49 | JWSAPR | IS-M/SD: Gift | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 50 | JWTRAE | IS-M/SD: Allowed Advertising Media for Campaign Framework | 7 | GUELTIGVON | Start of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 51 | TJIABCZONES | Definition of ABZ Zones per Edition | 7 | GUELTIGVON | Valid from date | nvarchar | 8 | 0 | | |
| 52 | TJL15 | IS-M/SD: Determine FI Tax Code | 4 | GUELTIGVON | IS-M: Start of validity of tax code | nvarchar | 8 | 0 | | |
| 53 | TJL29 | IS-M/SD: Postal Settlement Types | 3 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 54 | TJL30 | IS-M/SD: Postal Settlement Types (Texts) | 4 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 55 | TJL35 | IS-M/SD: Master Data for Contract Arrangement Determination | 9 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 56 | TJL39 | IS-M/SD: Master Data for Contract Arrangement Determination | 9 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 57 | TJL42 | IS-M/SD: Master Data for External Contract Arrangement Det. | 8 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 58 | TJL44 | IS-M/SD: Master Data for External Contract Arrangement Det. | 8 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 59 | TJLPB | IS-M/SD: Assign Insert Data to Postal Settlement NUubers | 7 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 60 | TJLPT | IS-M/SD: Assgt of Carrying Issue Data to Postal Settlemt Nos | 5 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
| 61 | TJWAK | IS-M/SD: Sales Promotion | 3 | GUELTIGVON | Start of Validity of Sales Promotion | nvarchar | 8 | 0 | | |
| TOPSAP Media |
| 62 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 13 | GUELTIGVON | Valid-From Date | nvarchar | 8 | 0 | | |
