A_LglCntntMDocCategory

DDL: A_LGLCNTNTMDOCCATEGORY SQL: ALGLDOCCAT Type: view CONSUMPTION

Legal Document Category

A_LglCntntMDocCategory is a Consumption CDS View that provides data about "Legal Document Category" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMDocCategoryTP) and exposes 6 fields with key field LglCntntMDocCategoryUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMDocCategoryTP LglDocCategory from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_LegalDocument _DocumentTP $projection.LglCntntMDocumentUUID = _DocumentTP.LglCntntMDocumentUUID
[1..1] A_LglCntntMDocParCategory _LglCntntMDocParCategoryTP $projection.LglCntntMDocParCatUUID = _LglCntntMDocParCategoryTP.LglCntntMDocParCatUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ALGLDOCCAT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Legal Document Category view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey LglCntntMDocCategoryUUID view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.delegatedAction false view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocCategoryUUID LglCntntMDocCategoryUUID Universal Unique ID
LglCntntMDocParCatUUID LglCntntMDocParCatUUID Universal Unique ID
LglCntntMDocumentUUID LglCntntMDocumentUUID Universal Unique ID
LglCntntMCategory LglCntntMCategory Category ID
_LglCntntMDocParCategory _LglCntntMDocParCategoryTP
_LegalDocument _DocumentTP

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 A_LglCntntMDocCategory.
-- 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: ALGLDOCCAT

CREATE VIEW A_LglCntntMDocCategory AS
SELECT
  LglCntntMDocCategoryUUID,
  LglCntntMDocParCatUUID,
  LglCntntMDocumentUUID,
  LglCntntMCategory
FROM I_LglCntntMDocCategoryTP AS LglDocCategory
LEFT OUTER JOIN A_LegalDocument AS _DocumentTP ON LglCntntMDocumentUUID = _DocumentTP.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN A_LglCntntMDocParCategory AS _LglCntntMDocParCategoryTP ON LglCntntMDocParCatUUID = _LglCntntMDocParCategoryTP.LglCntntMDocParCatUUID  -- association [1..1]
;