ESH_N_LEGAL_DOCUMENT

DDL: ESH_N_LEGAL_DOCUMENT SQL: ESH_L_LEGALDOC Type: view Package: BSESH_LCM_DOC_HANA_CONTENT
32 Fields 1 Data Sources

Anchor view -LEGAL_DOCUMENT

ESH_N_LEGAL_DOCUMENT is a CDS View that provides data about "Anchor view -LEGAL_DOCUMENT" in SAP S/4HANA. It reads from 1 data source (I_LCMDOCUMENT) and exposes 32 fields with key field LGLCNTNTMDOCUMENTUUID. Part of development package BSESH_LCM_DOC_HANA_CONTENT.

Data Sources (1)

SourceAliasJoin Type
I_LCMDOCUMENT I_LCMDOCUMENT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ESH_L_LEGALDOC view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY LGLCNTNTMDOCUMENTUUID LGLCNTNTMDOCUMENTUUID Universal Unique ID
DOCUMENTDESCRIPTION DOCUMENTDESCRIPTION Doc. Name
FILENAME _DOCATTACHALL FILENAME URL or Filenam Path
CHANGED_BY _CHANGEDBY FULLNAME Name
CREATED_BY _CREATEDBY FULLNAME Name
STAMP_CREATED_BY
INTERNALDOCUMENTSTATUS INTERNALDOCUMENTSTATUS Status
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
REL_LEGAL_TR
LEGALTRANSACTION _LEGALTRANSACTION LEGALTRANSACTION Legal Transaction ID
LEGALTRANSACTIONTITLE _LEGALTRANSACTION LEGALTRANSACTIONTITLE Title
REL_LEGAL_TR_NAME
LGLCNTNTMACCESSLVLNAME
LGLCNTNTMCHANGEDUTCDATETIME LGLCNTNTMCHANGEDUTCDATETIME Changed On
LGLCNTNTMCREATEDUTCDATETIME LGLCNTNTMCREATEDUTCDATETIME Created On
LGLCNTNTMDOCACCESSLVL LGLCNTNTMDOCACCESSLVL Acs. Level
LGLCNTNTMDOCCONTENTTYPE LGLCNTNTMDOCCONTENTTYPE Content Type
DOC_CONT_TYPE_C_SEARCH
LGLCNTNTMDOCSTATUSNAME
LGLCNTNTMDOCTEMPLATENAME _LGLCNTNTMDOCTEMPLATEINFO LGLCNTNTMDOCTEMPLATENAME Templ. Name
LGLCNTNTMDOCUMENT LGLCNTNTMDOCUMENT Document ID
LGLCNTNTMDOCUMENTISTOPVERSION LGLCNTNTMDOCUMENTISTOPVERSION TRUE
SYSTEM_STAMP_NAME
USER_STAMP_NAME
LGLCNTNTMMAINORGCOCODE _LEGALTRANSACTION LGLCNTNTMMAINORGCOCODE Entity ID
LGLCNTNTMMAINORGPURORG _LEGALTRANSACTION LGLCNTNTMMAINORGPURORG Entity ID
LGLCNTNTMMAINORGSALESORG _LEGALTRANSACTION LGLCNTNTMMAINORGSALESORG Entity ID
LGLCNTNTMPROFILE _LEGALTRANSACTION LGLCNTNTMPROFILE Profile
LGLCNTNTMSGNTRDOCSTATUSNAME
LGLTRANSACCESSLVL _LEGALTRANSACTION LGLTRANSACCESSLVL Acs. Level
PHYSDOCCNTNTTEXT
DOC_TYPE _DOCATTACHALL WORKSTATIONAPPLICATION Applic.

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_DOCUMENT.
-- 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_LEGALDOC
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_LEGAL_DOCUMENT AS
SELECT
  LGLCNTNTMDOCUMENTUUID,
  DOCUMENTDESCRIPTION,
  _DOCATTACHALL.FILENAME AS FILENAME,
  _CHANGEDBY.FULLNAME AS CHANGED_BY,
  _CREATEDBY.FULLNAME AS CREATED_BY,
  _LGLCNTNTMDOCUMENTSTAMP._CREATEDBY.FULLNAME AS STAMP_CREATED_BY,
  INTERNALDOCUMENTSTATUS,
  ISENDOFPURPOSEBLOCKED,
  _LEGALTRANSACTIONDOCLINK._LEGALTRANSACTION.LEGALTRANSACTION AS REL_LEGAL_TR,
  _LEGALTRANSACTION.LEGALTRANSACTION AS LEGALTRANSACTION,
  _LEGALTRANSACTION.LEGALTRANSACTIONTITLE AS LEGALTRANSACTIONTITLE,
  _LEGALTRANSACTIONDOCLINK._LEGALTRANSACTION.LEGALTRANSACTIONTITLE AS REL_LEGAL_TR_NAME,
  _ACCESSLVLTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMACCESSLVLNAME AS LGLCNTNTMACCESSLVLNAME,
  LGLCNTNTMCHANGEDUTCDATETIME,
  LGLCNTNTMCREATEDUTCDATETIME,
  LGLCNTNTMDOCACCESSLVL,
  LGLCNTNTMDOCCONTENTTYPE,
  _LGLCNTNTMDOCCNTNTTYPESRCHTXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMDOCCONTENTTYPENAME AS DOC_CONT_TYPE_C_SEARCH,
  _DOCSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMDOCSTATUSNAME AS LGLCNTNTMDOCSTATUSNAME,
  _LGLCNTNTMDOCTEMPLATEINFO.LGLCNTNTMDOCTEMPLATENAME AS LGLCNTNTMDOCTEMPLATENAME,
  LGLCNTNTMDOCUMENT,
  LGLCNTNTMDOCUMENTISTOPVERSION,
  _LGLCNTNTMDOCUMENTSTAMP._LGLCNTNTMSAPDOCSTAMPTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMDOCUMENTSTAMPNAME AS SYSTEM_STAMP_NAME,
  _LGLCNTNTMDOCUMENTSTAMP._LGLCNTNTMCSTMDOCSTAMPTXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMDOCUMENTSTAMPNAME AS USER_STAMP_NAME,
  _LEGALTRANSACTION.LGLCNTNTMMAINORGCOCODE AS LGLCNTNTMMAINORGCOCODE,
  _LEGALTRANSACTION.LGLCNTNTMMAINORGPURORG AS LGLCNTNTMMAINORGPURORG,
  _LEGALTRANSACTION.LGLCNTNTMMAINORGSALESORG AS LGLCNTNTMMAINORGSALESORG,
  _LEGALTRANSACTION.LGLCNTNTMPROFILE AS LGLCNTNTMPROFILE,
  _SGNTRDOCSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMSGNTRDOCSTATUSNAME AS LGLCNTNTMSGNTRDOCSTATUSNAME,
  _LEGALTRANSACTION.LGLTRANSACCESSLVL AS LGLTRANSACCESSLVL,
  _DOCATTACHALL._ATTACHMENT.PHYSDOCCNTNTTEXT AS PHYSDOCCNTNTTEXT,
  _DOCATTACHALL.WORKSTATIONAPPLICATION AS DOC_TYPE
FROM I_LCMDOCUMENT
;

Learn More