| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAP | IS-M/AM: Order-Publishing-Media Item | 27 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 2 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 95 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 3 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 92 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 4 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 71 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 5 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 68 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 6 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 91 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 7 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 105 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 8 | TJJCAMP | IS-M: Marketing Campaign | 2 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| 9 | TJJCAMPT | IS-M: Marketing Campaign Texts | 3 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| 10 | TJJCAMP_AM_ITYPE | IS-M/AM: Marketing Campaign - Item Type | 2 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| 11 | TJJCAMP_AM_T_ASS | IS-M/AM: Marketing Campaign- Assign Template Order | 2 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| 12 | TJJCAMP_SD_T_ASS | IS-M/SD: Marketing Campaign - Assign Template Offer | 2 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| 13 | TJJCAMP_SLS_AREA | IS-M/AM: Marketing Campaign - Sales Area | 2 | CAMPAIGN | IS-M: Marketing Campaign, Generic (GUID32) | nvarchar | 32 | 0 | | |
| TOPBasic Functions |
| 14 | CMPB_ASGN | Campaign Assignment | 4 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | | |
| TOPBilling |
| 15 | VBRP | Billing Document: Item Data | 219 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | | |
| TOPConditions |
| 16 | CMPB_MAP | Conversion Table CAIMPAIGN CRM <> CMPGN_ID | 2 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | | |
| TOPIntegration Customer Relationship Management |
| 17 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 18 | CAMPAIGN | IS-U: Marketing Campaign | varbinary | 16 | 0 | | |
| 18 | EVER_CRMQ | ISU Contract CRM-Entry Queue | 11 | CAMPAIGN | IS-U: Marketing Campaign | varbinary | 16 | 0 | | |
| TOPMaster Data |
| 19 | EVERH | IS-U Contract History | 14 | CAMPAIGN | IS-U: Marketing Campaign | varbinary | 16 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 20 | JKSENIP | IS-M: Shipping Schedule | 19 | CAMPAIGN | IS-M: Campaign | nvarchar | 24 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 21 | JFRP | IS-M/SD: Billing Document - Item Data | 117 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 22 | JKAP | Sales Order - Item Data | 133 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 23 | JKAP_INACTIVE | Publishing Sales Order: Inactive Item Data | 21 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | | |
| 24 | TJWAK | IS-M/SD: Sales Promotion | 35 | CAMPAIGN | IS-M: Default for Marketing Campaign | varbinary | 16 | 0 | | |
| TOPPrint Workbench |
| 25 | EPRINTACT | Print Action Record | 45 | CAMPAIGN | Marketing Campaign | nvarchar | 24 | 0 | | |
| TOPProcessing |
| 26 | EWMINSPDETAIL | Inspection List Detail | 2 | CAMPAIGN | Campaigns for inspections | nvarchar | 30 | 0 | | |
| 27 | EWMINSPHEAD | Inspection list header | 2 | CAMPAIGN | Campaigns for inspections | nvarchar | 30 | 0 | | |
| TOPSales |
| 28 | VBKD | Sales Document: Business Data | 78 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | | |
| TOPSimulation |
| 29 | VSVBKD_CN | Version: Sales document - commercial data | 79 | CAMPAIGN | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | | |
