ESH_N_LEGAL_TRANSACTION

DDL: ESH_N_LEGAL_TRANSACTION SQL: ESH_L_LEGALTR Type: view
64 Fields 1 Data Sources

ESH_N_LEGAL_TRANSACTION is a CDS View in SAP S/4HANA. It reads from 1 data source (I_LEGALTRANSACTION) and exposes 64 fields with key field LEGALTRANSACTIONUUID.

Data Sources (1)

SourceAliasJoin Type
I_LEGALTRANSACTION I_LEGALTRANSACTION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

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

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY LEGALTRANSACTIONUUID LEGALTRANSACTIONUUID Universal Unique ID
MAIN_ENTITY_CC
ENTITY_CC
MAIN_ORG_CC _COMPANYCODE COMPANYCODENAME Company Name
MAIN_ENTITY_BP_FN
MAIN_ENTITY_CUS_FN
MAIN_ENTITY_SUP_FN
CHANGED_BY_NAME _CHANGEDBY FULLNAME Name
INT_CNT_NAME
CREATED_BY_NAME _CREATEDBY FULLNAME 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 ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
LANGUAGENAME
MAIN_ENTITY_BP_LN
MAIN_ENTITY_CUS_LN
MAIN_ENTITY_SUP_LN
LEGALTRANSACTION LEGALTRANSACTION Legal Transaction ID
LEGALTRANSACTIONHEALTHNAME
LEGALTRANSACTIONTITLE LEGALTRANSACTIONTITLE Title
LGLCNTNTMACCESSLVLNAME
PARENT_CATEGORY_NAME
LGLCNTNTMCATEGORYNAME
LGLCNTNTMCHANGEDUTCDATETIME LGLCNTNTMCHANGEDUTCDATETIME Changed On
LGLCNTNTMCONTEXT _CONTEXT LGLCNTNTMCONTEXT Context ID
LGLCNTNTMCONTEXTTITLE _CONTEXT LGLCNTNTMCONTEXTTITLE Title
LGLCNTNTMCREATEDUTCDATETIME LGLCNTNTMCREATEDUTCDATETIME Created On
MAIN_ENTITY_TYPE
ENTITY_TYPE
LGLCNTNTMGOVLAWTEXT
LGLCNTNTMINTCNTCTUSER _LEGALTRANSACTIONINTCONTACT LGLCNTNTMINTCNTCTUSER User Name
LGLCNTNTMLINKDOBJ _LEGALTRLINKEDOBJECTS LGLCNTNTMLINKDOBJ Unique ID
LGLCNTNTMLINKDOBJTYPENAME
LGLCNTNTMMAINORGCOCODE LGLCNTNTMMAINORGCOCODE Entity ID
LGLCNTNTMMAINORGPURORG LGLCNTNTMMAINORGPURORG Entity ID
LGLCNTNTMMAINORGSALESORG LGLCNTNTMMAINORGSALESORG Entity ID
LGLCNTNTMMAINORGTYPENAME
LGLCNTNTMPROFILE LGLCNTNTMPROFILE Profile
LGLTRANSACCESSLVL LGLTRANSACCESSLVL Acs. Level
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 _PURCHASINGORGANIZATION PURCHASINGORGANIZATIONNAME Purch. Org. Name
ENTITY_PO
MAIN_ENTITY_PO
RELSHPLEGALTRANSACTION _LEGALTRRELATIONSHIP RELSHPLEGALTRANSACTION Legal Transaction ID
MAIN_ORG_SO
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_N_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_L_LEGALTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_LEGAL_TRANSACTION AS
SELECT
  LEGALTRANSACTIONUUID,
  _MAINLEGALTRANSACTIONENTITY._COMPANYCODE.COMPANYCODENAME AS MAIN_ENTITY_CC,
  _LEGALTRANSACTIONENTITY._COMPANYCODE.COMPANYCODENAME AS ENTITY_CC,
  _COMPANYCODE.COMPANYCODENAME AS MAIN_ORG_CC,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.FIRSTNAME AS MAIN_ENTITY_BP_FN,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.FIRSTNAME AS MAIN_ENTITY_CUS_FN,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.FIRSTNAME AS MAIN_ENTITY_SUP_FN,
  _CHANGEDBY.FULLNAME AS CHANGED_BY_NAME,
  _LEGALTRANSACTIONINTCONTACT._INTERNALCONTACT.FULLNAME AS INT_CNT_NAME,
  _CREATEDBY.FULLNAME AS CREATED_BY_NAME,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME1 AS MAIN_ENTITY_BP_GPN1,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME1 AS MAIN_ENTITY_CUS_GPN1,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME1 AS MAIN_ENTITY_SUP_GPN1,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME2 AS MAIN_ENTITY_BP_GPN2,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME2 AS MAIN_ENTITY_CUS_GPN2,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME2 AS MAIN_ENTITY_SUP_GPN2,
  ISENDOFPURPOSEBLOCKED,
  _LANGUAGETEXT[1: LANGUAGE = $parameters. P_Language].LANGUAGENAME AS LANGUAGENAME,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.LASTNAME AS MAIN_ENTITY_BP_LN,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.LASTNAME AS MAIN_ENTITY_CUS_LN,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.LASTNAME AS MAIN_ENTITY_SUP_LN,
  LEGALTRANSACTION,
  _LEGALTRANSACTIONHEALTHTEXT[1: LANGUAGE = $parameters. P_Language].LEGALTRANSACTIONHEALTHNAME AS LEGALTRANSACTIONHEALTHNAME,
  LEGALTRANSACTIONTITLE,
  _LGLCNTNTMACCESSLVLTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMACCESSLVLNAME AS LGLCNTNTMACCESSLVLNAME,
  _LEGALTRPARENTCATEGORY._LGLCNTNTMCATEGORYTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMCATEGORYNAME AS PARENT_CATEGORY_NAME,
  _LEGALTRANSACTIONCATEGORY._LGLCNTNTMCATEGORYTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMCATEGORYNAME AS LGLCNTNTMCATEGORYNAME,
  LGLCNTNTMCHANGEDUTCDATETIME,
  _CONTEXT.LGLCNTNTMCONTEXT AS LGLCNTNTMCONTEXT,
  _CONTEXT.LGLCNTNTMCONTEXTTITLE AS LGLCNTNTMCONTEXTTITLE,
  LGLCNTNTMCREATEDUTCDATETIME,
  _MAINLEGALTRANSACTIONENTITY._ENTITYTYPETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMENTITYTYPENAME AS MAIN_ENTITY_TYPE,
  _LEGALTRANSACTIONENTITY._ENTITYTYPETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMENTITYTYPENAME AS ENTITY_TYPE,
  _LGLCNTNTMGOVLAWTEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMGOVLAWTEXT AS LGLCNTNTMGOVLAWTEXT,
  _LEGALTRANSACTIONINTCONTACT.LGLCNTNTMINTCNTCTUSER AS LGLCNTNTMINTCNTCTUSER,
  _LEGALTRLINKEDOBJECTS.LGLCNTNTMLINKDOBJ AS LGLCNTNTMLINKDOBJ,
  _LEGALTRLINKEDOBJECTS._LINKEDOBJECTTYPETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMLINKDOBJTYPENAME AS LGLCNTNTMLINKDOBJTYPENAME,
  LGLCNTNTMMAINORGCOCODE,
  LGLCNTNTMMAINORGPURORG,
  LGLCNTNTMMAINORGSALESORG,
  _LGLCNTNTMMAINORGTYPETEXT[1: LANGUAGE = $parameters. P_Language].LGLCNTNTMMAINORGTYPENAME AS LGLCNTNTMMAINORGTYPENAME,
  LGLCNTNTMPROFILE,
  LGLTRANSACCESSLVL,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.ORGANIZATIONBPNAME1 AS MAIN_ENTITY_BP1,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER.ORGANIZATIONBPNAME1 AS MAIN_ENTITY_SUP1,
  _LEGALTRANSACTIONENTITY._CUSTOMER.ORGANIZATIONBPNAME1 AS ENTITY_CUS1,
  _LEGALTRANSACTIONENTITY._SUPPLIER.ORGANIZATIONBPNAME1 AS ENTITY_SUP1,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER.ORGANIZATIONBPNAME1 AS MAIN_ENTITY_CUS1,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.ORGANIZATIONBPNAME1 AS MAIN_ENTITY_CUSORG_FN,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.ORGANIZATIONBPNAME1 AS MAIN_ENTITY_SUPORG_FN,
  _MAINLEGALTRANSACTIONENTITY._BUSINESSPARTNER.ORGANIZATIONBPNAME2 AS MAIN_ENTITY_BP2,
  _LEGALTRANSACTIONENTITY._SUPPLIER.ORGANIZATIONBPNAME2 AS ENTITY_SUP2,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER.ORGANIZATIONBPNAME2 AS MAIN_ENTITY_SUP2,
  _LEGALTRANSACTIONENTITY._CUSTOMER.ORGANIZATIONBPNAME2 AS ENTITY_CUS2,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER.ORGANIZATIONBPNAME2 AS MAIN_ENTITY_CUS2,
  _MAINLEGALTRANSACTIONENTITY._CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.ORGANIZATIONBPNAME2 AS MAIN_ENTITY_CUSORG_LN,
  _MAINLEGALTRANSACTIONENTITY._SUPPLIER._SUPPLIERTOBUSINESSPARTNER._BUSINESSPARTNER.ORGANIZATIONBPNAME2 AS MAIN_ENTITY_SUPORG_LN,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS MAIN_ORG_PO,
  _LEGALTRANSACTIONENTITY._PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS ENTITY_PO,
  _MAINLEGALTRANSACTIONENTITY._PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS MAIN_ENTITY_PO,
  _LEGALTRRELATIONSHIP.RELSHPLEGALTRANSACTION AS RELSHPLEGALTRANSACTION,
  _SALESORGANIZATIONTEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS MAIN_ORG_SO,
  _LEGALTRANSACTIONENTITY._SALESORGANIZATIONTEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS ENTITY_SO,
  _MAINLEGALTRANSACTIONENTITY._SALESORGANIZATIONTEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS MAIN_ENTITY_SO
FROM I_LEGALTRANSACTION
;

Learn More