R_LegalCategoryItemTP

DDL: R_LEGALCATEGORYITEMTP Type: view_entity TRANSACTIONAL
24 Fields 1 Data Sources 2 Associations

Legal Category Item

R_LegalCategoryItemTP is a Transactional CDS View that provides data about "Legal Category Item" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCategory) and exposes 24 fields with key field LglCntntMCategory. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCategory I_LglCntntMCategory from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_LglCntntMCatModelText _LglCntntMCatModelText $projection.LglCntntMCatModel = _LglCntntMCatModelText.LglCntntMCatModel
[0..1] I_LglCntntMCategoryTypeText _LglCntntMCategoryTypeText $projection.LglCntntMCatType = _LglCntntMCategoryTypeText.LglCntntMCatType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey LglCntntMCategory view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Legal Category Item view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCategory LglCntntMCategory Category ID
LglCntntMCategoryName LglCntntMCategoryName Category Name
LglCntntMCatType LglCntntMCatType Category Type
LglCntntMCatIsMultiSelection LglCntntMCatIsMultiSelection Multiple Selection
LglCntntMCatIsSelect LglCntntMCatIsSelect Is Selectable
LglCntntMCatLevel LglCntntMCatLevel Category Level
LglCntntMCatIsObsolete LglCntntMCatIsObsolete Obsolete
LglCntntMChangedByUser LglCntntMChangedByUser Changed By
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed On
LglCntntMCreatedByUser LglCntntMCreatedByUser Created By
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Created On
LglCntntMParentCategory LglCntntMParentCategory Parent Category ID
LglCntntMRootCategory LglCntntMRootCategory Root Category ID
LglCntntMCatModel LglCntntMCatModel Model for Dnmc. Ctg.
LglCntntMCatIsUpdateFromTable LglCntntMCatIsUpdateFromTable Is Update From Table
LglCntntMCategoryValue LglCntntMCategoryValue Category Value
LglCntntMCatPurpose LglCntntMCatPurpose Category Purpose
LglCntntMCatIsSystGenerated LglCntntMCatIsSystGenerated System gen. category
LglCntntMCatConstant LglCntntMCatConstant Category Qualifier
LglCntntMLongTextUUID LglCntntMLongTextUUID Description UUID
_LegalCategoryTP _LegalCategoryTP
_LglCntntMParentCategoriesText _LglCntntMParentCategoriesText
_LglCntntMCatModelText _LglCntntMCatModelText
_LglCntntMCategoryTypeText _LglCntntMCategoryTypeText

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 R_LegalCategoryItemTP.
-- 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.

CREATE VIEW R_LegalCategoryItemTP AS
SELECT
  LglCntntMCategory,
  LglCntntMCategoryName,
  LglCntntMCatType,
  LglCntntMCatIsMultiSelection,
  LglCntntMCatIsSelect,
  LglCntntMCatLevel,
  LglCntntMCatIsObsolete,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  LglCntntMParentCategory,
  LglCntntMRootCategory,
  LglCntntMCatModel,
  LglCntntMCatIsUpdateFromTable,
  LglCntntMCategoryValue,
  LglCntntMCatPurpose,
  LglCntntMCatIsSystGenerated,
  LglCntntMCatConstant,
  LglCntntMLongTextUUID
FROM I_LglCntntMCategory
LEFT OUTER JOIN I_LglCntntMCatModelText AS _LglCntntMCatModelText ON LglCntntMCatModel = _LglCntntMCatModelText.LglCntntMCatModel  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMCategoryTypeText AS _LglCntntMCategoryTypeText ON LglCntntMCatType = _LglCntntMCategoryTypeText.LglCntntMCatType  -- association [0..1]
;

Learn More