ESH_N_LEGAL_CONTEXT

DDL: ESH_N_LEGAL_CONTEXT SQL: ESH_L_LGL_CTX Type: view
21 Fields 1 Data Sources

ESH_N_LEGAL_CONTEXT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_LGLCNTNTMCONTEXTBASIC) and exposes 21 fields with key field LGLCNTNTMCONTEXTUUID.

Data Sources (1)

SourceAliasJoin Type
I_LGLCNTNTMCONTEXTBASIC I_LGLCNTNTMCONTEXTBASIC from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

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
AbapCatalog.sqlViewName ESH_L_LGL_CTX view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LGLCNTNTMCONTEXTUUID LGLCNTNTMCONTEXTUUID Universal Unique ID
CTX_ENTITY_BP_FN
CHANGED_BY _CHANGEDBY FULLNAME Name
CREATED_BY _CREATEDBY FULLNAME Name
OWNER _OWNER FULLNAME Name
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
LANGUAGENAME
LGLCNTNTMACCESSLVLNAME
LGLCNTNTMCATEGORYNAME
PARENT_CATEGORY_NAME
LGLCNTNTMCHANGEDUTCDATETIME LGLCNTNTMCHANGEDUTCDATETIME Changed On
LGLCNTNTMCONTEXT LGLCNTNTMCONTEXT Context ID
LGLCNTNTMCONTEXTTITLE LGLCNTNTMCONTEXTTITLE Title
LGLCNTNTMCONTEXTVALIDFROMDATE LGLCNTNTMCONTEXTVALIDFROMDATE Valid From
LGLCNTNTMCONTEXTVALIDTODATE LGLCNTNTMCONTEXTVALIDTODATE Valid To
LGLCNTNTMCONTEXTVERSION LGLCNTNTMCONTEXTVERSION Context Version
LGLCNTNTMCREATEDUTCDATETIME LGLCNTNTMCREATEDUTCDATETIME Created On
MAIN_ENTITY_TYPE
LGLCNTNTMPROFILE LGLCNTNTMPROFILE Profile
LGLCNTNTMPROFILENAME
LGLCNTNTMSTATUSNAME

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_N_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_L_LGL_CTX
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_LEGAL_CONTEXT AS
SELECT
  LGLCNTNTMCONTEXTUUID,
  _CONTEXTENTITY._BUSINESSPARTNER.FIRSTNAME AS CTX_ENTITY_BP_FN,
  _CHANGEDBY.FULLNAME AS CHANGED_BY,
  _CREATEDBY.FULLNAME AS CREATED_BY,
  _OWNER.FULLNAME AS OWNER,
  ISENDOFPURPOSEBLOCKED,
  _LANGUAGETEXT[1: LANGUAGE = $parameters. P_Language].LANGUAGENAME AS LANGUAGENAME,
  _LGLCNTNTMACCESSLVLTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMACCESSLVLNAME AS LGLCNTNTMACCESSLVLNAME,
  _CONTEXTCATEGORY._LGLCNTNTMCATEGORYTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMCATEGORYNAME AS LGLCNTNTMCATEGORYNAME,
  _CONTEXTPARENTCATEGORY._LGLCNTNTMCATEGORYTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMCATEGORYNAME AS PARENT_CATEGORY_NAME,
  LGLCNTNTMCHANGEDUTCDATETIME,
  LGLCNTNTMCONTEXT,
  LGLCNTNTMCONTEXTTITLE,
  LGLCNTNTMCONTEXTVALIDFROMDATE,
  LGLCNTNTMCONTEXTVALIDTODATE,
  LGLCNTNTMCONTEXTVERSION,
  LGLCNTNTMCREATEDUTCDATETIME,
  _MAINCONTEXTENTITY._ENTITYTYPETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMENTITYTYPENAME AS MAIN_ENTITY_TYPE,
  LGLCNTNTMPROFILE,
  _LGLCNTNTMPROFILETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMPROFILENAME AS LGLCNTNTMPROFILENAME,
  _CONTEXTSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMSTATUSNAME AS LGLCNTNTMSTATUSNAME
FROM I_LGLCNTNTMCONTEXTBASIC
;

Learn More