I_LglTransCategoryGroupAPI01

DDL: I_LGLTRANSCATEGORYGROUPAPI01 SQL: ILTCATGRPAPI01 Type: view BASIC

Category Groups of Legal Transaction

I_LglTransCategoryGroupAPI01 (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_LglTransCategoryGroupAPI01 is a Basic CDS View that provides data about "Category Groups of Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LegalTrCategoryGroup) and exposes 6 fields with key field LegalTransactionCatGroupUUID. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Purpose
This CDS view provides details of categories of a legal transaction. This CDS view provides the data to answer the following business questions: What are the Categories maintained for a Legal Transaction? Is Category ID required for a Legal Transaction? 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 These restriction types are edited in the Maintain Business Roles app.

Structure
Fields Important fields in this view include the following: LglCntntMCategory used to display the Category ID of legal transaction LglCntntMIsMandatory used to display whether the Category ID is mandatory for a legal transaction

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

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LegalTrCategoryGroup I_LegalTrCategoryGroup from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionAPI01 _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[1..*] I_LglTransParentCategoryAPI01 _LglTransParentCategory $projection.LegalTransactionCatGroupUUID = _LglTransParentCategory.LegalTransactionCatGroupUUID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ILTCATGRPAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.representativeKey LegalTransactionCatGroupUUID 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 Category Groups of Legal Transaction view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionCatGroupUUID LegalTransactionCatGroupUUID Universal Unique Identifier
LegalTransactionUUID LegalTransactionUUID Universal Unique Identifier
LglCntntMCatGroupTitle LglCntntMCatGroupTitle Legal Transaction Name
LglCntntMIndex LglCntntMIndex Index
_LglTransParentCategory _LglTransParentCategory
_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_LglTransCategoryGroupAPI01.
-- 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: ILTCATGRPAPI01

CREATE VIEW I_LglTransCategoryGroupAPI01 AS
SELECT
  LegalTransactionCatGroupUUID,
  LegalTransactionUUID,
  LglCntntMCatGroupTitle,
  LglCntntMIndex
FROM I_LegalTrCategoryGroup
LEFT OUTER JOIN I_LegalTransactionAPI01 AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglTransParentCategoryAPI01 AS _LglTransParentCategory ON LegalTransactionCatGroupUUID = _LglTransParentCategory.LegalTransactionCatGroupUUID  -- association [1..*]
;