I_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 I_LegalTransactionTP.
-- 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: ILEGALTRTP

CREATE VIEW I_LegalTransactionTP AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LegalTransactionHealth,
  LglCntntMLanguage,
  LglCntntMContextUUID,
  LglCntntMCreatedByUser,
  LglTransWrkFlwModInstce,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMProfile,
  LegalTransactionSource,
  IsEndOfPurposeBlocked,
  LglCntntMRtntnPerdStartDate,
  _Context.LglCntntMContext AS LglCntntMContext,
  _Context.LglCntntMContextVersion AS LglCntntMContextVersion,
  _Context.LglCntntMContextTitle AS LglCntntMContextTitle,
  _LegalTransactionEntityMain.LglCntntMEntity AS LglCntntMEntity,
  _LegalTransactionEntityMain.LglCntntMEntityType AS LglCntntMEntityType,
  LglCntntMLongTextUUID,
  LglCntntMLongText,
  LglCntntMLongTextMimeType,
  LglCntntMGovLaw,
  LglTransAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMIntegrationType,
  cast( '' as boole_d ) AS LglCntntMSgntrIsDisabled,
  LglCntntMCrtedFrmLglTransUUID
FROM I_LegalTransaction
LEFT OUTER JOIN I_LegalTransactionEntityTP AS _LegalTransactionEntityTP ON LegalTransactionUUID = _LegalTransactionEntityTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionEntityMain AS _LegalTransactionEntityMain ON LegalTransactionUUID = _LegalTransactionEntityMain.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionIntContactTP AS _LegalTransactionIntContactTP ON LegalTransactionUUID = _LegalTransactionIntContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionExtContactTP AS _LegalTransactionExtContactTP ON LegalTransactionUUID = _LegalTransactionExtContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionDateTP AS _LegalTransactionDateTP ON LegalTransactionUUID = _LegalTransactionDateTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionReminderTP AS _LegalTransactionReminderTP ON LegalTransactionUUID = _LegalTransactionReminderTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTrRelationshipTP AS _LegalTrRelationshipTP ON LegalTransactionUUID = _LegalTrRelationshipTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTrLinkedObjectsTP AS _LegalTrLinkedObjectsTP ON LegalTransactionUUID = _LegalTrLinkedObjectsTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LCMContextTP AS _Context ON LglCntntMContextUUID = _Context.LglCntntMContextUUID  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDocLinkTP AS _LegalTransactionDocLinkTP ON LegalTransactionUUID = _LegalTransactionDocLinkTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTrCategoryGroupTP AS _LegalTrCategoryGroupTP ON LegalTransactionUUID = _LegalTrCategoryGroupTP.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN I_LglCntntMTaskGroupTP AS _LglCntntMTaskGroupTP ON LegalTransactionUUID = _LglCntntMTaskGroupTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransRnwlAndTermnTP AS _LegalTransRnwlAndTermnTP ON LegalTransactionUUID = _LegalTransRnwlAndTermnTP.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN E_LegalTransaction AS _Extenstion ON LegalTransactionUUID = _Extenstion.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMProfileText AS _LglCntntMProfileText ON LglCntntMProfile = _LglCntntMProfileText.LglCntntMProfile AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON LglCntntMLanguage = _LanguageText.LanguageCode AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionHealthText AS _LegalTransactionHealthText ON LegalTransactionHealth = _LegalTransactionHealthText.LegalTransactionHealth AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON LglCntntMMainOrgSalesOrg = _SalesOrganizationText.SalesOrganization AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMMainOrgTypeText AS _LglCntntMMainOrgTypeText ON LglCntntMMainOrgType = _LglCntntMMainOrgTypeText.LglCntntMMainOrgType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTrLinkedObjectTrigger AS _LglTrLinkedObjectTrigger ON LegalTransactionUUID = _LglTrLinkedObjectTrigger.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN I_LCMEntityTypeText AS _LCMEntityTypeText ON lglcntntmentitytype = _LCMEntityTypeText.LglCntntMEntityType  -- association [0..*]
;