I_LglTransRnwlTermnAPI01

DDL: I_LGLTRANSRNWLTERMNAPI01 SQL: ILTRNWAPI01 Type: view BASIC
14 Fields 1 Data Sources 1 Associations

Lifecycle of Legal Transaction

I_LglTransRnwlTermnAPI01 (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_LglTransRnwlTermnAPI01 is a Basic CDS View that provides data about "Lifecycle of Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionRnwlAndTermn) and exposes 14 fields with key field LglCntntMRnwlAndTermnUUID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Purpose
This CDS view provides details of renewals and terminations of a legal transaction. This CDS view provides the data to answer the following business questions: What are the Renewal Types maintained for a Legal Transaction? What is the Renewal duration? What is the unit of measurement maintained for Renewal Period? What is the Renewal Clause maintained? What is the Terminal Clause maintained? What is the Next Termination Clause? What is the Number of Auto Renewals? What is the user id maintained for Reminder Recipient? What is the user id maintained for Termination Reminder? What is the number of days for Renewal Reminder? What is the number of days for Termination Reminder? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

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 Organisation Company code Sales Organisation Purchase Organisation

Structure
Fields Important fields in this view include the following: LglCntntMRnwlType is used to display the renewal type. LglCntntMRnwlPeriod is used to display the duration of renewal. LglCntntMRnwlPeriodUnit is used to display unit of measurement for renewal period. LglCntntMRenewalClause is used to display the renewal clause. LglCntntMTerminationClause is used to display the termination clause. LglCntntMNextTermnClause is used to display the next termination clause. LglCntntMNmbrOfRenewals is used to display the number of auto renewals. LglCntntMRnwlReminderUser is used to display the reminder recipient user. LglCntntMTermnReminderUser is used to display the termination recipient user. LglCntntMRnwlReminderDays is used to display the renewal reminder days in advance. LglCntntMTermnReminderDays is used to display the termination reminder days in advance.

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 details of renewals and terminations of a legal transaction. </p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the Renewal Types maintained for a Legal Transaction? </p></li> <li><p>What is the Renewal duration? </p></li> <li><p>What is the unit of measurement maintained for Renewal Period? </p></li> <li><p>What is the Renewal Clause maintained? </p></li> <li><p>What is the Terminal Clause maintained? </p></li> <li><p>What is the Next Termination Clause? </p></li> <li><p>What is the Number of Auto Renewals? </p></li> <li><p>What is the user id maintained for Reminder Recipient? </p></li> <li><p>What is the user id maintained for Termination Reminder? </p></li> <li><p>What is the number of days for Renewal Reminder? </p></li> <li><p>What is the number of days for Termination Reminder?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionRnwlAndTermn I_LegalTransactionRnwlAndTermn from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionAPI01 _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ILTRNWAPI01 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.representativeKey LglCntntMRnwlAndTermnUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Lifecycle of Legal Transaction view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMRnwlAndTermnUUID LglCntntMRnwlAndTermnUUID Universal Unique Identifier
LegalTransactionUUID LegalTransactionUUID Universal Unique Identifier
LglCntntMRnwlType LglCntntMRnwlType Renewal Type
LglCntntMRnwlPeriod LglCntntMRnwlPeriod Duration of Renewal
LglCntntMRnwlPeriodUnit LglCntntMRnwlPeriodUnit Unit of Measurement from Renewal Period
LglCntntMRenewalClause LglCntntMRenewalClause Renewal Clause
LglCntntMTerminationClause LglCntntMTerminationClause Termination Clause
LglCntntMNextTermnClause LglCntntMNextTermnClause Next Termination Clause
LglCntntMNmbrOfRenewals LglCntntMNmbrOfRenewals Number of Auto Renewals
LglCntntMRnwlReminderUser LglCntntMRnwlReminderUser Renewal Recipient User
LglCntntMTermnReminderUser LglCntntMTermnReminderUser Termination Recipient User
LglCntntMRnwlReminderDays LglCntntMRnwlReminderDays Renewal Reminder Days in advance
LglCntntMTermnReminderDays LglCntntMTermnReminderDays Termination Reminder Days in advance
_LegalTransaction _LegalTransaction

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_LglTransRnwlTermnAPI01.
-- 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: ILTRNWAPI01

CREATE VIEW I_LglTransRnwlTermnAPI01 AS
SELECT
  LglCntntMRnwlAndTermnUUID,
  LegalTransactionUUID,
  LglCntntMRnwlType,
  LglCntntMRnwlPeriod,
  LglCntntMRnwlPeriodUnit,
  LglCntntMRenewalClause,
  LglCntntMTerminationClause,
  LglCntntMNextTermnClause,
  LglCntntMNmbrOfRenewals,
  LglCntntMRnwlReminderUser,
  LglCntntMTermnReminderUser,
  LglCntntMRnwlReminderDays,
  LglCntntMTermnReminderDays
FROM I_LegalTransactionRnwlAndTermn
LEFT OUTER JOIN I_LegalTransactionAPI01 AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
;

Learn More