ESH_S_LEGAL_TRANSACTION

DDL: ESH_S_LEGAL_TRANSACTION SQL: ESH_U_LEGALTR Type: view Package: BSESH_LCM_LT_HANA_CONTENT
64 Fields 1 Data Sources 1 Associations

Search view -LEGAL_TRANSACTION

ESH_S_LEGAL_TRANSACTION is a CDS View that provides data about "Search view -LEGAL_TRANSACTION" in SAP S/4HANA. It reads from 1 data source (ESH_N_LEGAL_TRANSACTION) and exposes 64 fields with key field LEGALTRANSACTIONUUID. It has 1 association to related views. Part of development package BSESH_LCM_LT_HANA_CONTENT.

Data Sources (1)

SourceAliasJoin Type
ESH_N_LEGAL_TRANSACTION ESH_N_LEGAL_TRANSACTION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_LEGALTRANSACTION _EXTENSTION ( $projection.LEGALTRANSACTIONUUID = _EXTENSTION.LEGALTRANSACTIONUUID )

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL 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 LegalTransaction view
UI.headerInfo.typeName Legal Transaction view
UI.headerInfo.typeNamePlural Legal Transactions view
Consumption.semanticObject LegalTransaction view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value LEGALTRANSACTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_LEGALTR view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY LEGALTRANSACTIONUUID LEGALTRANSACTIONUUID Universal Unique ID
MAIN_ENTITY_CC MAIN_ENTITY_CC
ENTITY_CC ENTITY_CC Entity Company Code
MAIN_ORG_CC MAIN_ORG_CC Company Name
MAIN_ENTITY_BP_FN MAIN_ENTITY_BP_FN Main Entity - Business Partner First Name
MAIN_ENTITY_CUS_FN MAIN_ENTITY_CUS_FN Main Entity - Customer First Name
MAIN_ENTITY_SUP_FN MAIN_ENTITY_SUP_FN
CHANGED_BY_NAME CHANGED_BY_NAME Last Changed By
INT_CNT_NAME INT_CNT_NAME Internal Contact Name
CREATED_BY_NAME CREATED_BY_NAME Created By
MAIN_ENTITY_BP_GPN1 MAIN_ENTITY_BP_GPN1 Main Entity - Group Business Partner Name1
MAIN_ENTITY_CUS_GPN1 MAIN_ENTITY_CUS_GPN1 Main Entity - Customer Group First Name
MAIN_ENTITY_SUP_GPN1 MAIN_ENTITY_SUP_GPN1 Main Entity - Supplier Group First Name
MAIN_ENTITY_BP_GPN2 MAIN_ENTITY_BP_GPN2 Main Entity - Group Business Partner Name2
MAIN_ENTITY_CUS_GPN2 MAIN_ENTITY_CUS_GPN2 Main Entity - Customer Group Last Name
MAIN_ENTITY_SUP_GPN2 MAIN_ENTITY_SUP_GPN2 Main Entity - Supplier Group Last Name
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
LANGUAGENAME LANGUAGENAME Language
MAIN_ENTITY_BP_LN MAIN_ENTITY_BP_LN Main Entity - Business Partner Last Name
MAIN_ENTITY_CUS_LN MAIN_ENTITY_CUS_LN Main Entity - Customer Last Name
MAIN_ENTITY_SUP_LN MAIN_ENTITY_SUP_LN Main Entity - Supplier Last Name
LEGALTRANSACTION LEGALTRANSACTION Legal Transaction ID
LEGALTRANSACTIONHEALTHNAME LEGALTRANSACTIONHEALTHNAME Status
LEGALTRANSACTIONTITLE LEGALTRANSACTIONTITLE Title
LGLCNTNTMACCESSLVLNAME LGLCNTNTMACCESSLVLNAME Access Level
PARENT_CATEGORY_NAME PARENT_CATEGORY_NAME
LGLCNTNTMCATEGORYNAME LGLCNTNTMCATEGORYNAME Category
LGLCNTNTMCHANGEDUTCDATETIME LGLCNTNTMCHANGEDUTCDATETIME Last Changed On
LGLCNTNTMCONTEXT LGLCNTNTMCONTEXT Context
LGLCNTNTMCONTEXTTITLE LGLCNTNTMCONTEXTTITLE Context
LGLCNTNTMCREATEDUTCDATETIME LGLCNTNTMCREATEDUTCDATETIME Created On
MAIN_ENTITY_TYPE MAIN_ENTITY_TYPE Main Entity Type
ENTITY_TYPE ENTITY_TYPE Entity Type
LGLCNTNTMGOVLAWTEXT LGLCNTNTMGOVLAWTEXT Governing Law
LGLCNTNTMINTCNTCTUSER LGLCNTNTMINTCNTCTUSER Internal Contact Name
LGLCNTNTMLINKDOBJ LGLCNTNTMLINKDOBJ Unique ID
LGLCNTNTMLINKDOBJTYPENAME LGLCNTNTMLINKDOBJTYPENAME Linked Object Type
LGLCNTNTMMAINORGCOCODE LGLCNTNTMMAINORGCOCODE Main Organization - Company Code
LGLCNTNTMMAINORGPURORG LGLCNTNTMMAINORGPURORG Main Organization - Purchase Org.
LGLCNTNTMMAINORGSALESORG LGLCNTNTMMAINORGSALESORG Main Organization - Sales Org.
LGLCNTNTMMAINORGTYPENAME LGLCNTNTMMAINORGTYPENAME Main Organization Type
LGLCNTNTMPROFILE LGLCNTNTMPROFILE Profile
LGLTRANSACCESSLVL LGLTRANSACCESSLVL Access Level
MAIN_ENTITY_BP1 MAIN_ENTITY_BP1 Main Entity - BP Org Name1
MAIN_ENTITY_SUP1 MAIN_ENTITY_SUP1
ENTITY_CUS1 ENTITY_CUS1 Entity Customer First Name
ENTITY_SUP1 ENTITY_SUP1 Entity Supplier First Name
MAIN_ENTITY_CUS1 MAIN_ENTITY_CUS1
MAIN_ENTITY_CUSORG_FN MAIN_ENTITY_CUSORG_FN Main Entity - Customer Org First Name
MAIN_ENTITY_SUPORG_FN MAIN_ENTITY_SUPORG_FN Main Entity - Supplier Org First Name
MAIN_ENTITY_BP2 MAIN_ENTITY_BP2 Main Entity - BP Org Name2
ENTITY_SUP2 ENTITY_SUP2 Entity Supplier Second Name
MAIN_ENTITY_SUP2 MAIN_ENTITY_SUP2
ENTITY_CUS2 ENTITY_CUS2 Entity Customer Second Name
MAIN_ENTITY_CUS2 MAIN_ENTITY_CUS2
MAIN_ENTITY_CUSORG_LN MAIN_ENTITY_CUSORG_LN Main Entity - Customer Org Last Name
MAIN_ENTITY_SUPORG_LN MAIN_ENTITY_SUPORG_LN Main Entity - Customer Org Last Name
MAIN_ORG_PO MAIN_ORG_PO Purch. Org. Name
ENTITY_PO ENTITY_PO Entity Purchasing Org.
MAIN_ENTITY_PO MAIN_ENTITY_PO
RELSHPLEGALTRANSACTION RELSHPLEGALTRANSACTION Related Legal Transaction
MAIN_ORG_SO MAIN_ORG_SO
ENTITY_SO ENTITY_SO Entity Sales Org.
MAIN_ENTITY_SO MAIN_ENTITY_SO

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_TRANSACTION.
-- 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_LEGALTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_LEGAL_TRANSACTION AS
SELECT
  LEGALTRANSACTIONUUID,
  MAIN_ENTITY_CC,
  ENTITY_CC,
  MAIN_ORG_CC,
  MAIN_ENTITY_BP_FN,
  MAIN_ENTITY_CUS_FN,
  MAIN_ENTITY_SUP_FN,
  CHANGED_BY_NAME,
  INT_CNT_NAME,
  CREATED_BY_NAME,
  MAIN_ENTITY_BP_GPN1,
  MAIN_ENTITY_CUS_GPN1,
  MAIN_ENTITY_SUP_GPN1,
  MAIN_ENTITY_BP_GPN2,
  MAIN_ENTITY_CUS_GPN2,
  MAIN_ENTITY_SUP_GPN2,
  ISENDOFPURPOSEBLOCKED,
  LANGUAGENAME,
  MAIN_ENTITY_BP_LN,
  MAIN_ENTITY_CUS_LN,
  MAIN_ENTITY_SUP_LN,
  LEGALTRANSACTION,
  LEGALTRANSACTIONHEALTHNAME,
  LEGALTRANSACTIONTITLE,
  LGLCNTNTMACCESSLVLNAME,
  PARENT_CATEGORY_NAME,
  LGLCNTNTMCATEGORYNAME,
  LGLCNTNTMCHANGEDUTCDATETIME,
  LGLCNTNTMCONTEXT,
  LGLCNTNTMCONTEXTTITLE,
  LGLCNTNTMCREATEDUTCDATETIME,
  MAIN_ENTITY_TYPE,
  ENTITY_TYPE,
  LGLCNTNTMGOVLAWTEXT,
  LGLCNTNTMINTCNTCTUSER,
  LGLCNTNTMLINKDOBJ,
  LGLCNTNTMLINKDOBJTYPENAME,
  LGLCNTNTMMAINORGCOCODE,
  LGLCNTNTMMAINORGPURORG,
  LGLCNTNTMMAINORGSALESORG,
  LGLCNTNTMMAINORGTYPENAME,
  LGLCNTNTMPROFILE,
  LGLTRANSACCESSLVL,
  MAIN_ENTITY_BP1,
  MAIN_ENTITY_SUP1,
  ENTITY_CUS1,
  ENTITY_SUP1,
  MAIN_ENTITY_CUS1,
  MAIN_ENTITY_CUSORG_FN,
  MAIN_ENTITY_SUPORG_FN,
  MAIN_ENTITY_BP2,
  ENTITY_SUP2,
  MAIN_ENTITY_SUP2,
  ENTITY_CUS2,
  MAIN_ENTITY_CUS2,
  MAIN_ENTITY_CUSORG_LN,
  MAIN_ENTITY_SUPORG_LN,
  MAIN_ORG_PO,
  ENTITY_PO,
  MAIN_ENTITY_PO,
  RELSHPLEGALTRANSACTION,
  MAIN_ORG_SO,
  ENTITY_SO,
  MAIN_ENTITY_SO
FROM ESH_N_LEGAL_TRANSACTION
LEFT OUTER JOIN E_LEGALTRANSACTION AS _EXTENSTION ON ( LEGALTRANSACTIONUUID = _EXTENSTION.LEGALTRANSACTIONUUID )  -- association [0..1]
;

Learn More