C_LegalTransactionIntegFacet

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_LegalTransactionIntegFacet.
-- 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: CLGLTRANSINTEGF

CREATE VIEW C_LegalTransactionIntegFacet AS
SELECT
  LinkedObject.LegalTransactionLinkdObjUUID AS LegalTransactionLinkdObjUUID,
  LinkedObject.LegalTransactionUUID AS LegalTransactionUUID,
  LegalTransaction.LegalTransaction AS LegalTransaction,
  _LegalTransactionEntityMain.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTransactionEntityMain.LglCntntMEntity AS LglCntntMEntity,
  _LegalTransactionEntityMain.LglCntntMEntityName AS LglCntntMEntityName,
  LegalTransaction.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  LegalTransaction.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  LinkedObject.LglCntntMLinkdObj AS LglCntntMLinkdObj,
  LinkedObject.LglCntntMIntegrationLink AS LglCntntMIntegrationLink,
  LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalTransactionAggrgn.LglTransHealthCriticality AS LglTransHealthCriticality,
  LegalTransaction.LglCntntMLanguage AS LglCntntMLanguage,
  LegalTransaction.LglCntntMGovLaw AS LglCntntMGovLaw,
  _LCMGovLawVH.LglCntntMGovLawText AS LglCntntMGovLawText,
  LegalTransaction.LglCntntMMainOrgType AS LglCntntMMainOrgType,
  _LegalTransactionAggrgn.LglCntntMMainOrg AS LglCntntMMainOrg,
  cast( '' as abap.char(25)) AS LglCntntMMainOrgName,
  cast( '' as lcm_valid_from ) AS LglCntntMFromDate,
  cast( '' as lcm_valid_to ) AS LglCntntMToDate,
  LinkedObject.LegalTransactionIsTriggerObj AS LegalTransactionIsTriggerObj,
  _LglTransToBeUpdated.LglCntntMLglTransUpdtIsRqd AS LglCntntMLglTransUpdtIsRqd,
  LegalTransaction.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  LegalTransaction.LglCntntMProfile AS LglCntntMProfile,
  LegalTransaction.LglTransAccessLvl AS LglTransAccessLvl,
  LegalTransaction.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalTransaction.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  LegalTransaction.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  LegalTransaction._LglCntntMMainOrgTypeText AS _LglCntntMMainOrgTypeText
FROM I_LegalTransaction AS LegalTransaction
INNER JOIN I_LglCntntMIntegLinkdObj AS LinkedObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LegalTransactionAggr AS _LegalTransactionAggrgn ON LegalTransactionUUID = _LegalTransactionAggrgn.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _ChangedByContactCard ON _ChangedByContactCard.ContactCardType = 'User' AND _ChangedByContactCard.ContactCardID = LglCntntMChangedByUser AND _ChangedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionHealthText AS _LegalTransactionHealthText ON LegalTransactionHealth = _LegalTransactionHealthText.LegalTransactionHealth  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionEntityMain AS _LegalTransactionEntityMain ON LegalTransactionUUID = _LegalTransactionEntityMain.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN I_LCMEntityTypeText AS _EntityTypeText ON lglcntntmentitytype = _EntityTypeText.LglCntntMEntityType  -- association [0..*]
LEFT OUTER JOIN I_Language AS _Language ON LglCntntMLanguage = _Language.Language  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMGovLawVH AS _LCMGovLawVH ON LglCntntMGovLaw = _LCMGovLawVH.LglCntntMGovLaw  -- association [0..1]
LEFT OUTER JOIN I_LglTransToBeUpdated AS _LglTransToBeUpdated ON LegalTransaction = _LglTransToBeUpdated.LegalTransaction AND LglCntntMLinkdObj = _LglTransToBeUpdated.LglCntntMLinkdObj  -- association [1..1]
LEFT OUTER JOIN E_LegalTransaction AS _LegalTransactionExtension ON LegalTransactionUUID = _LegalTransactionExtension.LegalTransactionUUID  -- association [1..1]
;