I_LglCntntMTaskNotif

DDL: I_LGLCNTNTMTASKNOTIF SQL: ILCMTASKNOTIF Type: view BASIC Package: VDM_LCM_TSK

Basic view for LCM Task Notification

I_LglCntntMTaskNotif is a Basic CDS View that provides data about "Basic view for LCM Task Notification" in SAP S/4HANA. It reads from 1 data source (lcm_task_notif) and exposes 8 fields with key fields LglCntntMTaskNotifUUID, LegalTransactionTask. It has 1 association to related views. Part of development package VDM_LCM_TSK.

Data Sources (1)

SourceAliasJoin Type
lcm_task_notif lcm_task_notif from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILCMTASKNOTIF view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
VDM.viewType #BASIC view
ObjectModel.representativeKey LegalTransactionTask view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Basic view for LCM Task Notification view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMTaskNotifUUID lglcntntmtasknotifuuid Universal Unique ID
KEY LegalTransactionTask lglcntntmtask Work Item ID
LglCntntMTaskNotifSender lglcntntmtasknotifsender Agent ID
LglCntntMTaskNotifRecipient lglcntntmtasknotifrecipient Agent ID
LglCntntMCreatedUTCDateTime lglcntntmcreatedutcdatetime Created On
LegalTransactionUUID legaltransactionuuid Universal Unique ID
LglCntntMTaskTopNotif lglcntntmtasktopnotificatoin Last Notification
_LegalTransaction _LegalTransaction

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LglCntntMTaskNotif.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ILCMTASKNOTIF

CREATE VIEW I_LglCntntMTaskNotif AS
SELECT
  LglCntntMTaskNotifUUID,
  lglcntntmtask AS LegalTransactionTask,
  LglCntntMTaskNotifSender,
  LglCntntMTaskNotifRecipient,
  LglCntntMCreatedUTCDateTime,
  LegalTransactionUUID,
  lglcntntmtasktopnotificatoin AS LglCntntMTaskTopNotif
FROM lcm_task_notif
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
;