SAP ABAP Table CRMT_PML_IL_QUERY (Personalized Mails: GENIL Query Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-ML (Application Component) Direct Mailing
     ⤷ CRM_MKTPML_IL (Package) CRM Marketing: Personalized Mails GENIL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PML_IL_QUERY	Table Relationship Diagram
Short Description	Personalized Mails: GENIL 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	QUERYID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	MAIL_ID	☐	CRMT_PML_ID	CRMD_PML_ID	CHAR	30	0	Personalized Mails: Mail Form ID
3	CREATED_BY	☐	CRMT_PML_CREATED_BY	TDUSER	CHAR	12	0	Personalized Mails: Created by
4	CREATED_AT_DATE	☐	CRMT_PML_CREATED_AT_DATE	DATUM	DATS	8	0	Personalized Mails: Created at date
5	CHANGED_BY	☐	CRMT_PML_CHANGED_BY	TDUSER	CHAR	12	0	Personalized Mails: Changed by
6	CHANGED_AT_DATE	☐	CRMT_PML_CHANGED_AT_DATE	DATUM	DATS	8	0	Personalized Mails: Changed at date
7	MAIL_USAGE	☐	CRMT_PML_USAGE	CRMD_PML_USAGE	CHAR	1	0	Personalized Mails: 'Channel - Text type' combination
8	DESCRIPTION	☐	CRMT_PML_DESCRIPTION	CRMD_PML_DESCR60	CHAR	60	0	Personalized Mails: Description of Mail Form
9	CAMP_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
10	CAMP_DESCR	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
11	MASTERLANG	☐	CRMT_PML_MASTERLANG	SPRAS	LANG	1	0	Personalized Mails: Master language of mail form	*
12	CUST_SCENARIO	☐	CRMT_IM_CUST_SCENARIO	CHAR30	CHAR	30	0	Scenario: Customer Presets
13	SCENARIO_TYPE	☐	CRMT_IM_SCENARIO_TYPE	CRMD_SCENARIO_TYPE	CHAR	3	0	Attribute Context Type for Mail Forms

History

Last changed by/on	SAP	20130604
SAP Release Created in	510