C_LegalTrContextIdValueHelp

DDL: C_LEGALTRCONTEXTIDVALUEHELP SQL: CLGLTRCTXIDVH Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

Value help for Legal Transaction Context ID

C_LegalTrContextIdValueHelp is a Consumption CDS View that provides data about "Value help for Legal Transaction Context ID" in SAP S/4HANA. It reads from 1 data source (I_LcmContext) and exposes 9 fields with key fields LglCntntMContext, LglCntntMContextVersion. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LcmContext I_LcmContext from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_LCMUserValueHelp _Owner _Owner.UserID = $projection.LglCntntMContextOwner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CLGLTRCTXIDVH view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey LglCntntMContext view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Value help for Legal Transaction Context ID view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMContext LglCntntMContext Context ID
KEY LglCntntMContextVersion LglCntntMContextVersion Version
LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMContextTitle LglCntntMContextTitle Context Title
LglCntntMContextOwner LglCntntMContextOwner Context Owner
FirstName _Owner FirstName Owner First Name
LastName _Owner LastName Owner Last Name
LglCntntMProfile LglCntntMProfile Profile
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Business Purpose Completed

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_LegalTrContextIdValueHelp.
-- 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: CLGLTRCTXIDVH

CREATE VIEW C_LegalTrContextIdValueHelp AS
SELECT
  LglCntntMContext,
  LglCntntMContextVersion,
  LglCntntMContextUUID,
  LglCntntMContextTitle,
  LglCntntMContextOwner,
  _Owner.FirstName AS FirstName,
  _Owner.LastName AS LastName,
  LglCntntMProfile,
  IsEndOfPurposeBlocked
FROM I_LcmContext
LEFT OUTER JOIN C_LCMUserValueHelp AS _Owner ON _Owner.UserID = LglCntntMContextOwner  -- association [0..1]
;

Learn More