C_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 C_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: CLEGALTRTP

CREATE VIEW C_LegalTransactionTP AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LglTransaction.LglCntntMContextUUID AS LglCntntMContextUUID,
  LglCntntMContext AS LegalContext,
  LglCntntMContextVersion,
  LglCntntMContext,
  LglCntntMContextTitle,
  LglCntntMProfile,
  LglCntntMIntegrationType,
  LglTransaction.LglCntntMEntityType AS LglCntntMEntityType,
  LglTransaction._LCMEntityTypeText[1: Language = $session.system_language].LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  LglTransaction.LglCntntMEntity AS LglCntntMEntity,
  cast ('' as char80) AS LglCntntMEntityName,
  cast('' as lcm_linkobj_type) AS LglCntntMLinkdObjType,
  cast('' as lcm_linkedobject_id) AS LglCntntMLinkdObj,
  cast('' as lcm_lt_is_trigger_object) AS LegalTransactionIsTriggerObj,
  LglCntntMLanguage,
  LglCntntMGovLaw,
  _LCMGovLawVH.LglCntntMGovLawText AS LglCntntMGovLawText,
  LglTransAccessLvl,
  _LglCntntMAccessLvlText.LglCntntMAccessLvlName AS LglCntntMAccessLvlName,
  LglTransAccessLvl AS LglTransAccessLvlFilter,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  cast( '' as butxt ) AS CompanyCodeName,
  LglCntntMMainOrgSalesOrg,
  cast( '' as salesorganizationname ) AS SalesOrganizationName,
  LglCntntMMainOrgPurOrg,
  cast('' as mm_a_purg_org_name ) AS PurchasingOrganizationName,
  cast( '' as lcm_entity_id ) AS LglCntntMMainOrg,
  cast( '' as abap.char(25)) AS LglCntntMMainOrgName,
  LglCntntMChangedByUser,
  cast('' as ad_namtext) AS LglCntntMChangedByFullName,
  LglCntntMCreatedByUser,
  cast('' as ad_namtext) AS LglCntntMCreatedByFullName,
  cast('' as abap.char( 1 )) AS LglCntntMDocAssemblyIsActv,
  cast( '' as lcm_icrts_is_active ) AS LglCntntMIcrtsIsActive,
  LglCntntMChangedUTCDateTime,
  cast ( '' as cdobjectv ) AS ChangeDocObject,
  cast('' as abap_boolean ) AS LglCntntMDocCreateEnabled,
  cast( '' as abap_boolean ) AS LglCntntMDocEditEnabled,
  cast( '' as abap_boolean ) AS LglCntntMSgntrIsAuthForSndg,
  cast( '' as abap_boolean ) AS LglCntntMSgntrIsAuthForCancel,
  LglCntntMCreatedUTCDateTime,
  cast ( 0 as int1 ) AS LglTransHealthCriticality,
  LegalTransactionHealth,
  LglTransWrkFlwModInstce,
  LegalTransactionSource,
  cast ( 0 as abap.int8 ) AS LglCntntMNotesCnt,
  LglTransaction.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  '' AS LglTransWrkflwButtonIsEnabled,
  LglCntntMRtntnPerdStartDate,
  LglCntntMLongText,
  LglCntntMLongTextMimeType,
  '' AS LglCntntMCntntTypeAuthorized,
  '' AS LglCntntMIsCopyFirstTimeDraft,
  cast( '' as abap.numc( 6 ) ) AS LglCntntMFilterCategory,
  cast( '' as lcm_contact_type ) AS LglCntntMIntCntctType,
  cast( '' as lcm_username ) AS LglCntntMIntCntctUser,
  cast( '' as lcm_is_main_entity) AS LglCntntMIsMainEntity,
  cast( '' as lcm_entity_type) AS LglCntntMEntityTypeFilter,
  cast( '' as lcm_entity_id ) AS LglCntntMFilterEntity,
  cast( '' as lcm_date_type ) AS LglCntntMDateType,
  cast( '' as lcm_valid_from ) AS LglCntntMFromDate,
  cast( '' as lcm_valid_to ) AS LglCntntMToDate,
  cast( '' as boole_d ) AS LglCntntMSgntrIsDisabled,
  cast ( '' as char1 ) AS LglCntntMDocSuppdSignatureType,
  '' AS LglCntntMgmtDOCUSIGNIsEnabled,
  LglCntntMCrtedFrmLglTransUUID,
  cast('' as lcm_legaltr_id) AS LglCntntMCrtedFromLglTrans,
  cast('' as lcm_title) AS LglCntntMCrtedFrmLglTransTitle,
  cast('' as lcm_lt_log_handle) AS LglCntntMLglTransLgHdlr,
  cast ('' as is_cloud_system ) AS IsCloudSystem,
  cast('' as lcm_intcntctteam) AS LglCntntMIntContactTeam,
  cast('' as lcm_is_collabn_active) AS LglCntntMIsCollabnActive
FROM I_LegalTransactionTP AS LglTransaction
LEFT OUTER JOIN I_LegalTransactionAggr AS _LegalTransactionAggrgn ON LegalTransactionUUID = _LegalTransactionAggrgn.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMContextQuickView AS _LglCntntMContextQuickView ON LglCntntMContextVersion = _LglCntntMContextQuickView.LglCntntMContextVersion AND LegalContext = _LglCntntMContextQuickView.LegalContext  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionEntityTP AS _LegalTransactionEntityTP ON LegalTransactionUUID = _LegalTransactionEntityTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionIntContactTP AS _LegalTransactionIntContactTP ON LegalTransactionUUID = _LegalTransactionIntContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionExtContactTP AS _LegalTransactionExtContactTP ON LegalTransactionUUID = _LegalTransactionExtContactTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransRnwlAndTermnTP AS _LegalTransRnwlAndTermnTP ON LegalTransactionUUID = _LegalTransRnwlAndTermnTP.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionDateTP AS _LegalTransactionDateTP ON LegalTransactionUUID = _LegalTransactionDateTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionReminderTP AS _LegalTransactionReminderTP ON LegalTransactionUUID = _LegalTransactionReminderTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTrRelationshipTP AS _LegalTrRelationshipTP ON LegalTransactionUUID = _LegalTrRelationshipTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTrLinkedObjectsTP AS _LegalTrLinkedObjectsTP ON LegalTransactionUUID = _LegalTrLinkedObjectsTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionStartedTasks AS _LegalTransactionStartedTasks ON LegalTransactionUUID = _LegalTransactionStartedTasks.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMWrkflwDocLink AS _LglCntntMWrkflwDocLink ON LegalTransactionUUID = _LglCntntMWrkflwDocLink.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMTaskGroupTP AS _LglCntntMTaskGroupTP ON LegalTransactionUUID = _LglCntntMTaskGroupTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMTaskGroup AS _LglCntntMTaskGroup ON LegalTransactionUUID = _LglCntntMTaskGroup.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTrCategoryGroupTP AS _LegalTrCategoryGroupTP ON LegalTransactionUUID = _LegalTrCategoryGroupTP.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN C_LCMLegalTrDocument AS _LCMLegalTrDocument ON LegalTransaction = _LCMLegalTrDocument.LegalTransaction AND _LCMLegalTrDocument.LglCntntMDocumentIsTopVersion = 'X'  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMDocRefresh AS _LglCntntMDocRefresh ON LegalTransaction = _LglCntntMDocRefresh.LegalTransaction  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMRefreshDocAgreement AS _LglCntntMRefreshDocAgreement ON LegalTransaction = _LglCntntMRefreshDocAgreement.LegalTransaction  -- association [0..*]
LEFT OUTER JOIN C_LCMLegalTrDocument AS _LglCntntMWrkflwDocAttach ON _LglCntntMWrkflwDocAttach.LegalTransaction = LegalTransaction AND _LglCntntMWrkflwDocAttach.LglCntntMDocumentIsTopVersion = 'X' AND _LglCntntMWrkflwDocAttach.LglCntntMIsRstrcdDocCntnt = '' AND ( ( InternalDocumentStatus <> 'A1' AND InternalDocumentStatus <> 'NW' ) AND( ( LglCntntMDocType = 'D' AND( ( _LglCntntMWrkflwDocAttach.LglCntntMSignatureDocStatus <> '01' AND _LglCntntMWrkflwDocAttach.LglCntntMDocIsLockedForCollabn <> 'X' AND LglCntntMDocRefreshStatus is null OR( LglCntntMDocRefreshStatus <> 'EVLTN' AND LglCntntMDocRefreshStatus <> 'REQRD' ) ) ) ) OR( LglCntntMDocType = 'V' AND( LglCntntMDocAssemblyStatus = 'final' AND( LglCntntMDocRefreshStatus is null OR( LglCntntMDocRefreshStatus <> 'EVLTN' AND LglCntntMDocRefreshStatus <> 'REQRD' ) ) ) ) ) )  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionDocLinkTP AS _LegalTransactionDocLinkTP ON LegalTransactionUUID = _LegalTransactionDocLinkTP.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMRelshpDocLink AS _LTRelshpDocLink ON LegalTransactionUUID = _LTRelshpDocLink.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionSgntrGrp AS _LegalTransactionSgntrGrp ON LegalTransactionUUID = _LegalTransactionSgntrGrp.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN C_LegalTransCollaboration AS _LegalTransCollaboration ON LegalTransactionUUID = _LegalTransCollaboration.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN C_LegalTransactionPhase AS _LegalTransactionPhase ON LegalTransactionUUID = _LegalTransactionPhase.LegalTransactionUUID  -- association [1..*]
LEFT OUTER JOIN C_LegalTrContextIdValueHelp AS _LegalTrContextIdValueHelp ON LglCntntMContextVersion = _LegalTrContextIdValueHelp.LglCntntMContextVersion AND LegalContext = _LegalTrContextIdValueHelp.LglCntntMContext  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON LegalTransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionHealthVH AS _LegalTransactionHealthVH ON LegalTransactionHealth = _LegalTransactionHealthVH.LegalTransactionHealth  -- association [0..1]
LEFT OUTER JOIN C_LCMUserValueHelp AS _CreatedBy ON LglCntntMCreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN C_LCMUserValueHelp AS _ChangedBy ON LglCntntMChangedByUser = _ChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN C_LcmLanguageValueHelp AS _LanguageValueHelp ON LglCntntMLanguage = _LanguageValueHelp.Language  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMMainEntity AS _LglCntntMMainEntity ON LegalTransactionUUID = _LglCntntMMainEntity.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMGovLawVH AS _LCMGovLawVH ON LglCntntMGovLaw = _LCMGovLawVH.LglCntntMGovLaw  -- association [0..1]
LEFT OUTER JOIN C_LglTransAccLvlValHelp AS _LglTransAccLvlValHelp ON LglTransAccessLvlFilter = _LglTransAccLvlValHelp.LglCntntMAccessLvl  -- association [0..1]
LEFT OUTER JOIN C_LglTransAccLvlEditValHelp AS _LglTransAccLvlEditValHelp ON LglTransAccessLvl = _LglTransAccLvlEditValHelp.LglCntntMAccessLvl AND LglCntntMProfile = _LglTransAccLvlEditValHelp.LglCntntMProfile  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgCoCodeEditVH AS _LglTransMainOrgCoCodeEditVH ON LglCntntMMainOrgCoCode = _LglTransMainOrgCoCodeEditVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgPurOrgEditVH AS _LglTransMainOrgPurOrgEditVH ON LglCntntMMainOrgPurOrg = _LglTransMainOrgPurOrgEditVH.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_LglTransMainOrgSlsOrgEditVH AS _LglTransMainOrgSlsOrgEditVH ON LglCntntMMainOrgSalesOrg = _LglTransMainOrgSlsOrgEditVH.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_LCMCompanyCodeValueHelp AS _CompanyCodeValueHelp ON LglCntntMMainOrgCoCode = _CompanyCodeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_LCMPurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON LglCntntMMainOrgPurOrg = _PurchasingOrgValueHelp.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_LCMSalesOrganizationVH AS _SalesOrganizationVH ON LglCntntMMainOrgSalesOrg = _SalesOrganizationVH.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LglCntntMCreatedByUser AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..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 C_LglCntntMProfileValueHelp AS _LglCntntMProfileValueHelp ON LglCntntMProfile = _LglCntntMProfileValueHelp.LglCntntMProfile AND LglCntntMIntegrationType = _LglCntntMProfileValueHelp.LglCntntMIntegrationType  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMIntegTypeVH AS _LglCntntMIntegTypeVH ON LglCntntMProfile = _LglCntntMIntegTypeVH.LglCntntMProfile AND LglCntntMIntegrationType = _LglCntntMIntegTypeVH.LglCntntMIntegrationType  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMNotesLglTrans AS _LglCntntMNotesLglTrans ON _LglCntntMNotesLglTrans.LglCntntMParApplObjUUID = LglTransaction.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMNotesLglTransObj AS _LglCntntMNotesLglTransObj ON _LglCntntMNotesLglTransObj.LglCntntMParApplObjUUID = LglTransaction.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMRelshpUseCaseStatus AS _LglCntntMRelshpUseCaseStatus ON LegalTransactionUUID = _LglCntntMRelshpUseCaseStatus.LegalTransactionUUID  -- association [0..*]
LEFT OUTER JOIN C_LCMActiveCntxtIdValueHelp AS _LCMActiveCntxtIdValueHelp ON LglCntntMContextUUID = _LCMActiveCntxtIdValueHelp.LglCntntMContextUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalContentRequestCntxtIDVH AS _LegalContentRequestCntxtIDVH ON LglCntntMContextUUID = _LegalContentRequestCntxtIDVH.LglCntntMContextUUID  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMDocOblgnReminder AS _LglCntntMDocOblgnReminder ON LegalTransaction = _LglCntntMDocOblgnReminder.LegalTransaction  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMDocObligation AS _LglCntntMDocObligation ON LegalTransaction = _LglCntntMDocObligation.LegalTransaction  -- association [0..*]
;