C_LglCntntMMyLegalTransDates

DDL: C_LGLCNTNTMMYLEGALTRANSDATES SQL: CLCMMYDATES Type: view CONSUMPTION Package: ODATA_LCM_COMMON
22 Fields 1 Data Sources 1 Associations

My Legal Transaction Dates

C_LglCntntMMyLegalTransDates is a Consumption CDS View that provides data about "My Legal Transaction Dates" in SAP S/4HANA. It reads from 1 data source (C_LegalTransactionDateTP) and exposes 22 fields with key fields LegalTransactionDateUUID, LegalTransactionUUID. It has 1 association to related views. Part of development package ODATA_LCM_COMMON.

Data Sources (1)

SourceAliasJoin Type
C_LegalTransactionDateTP C_LegalTransactionDateTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LglCntntMMyUsrInIntCntct _LglCntntMMyUsrInIntCntct $projection.LegalTransactionUUID = _LglCntntMMyUsrInIntCntct.LegalTransactionUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CLCMMYDATES view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.personalData.blockingIndicator IsEndOfPurposeBlocked view
Analytics.dataExtraction.enabled true view
AbapCatalog.preserveKey true view
UI.headerInfo.typeName My Legal Transaction Dates view
UI.headerInfo.typeNamePlural My Legal Transaction Dates view
EndUserText.label My Legal Transaction Dates view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionDateUUID LegalTransactionDateUUID Universal Unique ID
KEY LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LegalContext _LegalTransactionTP LegalContext
LglCntntMContextVersion _LegalTransactionTP LglCntntMContextVersion Context Version
LegalTransaction _LegalTransactionTP LegalTransaction Legal Transaction ID
LegalTransactionTitle _LegalTransactionTP LegalTransactionTitle Title
LegalTransactionHealth _LegalTransactionTP LegalTransactionHealth LT Status
LegalTransactionHealthName
LglTransHealthCriticality _LegalTransactionTP LglTransHealthCriticality
LglCntntMDateType LglCntntMDateType Date Type
LglCntntMDateTypeName _LCMDateTypeValueHelp LglCntntMDateTypeName Long Text
LglCntntMFromDate LglCntntMFromDate Valid From
LglCntntMToDate LglCntntMToDate Valid To
LglCntntMCreatedUTCDateTime _LegalTransactionTP LglCntntMCreatedUTCDateTime Created On
LglCntntMEntity _LegalTransactionTP LglCntntMEntity Entity ID
LglCntntMEntityType _LegalTransactionTP LglCntntMEntityType Entity Type
LglCntntMProfile _LegalTransactionTP LglCntntMProfile Profile
LglTransAccessLvl _LegalTransactionTP LglTransAccessLvl Acs. Level
LglCntntMMainOrgCoCode _LegalTransactionTP LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgSalesOrg _LegalTransactionTP LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg _LegalTransactionTP LglCntntMMainOrgPurOrg Entity ID
IsEndOfPurposeBlocked _LegalTransactionTP IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_LglCntntMMyLegalTransDates.
-- 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: CLCMMYDATES

CREATE VIEW C_LglCntntMMyLegalTransDates AS
SELECT
  LegalTransactionDateUUID,
  LegalTransactionUUID,
  _LegalTransactionTP.LegalContext AS LegalContext,
  _LegalTransactionTP.LglCntntMContextVersion AS LglCntntMContextVersion,
  _LegalTransactionTP.LegalTransaction AS LegalTransaction,
  _LegalTransactionTP.LegalTransactionTitle AS LegalTransactionTitle,
  _LegalTransactionTP.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalTransactionTP._LegalTransactionHealthText.LegalTransactionHealthName AS LegalTransactionHealthName,
  _LegalTransactionTP.LglTransHealthCriticality AS LglTransHealthCriticality,
  LglCntntMDateType,
  _LCMDateTypeValueHelp.LglCntntMDateTypeName AS LglCntntMDateTypeName,
  LglCntntMFromDate,
  LglCntntMToDate,
  _LegalTransactionTP.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  _LegalTransactionTP.LglCntntMEntity AS LglCntntMEntity,
  _LegalTransactionTP.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTransactionTP.LglCntntMProfile AS LglCntntMProfile,
  _LegalTransactionTP.LglTransAccessLvl AS LglTransAccessLvl,
  _LegalTransactionTP.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  _LegalTransactionTP.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  _LegalTransactionTP.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  _LegalTransactionTP.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM C_LegalTransactionDateTP
LEFT OUTER JOIN I_LglCntntMMyUsrInIntCntct AS _LglCntntMMyUsrInIntCntct ON LegalTransactionUUID = _LglCntntMMyUsrInIntCntct.LegalTransactionUUID  -- association [1..1]
;

Learn More