I_LegalTransactionBase

DDL: I_LEGALTRANSACTIONBASE SQL: ILEGALTRBASE Type: view BASIC Package: VDM_LCM_LT
17 Fields 1 Data Sources 1 Associations

Basic Data of Legal Transaction

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. Part of development package VDM_LCM_LT.

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 These restriction types are edited in the Maintain Business Roles app.

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 →

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 ID
LegalTransaction legaltransaction Legal Transaction ID
LegalTransactionTitle legaltransactiontitle Title
LegalTransactionHealth legaltransactionhealth LT Status
LglCntntMLanguage lglcntntmlanguage Language
LglCntntMCreatedByUser lglcntntmcreatedbyuser Created By
LglCntntMCreatedUTCDateTime lglcntntmcreatedutcdatetime Created On
LglCntntMChangedByUser lglcntntmchangedbyuser Changed By
LglCntntMChangedUTCDateTime lglcntntmchangedutcdatetime Changed On
LglCntntMProfile lglcntntmprofile Profile
IsEndOfPurposeBlocked isendofpurposeblocked Busin. Purp. Cmpltd.
LglCntntMGovLaw lglcntntmgovlaw Governing Law
LglTransAccessLvl lgltransaccesslvl Acs. Level
LglCntntMMainOrgType lglcntntmmainorgtype Main Organisation Ty
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]
;

Learn More