What is A_LglTransCategory in SAP S/4HANA?

A_LglTransCategory is a consumption CDS view in SAP S/4HANA. Categories It contains 7 fields.

Which tables does A_LglTransCategory read from?

A_LglTransCategory reads data from: I_LegalTransactionCategoryTP.

What VDM layer is A_LglTransCategory?

A_LglTransCategory is classified as a Consumption view optimized for specific business scenarios and reporting.

A_LglTransCategory

DDL: A_LGLTRANSCATEGORY SQL: ALGLTRANSCATEG Type: view CONSUMPTION

7 Fields 1 Data Sources 2 Associations

Data Sources (1)

Source	Alias	Join Type
I_LegalTransactionCategoryTP	LglTransCategory	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_LegalTransaction	_LegalTransactionTP	`$projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID`
[1..1]	A_LglTransParentCategory	_LegalTrParentCategoryTP	`$projection.LegalTransactionParCatUUID = _LegalTrParentCategoryTP.LegalTransactionParCatUUID`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ALGLTRANSCATEG	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Categories	view
ObjectModel.representativeKey	LegalTransactionCategoryUUID	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (7)

Key	Field	Source Table	Source Field	Description
KEY	LegalTransactionCategoryUUID	I_LegalTransactionCategoryTP	LegalTransactionCategoryUUID	Universal Unique ID
	LegalTransactionParCatUUID	I_LegalTransactionCategoryTP	LegalTransactionParCatUUID	Universal Unique ID
	LegalTransactionUUID	I_LegalTransactionCategoryTP	LegalTransactionUUID	Universal Unique ID
	LglCntntMCategory	I_LegalTransactionCategoryTP	LglCntntMCategory	Category ID
	LglCntntMIsMandatory		LglCntntMIsMandatory	Is Mandatory
	_LglTransParentCategory		_LegalTrParentCategoryTP
	_LegalTransaction		_LegalTransactionTP

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_LglTransCategory.
-- 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: ALGLTRANSCATEG

CREATE VIEW A_LglTransCategory AS
SELECT
  LglTransCategory.LegalTransactionCategoryUUID AS LegalTransactionCategoryUUID,
  LglTransCategory.LegalTransactionParCatUUID AS LegalTransactionParCatUUID,
  LglTransCategory.LegalTransactionUUID AS LegalTransactionUUID,
  LglTransCategory.LglCntntMCategory AS LglCntntMCategory,
  LglCntntMIsMandatory
FROM I_LegalTransactionCategoryTP AS LglTransCategory
LEFT OUTER JOIN A_LegalTransaction AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN A_LglTransParentCategory AS _LegalTrParentCategoryTP ON LegalTransactionParCatUUID = _LegalTrParentCategoryTP.LegalTransactionParCatUUID  -- association [1..1]
;

Depth:

A_LglTransCategory view

I_LegalTransactionCategoryTP view