I_LegalCategoryAPI01

DDL: I_LEGALCATEGORYAPI01 SQL: ILCMCATAPI01 Type: view BASIC
21 Fields 1 Data Sources

Legal Category

I_LegalCategoryAPI01 (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_LegalCategoryAPI01 is a Basic CDS View that provides data about "Legal Category" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCategory) and exposes 21 fields with key field LglCntntMCategory.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Data CategoryBasic
StatusReleased
Purpose
The CDS view provides the general information about the Categories. This CDS view provides the prerequisites for answering the following business questions: What is the type of the Category? What is the Category level? What is the Parent Category? What is the root Category? Does the Category have multiple selection When was the Category created or changed and by whom and when?

Structure
Object types This view relates to the following SAP object types: Categories Measures and attributes Some important measures and attributes are: Attribute Description LglCntntMCategory Identifier of the Category LglCntntMCategoryName Name of the Category LglCntntMCatLevel Category Level LglCntntMCatType Category Type LglCntntMCatIsMultiSelection Category is Multi-Selectable LglCntntMParentCategory Parent Category LglCntntMRootCategory Root Category

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentCM-CAT
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>The CDS view provides the general information about the Categories.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the type of the Category?</p></li> <li><p>What is the Category level?</p></li> <li><p>What is the Parent Category?</p></li> <li><p>What is the root Category?</p></li> <li><p>Does the Category have multiple selection</p></li> <li><p>When was the Category created or changed and by whom and when?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCategory I_LglCntntMCategory from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ILCMCATAPI01 view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.semanticKey LglCntntMCategory view
ObjectModel.representativeKey LglCntntMCategory view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Legal Category view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCategory LglCntntMCategory Category ID
LglCntntMCatLevel LglCntntMCatLevel Category Level
LglCntntMCatType LglCntntMCatType Category Type
LglCntntMCatIsSelect LglCntntMCatIsSelect Category Is Selectable
LglCntntMCatIsMultiSelection LglCntntMCatIsMultiSelection Multiple Selection of Categories
LglCntntMCatIsObsolete LglCntntMCatIsObsolete Category Is Obsolete
LglCntntMCatModel LglCntntMCatModel Model for Dynamic Categories
LglCntntMCategoryValue LglCntntMCategoryValue Category Value
LglCntntMCatIsUpdateFromTable LglCntntMCatIsUpdateFromTable Is Update From Table
LglCntntMCreatedByUser LglCntntMCreatedByUser Created By
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Created On
LglCntntMChangedByUser LglCntntMChangedByUser Changed By User
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed UTC Date Time
LglCntntMParentCategory LglCntntMParentCategory Parent Category ID
LglCntntMRootCategory LglCntntMRootCategory Root Category ID
LglCntntMCatPurpose LglCntntMCatPurpose Category Purpose
LglCntntMCatIsSystGenerated LglCntntMCatIsSystGenerated System generated category
LglCntntMCatConstant LglCntntMCatConstant Category Qualifier
LglCntntMCategoryName LglCntntMCategoryName Category Name
LglCntntMCategoryNameSyst LglCntntMCategoryNameSyst Category Name
LglCntntMCategoryNameInEnglish LglCntntMCategoryNameInEnglish Category Name

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_LegalCategoryAPI01.
-- 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: ILCMCATAPI01

CREATE VIEW I_LegalCategoryAPI01 AS
SELECT
  LglCntntMCategory,
  LglCntntMCatLevel,
  LglCntntMCatType,
  LglCntntMCatIsSelect,
  LglCntntMCatIsMultiSelection,
  LglCntntMCatIsObsolete,
  LglCntntMCatModel,
  LglCntntMCategoryValue,
  LglCntntMCatIsUpdateFromTable,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMParentCategory,
  LglCntntMRootCategory,
  LglCntntMCatPurpose,
  LglCntntMCatIsSystGenerated,
  LglCntntMCatConstant,
  LglCntntMCategoryName,
  LglCntntMCategoryNameSyst,
  LglCntntMCategoryNameInEnglish
FROM I_LglCntntMCategory
;

Learn More