C_LCMContextTP

DDL: C_LCMCONTEXTTP Type: view_entity CONSUMPTION
61 Fields 1 Data Sources 6 Associations

Enterprise Contract Mgmt. Legal Context

C_LCMContextTP is a Consumption CDS View that provides data about "Enterprise Contract Mgmt. Legal Context" in SAP S/4HANA. It reads from 1 data source (I_LCMContextTP) and exposes 61 fields with key field LglCntntMContextUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LCMContextTP I_LCMContextTP projection

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_LCMUserContactCard _CreatedByContactCard _CreatedByContactCard.ContactCardType = 'User' and _CreatedByContactCard.ContactCardID = $projection.LglCntntMCreatedByUser and _CreatedByContactCard.ContactCardRole = 'Creator'
[0..1] I_LCMUserContactCard _OwnerContactCard _OwnerContactCard.ContactCardType = 'User' and _OwnerContactCard.ContactCardID = $projection.LglCntntMContextOwner and _OwnerContactCard.ContactCardRole = 'Creator'
[0..1] I_LCMUserContactCard _ChangedByContactCard _ChangedByContactCard.ContactCardType = 'User' and _ChangedByContactCard.ContactCardID = $projection.LglCntntMChangedByUser and _ChangedByContactCard.ContactCardRole = 'Creator'
[0..1] C_LglCntntMContextQuickView _LglCntntMContextQuickView $projection.LglCntntMContextVersion = _LglCntntMContextQuickView.LglCntntMContextVersion and $projection.LegalContext = _LglCntntMContextQuickView.LegalContext
[0..*] C_LglCntntMChangeLog _LglCntntMChangeLog $projection.ChangeDocObject = _LglCntntMChangeLog.ChangeDocObject
[0..1] C_LglCntntMProfileValueHelp _LglCntntMProfileValueHelp $projection.LglCntntMProfile = _LglCntntMProfileValueHelp.LglCntntMProfile and $projection.LglCntntMIntegrationType = _LglCntntMProfileValueHelp.LglCntntMIntegrationType

Annotations (9)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey LglCntntMContextUUID view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Enterprise Contract Mgmt. Legal Context view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LegalContext LglCntntMContext Context ID
LglCntntMCntxtStsCriticality _LCMContextAggr LglCntntMCntxtStsCriticality
LglCntntMContextStatus LglCntntMContextStatus Status
LglCntntMProfile LglCntntMProfile Profile
LglCntntMIntegrationType LglCntntMIntegrationType Integration Variant
FldCtrlLglCntntMContextStatus _LCMContextAggr FldCtrlLglCntntMContextStatus
FldCtrlLglCntntMProfile _LCMContextAggr FldCtrlLglCntntMProfile
LglCntntMContextCurStatus LglCntntMContextCurStatus Status
LglCntntMStsPrfl LglCntntMStsPrfl Status Profile
LglCntntMContextVersion LglCntntMContextVersion Context Version
LglCntntMContextTitle LglCntntMContextTitle Title
LglCntntMContextOwner LglCntntMContextOwner Owner
LglCntntMCreatedByUser LglCntntMCreatedByUser Created By
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Created On
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed On
LglCntntMChangedByUser LglCntntMChangedByUser Changed By
LglCntntMContextValidFromDate LglCntntMContextValidFromDate Valid From
LglCntntMContextValidToDate LglCntntMContextValidToDate Valid To
LglCntntMPrevCntxtVers LglCntntMPrevCntxtVers Universal Unique ID
LglCntntMCntxtLanguage LglCntntMCntxtLanguage Language
LglCntntMGovLaw LglCntntMGovLaw Governing Law
LglCntntMGovLawText
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
LglCntntMNumerator _LCMContextAggr LglCntntMNumerator
LglCntntMNextCntxtUUID _LCMContextAggr LglCntntMNextCntxtUUID
LglCntntMNextCntxt _LCMContextAggr LglCntntMNextCntxt
LglCntntMNextCntxtTitle _LCMContextAggr LglCntntMNextCntxtTitle
LglCntntMPrevCntxtUUID _LCMContextAggr LglCntntMPrevCntxtUUID
LglCntntMPrevCntxt _LCMContextAggr LglCntntMPrevCntxt
LglCntntMPrevCntxtTitle _LCMContextAggr LglCntntMPrevCntxtTitle
LglCntntMCntxtAccessLvl LglCntntMCntxtAccessLvl Acs. Level
LglCntntMEntityType _LCMContextMainEntity LglCntntMEntityType Entity Type
LglCntntMEntity _LCMContextMainEntity LglCntntMEntity Entity ID
LglCntntMMainOrgType LglCntntMMainOrgType Main Organisation Ty
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode Entity ID
CompanyCodeName _CompanyCode CompanyCodeName Company Name
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg Entity ID
LglCntntMMainOrg _LCMContextAggr LglCntntMMainOrg
ChangeDocObject _LCMContextAggr ChangeDocObject Object Value
LanguageNameasLanguageNamelocalized
virtualLglCntntMEntityNamechar80
LglCntntMLongText LglCntntMLongText
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
LglCntntMLongTextMimeType LglCntntMLongTextMimeType
_LCMContextAggr _LCMContextAggr
_CreatedByContactCard _CreatedByContactCard
_OwnerContactCard _OwnerContactCard
_ChangedByContactCard _ChangedByContactCard
_LglCntntMChangeLog _LglCntntMChangeLog
_LglCntntMProfileValueHelp _LglCntntMProfileValueHelp
_LglCntntMContextQuickView _LglCntntMContextQuickView
_LanguageText _LanguageText
_LglCntntMAccessLvlText _LglCntntMAccessLvlText
_LglCntntMMainOrgTypeText _LglCntntMMainOrgTypeText
_SalesOrganizationText _SalesOrganizationText
_LCMContextMainEntity _LCMContextMainEntity
_LglCntntMProfileText _LglCntntMProfileText
_LglCntntMIntegTypeText _LglCntntMIntegTypeText
_LglCntntMCntxtCurrentStsTxt _LglCntntMCntxtCurrentStsTxt

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_LCMContextTP.
-- 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_LCMContextTP AS
SELECT
  LglCntntMContextUUID,
  LglCntntMContext AS LegalContext,
  _LCMContextAggr.LglCntntMCntxtStsCriticality AS LglCntntMCntxtStsCriticality,
  LglCntntMContextStatus,
  LglCntntMProfile,
  LglCntntMIntegrationType,
  _LCMContextAggr.FldCtrlLglCntntMContextStatus AS FldCtrlLglCntntMContextStatus,
  _LCMContextAggr.FldCtrlLglCntntMProfile AS FldCtrlLglCntntMProfile,
  LglCntntMContextCurStatus,
  LglCntntMStsPrfl,
  LglCntntMContextVersion,
  LglCntntMContextTitle,
  LglCntntMContextOwner,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMContextValidFromDate,
  LglCntntMContextValidToDate,
  LglCntntMPrevCntxtVers,
  LglCntntMCntxtLanguage,
  LglCntntMGovLaw,
  _LglCntntMGovLaw._LglCntntMGovLawText.LglCntntMGovLawText AS LglCntntMGovLawText,
  IsEndOfPurposeBlocked,
  _LCMContextAggr.LglCntntMNumerator AS LglCntntMNumerator,
  _LCMContextAggr.LglCntntMNextCntxtUUID AS LglCntntMNextCntxtUUID,
  _LCMContextAggr.LglCntntMNextCntxt AS LglCntntMNextCntxt,
  _LCMContextAggr.LglCntntMNextCntxtTitle AS LglCntntMNextCntxtTitle,
  _LCMContextAggr.LglCntntMPrevCntxtUUID AS LglCntntMPrevCntxtUUID,
  _LCMContextAggr.LglCntntMPrevCntxt AS LglCntntMPrevCntxt,
  _LCMContextAggr.LglCntntMPrevCntxtTitle AS LglCntntMPrevCntxtTitle,
  LglCntntMCntxtAccessLvl,
  _LCMContextMainEntity.LglCntntMEntityType AS LglCntntMEntityType,
  _LCMContextMainEntity.LglCntntMEntity AS LglCntntMEntity,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  _LCMContextAggr.LglCntntMMainOrg AS LglCntntMMainOrg,
  _LCMContextAggr.ChangeDocObject AS ChangeDocObject,
  _LanguageText.LanguageName as LanguageName : localized AS LanguageNameasLanguageNamelocalized,
  virtual LglCntntMEntityName : char80 AS virtualLglCntntMEntityNamechar80,
  LglCntntMLongText,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  LglCntntMLongTextMimeType
FROM I_LCMContextTP
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LglCntntMCreatedByUser AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _OwnerContactCard ON _OwnerContactCard.ContactCardType = 'User' AND _OwnerContactCard.ContactCardID = LglCntntMContextOwner AND _OwnerContactCard.ContactCardRole = 'Creator'  -- association [0..1]
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 C_LglCntntMContextQuickView AS _LglCntntMContextQuickView ON LglCntntMContextVersion = _LglCntntMContextQuickView.LglCntntMContextVersion AND LegalContext = _LglCntntMContextQuickView.LegalContext  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMChangeLog AS _LglCntntMChangeLog ON ChangeDocObject = _LglCntntMChangeLog.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMProfileValueHelp AS _LglCntntMProfileValueHelp ON LglCntntMProfile = _LglCntntMProfileValueHelp.LglCntntMProfile AND LglCntntMIntegrationType = _LglCntntMProfileValueHelp.LglCntntMIntegrationType  -- association [0..1]
;

Learn More