CMD_CNSNT - Consent Administration: Consent

Consent Administration: Consent information is stored in SAP table CMD_CNSNT.
It is part of development package CONSENT_DB in software component CA-GTF-CON. This development package consists of objects that can be grouped under "Consent Administration: Database Layer".

Fields for table CMD_CNSNT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
CONSENT_UUID	Consent Administration: Consent UUID	X	CME_CONSENT_UUID	RAW	16
CONSENT_MODEL	Consent Administration: Consent Method		CME_CONSENT_MODEL	NUMC	4
JURISDICTION	Consent Administration: Jurisdiction		CME_JURISDICTION	CHAR	6	T005
VALID_FROM	Consent Administration: Consent's Valid From Point in Time		CME_CONSENT_VALID_FROM	DEC	11
VALID_TO	Consent Administration: Consent's Valid To Point in Time		CME_CONSENT_VALID_TO	DEC	11
EXPIRING_DATE	Consent Administration: Expiring Date		CME_EXPIRING_DATE	DEC	11
CONSENT_STATUS	Consent Administration: Consent Status		CME_CONSENT_STATUS	NUMC	4
GRANTED_AT	Consent Administration: Granted At		CME_GRANTED_AT	DEC	11
GRANTED_BY	Consent Administration: Granted By User		CME_GRANTED_BY	CHAR	256
WITHDRAWN_AT	Consent Administration: Point in time Consent is withdrawn		CME_WITHDRAWN_AT	DEC	11
WITHDRAWN_BY	Consent Administration: User who withdraw the Consent		CME_WITHDRAWN_BY	CHAR	256
LANGUAGE	Consent Administration: Language		CME_LANGUAGE	LANG	2	T002
LIFECYCLE_STATUS	Consent Administration: Consent Lifecycle Status		CME_CONSENT_LIFECYCLE_STATUS	NUMC	4
PURPOSE_EXPLANATORY_TEXT_UUID	Consent Administration: Purpose Explanatory Text ID		CME_PRPS_EXPL_TXT_UUID	RAW	16
CONSENT_EXPLANATORY_TEXT_UUID	Consent Administration: Consent Explanatory Text ID		CME_CNSNT_EXPL_TXT_UUID	RAW	16
CONSENT_QUESTION_TEXT_UUID	Consent Administration: Consent Question Text ID		CME_CNSNT_QSTN_TXT_UUID	RAW	16
CONSENT_CONSEQUENT_TEXT_UUID	Consent Administration: Consent Consequence Text ID		CME_CNSNT_CNSQNC_TXT_UUID	RAW	16
CONSENT_PRIVACY_TEXT_UUID	Consent Administration: Consent Privacy Statement Text ID		CME_CNSNT_PRVCY_TXT_UUID	RAW	16
TEMPLATE_NAME	Consent Administration: Form Name		CME_TEMPLATE_NAME	CHAR	60
TEMPLATE_UUID	Consent Administration: Form ID		CME_TEMPLATE_UUID	RAW	16
TEMPLATE_DESCRIPTION	Consent Administration: Form Description		CME_TEMPLATE_DSCR	CHAR	160
PURPOSE_NAME	Consent Administration: Purpose Name		CME_PURPOSE_NAME	CHAR	60
PURPOSE_UUID	Consent Administration: Purpose ID		CME_PURPOSE_UUID	RAW	16
PURPOSE_DESCRIPTION	Consent Administration: Purpose Description		CME_PURPOSE_DSCR	CHAR	160
PURPOSE_SENS_PERS_DATA	Consent Administration: Purpose Sensitive Data		CME_PURPOSE_SENSITIVE_DATA	CHAR	2
CONTROLLER_NAME	Consent Administration: Controller Name		CME_CONTROLLER_NAME	CHAR	60
CONTROLLER_UUID	Consent Administration: Controller UUID		CME_CONTROLLER_UUID	RAW	16
CONTROLLER_DESCRIPTION	Consent Administration: Data Controller Description		CME_CONTROLLER_DSCR	CHAR	160
APPLICATION_NAME	Consent Administration: Application Name		CME_APPLICATION_NAME	CHAR	60
APPLICATION_UUID	Consent Administration: Application ID		CME_APPLICATION_UUID	RAW	16
APPLICATION_DESCRIPTION	Consent Administration: Application Description		CME_APPLICATION_DSCR	CHAR	160
APPLICATION_TEMPLATE_ID	Consent Administration: Application given Form ID		CME_APPLICATION_TEMPLATE_ID	CHAR	256
DATA_SUBJECT_ID_TYPE	Consent Administration: Data Subject ID Type		CME_DATA_SUBJECT_ID_TYPE	NUMC	10	CMC_DS_IDTYPE
DATA_SUBJECT_ID	Consent Administration: Data Subject ID		CME_DATA_SUBJECT_ID	CHAR	256
DATA_SUBJECT_FORMATTED_DSCR	Consent Administration: Data Subject Description		CME_DATA_SUBJECT_FORM_DSCR	CHAR	510
THIRD_PARTY_NAME	Consent Administration: Third Party Name		CME_THIRD_PARTY_NAME	CHAR	60
THIRD_PARTY_UUID	Consent Administration: Third Party ID		CME_THIRD_PARTY_UUID	RAW	16
THIRD_PARTY_FUNCTION	Consent Administration: Third Party Function		CME_THIRD_PARTY_FUNCTION	NUMC	4
THIRD_PARTY_FORMATTED_DSCR	Consent Administration: Third Party Formatted Description		CME_THIRD_PARTY_FORM_DSCR	CHAR	510
THIRD_PARTY_SENS_PERS_DATA	Consent Administration: Third Party Sensitive Data		CME_THIRD_PARTY_SENS_DATA	CHAR	2
IMPORT_SOURCE_NAME	Consent Administration: Import Source Name		CME_IMPORT_SOURCE_NAME	CHAR	120
IMPORT_SOURCE_UUID	Consent Administration: Obsolete		CME_SOURCE_UUID	RAW	16
ORIGIN_CHANGED_AT	Consent Administration: Origin Changed At		CME_ORIGIN_CHANGED_AT	DEC	11
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
.INCLUDE				CMS_ADMIN_DATA	0
CREATED_AT	Consent Administration: Created At		CME_CREATED_AT	DEC	11
CREATED_BY	Consent Administration: Created By		CME_CREATED_BY	CHAR	24
CHANGED_AT	Consent Administration: Changed At		CME_CHANGED_AT	DEC	11
CHANGED_BY	Consent Administration: Changed By		CME_CHANGED_BY	CHAR	24
CONSENT_ID	Consent Administration: Consent ID		CME_CONSENT_ID	CHAR	30
END_OF_VALIDITY	Consent Administration: Consent End Of Validity		CME_CONSENT_END_OF_VALIDITY	DEC	11
TERMINATED_AT	Consent Administration: Terminated At		CME_TERMINATED_AT	DEC	11
TERMINATED_BY	Consent Administration: Terminated By		CME_TERMINATED_BY	CHAR	256
CONTROLLER_ID	Consent Administration: Data Controller ID		CME_CONTROLLER_ID	CHAR	100
CONTROLLER_ID_TYPE	Consent Administration: Data Controller ID Type		CME_CONTROLLER_ID_TYPE	NUMC	10