I_LegalTransactionBase

DDL: I_LEGALTRANSACTIONBASE SQL: ILEGALTRBASE Type: view BASIC

Basic Data of Legal Transaction

I_LegalTransactionBase (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_LegalTransactionBase is a Basic CDS View that provides data about "Basic Data of Legal Transaction" in SAP S/4HANA. It reads from 1 data source (lcm_legaltr) and exposes 17 fields with key field LegalTransactionUUID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Data CategoryBasic
StatusReleased
Purpose
This CDS view provides the general information about the Legal Transaction. This CDS view provides the prerequisites for answering the following business questions: What is the ID of Legal Transaction? What is the Title of Legal Transaction? What is the Profile of Legal Transaction? What is the Language of Legal Transaction? What is the Governing Law of Legal Transaction? What is the Access Level of Legal Transaction? What is the Main Organization Type and value for Legal Transaction? When was Legal Transaction created or changed and by whom and when?

Prerequisites
You can create reports for Manage Legal Transaction application using this CDS view. Users who want to run these reports must have a role based on the SAP_BR_ADMINISTRATOR_LCM , SAP_BR_LEGAL_COUNSEL , and SAP_BR_EMPLOYEE_LEGAL_CONTENT business role templates. In this role, the user must have authorization to the following: Certain Profiles Access Level Organization Company Code Sales Organization Purchase Organization

Structure
Object types This view relates to the following SAP object types: Legal Transaction Measures and attributes Some important measures and attributes are: Attribute Description LegalTransaction Identifier of the Legal Transaction LegalTransactionTitle Title of the Legal Transaction LglCntntMMainOrgType Main Organization Type for Legal Transaction LglCntntMProfile Profile of the Legal Transaction LglCntntMLanguage Language of the Legal Transaction LglCntntMGovLaw Governing Law of the Legal Context LglTransAccessLv Access level for Legal Transaction

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentCM-LT
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the general information about the Legal Transaction.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the ID of Legal Transaction?</p></li> <li><p>What is the Title of Legal Transaction?</p></li> <li><p>What is the Profile of Legal Transaction?</p></li> <li><p>What is the Language of Legal Transaction?</p></li> <li><p>What is the Governing Law of Legal Transaction?</p></li> <li><p>What is the Access Level of Legal Transaction?</p></li> <li><p>What is the Main Organization Type and value for Legal Transaction?</p></li> <li><p>When was Legal Transaction created or changed and by whom and when?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
lcm_legaltr lcm_legaltr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_LegalTransaction _Extension $projection.LegalTransactionUUID = _Extension.LegalTransactionUUID

Annotations (12)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName ILEGALTRBASE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Basic Data of Legal Transaction view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionUUID legaltransactionuuid Universal Unique Identifier
LegalTransaction legaltransaction Legal Transaction ID
LegalTransactionTitle legaltransactiontitle Legal Transaction Name
LegalTransactionHealth legaltransactionhealth Legal Transaction Status
LglCntntMLanguage lglcntntmlanguage Language Key
LglCntntMCreatedByUser lglcntntmcreatedbyuser Created By
LglCntntMCreatedUTCDateTime lglcntntmcreatedutcdatetime Created On
LglCntntMChangedByUser lglcntntmchangedbyuser Changed By User
LglCntntMChangedUTCDateTime lglcntntmchangedutcdatetime Changed UTC Date Time
LglCntntMProfile lglcntntmprofile Profile
IsEndOfPurposeBlocked isendofpurposeblocked Business Purpose Completed
LglCntntMGovLaw lglcntntmgovlaw Governing Law
LglTransAccessLvl lgltransaccesslvl Access Level
LglCntntMMainOrgType lglcntntmmainorgtype Entity Technical Type
LglCntntMMainOrgCoCode lglcntntmmainorgcocode Entity ID
LglCntntMMainOrgSalesOrg lglcntntmmainorgsalesorg Entity ID
LglCntntMMainOrgPurOrg lglcntntmmainorgpurorg Entity ID

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 I_LegalTransactionBase.
-- 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: ILEGALTRBASE

CREATE VIEW I_LegalTransactionBase AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LegalTransactionHealth,
  LglCntntMLanguage,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMProfile,
  IsEndOfPurposeBlocked,
  LglCntntMGovLaw,
  LglTransAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg
FROM lcm_legaltr
LEFT OUTER JOIN E_LegalTransaction AS _Extension ON LegalTransactionUUID = _Extension.LegalTransactionUUID  -- association [1..1]
;