Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

CRMT_ACTIVITY_ALV SAP (CRM: Structure for the Application Workplace - Activities) Structure details

Dictionary Type: Structure
Description: CRM: Structure for the Application Workplace - Activities

ABAP Code to SELECT data from CRMT_ACTIVITY_ALV
Related tables to CRMT_ACTIVITY_ALV
Access table CRMT_ACTIVITY_ALV

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

CRMT_ACTIVITY_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CRM: Structure for the Application Workplace - Activities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_ACTIVITY_ALV TYPE CRMT_ACTIVITY_ALV.

The CRMT_ACTIVITY_ALV table consists of various fields, each holding specific information or linking keys about CRM: Structure for the Application Workplace - Activities data available in SAP. These include CATEGORY (Activity Category (Communication Type)), PRIORITY (Activity Priority), OBJECTIVE (Goal of an Activity), DIRECTION (Direction of an Activity).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CRMT_ACTIVITY_ALV structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
CATEGORY	Activity Category (Communication Type)	CRMT_ACTIVITY_CATEGORY	CHAR	3	CRMC_ACT_CATEGOR		CRM_ACTIVITY_CATEGORY
PRIORITY	Activity Priority	CRMT_PRIORITY	NUMC	1	SCPRIO		SC_PRIO
OBJECTIVE	Goal of an Activity	CRMT_OBJECTIVE	CHAR	3	CRMC_ACT_OBJ		CRM_OBJECTIVE
DIRECTION	Direction of an Activity	CRMT_DIRECTION	CHAR	1			CRM_DIRECTION
EXTERN_ACT_ID	External Business Transaction Number	CRMT_EXTERNAL_ACTIVITY_ID	CHAR	20			CRM_EXTERNAL_ACTIVITY_ID
ADDRESS_ID	Location where Activity takes place	CRMT_ADDRESS	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM
PRIVATE_FLAG	Indicator: Task is Private	CRMT_PRIVAT	CHAR	1			CRM_BOOLEAN
COMPLETION	Completion Rate in Percent	CRMT_COMPLETION	NUMC	3			CRM_COMPLETION		CRM_ACT_COMPLETION
ACT_LOCATION	Location	CRMT_ACTIVITY_LCTN	CHAR	100			CRM_ACTIVITY_LOCATION
OBJECT_ID	Transaction Number	CRMT_OBJECT_ID_DB	CHAR	10		ALPHA	CRM_OBJECT_ID
PROCESS_TYPE	Business Transaction Type	CRMT_PROCESS_TYPE_DB	CHAR	4	Assigned to domain		CRM_PROCESS_TYPE
POSTING_DATE	Posting Date for a Business Transaction	CRMT_POSTING_DATE	DATS	8
DESCRIPTION	Transaction Description	CRMT_PROCESS_DESCRIPTION	CHAR	40			CRM_PROCESS_DESCRIPTION
DESCR_LANGUAGE	Language Key of Description	CRMT_PROCESS_DESCRIPTION_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
LOGICAL_SYSTEM	Logical System	CRMT_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
CRM_RELEASE	SAP Release	SAPRELEASE	CHAR	10			CHAR10
SCENARIO	Scenario Identity	CRMT_SCENARIO	CHAR	10			CRM_SCENARIO
TEMPLATE_TYPE	Template Type of CRM Transaction	CRMT_TEMPLATE_TYPE_DB	CHAR	1			CRM_TEMPLATE_TYPE
CREATED_AT	Created At (Output in User Time Zone)	COMT_CREATED_AT_USR	DEC	15		TSTLC	COM_TSTMP
CREATED_BY	User that Created the Transaction	CRMT_CREATED_BY	CHAR	12			UNAME		USER_ADDR
CHANGED_AT	Changed At (Output in User Time Zone)	COMT_CHANGED_AT_USR	DEC	15		TSTLC	COM_TSTMP
CHANGED_BY	Transaction Last Changed By	CRMT_CHANGED_BY	CHAR	12			UNAME
HEAD_CHANGED_AT	Time of Last Change to the Transaction	CRMT_CHANGED_AT	DEC	15		TSTPS	BCOS_TSTMP
ORDERADM_H_DUMMY	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
.INCLU--AP				0
INPUT_CHANNEL	Input channel	CRMT_INPUT_CHANNEL	CHAR	3			CRM_INPUT_CHANNEL
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	GUID of a CRM Order Object	CRMT_OBJECT_GUID	RAW	16			SYSUUID
STAT	Object status	J_STATUS	CHAR	5			J_STATUS
STATUS	Longtext Status for a Sales Document	CRMT_RPRTNG_STATUS_L	CHAR	40			TEXT40
CATEGORY_TEXT	Description (20 Characters)	CRMT_DESCRIPTION_20	CHAR	20			TEXT20
PRIORITY_TEXT	Description (20 Characters)	CRMT_DESCRIPTION_20	CHAR	20			TEXT20
OBJECTIVE_TEXT	Description (20 Characters)	CRMT_DESCRIPTION_20	CHAR	20			TEXT20
DIRECTION_TEXT	Description (20 Characters)	CRMT_DESCRIPTION_20	CHAR	20			TEXT20
PARTNER_FCT	Function That a Processor Has in a Sales Document	CRMT_RPRTNG_MYFUNCTION	CHAR	8			CHAR8
FCT_DESCRIPTION	Partner Function: Long Text	CRMT_REPORT_FNKT_LONG	CHAR	30			TEXT30
FCT_SHORT_DESC	Partner Function: Short Text	CRMT_REPORT_FNKT_SHORT	CHAR	4			TEXT4
MAIN_BP_1_NO	Partner Number	CRMT_PARTNER_NO	CHAR	32			CRM_PARTNER_NO
MAIN_BP_1_FCT	Role of an Additional Business Partner for Display	CRMT_RPRTNG_ADDFUNCTION	CHAR	8			CHAR8
MAIN_BP_1	Additional Business Partner	CRMT_RPRTNG_ADDPARTNER	CHAR	35			NAME
MAIN_BP_1_DESC	Partner Function: Long Text	CRMT_REPORT_FNKT_LONG	CHAR	30			TEXT30
MAIN_BP_1_DESC_S	Partner Function: Short Text	CRMT_REPORT_FNKT_SHORT	CHAR	4			TEXT4
MAIN_BP_1_NAMELIST	One-line short form of formatted address	AD_LINE_S	CHAR	80			CHAR80
MAIN_BP_2_NO	Partner Number	CRMT_PARTNER_NO	CHAR	32			CRM_PARTNER_NO
MAIN_BP_2_FCT	Role of an Additional Business Partner for Display	CRMT_RPRTNG_ADDFUNCTION	CHAR	8			CHAR8
MAIN_BP_2	Additional Business Partner	CRMT_RPRTNG_ADDPARTNER	CHAR	35			NAME
MAIN_BP_2_DESC	Partner Function: Long Text	CRMT_REPORT_FNKT_LONG	CHAR	30			TEXT30
MAIN_BP_2_DESC_S	Partner Function: Short Text	CRMT_REPORT_FNKT_SHORT	CHAR	4			TEXT4
MAIN_BP_2_NAMELIST	One-line short form of formatted address	AD_LINE_S	CHAR	80			CHAR80
STATUS_USER_LONG	Longform User Status	CRMT_REPORT_STATUS_UL	CHAR	100			CHAR100
STATUS_USER	Shortform Status	CRMT_REPORT_STATUS_U	CHAR	40			CHAR40
STATUS_LONG	Longform Status	CRMT_REPORT_STATUS_L	CHAR	100			CHAR100
PLANNEDDATEFROM	Start Date	SC_DATEFRO	DATS	8			DATUM
PLANNEDDATETO	End Date	SC_DATETO	DATS	8			DATUM
PLANNEDZONE	Appointment calendar: Time zone of start of appointment	SC_ZONEFRO	CHAR	6	Assigned to domain		TZNZONE
PLANNEDTIMEFROM	From Time	SC_TIMEFRO	TIMS	6			SYTIME
PLANNEDTIMETO	To Time	SC_TIMETO	TIMS	6			SYTIME
ACTUALDATEFROM	Start Date	SC_DATEFRO	DATS	8			DATUM
ACTUALDATETO	End Date	SC_DATETO	DATS	8			DATUM
ACTUALZONE	Appointment calendar: Time zone of start of appointment	SC_ZONEFRO	CHAR	6	Assigned to domain		TZNZONE
ACTUALTIMEFROM	From Time	SC_TIMEFRO	TIMS	6			SYTIME
ACTUALTIMETO	To Time	SC_TIMETO	TIMS	6			SYTIME
PROPOSEDDATEFROM	Start Date	SC_DATEFRO	DATS	8			DATUM
PROPOSEDDATETO	End Date	SC_DATETO	DATS	8			DATUM
PROPOSEDZONE	Appointment calendar: Time zone of start of appointment	SC_ZONEFRO	CHAR	6	Assigned to domain		TZNZONE
PROPOSEDTIMEFROM	From Time	SC_TIMEFRO	TIMS	6			SYTIME
PROPOSEDTIMETO	To Time	SC_TIMETO	TIMS	6			SYTIME

Key field

Non-key field

How do I retrieve data from SAP structure CRMT_ACTIVITY_ALV using ABAP code?

As CRMT_ACTIVITY_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_ACTIVITY_ALV as there is no data to select.

How to access SAP table CRMT_ACTIVITY_ALV

Within an ECC or HANA version of SAP you can also view further information about CRMT_ACTIVITY_ALV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!