A_LegalTransaction

DDL: A_LEGALTRANSACTION SQL: ALEGALTRANS Type: view CONSUMPTION
26 Fields 1 Data Sources 7 Associations

Legal Transactions

A_LegalTransaction is a Consumption CDS View that provides data about "Legal Transactions" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionTP) and exposes 26 fields with key field LegalTransactionUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionTP LegalTransaction from

Associations (7)

CardinalityTargetAliasCondition
[0..*] A_LglTransEntity _LegalTransactionEntityTP $projection.LegalTransactionUUID = _LegalTransactionEntityTP.LegalTransactionUUID
[0..*] A_LglTransInternalContact _LegalTransactionIntContactTP $projection.LegalTransactionUUID = _LegalTransactionIntContactTP.LegalTransactionUUID
[0..*] A_LglTransExternalContact _LegalTransactionExtContactTP $projection.LegalTransactionUUID = _LegalTransactionExtContactTP.LegalTransactionUUID
[0..*] A_LglTransDate _LegalTransactionDateTP $projection.LegalTransactionUUID = _LegalTransactionDateTP.LegalTransactionUUID
[0..*] A_LglTransRelationship _LegalTrRelationshipTP $projection.LegalTransactionUUID = _LegalTrRelationshipTP.LegalTransactionUUID
[0..*] A_LglTransLinkedObjects _LegalTrLinkedObjectsTP $projection.LegalTransactionUUID = _LegalTrLinkedObjectsTP.LegalTransactionUUID
[1..*] A_LglTransCategoryGroup _LegalTrCategoryGroupTP $projection.LegalTransactionUUID = _LegalTrCategoryGroupTP.LegalTransactionUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ALEGALTRANS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Legal Transactions view
ObjectModel.representativeKey LegalTransactionUUID view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionUUID I_LegalTransactionTP LegalTransactionUUID Universal Unique ID
LegalTransaction I_LegalTransactionTP LegalTransaction Legal Transaction ID
LegalTransactionTitle I_LegalTransactionTP LegalTransactionTitle Title
LglCntntMContext I_LegalTransactionTP LglCntntMContext Context ID
LglCntntMContextUUID I_LegalTransactionTP LglCntntMContextUUID Universal Unique ID
LglCntntMLanguage I_LegalTransactionTP LglCntntMLanguage Language
LglCntntMChangedByUser I_LegalTransactionTP LglCntntMChangedByUser Changed By
LglCntntMChangedUTCDateTime I_LegalTransactionTP LglCntntMChangedUTCDateTime Changed On
LglCntntMCreatedByUser I_LegalTransactionTP LglCntntMCreatedByUser Created By
LglCntntMCreatedUTCDateTime I_LegalTransactionTP LglCntntMCreatedUTCDateTime Created On
LegalTransactionHealth I_LegalTransactionTP LegalTransactionHealth LT Status
LglCntntMProfile I_LegalTransactionTP LglCntntMProfile Profile
LegalTransactionSource I_LegalTransactionTP LegalTransactionSource LegalTr Source
IsEndOfPurposeBlocked I_LegalTransactionTP IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
LglCntntMGovLaw LglCntntMGovLaw Governing Law
LglTransAccessLvl LglTransAccessLvl Acs. Level
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg Entity ID
_LglTransEntity _LegalTransactionEntityTP
_LglTransInternalContact _LegalTransactionIntContactTP
_LglTransExternalContact _LegalTransactionExtContactTP
_LglTransRelationship _LegalTrRelationshipTP
_LglTransLinkedObjects _LegalTrLinkedObjectsTP
_LglTransDate _LegalTransactionDateTP
_LglTransCategoryGroup _LegalTrCategoryGroupTP

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_LegalTransaction.
-- 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: ALEGALTRANS

CREATE VIEW A_LegalTransaction AS
SELECT
  LegalTransaction.LegalTransactionUUID AS LegalTransactionUUID,
  LegalTransaction.LegalTransaction AS LegalTransaction,
  LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  LegalTransaction.LglCntntMContext AS LglCntntMContext,
  LegalTransaction.LglCntntMContextUUID AS LglCntntMContextUUID,
  LegalTransaction.LglCntntMLanguage AS LglCntntMLanguage,
  LegalTransaction.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  LegalTransaction.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  LegalTransaction.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  LegalTransaction.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  LegalTransaction.LglCntntMProfile AS LglCntntMProfile,
  LegalTransaction.LegalTransactionSource AS LegalTransactionSource,
  LegalTransaction.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  LglCntntMGovLaw,
  LglTransAccessLvl,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg
FROM I_LegalTransactionTP AS LegalTransaction
LEFT OUTER JOIN A_LglTransEntity AS _LegalTransactionEntityTP ON LegalTransactionUUID = _LegalTransactionEntityTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransInternalContact AS _LegalTransactionIntContactTP ON LegalTransactionUUID = _LegalTransactionIntContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransExternalContact AS _LegalTransactionExtContactTP ON LegalTransactionUUID = _LegalTransactionExtContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransDate AS _LegalTransactionDateTP ON LegalTransactionUUID = _LegalTransactionDateTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransRelationship AS _LegalTrRelationshipTP ON LegalTransactionUUID = _LegalTrRelationshipTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransLinkedObjects AS _LegalTrLinkedObjectsTP ON LegalTransactionUUID = _LegalTrLinkedObjectsTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN A_LglTransCategoryGroup AS _LegalTrCategoryGroupTP ON LegalTransactionUUID = _LegalTrCategoryGroupTP.LegalTransactionUUID  -- association [1..*]
;

Learn More