I_LegalTransaction

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_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: ILEGALTR

CREATE VIEW I_LegalTransaction AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LegalTransactionHealth,
  LglCntntMLanguage,
  LglCntntMCreatedByUser,
  LglCntntMContextUUID,
  LglTransWrkFlwModInstce,
  LglCntntMCreatedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMProfile,
  LegalTransactionSource,
  IsEndOfPurposeBlocked,
  LglCntntMRtntnPerdStartDate,
  LglCntntMGovLaw,
  LglTransAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMLongTextUUID,
  LglCntntMIntegrationType,
  LglCntntMCrtedFrmLglTransUUID,
  _Note.content AS LglCntntMLongText,
  _Note.mimetype AS LglCntntMLongTextMimeType
FROM lcm_legaltr
LEFT OUTER JOIN Sgbt_Nte_Cds_Cont AS _Note ON _Note.noteid = LglCntntMLongTextUUID AND _Note.objectnodetype = 'LegalTransaction' AND _Note.notetype = 'LCM_LONGTEXT'  -- association [0..1]
LEFT OUTER JOIN E_LegalTransaction AS _Extenstion ON LegalTransactionUUID = _Extenstion.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMContextBasic AS _Context ON LglCntntMContextUUID = _Context.LglCntntMContextUUID  -- association [1..1]
LEFT OUTER JOIN I_LegalTransactionEntity AS _MainLegalTransactionEntity ON LegalTransactionUUID = _MainLegalTransactionEntity.LegalTransactionUUID AND _MainLegalTransactionEntity.LglCntntMIsMainEntity = 'X'  -- association [1..1]
LEFT OUTER JOIN I_LegalTransactionEntity AS _LegalTransactionEntity ON LegalTransactionUUID = _LegalTransactionEntity.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN I_LegalTrParentCategory AS _LegalTrParentCategory ON LegalTransactionUUID = _LegalTrParentCategory.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN I_LegalTransactionCategory AS _LegalTransactionCategory ON LegalTransactionUUID = _LegalTransactionCategory.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN I_LegalTrLinkedObjects AS _LegalTrLinkedObjects ON LegalTransactionUUID = _LegalTrLinkedObjects.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTrRelationship AS _LegalTrRelationship ON LegalTransactionUUID = _LegalTrRelationship.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LegalTransactionIntContact AS _LegalTransactionIntContact ON LegalTransactionUUID = _LegalTransactionIntContact.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMMainOrgTypeText AS _LglCntntMMainOrgTypeText ON LglCntntMMainOrgType = _LglCntntMMainOrgTypeText.LglCntntMMainOrgType AND _LglCntntMMainOrgTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON LglCntntMMainOrgPurOrg = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON LglCntntMMainOrgSalesOrg = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON LglCntntMMainOrgCoCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionHealthText AS _LegalTransactionHealthText ON LegalTransactionHealth = _LegalTransactionHealthText.LegalTransactionHealth AND _LegalTransactionHealthText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON LglCntntMLanguage = _LanguageText.LanguageCode AND _LanguageText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMAccessLvlText AS _LglCntntMAccessLvlText ON LglTransAccessLvl = _LglCntntMAccessLvlText.LglCntntMAccessLvl AND _LglCntntMAccessLvlText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _CreatedBy ON LglCntntMCreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _ChangedBy ON LglCntntMChangedByUser = _ChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMGovLawText AS _LglCntntMGovLawText ON LglCntntMGovLaw = _LglCntntMGovLawText.LglCntntMGovLaw AND _LglCntntMGovLawText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMIntegTypeText AS _LglCntntMIntegTypeText ON LglCntntMIntegrationType = _LglCntntMIntegTypeText.LglCntntMIntegrationType AND Language = $session.system_language  -- association [0..1]
;