C_LglCntntMCntxtRnwlAndTermnTP

DDL: C_LGLCNTNTMCNTXTRNWLANDTERMNTP Type: view_entity CONSUMPTION Package: ODATA_LCM_CTX
23 Fields 1 Data Sources 2 Associations

LCM Context Renewal and Termination

C_LglCntntMCntxtRnwlAndTermnTP is a Consumption CDS View that provides data about "LCM Context Renewal and Termination" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCntxtRnwlAndTermnTP) and exposes 23 fields with key field LglCntntMContextUUID. It has 2 associations to related views. Part of development package ODATA_LCM_CTX.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCntxtRnwlAndTermnTP I_LglCntntMCntxtRnwlAndTermnTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LCMUserContactCard _RnwlContactCard _RnwlContactCard.ContactCardType = 'User' and _RnwlContactCard.ContactCardID = $projection.LglCntntMRnwlReminderUser and _RnwlContactCard.ContactCardRole = 'Creator'
[0..1] I_LCMUserContactCard _TermnContactCard _TermnContactCard.ContactCardType = 'User' and _TermnContactCard.ContactCardID = $projection.LglCntntMTermnReminderUser and _TermnContactCard.ContactCardRole = 'Creator'

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label LCM Context Renewal and Termination view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey LglCntntMContextUUID view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMRnwlType LglCntntMRnwlType Renewal Type
LglCntntMRnwlTypeName _LglCntntMRnwlTypeText LglCntntMRnwlTypeName
LglCntntMRenewalClause LglCntntMRenewalClause Renewal Clause
LglCntntMRnwlPeriod LglCntntMRnwlPeriod Renewal Period
LglCntntMRnwlPeriodUnit LglCntntMRnwlPeriodUnit Period Unit
UnitOfMeasureName _UnitOfMeasureText UnitOfMeasureName Meas. Unit Text
LglCntntMRnwlReminderDays LglCntntMRnwlReminderDays Rnwl Reminder Days
LglCntntMRnwlReminderUser LglCntntMRnwlReminderUser Rnwl Recipient User
FullName _RnwlUserDetails FullName Name
LglCntntMTerminationClause LglCntntMTerminationClause Termination Clause
LglCntntMNextTermnClause LglCntntMNextTermnClause Next Termn Clause
LglCntntMTermnReminderDays LglCntntMTermnReminderDays Term Reminder Days
LglCntntMReminderTimeUnit LglCntntMReminderTimeUnit
LglCntntMReminderTimeUnitName _ReminderUnitOfMeasureText UnitOfMeasureName Meas. Unit Text
LglCntntMTermnReminderUser LglCntntMTermnReminderUser Term Recipient User
RecipientFullName _TermnUserDetails FullName Name
_LglCntntMContext _LglCntntMContext
_TermnContactCard _TermnContactCard
_RnwlContactCard _RnwlContactCard
_TermnUserDetails _TermnUserDetails
_RnwlUserDetails _RnwlUserDetails
_ReminderUnitOfMeasureText _ReminderUnitOfMeasureText

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_LglCntntMCntxtRnwlAndTermnTP.
-- 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.

CREATE VIEW C_LglCntntMCntxtRnwlAndTermnTP AS
SELECT
  LglCntntMContextUUID,
  LglCntntMRnwlType,
  _LglCntntMRnwlTypeText.LglCntntMRnwlTypeName AS LglCntntMRnwlTypeName,
  LglCntntMRenewalClause,
  LglCntntMRnwlPeriod,
  LglCntntMRnwlPeriodUnit,
  _UnitOfMeasureText.UnitOfMeasureName AS UnitOfMeasureName,
  LglCntntMRnwlReminderDays,
  LglCntntMRnwlReminderUser,
  _RnwlUserDetails.FullName AS FullName,
  LglCntntMTerminationClause,
  LglCntntMNextTermnClause,
  LglCntntMTermnReminderDays,
  LglCntntMReminderTimeUnit,
  _ReminderUnitOfMeasureText.UnitOfMeasureName AS LglCntntMReminderTimeUnitName,
  LglCntntMTermnReminderUser,
  _TermnUserDetails.FullName AS RecipientFullName
FROM I_LglCntntMCntxtRnwlAndTermnTP
LEFT OUTER JOIN I_LCMUserContactCard AS _RnwlContactCard ON _RnwlContactCard.ContactCardType = 'User' AND _RnwlContactCard.ContactCardID = LglCntntMRnwlReminderUser AND _RnwlContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _TermnContactCard ON _TermnContactCard.ContactCardType = 'User' AND _TermnContactCard.ContactCardID = LglCntntMTermnReminderUser AND _TermnContactCard.ContactCardRole = 'Creator'  -- association [0..1]
;

Learn More