I_LglTransParentCategoryAPI01

DDL: I_LGLTRANSPARENTCATEGORYAPI01 SQL: ILTPARCATAPI01 Type: view BASIC

Parent Categories of Legal Transaction

I_LglTransParentCategoryAPI01 (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_LglTransParentCategoryAPI01 is a Basic CDS View that provides data about "Parent Categories of Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LegalTrParentCategory) and exposes 10 fields with key field LegalTransactionParCatUUID. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Purpose
This CDS view provides details of parent categories of a legal transaction. This CDS view provides the data to answer the following business questions: What are the parent categories of a legal transaction? Is a parent category required for a legal transaction? What is the index position of the parent category in a category group?

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: LglCntntMParentCategory used to display parent category ID LglCntntMIsMandatory used to display if the parent category is required for a legal transaction. LglCntntMIndex used to display the index position of a parent category in a category group of 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
Description <p>This CDS view provides details of parent categories of a legal transaction. </p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the parent categories of a legal transaction? </p></li> <li><p>Is a parent category required for a legal transaction? </p></li> <li><p>What is the index position of the parent category in a category group?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LegalTrParentCategory I_LegalTrParentCategory from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionAPI01 _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[1..1] I_LglTransCategoryGroupAPI01 _LglTransCategoryGroup $projection.LegalTransactionCatGroupUUID = _LglTransCategoryGroup.LegalTransactionCatGroupUUID
[0..*] I_LglTransCategoryAPI01 _LglTransCategory $projection.LegalTransactionParCatUUID = _LglTransCategory.LegalTransactionParCatUUID
[1..1] I_LegalCategoryAPI01 _LegalCategory $projection.LglCntntMParentCategory = _LegalCategory.LglCntntMCategory

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ILTPARCATAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.representativeKey LegalTransactionParCatUUID 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 Parent Categories of Legal Transaction view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionParCatUUID LegalTransactionParCatUUID Universal Unique Identifier
LegalTransactionCatGroupUUID LegalTransactionCatGroupUUID Universal Unique Identifier
LegalTransactionUUID LegalTransactionUUID Universal Unique Identifier
LglCntntMParentCategory LglCntntMParentCategory Parent Category ID
LglCntntMIsMandatory LglCntntMIsMandatory Is Mandatory
LglCntntMIndex LglCntntMIndex Index
_LglTransCategoryGroup _LglTransCategoryGroup
_LglTransCategory _LglTransCategory
_LegalCategory _LegalCategory
_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_LglTransParentCategoryAPI01.
-- 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: ILTPARCATAPI01

CREATE VIEW I_LglTransParentCategoryAPI01 AS
SELECT
  LegalTransactionParCatUUID,
  LegalTransactionCatGroupUUID,
  LegalTransactionUUID,
  LglCntntMParentCategory,
  LglCntntMIsMandatory,
  LglCntntMIndex
FROM I_LegalTrParentCategory
LEFT OUTER JOIN I_LegalTransactionAPI01 AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglTransCategoryGroupAPI01 AS _LglTransCategoryGroup ON LegalTransactionCatGroupUUID = _LglTransCategoryGroup.LegalTransactionCatGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_LglTransCategoryAPI01 AS _LglTransCategory ON LegalTransactionParCatUUID = _LglTransCategory.LegalTransactionParCatUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalCategoryAPI01 AS _LegalCategory ON LglCntntMParentCategory = _LegalCategory.LglCntntMCategory  -- association [1..1]
;