SAP ABAP Table CRMD_MKTHV_MC (CRM Marketing: Marketing Prospect Table)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTHV_MC (Package) CRM Marketing: Marketing Contact - High Volume
Basic Data
Table Category TRANSP    Transparent table 
Transparent table CRMD_MKTHV_MC   Table Relationship Diagram
Short Description CRM Marketing: Marketing Prospect Table    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Generic Key Structure  
2 CLIENT MANDT MANDT CLNT 3   0   Client *
3 GUID CRMT_MKTHV_MC_GENERIC_GUID SYSUUID RAW 16   0   CRM Marketing: Marketing Prospect Generic GUID  
4 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Structure  
5 ID CRMT_MKTHV_MC_ID CRM_MKTHV_MC_ID CHAR 10   0   Marketing Prospect ID  
6 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
7 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
8 NAME_FIRST CRMT_MKTHV_MC_FNAME CRM_MKTHV_MC_FNAME CHAR 40   0   CRM Marketing: Marketing Prospect First Name  
9 NAME_LAST CRMT_MKTHV_MC_LNAME CRM_MKTHV_MC_LNAME CHAR 40   0   CRM Marketing: Marketing Prospect Last Name  
10 NAMEMIDDLE CRMT_MKTHV_MC_MNAME CRM_MKTHV_MC_MNAME CHAR 40   0   CRM Marketing: Marketing Prospect Middle Name  
11 FULLNAME CRMT_MKTHV_MC_FULL_NAME CRM_MKTHV_MC_FULL_NAME CHAR 80   0   CRM Marketing: Marketing Prospect Full Name  
12 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
13 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
14 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) *
15 PREFIX1 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
16 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
17 LANGU_CORR LANGU SPRAS LANG 1   0   Language Key T002
18 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
19 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
20 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
21 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
22 STREET AD_STREET TEXT60 CHAR 60   0   Street  
23 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
24 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
25 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
26 .INCLUDE       0   0   CRM Marketing: Marketing Prospect EEW Include for Customer  
27 MC_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
28 .INCLUDE       0   0   Marketing Permission  
29 CONSENT_TEL CRMT_MC_MKTPERM_CONSENT_TEL CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for Telephone  
30 CONSENT_EMAIL CRMT_MC_MKTPERM_CONSENT_EMAIL CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for E-Mail  
31 CONSENT_FAX CRMT_MC_MKTPERM_CONSENT_FAX CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for Fax  
32 CONSENT_SMS CRMT_MC_MKTPERM_CONSENT_SMS CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for SMS  
33 ORIGIN CRMT_BU_MKTPERM_ORIGIN CRMT_BU_MKTPERM_ORIGIN CHAR 3   0   Form of Consent *
34 DATE_OF_CONSENT CRMT_BU_MKTPERM_ORIGIN_DATE DATS DATS 8   0   Marketing Permission: Date of Consent  
35 .INCLUDE       0   0   MC Structure - All data storted in Upper case  
36 NAME_FIRST_UC CRMT_MKTHV_MC_FNAME_UC CRM_MKTHV_MC_FNAME_UC CHAR 40   0   Marketing Prospect: First Name  
37 NAME_LAST_UC CRMT_MKTHV_MC_LNAME_UC CRM_MKTHV_MC_LNAME_UC CHAR 40   0   Marketing Prospect: Last Name  
38 NAMEMIDDLE_UC CRMT_MKTHV_MC_MNAME_UC CRM_MKTHV_MC_MNAME_UC CHAR 40   0   Marketing Prospect: Middle Name  
39 FULLNAME_UC CRMT_MKTHV_MC_FULL_NAME_UC CRM_MKTHV_MC_FULL_NAME_UC CHAR 80   0   Marketing Prospect: Full Name  
40 STREET_UC CRMT_MKTHV_MC_STREET_UC CRM_MKTHV_MC_STREET_UC CHAR 60   0   Street  
41 CITY1_UC CRMT_MKTHV_MC_CITY1_UC CRM_MKTHV_MC_CITY1_UC CHAR 40   0   City  
42 COMPANY_NAME_UC CRMT_MKTHV_MC_COMP_NAME_UC CRM_MKTHV_MC_COMP_NAME_UC CHAR 40   0   Company Name  
43 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Miscellaneous Attr Struct.  
44 INVALID_EMAIL CRMT_MKTHV_MC_INVALID_EMAIL CRMT_MKTHV_MC_BOOLEAN CHAR 1   0   CRM Marketing: Marketing Prospect Invalid E-Mail  
45 USAGE_COUNT INT4 INT4 INT4 10   0   Natural number  
46 RENTED BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
47 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Organization Data  
48 COMPANY_ID CRMT_MKTHV_MC_COMP_ID BU_PARTNER CHAR 10   0   Company ID *
49 COMPANY_TITLE CRMT_MKTHV_MC_COMP_TITLE AD_TITLE CHAR 4   0   Company Title TSAD3
50 COMPANY_NAME CRMT_MKTHV_MC_COMP_NAME BU_NAME CHAR 40   0   Company Name  
51 COMP_LEGAL_FORM CRMT_MKTHV_MC_COMP_LEGENTY BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
52 COMP_TELNR_LONG CRMT_MKTHV_MC_COMP_TELNR CHAR30 CHAR 30   0   Company First Telephone No.: Dialling code+Number  
53 COMP_FAXNR_LONG CRMT_MKTHV_MC_COMP_FXNRLNG CHAR30 CHAR 30   0   Company Fax Number: Dialling Code+Number+Extension  
54 COMPANY_URL CRMT_MKTHV_MC_COMP_URISCR AD_URISCR CHAR 132   0   Company URI, e.g. Homepage or ftp Address  
55 COMPANY_COUNTRY CRMT_MKTHV_MC_COMP_LAND1 LAND1 CHAR 3   0   Company Country Key T005
56 COMPANY_REGION CRMT_MKTHV_MC_COMP_REGIO REGIO CHAR 3   0   Company Region (State, Province, County) T005S
57 COMPANY_CITY CRMT_MKTHV_MC_COMP_CITY1 TEXT40 CHAR 40   0   Company City  
58 COMP_POSTAL_CODE CRMT_MKTHV_MC_COMP_PSTCD1 CHAR10 CHAR 10   0   Company City Postal Code  
59 COMPANY_PO_BOX CRMT_MKTHV_MC_COMP_POBX CHAR10 CHAR 10   0   Company PO Box  
60 COMPANY_STREET CRMT_MKTHV_MC_COMP_STREET TEXT60 CHAR 60   0   Company Street  
61 COMPANY_HOUSE_NO CRMT_MKTHV_MC_COMP_HSNM1 CHAR10 CHAR 10   0   Company House Number  
62 COMPANY_EMAIL CRMT_MKTHV_MC_COMP_SMTPADR AD_SMTPADR CHAR 241   0   Company E-Mail Address  
63 PROSP_FUN_NAME CRMT_MKTHV_MC_COMP_FNCTN TEXT40 CHAR 40   0   Function Name of Partner  
64 PROSPECT_FUN_KEY CRMT_MKTHV_MC_COMP_PAFKT BU_PAFKT CHAR 4   0   Function of Partner *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMD_MKTHV_MC COMPANY_COUNTRY T005 LAND1 REF 1 CN
2 CRMD_MKTHV_MC COMPANY_REGION T005S BLAND REF C CN
3 CRMD_MKTHV_MC COMPANY_TITLE TSAD3 TITLE REF 1 CN
4 CRMD_MKTHV_MC COMP_LEGAL_FORM TB019 LEGAL_ENTY KEY 1 CN
5 CRMD_MKTHV_MC COUNTRY T005 LAND1 REF 1 CN
6 CRMD_MKTHV_MC LANGU_CORR T002 SPRAS    
7 CRMD_MKTHV_MC REGION T005S BLAND REF C CN
8 CRMD_MKTHV_MC TITLE TSAD3 TITLE    
History
Last changed by/on SAP  20140117 
SAP Release Created in 700