C_LegalContentRequest

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_LegalContentRequest.
-- 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: CLEGALTRREQ

CREATE VIEW C_LegalContentRequest AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LglCntntMContextUUID,
  LglTransWrkFlwModInstce,
  LglCntntMProfile,
  LglTransAccessLvl,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  _LglTransMainOrgCoCodeCrteVH.CompanyCodeName AS CompanyCodeName,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMLongText,
  IsEndOfPurposeBlocked,
  _LglCntntMContext.LglCntntMContext AS LglCntntMContext,
  _LglCntntMContext.LglCntntMContextTitle AS LglCntntMContextTitle,
  _LglCntntMContext.LglCntntMContextOwner AS LglCntntMContextOwner,
  cast( '' as ad_namtext) AS FullName,
  LglCntntMLanguage,
  LglCntntMGovLaw,
  _LCMGovLawVH.LglCntntMGovLawText AS LglCntntMGovLawText
FROM I_LegalTransaction AS LegalTr
LEFT OUTER JOIN I_LcmContext AS _LglCntntMContext ON LglCntntMContextUUID = _LglCntntMContext.LglCntntMContextUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionEntity AS _LegalTransactionEntity ON LegalTransactionUUID = _LegalTransactionEntity.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionIntContact AS _LegalTransactionIntContact ON LegalTransactionUUID = _LegalTransactionIntContact.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionExtContact AS _LegalTransactionExtContact ON LegalTransactionUUID = _LegalTransactionExtContact.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTrRelationShip AS _LegalTrRelationShip ON LegalTransactionUUID = _LegalTrRelationShip.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTrLinkedObjects AS _LegalTrLinkedObjects ON LegalTransactionUUID = _LegalTrLinkedObjects.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN I_LCMUserContactCard AS _OwnerContactCard ON _OwnerContactCard.ContactCardType = 'User' AND _OwnerContactCard.ContactCardID = lglcntntmcontextowner AND _OwnerContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionDate AS _LegalTransactionDate ON LegalTransactionUUID = _LegalTransactionDate.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglTransReqLglCntntDoc AS _LglTransReqLglCntntDoc ON LegalTransactionUUID = _LglTransReqLglCntntDoc.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglTransCategoryGroup AS _LglTransCategoryGroup ON LegalTransactionUUID = _LglTransCategoryGroup.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalContentRequestCntxtIDVH AS _ContextIdValueHelp ON LglCntntMContext = _ContextIdValueHelp.LglCntntMContext  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LanguageValueHelp ON LglCntntMLanguage = _LanguageValueHelp.Language  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMGovLawVH AS _LCMGovLawVH ON LglCntntMGovLaw = _LCMGovLawVH.LglCntntMGovLaw  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgCoCodeCrteVH AS _LglTransMainOrgCoCodeCrteVH ON LglCntntMMainOrgCoCode = _LglTransMainOrgCoCodeCrteVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgPurOrgCrteVH AS _LglTransMainOrgPurOrgCrteVH ON LglCntntMMainOrgPurOrg = _LglTransMainOrgPurOrgCrteVH.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgSlsOrgCrteVH AS _LglTransMainOrgSlsOrgCrteVH ON LglCntntMMainOrgSalesOrg = _LglTransMainOrgSlsOrgCrteVH.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgTypeCrteVH AS _LglTransMainOrgTypeCrteVH ON LglCntntMMainOrgType = _LglTransMainOrgTypeCrteVH.LglCntntMMainOrgType  -- association [0..1]
LEFT OUTER JOIN C_LglTransAccLvlEditValHelp AS _LglTransAccLvlEditValHelp ON LglTransAccessLvl = _LglTransAccLvlEditValHelp.LglCntntMAccessLvl AND LglCntntMProfile = _LglTransAccLvlEditValHelp.LglCntntMProfile  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMAccessLvlText AS _AccessLvlText ON LglTransAccessLvl = _AccessLvlText.LglCntntMAccessLvl 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_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_PurchasingOrganization AS _PurchasingOrganization ON LglCntntMMainOrgPurOrg = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
;