SAP ABAP Table CRMS_MKTHV_MC_QUERY_IL (CRM Marketing: Marketing Contact Query Structure.)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MP (Application Component) Marketing Prospect
     ⤷ CRM_MKTHV_MC_IL (Package) CRM Marketing: Marketing Contact BOL/GenIL
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_MKTHV_MC_QUERY_IL   Table Relationship Diagram
Short Description CRM Marketing: Marketing Contact Query Structure.    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Structure  
2 ID CRMT_MKTHV_MC_ID CRM_MKTHV_MC_ID CHAR 10   0   Marketing Prospect ID  
3 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
4 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
5 NAME_FIRST CRMT_MKTHV_MC_FNAME CRM_MKTHV_MC_FNAME CHAR 40   0   CRM Marketing: Marketing Prospect First Name  
6 NAME_LAST CRMT_MKTHV_MC_LNAME CRM_MKTHV_MC_LNAME CHAR 40   0   CRM Marketing: Marketing Prospect Last Name  
7 NAMEMIDDLE CRMT_MKTHV_MC_MNAME CRM_MKTHV_MC_MNAME CHAR 40   0   CRM Marketing: Marketing Prospect Middle Name  
8 FULLNAME CRMT_MKTHV_MC_FULL_NAME CRM_MKTHV_MC_FULL_NAME CHAR 80   0   CRM Marketing: Marketing Prospect Full Name  
9 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
10 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
11 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) *
12 PREFIX1 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
13 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
14 LANGU_CORR LANGU SPRAS LANG 1   0   Language Key T002
15 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
16 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
17 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
18 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
19 STREET AD_STREET TEXT60 CHAR 60   0   Street  
20 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
21 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
22 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
23 .INCLUDE       0   0   CRM Marketing: Marketing Prospect EEW Include for Customer  
24 MC_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
25 .INCLUDE       0   0   Marketing Permission  
26 CONSENT_TEL CRMT_MC_MKTPERM_CONSENT_TEL CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for Telephone  
27 CONSENT_EMAIL CRMT_MC_MKTPERM_CONSENT_EMAIL CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for E-Mail  
28 CONSENT_FAX CRMT_MC_MKTPERM_CONSENT_FAX CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for Fax  
29 CONSENT_SMS CRMT_MC_MKTPERM_CONSENT_SMS CRMT_BU_MKTPERM_PERMISSION NUMC 3   0   Consent ID for SMS  
30 ORIGIN CRMT_BU_MKTPERM_ORIGIN CRMT_BU_MKTPERM_ORIGIN CHAR 3   0   Form of Consent *
31 DATE_OF_CONSENT CRMT_BU_MKTPERM_ORIGIN_DATE DATS DATS 8   0   Marketing Permission: Date of Consent  
32 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Technical Structure  
33 BP_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
34 EXTRN_LIST_ID CRMT_MKTLIST_LIST_ID CRM_MKTLIST_LIST_ID CHAR 28   0   CRM Marketing: ID for External List  
35 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Miscellaneous Attr Struct.  
36 INVALID_EMAIL CRMT_MKTHV_MC_INVALID_EMAIL CRMT_MKTHV_MC_BOOLEAN CHAR 1   0   CRM Marketing: Marketing Prospect Invalid E-Mail  
37 USAGE_COUNT INT4 INT4 INT4 10   0   Natural number  
38 RENTED BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
39 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Organization Data  
40 COMPANY_ID CRMT_MKTHV_MC_COMP_ID BU_PARTNER CHAR 10   0   Company ID *
41 COMPANY_TITLE CRMT_MKTHV_MC_COMP_TITLE AD_TITLE CHAR 4   0   Company Title TSAD3
42 COMPANY_NAME CRMT_MKTHV_MC_COMP_NAME BU_NAME CHAR 40   0   Company Name  
43 COMP_LEGAL_FORM CRMT_MKTHV_MC_COMP_LEGENTY BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
44 COMP_TELNR_LONG CRMT_MKTHV_MC_COMP_TELNR CHAR30 CHAR 30   0   Company First Telephone No.: Dialling code+Number  
45 COMP_FAXNR_LONG CRMT_MKTHV_MC_COMP_FXNRLNG CHAR30 CHAR 30   0   Company Fax Number: Dialling Code+Number+Extension  
46 COMPANY_URL CRMT_MKTHV_MC_COMP_URISCR AD_URISCR CHAR 132   0   Company URI, e.g. Homepage or ftp Address  
47 COMPANY_COUNTRY CRMT_MKTHV_MC_COMP_LAND1 LAND1 CHAR 3   0   Company Country Key T005
48 COMPANY_REGION CRMT_MKTHV_MC_COMP_REGIO REGIO CHAR 3   0   Company Region (State, Province, County) T005S
49 COMPANY_CITY CRMT_MKTHV_MC_COMP_CITY1 TEXT40 CHAR 40   0   Company City  
50 COMP_POSTAL_CODE CRMT_MKTHV_MC_COMP_PSTCD1 CHAR10 CHAR 10   0   Company City Postal Code  
51 COMPANY_PO_BOX CRMT_MKTHV_MC_COMP_POBX CHAR10 CHAR 10   0   Company PO Box  
52 COMPANY_STREET CRMT_MKTHV_MC_COMP_STREET TEXT60 CHAR 60   0   Company Street  
53 COMPANY_HOUSE_NO CRMT_MKTHV_MC_COMP_HSNM1 CHAR10 CHAR 10   0   Company House Number  
54 COMPANY_EMAIL CRMT_MKTHV_MC_COMP_SMTPADR AD_SMTPADR CHAR 241   0   Company E-Mail Address  
55 PROSP_FUN_NAME CRMT_MKTHV_MC_COMP_FNCTN TEXT40 CHAR 40   0   Function Name of Partner  
56 PROSPECT_FUN_KEY CRMT_MKTHV_MC_COMP_PAFKT BU_PAFKT CHAR 4   0   Function of Partner *
57 .INCLUDE       0   0   CRM Marketing: Generic Search for Marketing Attributes  
58 MARKETINGATTR CRMT_BUPA_IL_MARKATTR_SEARCH CRMT_BUPA_IL_MARKATTR_SEARCH CHAR 150   0   Generic Search for Marketing Attributes  
59 .INCLUDE       0   0   CRM MArketing : MP Technil Attribute IL structure  
60 CONVTD_TO_BP CRMT_MKTHV_MC_CONVTDTOBP CRMT_MKTHV_MC_CONVTDTOBP_BOOL CHAR 1   0   Boolean Value(Yes/No)  
61 SCORE CRMT_MKTHV_MC_SCORE CRMT_MKTHV_MC_SCORE NUMC 4   0   Marketing Prospect: Qualification Score  
62 BP_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
63 CREATED_BY CRMT_MP_USER_ID UNAME CHAR 12   0   User ID  
64 CREATED_BY_NAME CRMT_MP_USER_NAME TEXT80UEB CHAR 80   0   User Name  
65 CREATED_ON_DATE CRMT_MP_DATE DATUM DATS 8   0   Date  
66 CREATED_AT_TIME CRMT_MP_TIME UZEIT TIMS 6   0   Time  
67 CHANGED_BY CRMT_MP_USER_ID UNAME CHAR 12   0   User ID  
68 CHANGED_BY_NAME CRMT_MP_USER_NAME TEXT80UEB CHAR 80   0   User Name  
69 CHANGED_ON_DATE CRMT_MP_DATE DATUM DATS 8   0   Date  
70 CHANGED_AT_TIME CRMT_MP_TIME UZEIT TIMS 6   0   Time  
71 .INCLUDE       0   0   Search Filter Key / Value Entries  
72 FILTER_KEY CRMT_BUPA_IL_FILTER_KEY CHAR4 CHAR 4   0   Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH  
73 FILTER_VALUE CRMT_BUPA_IL_FILTER_VALUE SYSUUID_C CHAR 32   0   Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMS_MKTHV_MC_QUERY_IL COMPANY_COUNTRY T005 LAND1 REF 1 CN
2 CRMS_MKTHV_MC_QUERY_IL COMPANY_REGION T005S BLAND REF C CN
3 CRMS_MKTHV_MC_QUERY_IL COMPANY_TITLE TSAD3 TITLE REF 1 CN
4 CRMS_MKTHV_MC_QUERY_IL COMP_LEGAL_FORM TB019 LEGAL_ENTY KEY 1 CN
5 CRMS_MKTHV_MC_QUERY_IL COUNTRY T005 LAND1 REF 1 CN
6 CRMS_MKTHV_MC_QUERY_IL LANGU_CORR T002 SPRAS    
7 CRMS_MKTHV_MC_QUERY_IL REGION T005S BLAND REF C CN
History
Last changed by/on SAP  20140117 
SAP Release Created in 700