SAP ABAP Table CRMS_MKTHV_MC_READ (CRM Marketing: Marketing Prospect Read Structure)
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 INTTAB    Structure 
Structure CRMS_MKTHV_MC_READ   Table Relationship Diagram
Short Description CRM Marketing: Marketing Prospect Read 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 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 *
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   CRM Marketing: Marketing Prospect Text Structure  
36 COUNTRY_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
37 REGION_TEXT BEZEI20 TEXT20 CHAR 20   0   Description  
38 TITLE_TEXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
39 LANGU_CORR_TEXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
40 TITLE_ACA1_TEXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
41 TITLE_ACA2_TEXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
42 TITLE_ROYL_TEXT AD_TITLEST TEXT20 CHAR 20   0   Name supplement, e.g. noble title (written form)  
43 PREFIX1_TEXT AD_PREFIXT TEXT20 CHAR 20   0   Name prefix  
44 PREFIX2_TEXT AD_PREFIXT TEXT20 CHAR 20   0   Name prefix  
45 COMPANY_COUNTRY_TXT LANDX TEXT15 CHAR 15   0   Country Name  
46 COMPANY_REGION_TXT BEZEI20 TEXT20 CHAR 20   0   Description  
47 COMPANY_TITLE_TXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
48 COMP_LEGAL_FORM_TXT BU_TEXT40 BU_TEXT40 CHAR 40   0   Description  
49 ACCOUNT_NAME BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
50 PROSPECT_FUN_KEY_DESCR CHAR80 CHAR80 CHAR 80   0   Char 80  
51 .INCLUDE       0   0   Marketing Permission Texts  
52 CONSENT_TEL_TEXT CRMT_MC_MKTPERM_CONSENT_TEL_T DDTEXT CHAR 60   0   Description of Consent for Telephone  
53 CONSENT_FAX_TEXT CRMT_MC_MKTPERM_CONSENT_FAX_T DDTEXT CHAR 60   0   Description of consent for Fax  
54 CONSENT_EMAIL_TEXT CRMT_MC_MKTPERM_CONSENT_MAIL_T DDTEXT CHAR 60   0   Description of consent for E-Mail  
55 CONSENT_SMS_TEXT CRMT_MC_MKTPERM_CONSENT_SMS_T DDTEXT CHAR 60   0   Description of Consent for SMS  
56 ORIGIN_TEXT CRMT_MC_MKTPERM_ORIGIN_TEXT CRMT_BU_MKTPERM_ORIGIN_TEXT CHAR 40   0   Marketing Permission: Form of Consent Text  
57 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Miscellaneous Attr Struct.  
58 INVALID_EMAIL CRMT_MKTHV_MC_INVALID_EMAIL CRMT_MKTHV_MC_BOOLEAN CHAR 1   0   CRM Marketing: Marketing Prospect Invalid E-Mail  
59 USAGE_COUNT INT4 INT4 INT4 10   0   Natural number  
60 RENTED BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
61 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Organization Data  
62 COMPANY_ID CRMT_MKTHV_MC_COMP_ID BU_PARTNER CHAR 10   0   Company ID *
63 COMPANY_TITLE CRMT_MKTHV_MC_COMP_TITLE AD_TITLE CHAR 4   0   Company Title TSAD3
64 COMPANY_NAME CRMT_MKTHV_MC_COMP_NAME BU_NAME CHAR 40   0   Company Name  
65 COMP_LEGAL_FORM CRMT_MKTHV_MC_COMP_LEGENTY BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
66 COMP_TELNR_LONG CRMT_MKTHV_MC_COMP_TELNR CHAR30 CHAR 30   0   Company First Telephone No.: Dialling code+Number  
67 COMP_FAXNR_LONG CRMT_MKTHV_MC_COMP_FXNRLNG CHAR30 CHAR 30   0   Company Fax Number: Dialling Code+Number+Extension  
68 COMPANY_URL CRMT_MKTHV_MC_COMP_URISCR AD_URISCR CHAR 132   0   Company URI, e.g. Homepage or ftp Address  
69 COMPANY_COUNTRY CRMT_MKTHV_MC_COMP_LAND1 LAND1 CHAR 3   0   Company Country Key T005
70 COMPANY_REGION CRMT_MKTHV_MC_COMP_REGIO REGIO CHAR 3   0   Company Region (State, Province, County) T005S
71 COMPANY_CITY CRMT_MKTHV_MC_COMP_CITY1 TEXT40 CHAR 40   0   Company City  
72 COMP_POSTAL_CODE CRMT_MKTHV_MC_COMP_PSTCD1 CHAR10 CHAR 10   0   Company City Postal Code  
73 COMPANY_PO_BOX CRMT_MKTHV_MC_COMP_POBX CHAR10 CHAR 10   0   Company PO Box  
74 COMPANY_STREET CRMT_MKTHV_MC_COMP_STREET TEXT60 CHAR 60   0   Company Street  
75 COMPANY_HOUSE_NO CRMT_MKTHV_MC_COMP_HSNM1 CHAR10 CHAR 10   0   Company House Number  
76 COMPANY_EMAIL CRMT_MKTHV_MC_COMP_SMTPADR AD_SMTPADR CHAR 241   0   Company E-Mail Address  
77 PROSP_FUN_NAME CRMT_MKTHV_MC_COMP_FNCTN TEXT40 CHAR 40   0   Function Name of Partner  
78 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 CRMS_MKTHV_MC_READ COMPANY_COUNTRY T005 LAND1 REF 1 CN
2 CRMS_MKTHV_MC_READ COMPANY_REGION T005S BLAND REF C CN
3 CRMS_MKTHV_MC_READ COMPANY_TITLE TSAD3 TITLE REF 1 CN
4 CRMS_MKTHV_MC_READ COMP_LEGAL_FORM TB019 LEGAL_ENTY KEY 1 CN
5 CRMS_MKTHV_MC_READ COUNTRY T005 LAND1 REF 1 CN
6 CRMS_MKTHV_MC_READ LANGU_CORR T002 SPRAS    
7 CRMS_MKTHV_MC_READ REGION T005S BLAND REF C CN
History
Last changed by/on SAP  20140117 
SAP Release Created in 700