I_LegalTrCategoryGroupTP

DDL: I_LEGALTRCATEGORYGROUPTP SQL: ILEGALTRCATGRPTP Type: view TRANSACTIONAL

TP view for LegalTr Categories Group

I_LegalTrCategoryGroupTP is a Transactional CDS View that provides data about "TP view for LegalTr Categories Group" in SAP S/4HANA. It reads from 1 data source (I_LegalTrCategoryGroup) and exposes 7 fields with key field LegalTransactionCatGroupUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTrCategoryGroup I_LegalTrCategoryGroup from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionTP _LegalTransactionTP $projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID
[1..*] I_LegalTrParentCategoryTP _LegalTrParentCategoryTP $projection.LegalTransactionCatGroupUUID = _LegalTrParentCategoryTP.LegalTransactionCatGroupUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ILEGALTRCATGRPTP view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.semanticKey LegalTransactionCatGroupUUID view
ObjectModel.representativeKey LegalTransactionCatGroupUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence LCM_LT_CAT_GR view
ObjectModel.writeDraftPersistence LCM_LT_CAT_GR_D view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label TP view for LegalTr Categories Group view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionCatGroupUUID LegalTransactionCatGroupUUID Universal Unique ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMCatGroupTitle LglCntntMCatGroupTitle Title
LglCntntMIndex LglCntntMIndex Index
_LegalTransaction _LegalTransaction
_LegalTransactionTP _LegalTransactionTP
_LegalTrParentCategoryTP _LegalTrParentCategoryTP

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_LegalTrCategoryGroupTP.
-- 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: ILEGALTRCATGRPTP

CREATE VIEW I_LegalTrCategoryGroupTP AS
SELECT
  LegalTransactionCatGroupUUID,
  LegalTransactionUUID,
  LglCntntMCatGroupTitle,
  LglCntntMIndex
FROM I_LegalTrCategoryGroup
LEFT OUTER JOIN I_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LegalTrParentCategoryTP AS _LegalTrParentCategoryTP ON LegalTransactionCatGroupUUID = _LegalTrParentCategoryTP.LegalTransactionCatGroupUUID  -- association [1..*]
;