C_LegalTransactionDate

DDL: C_LEGALTRANSACTIONDATE SQL: CLEGALTRDATE Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Legal Transaction Date (Draft disabled)

C_LegalTransactionDate is a Consumption CDS View that provides data about "Legal Transaction Date (Draft disabled)" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionDate) and exposes 11 fields with key field LegalTransactionDateUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionDate I_LegalTransactionDate from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_LCMDateTypeValueHelp _LCMDateTypeValueHelp $projection.LglCntntMDateType = _LCMDateTypeValueHelp.LglCntntMDateType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLEGALTRDATE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.semanticKey LglCntntMDateType view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Legal Transaction Date (Draft disabled) view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionDateUUID LegalTransactionDateUUID Universal Unique ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMFromDate LglCntntMFromDate From
LglCntntMToDate LglCntntMToDate To
LglCntntMDateType LglCntntMDateType Date Type
LglCntntMDateTypeName _LCMDateTypeValueHelp LglCntntMDateTypeName Long Text
LglCntntMDateIsPeriod
LegalTransactionMandatoryFlag LegalTransactionMandatoryFlag Mandatory
LglCntntMIsMandatory Required
_LCMDateTypeValueHelp _LCMDateTypeValueHelp
_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_LegalTransactionDate.
-- 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: CLEGALTRDATE

CREATE VIEW C_LegalTransactionDate AS
SELECT
  LegalTransactionDateUUID,
  LegalTransactionUUID,
  LglCntntMFromDate,
  LglCntntMToDate,
  LglCntntMDateType,
  _LCMDateTypeValueHelp.LglCntntMDateTypeName AS LglCntntMDateTypeName,
  '' AS LglCntntMDateIsPeriod,
  LegalTransactionMandatoryFlag,
  cast ( '' as lcm_is_mandatory preserving type ) AS LglCntntMIsMandatory
FROM I_LegalTransactionDate
LEFT OUTER JOIN C_LCMDateTypeValueHelp AS _LCMDateTypeValueHelp ON LglCntntMDateType = _LCMDateTypeValueHelp.LglCntntMDateType  -- association [0..1]
;

Learn More