CMD_CNSNT

Consent Administration: Consent | #transactional | Component: Consent Administration
Column Name Description
CLIENT Client
CONSENT_UUID Consent Administration: Consent UUID
Column Name Description
Column Name Description
Column Name Description
_DATAAGING Data Filter Value for Data Aging
Column Name Description
CONSENT_MODEL Consent Administration: Consent Method Show values
CONSENT_STATUS Consent Administration: Consent Status Show values
LIFECYCLE_STATUS Consent Administration: Consent Lifecycle Status Show values
PURPOSE_SENS_PERS_DATA Consent Administration: Purpose Sensitive Data Show values
THIRD_PARTY_FUNCTION Consent Administration: Third Party Function Show values
THIRD_PARTY_SENS_PERS_DATA Consent Administration: Third Party Sensitive Data Show values
Column Name Description Domain name
VALID_FROM Consent Administration: Consent's Valid From Point in Time TZNTSTMPL
VALID_TO Consent Administration: Consent's Valid To Point in Time TZNTSTMPL
EXPIRING_DATE Consent Administration: Expiring Date TZNTSTMPL
GRANTED_AT Consent Administration: Granted At TZNTSTMPL
GRANTED_BY Consent Administration: Granted By User CMA_ID_128
WITHDRAWN_AT Consent Administration: Point in time Consent is withdrawn TZNTSTMPL
WITHDRAWN_BY Consent Administration: User who withdraw the Consent CMA_ID_128
PURPOSE_EXPLANATORY_TEXT_UUID Consent Administration: Purpose Explanatory Text ID CMA_UUID
CONSENT_EXPLANATORY_TEXT_UUID Consent Administration: Consent Explanatory Text ID CMA_UUID
CONSENT_QUESTION_TEXT_UUID Consent Administration: Consent Question Text ID CMA_UUID
CONSENT_CONSEQUENT_TEXT_UUID Consent Administration: Consent Consequence Text ID CMA_UUID
CONSENT_PRIVACY_TEXT_UUID Consent Administration: Consent Privacy Statement Text ID CMA_UUID
TEMPLATE_NAME Consent Administration: Form Name CMA_NAME
TEMPLATE_UUID Consent Administration: Form ID CMA_UUID
TEMPLATE_DESCRIPTION Consent Administration: Form Description CMA_DESCRIPTION_80
PURPOSE_NAME Consent Administration: Purpose Name CMA_NAME
PURPOSE_UUID Consent Administration: Purpose ID CMA_UUID
PURPOSE_DESCRIPTION Consent Administration: Purpose Description CMA_DESCRIPTION_80
CONTROLLER_NAME Consent Administration: Controller Name CMA_TYPE_30
CONTROLLER_UUID Consent Administration: Controller UUID CMA_UUID
CONTROLLER_DESCRIPTION Consent Administration: Data Controller Description CMA_DESCRIPTION_80
APPLICATION_NAME Consent Administration: Application Name CMA_TYPE_30
APPLICATION_UUID Consent Administration: Application ID CMA_UUID
APPLICATION_DESCRIPTION Consent Administration: Application Description CMA_DESCRIPTION_80
APPLICATION_TEMPLATE_ID Consent Administration: Application given Form ID CMA_ID_128
DATA_SUBJECT_ID Consent Administration: Data Subject ID CMA_ID_128
DATA_SUBJECT_FORMATTED_DSCR Consent Administration: Data Subject Description CMA_DESCRIPTION_255
THIRD_PARTY_NAME Consent Administration: Third Party Name CMA_NAME
THIRD_PARTY_UUID Consent Administration: Third Party ID CMA_UUID
THIRD_PARTY_FORMATTED_DSCR Consent Administration: Third Party Formatted Description CMA_DESCRIPTION_255
IMPORT_SOURCE_NAME Consent Administration: Import Source Name CMA_SOURCE_NAME
IMPORT_SOURCE_UUID Consent Administration: Obsolete CMA_UUID
ORIGIN_CHANGED_AT Consent Administration: Origin Changed At TZNTSTMPL
CREATED_AT Consent Administration: Created At TZNTSTMPL
CREATED_BY Consent Administration: Created By UNAME
CHANGED_AT Consent Administration: Changed At TZNTSTMPL
CHANGED_BY Consent Administration: Changed By UNAME
CONSENT_ID Consent Administration: Consent ID CMA_CONSENT_NUMBER
END_OF_VALIDITY Consent Administration: Consent End Of Validity TZNTSTMPL
TERMINATED_AT Consent Administration: Terminated At TZNTSTMPL
TERMINATED_BY Consent Administration: Terminated By CMA_ID_128
CONTROLLER_ID Consent Administration: Data Controller ID CMA_ID_50
CONTROLLER_ID_TYPE Consent Administration: Data Controller ID Type CMA_CONTROLLER_ID_TYPE
Master Data Relations Join Conditions
Consent Administration: Data Subject ID Type
  • Consent Administration: Data Subject ID Type
  • Client
Consent Administration: Jurisdiction
  • Consent Administration: Jurisdiction
  • Client
  • CMD_CNSNT.JURISDICTION == T005.LAND1
  • CMD_CNSNT.CLIENT == T005.MANDT
Consent Administration: Language CMD_CNSNT.LANGUAGE == T002.SPRAS