C_LegalTransactionDateLog

DDL: C_LEGALTRANSACTIONDATELOG SQL: CLEGALTRENTITY Type: view CONSUMPTION
19 Fields 1 Data Sources 2 Associations

Consumption for Legal Transaction Date Log

C_LegalTransactionDateLog is a Consumption CDS View that provides data about "Consumption for Legal Transaction Date Log" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionDateLog) and exposes 19 fields with key field LegalTransactionDateLogUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionDateLog I_LegalTransactionDateLog from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LCMUserContactCard _ChangedByContactCard _ChangedByContactCard.ContactCardType = 'User' and _ChangedByContactCard.ContactCardID = $projection.LglCntntMChangedByUser and _ChangedByContactCard.ContactCardRole = 'Creator'
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CLEGALTRENTITY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey LegalTransactionDateLogUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
UI.headerInfo.typeName Change History view
UI.headerInfo.typeNamePlural Change History view
EndUserText.label Consumption for Legal Transaction Date Log view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionDateLogUUID LegalTransactionDateLogUUID Universal Unique ID
LegalTransaction LegalTransaction Legal Transaction ID
LglCntntMDateType LglCntntMDateType Date Type
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LegalTransactionDateUUID LegalTransactionDateUUID Universal Unique ID
LglCntntMOldFromDate LglCntntMOldFromDate Old Date
LglCntntMNewFromDate LglCntntMNewFromDate New Date
LglCntntMOldToDate LglCntntMOldToDate Date To Old
LglCntntMNewToDate LglCntntMNewToDate Date To New
LegalTransDateChangeReason LegalTransDateChangeReason Reason for Date Change
LegalTransDateChangeReasonName
LegalTransDateChangeType LegalTransDateChangeType Change Type
LegalTransDateChangeTypeName
LglCntntMChangedByUser LglCntntMChangedByUser Changed By
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed On
_ChangedByContactCard _ChangedByContactCard
_LglTransDateChangeReasonText _LglTransDateChangeReasonText
_LglTransDateChangeTypeText _LglTransDateChangeTypeText
_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 C_LegalTransactionDateLog.
-- 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: CLEGALTRENTITY

CREATE VIEW C_LegalTransactionDateLog AS
SELECT
  LegalTransactionDateLogUUID,
  LegalTransaction,
  LglCntntMDateType,
  LegalTransactionUUID,
  LegalTransactionDateUUID,
  LglCntntMOldFromDate,
  LglCntntMNewFromDate,
  LglCntntMOldToDate,
  LglCntntMNewToDate,
  LegalTransDateChangeReason,
  _LglTransDateChangeReasonText[1: Language = $session.system_language].LegalTransDateChangeReasonName AS LegalTransDateChangeReasonName,
  LegalTransDateChangeType,
  _LglTransDateChangeTypeText[1: Language = $session.system_language].LegalTransDateChangeTypeName AS LegalTransDateChangeTypeName,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime
FROM I_LegalTransactionDateLog
LEFT OUTER JOIN I_LCMUserContactCard AS _ChangedByContactCard ON _ChangedByContactCard.ContactCardType = 'User' AND _ChangedByContactCard.ContactCardID = LglCntntMChangedByUser AND _ChangedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
;

Learn More