SAP ABAP Table CRMT_MKTP_ODATA_HEADER (Marketing Prospect Header Data for OData Service)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MP (Application Component) Marketing Prospect
     ⤷ CRM_MKT_PROSPECT_ODATA (Package) OData services for Marketing Prospect
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_MKTP_ODATA_HEADER   Table Relationship Diagram
Short Description Marketing Prospect Header Data for OData Service    
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 ID CRMT_MKTHV_MC_ID CRM_MKTHV_MC_ID CHAR 10   0   Marketing Prospect ID  
5 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
6 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
7 NAME_FIRST CRMT_MKTHV_MC_FNAME CRM_MKTHV_MC_FNAME CHAR 40   0   CRM Marketing: Marketing Prospect First Name  
8 NAME_LAST CRMT_MKTHV_MC_LNAME CRM_MKTHV_MC_LNAME CHAR 40   0   CRM Marketing: Marketing Prospect Last Name  
9 NAMEMIDDLE CRMT_MKTHV_MC_MNAME CRM_MKTHV_MC_MNAME CHAR 40   0   CRM Marketing: Marketing Prospect Middle Name  
10 FULLNAME CRMT_MKTHV_MC_FULL_NAME CRM_MKTHV_MC_FULL_NAME CHAR 80   0   CRM Marketing: Marketing Prospect Full Name  
11 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
12 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
13 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) *
14 PREFIX1 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
15 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) *
16 LANGU_CORR LANGU SPRAS LANG 1   0   Language Key *
17 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
18 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
19 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
20 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
21 STREET AD_STREET TEXT60 CHAR 60   0   Street  
22 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
23 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
24 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
25 .INCLUDE       0   0   CRM Marketing: Marketing Prospect EEW Include for Customer  
26 MC_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
27 CONSENT_TEL CRMT_MC_MKTPERM_CONSENT_TEL_OD CRMT_BU_MKTPERM_PERMISSION_OD CHAR 3   0   Marketing Permission: Consent ID for Telephone  
28 CONSENT_EMAIL CRMT_MC_MKTPERM_CONSENT_EMA_OD CRMT_BU_MKTPERM_PERMISSION_OD CHAR 3   0   Marketing Permission: Consent ID for E-Mail  
29 CONSENT_FAX CRMT_MC_MKTPERM_CONSENT_FAX_OD CRMT_BU_MKTPERM_PERMISSION_OD CHAR 3   0   Marketing Permission: Consent ID for Fax  
30 CONSENT_SMS CRMT_MC_MKTPERM_CONSENT_SMS_OD CRMT_BU_MKTPERM_PERMISSION_OD CHAR 3   0   Marketing Permission: Consent ID for SMS  
31 ORIGIN CRMT_BU_MKTPERM_ORIGIN CRMT_BU_MKTPERM_ORIGIN CHAR 3   0   Form of Consent *
32 DATE_OF_CONSENT CRMT_BU_MKTPERM_ORIGIN_DATE DATS DATS 8   0   Marketing Permission: Date of Consent  
33 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Text Structure  
34 COUNTRY_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
35 REGION_TEXT BEZEI20 TEXT20 CHAR 20   0   Description  
36 TITLE_TEXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
37 LANGU_CORR_TEXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
38 TITLE_ACA1_TEXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
39 TITLE_ACA2_TEXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
40 TITLE_ROYL_TEXT AD_TITLEST TEXT20 CHAR 20   0   Name supplement, e.g. noble title (written form)  
41 PREFIX1_TEXT AD_PREFIXT TEXT20 CHAR 20   0   Name prefix  
42 PREFIX2_TEXT AD_PREFIXT TEXT20 CHAR 20   0   Name prefix  
43 COMPANY_COUNTRY_TXT LANDX TEXT15 CHAR 15   0   Country Name  
44 COMPANY_REGION_TXT BEZEI20 TEXT20 CHAR 20   0   Description  
45 COMPANY_TITLE_TXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
46 COMP_LEGAL_FORM_TXT BU_TEXT40 BU_TEXT40 CHAR 40   0   Description  
47 ACCOUNT_NAME BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
48 PROSPECT_FUN_KEY_DESCR CHAR80 CHAR80 CHAR 80   0   Char 80  
49 .INCLUDE       0   0   Marketing Permission Texts  
50 CONSENT_TEL_TEXT CRMT_MC_MKTPERM_CONSENT_TEL_T DDTEXT CHAR 60   0   Description of Consent for Telephone  
51 CONSENT_FAX_TEXT CRMT_MC_MKTPERM_CONSENT_FAX_T DDTEXT CHAR 60   0   Description of consent for Fax  
52 CONSENT_EMAIL_TEXT CRMT_MC_MKTPERM_CONSENT_MAIL_T DDTEXT CHAR 60   0   Description of consent for E-Mail  
53 CONSENT_SMS_TEXT CRMT_MC_MKTPERM_CONSENT_SMS_T DDTEXT CHAR 60   0   Description of Consent for SMS  
54 ORIGIN_TEXT CRMT_MC_MKTPERM_ORIGIN_TEXT CRMT_BU_MKTPERM_ORIGIN_TEXT CHAR 40   0   Marketing Permission: Form of Consent Text  
55 .INCLUDE       0   0   CRM Marketing: Marketing Prospect Organization Data  
56 COMPANY_ID CRMT_MKTHV_MC_COMP_ID BU_PARTNER CHAR 10   0   Company ID *
57 COMPANY_TITLE CRMT_MKTHV_MC_COMP_TITLE AD_TITLE CHAR 4   0   Company Title TSAD3
58 COMPANY_NAME CRMT_MKTHV_MC_COMP_NAME BU_NAME CHAR 40   0   Company Name  
59 COMP_LEGAL_FORM CRMT_MKTHV_MC_COMP_LEGENTY BU_LEGENTY CHAR 2   0   Legal Form of Organization TB019
60 COMP_TELNR_LONG CRMT_MKTHV_MC_COMP_TELNR CHAR30 CHAR 30   0   Company First Telephone No.: Dialling code+Number  
61 COMP_FAXNR_LONG CRMT_MKTHV_MC_COMP_FXNRLNG CHAR30 CHAR 30   0   Company Fax Number: Dialling Code+Number+Extension  
62 COMPANY_URL CRMT_MKTHV_MC_COMP_URISCR AD_URISCR CHAR 132   0   Company URI, e.g. Homepage or ftp Address  
63 COMPANY_COUNTRY CRMT_MKTHV_MC_COMP_LAND1 LAND1 CHAR 3   0   Company Country Key T005
64 COMPANY_REGION CRMT_MKTHV_MC_COMP_REGIO REGIO CHAR 3   0   Company Region (State, Province, County) T005S
65 COMPANY_CITY CRMT_MKTHV_MC_COMP_CITY1 TEXT40 CHAR 40   0   Company City  
66 COMP_POSTAL_CODE CRMT_MKTHV_MC_COMP_PSTCD1 CHAR10 CHAR 10   0   Company City Postal Code  
67 COMPANY_PO_BOX CRMT_MKTHV_MC_COMP_POBX CHAR10 CHAR 10   0   Company PO Box  
68 COMPANY_STREET CRMT_MKTHV_MC_COMP_STREET TEXT60 CHAR 60   0   Company Street  
69 COMPANY_HOUSE_NO CRMT_MKTHV_MC_COMP_HSNM1 CHAR10 CHAR 10   0   Company House Number  
70 COMPANY_EMAIL CRMT_MKTHV_MC_COMP_SMTPADR AD_SMTPADR CHAR 241   0   Company E-Mail Address  
71 PROSP_FUN_NAME CRMT_MKTHV_MC_COMP_FNCTN TEXT40 CHAR 40   0   Function Name of Partner  
72 PROSPECT_FUN_KEY CRMT_MKTHV_MC_COMP_PAFKT BU_PAFKT CHAR 4   0   Function of Partner *
73 COMPANY_EXIST CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
74 CONVTD_TO_BP CRMT_MKTHV_MC_CONVTDTOBP CRMT_MKTHV_MC_CONVTDTOBP_BOOL CHAR 1   0   Boolean Value(Yes/No)  
75 SCORE CRMT_MKTHV_MC_SCORE_OD   CHAR 4   0   Marketing Prospect: Qualification Score  
76 BP_GUID BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
77 CREATED_BY CRMT_MP_USER_ID UNAME CHAR 12   0   User ID  
78 CREATED_BY_NAME CRMT_MP_USER_NAME TEXT80UEB CHAR 80   0   User Name  
79 CREATED_ON_DATE CRMT_MP_DATE DATUM DATS 8   0   Date  
80 CREATED_AT_TIME CRMT_MP_TIME UZEIT TIMS 6   0   Time  
81 CHANGED_BY CRMT_MP_USER_ID UNAME CHAR 12   0   User ID  
82 CHANGED_BY_NAME CRMT_MP_USER_NAME TEXT80UEB CHAR 80   0   User Name  
83 CHANGED_ON_DATE CRMT_MP_DATE DATUM DATS 8   0   Date  
84 CHANGED_AT_TIME CRMT_MP_TIME UZEIT TIMS 6   0   Time  
85 NO_DUPLICATE_CHECK CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_MKTP_ODATA_HEADER COMPANY_COUNTRY T005 LAND1 REF 1 CN
2 CRMT_MKTP_ODATA_HEADER COMPANY_REGION T005S BLAND REF C CN
3 CRMT_MKTP_ODATA_HEADER COMPANY_TITLE TSAD3 TITLE REF 1 CN
4 CRMT_MKTP_ODATA_HEADER COMP_LEGAL_FORM TB019 LEGAL_ENTY KEY 1 CN
History
Last changed by/on SAP  20140117 
SAP Release Created in