What is C_LegalTransactionEntityTP in SAP S/4HANA?

C_LegalTransactionEntityTP is a consumption CDS view in SAP S/4HANA. Legal Transaction Entity It contains 48 fields.

Which tables does C_LegalTransactionEntityTP read from?

C_LegalTransactionEntityTP reads data from: I_LegalTransactionEntityTP.

What VDM layer is C_LegalTransactionEntityTP?

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

C_LegalTransactionEntityTP

DDL: C_LEGALTRANSACTIONENTITYTP SQL: CLEGALTRENTITYTP Type: view CONSUMPTION Package: ODATA_LCM_LT

48 Fields 1 Data Sources 6 Associations

Legal Transaction Entity

C_LegalTransactionEntityTP is a Consumption CDS View that provides data about "Legal Transaction Entity" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionEntityTP) and exposes 48 fields with key field LegalTransactionEntityUUID. It has 6 associations to related views. Part of development package ODATA_LCM_LT.

Data Sources (1)

Source	Alias	Join Type
I_LegalTransactionEntityTP	LglTransactionEntity	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	C_LegalTransactionTP	_LegalTransactionTP	`$projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID`
[0..1]	I_LegalTrEntityAggr	_LegalTrEntityAggr	`$projection.LegalTransactionEntityUUID = _LegalTrEntityAggr.LegalTransactionEntityUUID`
[0..1]	C_LCMCompanyCodeValueHelp	_CompanyCodeValueHelp	`$projection.LglCntntMEntity = _CompanyCodeValueHelp.CompanyCode`
[0..1]	C_LCMPurchasingOrgValueHelp	_PurchasingOrgValueHelp	`$projection.LglCntntMEntity = _PurchasingOrgValueHelp.PurchasingOrganization`
[0..1]	C_LCMSalesOrganizationVH	_SalesOrganizationVH	`$projection.LglCntntMEntity = _SalesOrganizationVH.SalesOrganization`
[0..1]	C_LCMEntityTypeValueHelp	_LCMEntityTypeValueHelp	`$projection.LglCntntMEntityType = _LCMEntityTypeValueHelp.LglCntntMEntityType`

Annotations (20)

Name	Value	Level
AbapCatalog.sqlViewName	CLEGALTRENTITYTP	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Legal Transaction Entity	view
VDM.viewType	#CONSUMPTION	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.semanticKey	LegalTransactionEntityUUID	view
ObjectModel.representativeKey	LegalTransactionEntityUUID	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	EXTERNAL_CALCULATION	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
Search.searchable	true	view
UI.headerInfo.typeName	Entity	view
UI.headerInfo.typeNamePlural	Entities	view
UI.headerInfo.title.value	LglCntntMEntityName	view
UI.headerInfo.description.value	_LCMEntityTypeText.LglCntntMEntityTypeName	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	LegalTransactionEntityUUID		LegalTransactionEntityUUID	Universal Unique ID
	LegalTransactionUUID	I_LegalTransactionEntityTP	LegalTransactionUUID	Universal Unique ID
	LglCntntMRank	I_LegalTransactionEntityTP	LglCntntMRank	Rank
	LglCntntMEntityType	I_LegalTransactionEntityTP	LglCntntMEntityType	Entity Type
	LglCntntMTechEntityType		LglCntntMTechEntityType	Entity Techn. Type
	LglCntntMEntity		LglCntntMEntity	Entity
	LglCntntMEntityName	_LegalTrEntityAggr	LglCntntMEntityName
	LglCntntMEntitySupplier		LglCntntMEntity	Name
	LglCntntMEntityCustomer		LglCntntMEntity	Name
	LglCntntMEntityCoCode		LglCntntMEntity	Name
	LglCntntMEntitySlsOrg		LglCntntMEntity	Name
	LglCntntMEntityPurOrg		LglCntntMEntity	Name
	LglCntntMEntityBusinessPartner		LglCntntMEntity	Name
	LegalTransactionMandatoryFlag	I_LegalTransactionEntityTP	LegalTransactionMandatoryFlag	Mandatory
	LglCntntMIsMandatory			Required
	LglCntntMIsMainEntity		LglCntntMIsMainEntity	Main Entity
	LglCntntMIsIntegRelevant		LglCntntMIsIntegRelevant	Integrated
	LglCntntMSupplierFirstName	_LegalTrEntityAggr	LglCntntMSupplierFirstName
	LglCntntMSupplierLastName	_LegalTrEntityAggr	LglCntntMSupplierLastName
	LglCntntMSupplierOrgFirstName	_LegalTrEntityAggr	LglCntntMSupplierOrgFirstName
	LglCntntMSupplierOrgSecondName	_LegalTrEntityAggr	LglCntntMSupplierOrgSecondName
	LglCntntMSupplierGrpFirstName	_LegalTrEntityAggr	LglCntntMSupplierGrpFirstName
	LglCntntMSupplierGrpSecondName	_LegalTrEntityAggr	LglCntntMSupplierGrpSecondName
	LglCntntMCustomerFirstName	_LegalTrEntityAggr	LglCntntMCustomerFirstName
	LglCntntMCustomerSecondName	_LegalTrEntityAggr	LglCntntMCustomerSecondName
	LglCntntMCustomerOrgFirstName	_LegalTrEntityAggr	LglCntntMCustomerOrgFirstName
	LglCntntMCustomerOrgSecondName	_LegalTrEntityAggr	LglCntntMCustomerOrgSecondName
	LglCntntMCustomerGrpFirstName	_LegalTrEntityAggr	LglCntntMCustomerGrpFirstName
	LglCntntMCustomerGrpSecondName	_LegalTrEntityAggr	LglCntntMCustomerGrpSecondName
	FirstName	_LegalTrEntityAggr	FirstName	First Name
	LastName	_LegalTrEntityAggr	LastName	Last Name
	OrganizationBPName1	_LegalTrEntityAggr	OrganizationBPName1	Name 1
	OrganizationBPName2	_LegalTrEntityAggr	OrganizationBPName2	Name 2
	GroupBusinessPartnerName1	_LegalTrEntityAggr	GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2	_LegalTrEntityAggr	GroupBusinessPartnerName2	Name 2
	CompanyCodeName	_LegalTrEntityAggr	CompanyCodeName	Company Name
	SalesOrganizationName	_LegalTrEntityAggr	SalesOrganizationName	Sales Organization Description
	PurchasingOrganizationName	_LegalTrEntityAggr	PurchasingOrganizationName	Purch. Org. Name
	_LegalTransactionTP		_LegalTransactionTP
	_LegalTransaction		_LegalTransaction
	_LCMEntityTypeText		_LCMEntityTypeText
	_LCMEntityTypeValueHelp		_LCMEntityTypeValueHelp
	_CompanyCodeValueHelp		_CompanyCodeValueHelp
	_PurchasingOrgValueHelp		_PurchasingOrgValueHelp
	_SalesOrganizationVH		_SalesOrganizationVH
	_Supplier		_Supplier
	_Customer		_Customer
	_BusinessPartner		_BusinessPartner

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 C_LegalTransactionEntityTP.
-- 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: CLEGALTRENTITYTP

CREATE VIEW C_LegalTransactionEntityTP AS
SELECT
  LegalTransactionEntityUUID,
  LglTransactionEntity.LegalTransactionUUID AS LegalTransactionUUID,
  LglTransactionEntity.LglCntntMRank AS LglCntntMRank,
  LglTransactionEntity.LglCntntMEntityType AS LglCntntMEntityType,
  LglCntntMTechEntityType,
  LglCntntMEntity,
  _LegalTrEntityAggr.LglCntntMEntityName AS LglCntntMEntityName,
  LglCntntMEntity AS LglCntntMEntitySupplier,
  LglCntntMEntity AS LglCntntMEntityCustomer,
  LglCntntMEntity AS LglCntntMEntityCoCode,
  LglCntntMEntity AS LglCntntMEntitySlsOrg,
  LglCntntMEntity AS LglCntntMEntityPurOrg,
  LglCntntMEntity AS LglCntntMEntityBusinessPartner,
  LglTransactionEntity.LegalTransactionMandatoryFlag AS LegalTransactionMandatoryFlag,
  '' AS LglCntntMIsMandatory,
  LglCntntMIsMainEntity,
  LglCntntMIsIntegRelevant,
  _LegalTrEntityAggr.LglCntntMSupplierFirstName AS LglCntntMSupplierFirstName,
  _LegalTrEntityAggr.LglCntntMSupplierLastName AS LglCntntMSupplierLastName,
  _LegalTrEntityAggr.LglCntntMSupplierOrgFirstName AS LglCntntMSupplierOrgFirstName,
  _LegalTrEntityAggr.LglCntntMSupplierOrgSecondName AS LglCntntMSupplierOrgSecondName,
  _LegalTrEntityAggr.LglCntntMSupplierGrpFirstName AS LglCntntMSupplierGrpFirstName,
  _LegalTrEntityAggr.LglCntntMSupplierGrpSecondName AS LglCntntMSupplierGrpSecondName,
  _LegalTrEntityAggr.LglCntntMCustomerFirstName AS LglCntntMCustomerFirstName,
  _LegalTrEntityAggr.LglCntntMCustomerSecondName AS LglCntntMCustomerSecondName,
  _LegalTrEntityAggr.LglCntntMCustomerOrgFirstName AS LglCntntMCustomerOrgFirstName,
  _LegalTrEntityAggr.LglCntntMCustomerOrgSecondName AS LglCntntMCustomerOrgSecondName,
  _LegalTrEntityAggr.LglCntntMCustomerGrpFirstName AS LglCntntMCustomerGrpFirstName,
  _LegalTrEntityAggr.LglCntntMCustomerGrpSecondName AS LglCntntMCustomerGrpSecondName,
  _LegalTrEntityAggr.FirstName AS FirstName,
  _LegalTrEntityAggr.LastName AS LastName,
  _LegalTrEntityAggr.OrganizationBPName1 AS OrganizationBPName1,
  _LegalTrEntityAggr.OrganizationBPName2 AS OrganizationBPName2,
  _LegalTrEntityAggr.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _LegalTrEntityAggr.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _LegalTrEntityAggr.CompanyCodeName AS CompanyCodeName,
  _LegalTrEntityAggr.SalesOrganizationName AS SalesOrganizationName,
  _LegalTrEntityAggr.PurchasingOrganizationName AS PurchasingOrganizationName
FROM I_LegalTransactionEntityTP AS LglTransactionEntity
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggr ON LegalTransactionEntityUUID = _LegalTrEntityAggr.LegalTransactionEntityUUID  -- association [0..1]
LEFT OUTER JOIN C_LCMCompanyCodeValueHelp AS _CompanyCodeValueHelp ON LglCntntMEntity = _CompanyCodeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_LCMPurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON LglCntntMEntity = _PurchasingOrgValueHelp.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_LCMSalesOrganizationVH AS _SalesOrganizationVH ON LglCntntMEntity = _SalesOrganizationVH.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_LCMEntityTypeValueHelp AS _LCMEntityTypeValueHelp ON LglCntntMEntityType = _LCMEntityTypeValueHelp.LglCntntMEntityType  -- association [0..1]
;

Depth:

C_LegalTransactionEntityTP view

I_LegalTransactionEntityTP view