C_LegalTransactionHealthByQtr

DDL: C_LEGALTRANSACTIONHEALTHBYQTR SQL: CLCMLTHEALTHQTR Type: view CONSUMPTION
16 Fields 1 Data Sources

Legal Transaction Status

C_LegalTransactionHealthByQtr is a Consumption CDS View that provides data about "Legal Transaction Status" in SAP S/4HANA. It reads from 1 data source (C_LegalTransactionHealth) and exposes 16 fields with key field LegalTransactionUUID.

Data Sources (1)

SourceAliasJoin Type
C_LegalTransactionHealth C_LegalTransactionHealth from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CLCMLTHEALTHQTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeNamePlural Total Legal Transactions Status view
UI.headerInfo.typeName Total Legal Transactions Status view
UI.headerInfo.title.label Total Legal Transactions Status view
UI.presentationVariant.qualifier SegmentAmount view
UI.presentationVariant.maxItems 3 view
UI.presentationVariant.sortOrder.by LglCntntMNumerator view
UI.presentationVariant.sortOrder.direction #DESC view
Consumption.semanticObject LegalTransaction view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Legal Transaction Status view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LegalTransaction LegalTransaction Legal Transaction ID
LegalTransactionHealth LegalTransactionHealth LT Status
LegalTransactionHealthName LegalTransactionHealthName Long Text
LglCntntMNumerator Amount
LegalContext LglCntntMContext Context ID
LglCntntMContextVersion LglCntntMContextVersion Context Version
LglCntntMEntity LglCntntMEntity Entity ID
LglCntntMEntityType LglCntntMEntityType Entity Type
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Created On
LglCntntMProfile LglCntntMProfile Profile
LglTransAccessLvl LglTransAccessLvl Acs. Level
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg Entity ID
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_LegalTransactionHealthByQtr.
-- 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: CLCMLTHEALTHQTR

CREATE VIEW C_LegalTransactionHealthByQtr AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionHealth,
  LegalTransactionHealthName,
  cast( 1 as abap.int8 ) AS LglCntntMNumerator,
  LglCntntMContext AS LegalContext,
  LglCntntMContextVersion,
  LglCntntMEntity,
  LglCntntMEntityType,
  LglCntntMCreatedUTCDateTime,
  LglCntntMProfile,
  LglTransAccessLvl,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  IsEndOfPurposeBlocked
FROM C_LegalTransactionHealth
;

Learn More