ESH_S_LEGAL_CONTEXT

DDL: ESH_S_LEGAL_CONTEXT SQL: ESH_U_LGL_CTX Type: view Package: BSESH_LCM_CTX_HANA_CONTENT

Search view -LEGAL_CONTEXT

ESH_S_LEGAL_CONTEXT is a CDS View that provides data about "Search view -LEGAL_CONTEXT" in SAP S/4HANA. It reads from 1 data source (ESH_N_LEGAL_CONTEXT) and exposes 21 fields with key field LGLCNTNTMCONTEXTUUID. It has 1 association to related views. Part of development package BSESH_LCM_CTX_HANA_CONTENT.

Data Sources (1)

SourceAliasJoin Type
ESH_N_LEGAL_CONTEXT ESH_N_LEGAL_CONTEXT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_LGLCNTNTMCONTEXT _EXTENSION ( $projection.LGLCNTNTMCONTEXTUUID = _EXTENSION.LGLCNTNTMCONTEXTUUID )

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name LegalContext view
UI.headerInfo.typeName Legal Context view
UI.headerInfo.typeNamePlural Legal Contexts view
Consumption.semanticObject LegalContext view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value LGLCNTNTMCONTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_LGL_CTX view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LGLCNTNTMCONTEXTUUID LGLCNTNTMCONTEXTUUID Universal Unique ID
CTX_ENTITY_BP_FN CTX_ENTITY_BP_FN
CHANGED_BY CHANGED_BY Last Changed By
CREATED_BY CREATED_BY Created By
OWNER OWNER Owner
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
LANGUAGENAME LANGUAGENAME Language
LGLCNTNTMACCESSLVLNAME LGLCNTNTMACCESSLVLNAME Access Level
LGLCNTNTMCATEGORYNAME LGLCNTNTMCATEGORYNAME Category
PARENT_CATEGORY_NAME PARENT_CATEGORY_NAME Category Path
LGLCNTNTMCHANGEDUTCDATETIME LGLCNTNTMCHANGEDUTCDATETIME Last Changed On
LGLCNTNTMCONTEXT LGLCNTNTMCONTEXT Context ID
LGLCNTNTMCONTEXTTITLE LGLCNTNTMCONTEXTTITLE Title
LGLCNTNTMCONTEXTVALIDFROMDATE LGLCNTNTMCONTEXTVALIDFROMDATE Valid From
LGLCNTNTMCONTEXTVALIDTODATE LGLCNTNTMCONTEXTVALIDTODATE Valid To
LGLCNTNTMCONTEXTVERSION LGLCNTNTMCONTEXTVERSION Version
LGLCNTNTMCREATEDUTCDATETIME LGLCNTNTMCREATEDUTCDATETIME Created On
MAIN_ENTITY_TYPE MAIN_ENTITY_TYPE Main Entity Type
LGLCNTNTMPROFILE LGLCNTNTMPROFILE Profile
LGLCNTNTMPROFILENAME LGLCNTNTMPROFILENAME Profile Name
LGLCNTNTMSTATUSNAME LGLCNTNTMSTATUSNAME Status

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 ESH_S_LEGAL_CONTEXT.
-- 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: ESH_U_LGL_CTX
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_LEGAL_CONTEXT AS
SELECT
  LGLCNTNTMCONTEXTUUID,
  CTX_ENTITY_BP_FN,
  CHANGED_BY,
  CREATED_BY,
  OWNER,
  ISENDOFPURPOSEBLOCKED,
  LANGUAGENAME,
  LGLCNTNTMACCESSLVLNAME,
  LGLCNTNTMCATEGORYNAME,
  PARENT_CATEGORY_NAME,
  LGLCNTNTMCHANGEDUTCDATETIME,
  LGLCNTNTMCONTEXT,
  LGLCNTNTMCONTEXTTITLE,
  LGLCNTNTMCONTEXTVALIDFROMDATE,
  LGLCNTNTMCONTEXTVALIDTODATE,
  LGLCNTNTMCONTEXTVERSION,
  LGLCNTNTMCREATEDUTCDATETIME,
  MAIN_ENTITY_TYPE,
  LGLCNTNTMPROFILE,
  LGLCNTNTMPROFILENAME,
  LGLCNTNTMSTATUSNAME
FROM ESH_N_LEGAL_CONTEXT
LEFT OUTER JOIN E_LGLCNTNTMCONTEXT AS _EXTENSION ON ( LGLCNTNTMCONTEXTUUID = _EXTENSION.LGLCNTNTMCONTEXTUUID )  -- association [0..1]
;