I_LegalTransRnwlAndTermnTP

DDL: I_LEGALTRANSRNWLANDTERMNTP SQL: ILTRNWLTP Type: view TRANSACTIONAL
1 Data Sources 4 Associations

Legal Transaction Transactional view for Renewal

I_LegalTransRnwlAndTermnTP is a Transactional CDS View that provides data about "Legal Transaction Transactional view for Renewal" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionRnwlAndTermn). It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionRnwlAndTermn I_LegalTransactionRnwlAndTermn from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionTP _LegalTransactionTP $projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID
[0..1] I_UnitOfMeasureText _UnitOfMeasureText $projection.LglCntntMRnwlPeriodUnit = _UnitOfMeasureText.UnitOfMeasure and _UnitOfMeasureText.Language = $session.system_language
[0..1] I_UnitOfMeasureText _ReminderUnitOfMeasureText $projection.LglCntntMReminderTimeUnit = _ReminderUnitOfMeasureText.UnitOfMeasure and _ReminderUnitOfMeasureText.Language = $session.system_language
[0..1] I_LegalTransactionDate _LegalTransactionDate $projection.LegalTransactionUUID = _LegalTransactionDate.LegalTransactionUUID and _LegalTransactionDate.LglCntntMDateType = 'SAP3' / _LegalTransaction, _UnitOfMeasureText, _ReminderUnitOfMeasureText, _LegalTransactionDate, _LglCntntMRnwlTypeText, @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT] _LegalTransactionTP }

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ILTRNWLTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey LglCntntMRnwlAndTermnUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence LCM_LT_RNWTRM view
ObjectModel.writeDraftPersistence LCM_LT_RNWTRM_D view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Legal Transaction Transactional view for Renewal view

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_LegalTransRnwlAndTermnTP.
-- 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: ILTRNWLTP

CREATE VIEW I_LegalTransRnwlAndTermnTP AS
SELECT *  -- field list not available in parsed metadata
FROM I_LegalTransactionRnwlAndTermn
LEFT OUTER JOIN I_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON LglCntntMRnwlPeriodUnit = _UnitOfMeasureText.UnitOfMeasure AND _UnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ReminderUnitOfMeasureText ON LglCntntMReminderTimeUnit = _ReminderUnitOfMeasureText.UnitOfMeasure AND _ReminderUnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDate AS _LegalTransactionDate ON LegalTransactionUUID = _LegalTransactionDate.LegalTransactionUUID AND _LegalTransactionDate.LglCntntMDateType = 'SAP3' / _LegalTransaction, _UnitOfMeasureText, _ReminderUnitOfMeasureText, _LegalTransactionDate, _LglCntntMRnwlTypeText,  -- association [0..1]
;

Learn More