CRMS4D_ACTV_H - Activity Header: Header transaction data

Activity Header: Header transaction data information is stored in SAP table CRMS4D_ACTV_H.
It is part of development package CRMS4_ORDER in software component CRM-S4-BTX. This development package consists of objects that can be grouped under "One Order: Redesign of Persistence Layer".

Fields for table CRMS4D_ACTV_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE	KEY	X		CRMS4S_KEY_H	0
CLIENT	Client	X	MANDT	CLNT	6	T000
OBJTYPE_H	Business Trans. Cat.	X	CRMT_SUBOBJECT_CATEGORY_DB	CHAR	20	CRMC_SUBOB_CAT
OBJECT_ID	Transaction ID	X	CRMT_OBJECT_ID_DB	CHAR	20
.INCLUDE	ACTIVITY_H			CRMS4S_ACTV_H_ACTIVITY_H	0
CATEGORY	Activity Category (Communication Type)		CRMT_ACTIVITY_CATEGORY	CHAR	6	CRMC_ACT_CATEGOR
PRIORITY	Activity Priority		CRMT_PRIORITY	NUMC	2	SCPRIO
OBJECTIVE	Goal of an Activity		CRMT_OBJECTIVE	CHAR	6	CRMC_ACT_OBJ
DIRECTION	Direction of an Activity		CRMT_DIRECTION	CHAR	2
EXTERN_ACT_ID	External Business Transaction Number		CRMT_EXTERNAL_ACTIVITY_ID	CHAR	40
ADDRESS_ID	Location where Activity takes place		CRMT_ADDRESS	CHAR	20	ADRC
PRIVATE_FLAG	Indicator: Task is Private		CRMT_PRIVAT	CHAR	2
COMPLETION	Completion Rate in Percent		CRMT_COMPLETION	NUMC	6
ACT_LOCATION	Location		CRMT_ACTIVITY_LCTN	CHAR	200
CALENDAR	Include Activity in Calendar		CRMT_CALENDAR	CHAR	2
TASK	Indicator: Activity is a Task		CRMT_TASK	CHAR	2
CLASS	Activity Class		CRMT_ACTIVITY_CLASS	CHAR	2
.INCLUDE	DATES			CRMS4S_ACTV_H_DATES	0
ORDERACT_FROM	Actual Start		CRMS4_ACT_ORDERACT_FROM	DEC	8
ORDERACT_TO	Actual End		CRMS4_ACT_ORDERACT_TO	DEC	8
ORDERPLAN_FROM	Planned Start		CRMS4_ACT_ORDERPLAN_FROM	DEC	8
ORDERPLAN_TO	Planned End		CRMS4_ACT_ORDERPLAN_TO	DEC	8
ACT_TOTAL_FROM	Actual Total Value of Duration		CRMS4_ACT_ACTUAL_TOTAL	DEC	7
ACT_TOTAL_UNIT	Actual Duration Unit of Measure		CRMS4_ACT_DURATION_UNIT	UNIT	6	T006
DATE_FROM	Start Date		CRMS4_ACT_DATE_FROM	DEC	8
DATE_TO	End Date		CRMS4_ACT_DATE_TO	DEC	8
.INCLUDE	ORDERADM_H			CRMS4S_ACTV_H_ORDERADM_H	0
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PROCESS_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE_DB	CHAR	8	CRMC_PROC_TYPE
POSTING_DATE	Posting Date for a Business Transaction		CRMT_POSTING_DATE	DATS	16
DESCRIPTION_H	Transaction Description		CRMT_PROCESS_DESCRIPTION	CHAR	80
DESCR_LANGUAGE	Language Key of Description		CRMT_PROCESS_DESCRIPTION_LANGU	LANG	2	T002
TEMPLATE_TYPE	Template Type of CRM Transaction		CRMT_TEMPLATE_TYPE_DB	CHAR	2
CREATED_AT_H	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_H	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_H	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_H	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
HEAD_CHANGED_AT	Time of Last Change to the Transaction		CRMT_CHANGED_AT	DEC	8
BTX_CLASS	CRM Business Transaction Classification		CRMT_TRANSACTION_CLASSIFICATN	CHAR	2	CRMC_TRANS_CLASS
AUTH_SCOPE	Authorization Scope		CRM_AUTH_SCOPE	NUMC	12	CRMC_AUTH_SCP
ARCHIVING_FLAG	Indicator Whether the Business Transaction Can Be Archived		CRMT_ARCHIVING_FLAG	CHAR	2
OBJECT_ID_OK	Indicator That Transaction ID Is Correct		CRMT_OBJECT_ID_OK	CHAR	2
VERIFY_DATE	Time Period of Last Archiving Attempt		CRMT_VERIFY_DATE	DEC	8
HEADER_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
SDM_STATUS_DURA	SDM status of duration migration		CRMS4_SDM_STATUS_DURA	CHAR	4
.INCLUDE	ORGMAN			CRMS4S_ACTV_H_ORGMAN	0
DIS_CHANNEL	Distribution Channel		CRMT_DISTRIBUTION_CHANNEL	CHAR	4	TVTW
DIVISION	Division		CRMT_DIVISION	CHAR	4	TSPA
SERVICE_ORG_ORI	Origin Indicator: Service Organization		CRMT_SERVICE_ORG_ORIGIN	CHAR	2
SERVICE_ORGR_ORI	Origin Indicator: Service Scenario Organizational Unit		CRMT_SERVICE_ORG_RESP_ORIGIN	CHAR	2
SALES_ORG_ORI	Origin Indicator: Sales Organization		CRMT_SALES_ORG_ORIGIN	CHAR	2
DIS_CHANNEL_ORI	Origin Indicator: Distribution Channel		CRMT_DIS_CHANNEL_ORIGIN	CHAR	2
SALES_OFF_ORI	Origin Indicator: Sales Office		CRMT_SALES_OFFICE_ORIGIN	CHAR	2
SALES_GROUP_ORI	Origin Indicator: Sales Group		CRMT_SALES_GROUP_ORIGIN	CHAR	2
SALES_ORGR_ORI	Origin Indicator: Sales Scenario Organizational Unit		CRMT_SALES_ORG_RESP_ORIGIN	CHAR	2
DIVISION_ORI	Origin Flag: Division		CRMT_DIVISION_ORIGIN	CHAR	2
SALES_ORG	Sales Organization ID		CRMT_SALES_ORG	CHAR	28
SALES_OFFICE	Sales Office		CRMT_SALES_OFFICE	CHAR	28
SALES_GROUP	Sales Group		CRMT_SALES_GROUP	CHAR	28
SALES_ORG_RESP	Organizational Unit (Sales)		CRMT_SALES_ORG_RESP	CHAR	28
SERVICE_ORG	Service Organization		CRMT_SERVICE_ORG	CHAR	28
SERVICE_ORG_RESP	Organizational Unit (Service)		CRMT_SERVICE_ORG_RESP	CHAR	28
.INCLUDE				CRMS4S_ORGMAN_SALES_SD	0
SALES_ORG_SD	Sales Organization		VKORG	CHAR	8
SALES_OFFICE_SD	Sales office		VKBUR	CHAR	8	*
SALES_GROUP_SD	Sales group		VKGRP	CHAR	6	*
.INCLUDE	PARTNER			CRMS4S_ACTV_H_PARTNER	0
ACTIVITY_PARTNER	Activity Partner		CRMT_ACTIVITY_PARTNER	CHAR	20	BUT000
CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
PERSON_RESP	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
.INCLUDE				CRMS4S_INBOX_PARTNER	0
INBOX_ASSIGNED_TO	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
INBOX_GROUP_ASSIGNED	Responsible Group		CRMT_RESPONSIBLE_GROUP	CHAR	20	BUT000
INBOX_ACCOUNT	Sales Partners		CRMT_SALESPARTNER	CHAR	20	BUT000
INBOX_CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
.INCLUDE	STATUS			CRMS4S_ACTV_H_STATUS	0
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_CANCELLED	Cancellation Status		CRMS4_STAT_CANCELLED	CHAR	2
STAT_RELEASED	Release Status		CRMS4_STAT_RELEASED	CHAR	2
STAT_ERROR	Error Status		CRMS4_STAT_ERROR	CHAR	2
STAT_ARCHIVABLE	Archivable		CRMS4_STAT_ARCHIVABLE	CHAR	2
STAT_ARCHIVED	Archived		CRMS4_STAT_ARCHIVED	CHAR	2
STAT_OPEN	Status "Open"		CRMS4_STAT_OPEN	CHAR	2
INBOX_STATUS	Status of Agent Inbox Item		CRMT_AUI_STATUS	NUMC	8	CRMC_AUI_STATUS
.INCLUDE	SUBJECT			CRMS4S_ACTV_H_SUBJECT	0
CATLVLGUID01_01	Category GUID 1- schema 1		CRM_REP_CAT_GUID_LEV01_S1	RAW	16
CATLVLGUID02_01	Category GUID 2- schema 1		CRM_REP_CAT_GUID_LEV02_S1	RAW	16
CATLVLGUID03_01	Category GUID 3- schema 1		CRM_REP_CAT_GUID_LEV03_S1	RAW	16
CATLVLGUID04_01	Category GUID 4- schema 1		CRM_REP_CAT_GUID_LEV04_S1	RAW	16
CATLVLGUID05_01	Category GUID 5- schema 1		CRM_REP_CAT_GUID_LEV05_S1	RAW	16
CATLVLGUID06_01	Category GUID 6- schema 1		CRM_REP_CAT_GUID_LEV06_S1	RAW	16
CATLVLGUID07_01	Category GUID 7- schema 1		CRM_REP_CAT_GUID_LEV07_S1	RAW	16
CATLVLGUID08_01	Category GUID 8- schema 1		CRM_REP_CAT_GUID_LEV08_S1	RAW	16
CATLVLGUID09_01	Category GUID 9- schema 1		CRM_REP_CAT_GUID_LEV09_S1	RAW	16
CATLVLGUID10_01	Category GUID 10- schema 1		CRM_REP_CAT_GUID_LEV10_S1	RAW	16
ASP_ID_01	Coherent Cat. - Aspect ID		CRM_ERMS_CAT_AS_ID	CHAR	80
CAT_ID_01	Coherent Cat. - Aspect ID		CRM_ERMS_CAT_AS_ID	CHAR	80
.INCLUDE				CRMS4S_ACTV_H_INCL_EEW_PS	0
ACTV_H_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2