I_LegalTransactionIntContact

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_LegalTransactionIntContact.
-- 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: ILEGALTRINTCONT

CREATE VIEW I_LegalTransactionIntContact AS
SELECT
  lcm_lt_intcont.legaltransactionintcntctuuid AS LegalTransactionIntCntctUUID,
  lcm_lt_intcont.lglcntntmrank AS LglCntntMRank,
  lcm_lt_intcont.lglcntntmintcntctuser AS LglCntntMIntCntctUser,
  lcm_lt_intcont.lglcntntmintcontactteam AS LglCntntMIntContactTeam,
  lcm_lt_intcont.lglcntntmintcntcttype AS LglCntntMIntCntctType,
  lcm_lt_intcont.lglcntntmintcontactusertype AS LglCntntMIntContactUserType,
  lcm_lt_intcont.legaltransactionuuid AS LegalTransactionUUID,
  lcm_lt_intcont.legaltransactionmandatoryflag AS LegalTransactionMandatoryFlag,
  lcm_lt_intcont.lglcntntmisintegrelevant AS LglCntntMIsIntegRelevant,
  lcm_lt_intcont.lglcntntmisaddedbyintegvarbl AS LglCntntMIsAddedByIntegVarbl
FROM lcm_lt_intcont
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LCMIntContactTypeText AS _IntContactTypeText ON LglCntntMIntCntctType = _IntContactTypeText.LglCntntMIntCntctType AND _IntContactTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _InternalContact ON LglCntntMIntCntctUser = _InternalContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMIntCntctUsrTypeText AS _LglCntntMIntCntctUsrTypeText ON LglCntntMIntContactUserType = _LglCntntMIntCntctUsrTypeText.LglCntntMIntContactUserType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMTeamUserList AS _LglCntntMTeamUserList ON LglCntntMIntContactTeam = _LglCntntMTeamUserList.LglCntntMIntContactTeam  -- association [0..*]
;