P_LegalTransactionCube

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 P_LegalTransactionCube.
-- 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: PLCMPLGLTR

CREATE VIEW P_LegalTransactionCube AS
SELECT
  LegalTransactionUUID,
  LegalTransaction,
  LegalTransactionTitle,
  LegalTransactionHealth,
  LglCntntMLanguage,
  LglCntntMCreatedByUser,
  _CreatedBy.FullName AS CreatedByName,
  cast(SUBSTRING(cast( LglCntntMCreatedUTCDateTime as abap.char(28)),1,8) as ecm_creationdate) AS LglCntntMCreatedDate,
  LglCntntMChangedByUser,
  _ChangedBy.FullName AS ChangedByName,
  LglCntntMChangedUTCDateTime,
  LglCntntMProfile,
  LegalTransactionSource,
  LglCntntMRtntnPerdStartDate,
  _Context.LglCntntMContext AS LglCntntMContext,
  _Context.LglCntntMContextTitle AS LglCntntMContextTitle,
  _LegalTransactionDateTP.LglCntntMFromDate AS LglCntntMFromDate,
  _LegalTransactionEndDateTP.LglCntntMFromDate AS LglCntntMToDate,
  LglCntntMGovLaw,
  _LglCntntMGovLawText[1: Language = $session.system_language].LglCntntMGovLawText AS LglCntntMGovLawText,
  LglTransAccessLvl,
  _LglCntntMAccessLvlText[1: Language = $session.system_language].LglCntntMAccessLvlName AS LglCntntMAccessLvlName,
  LglCntntMMainOrgType,
  LglCntntMMainOrgCoCode,
  _SalesOrganizationText[1: Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMIntegrationType,
  _LegalTransactionHealthText.LegalTransactionHealthName AS LegalTransactionHealthName,
  _LglCntntMMainOrgTypeText.LglCntntMMainOrgTypeName AS LglCntntMMainOrgTypeName,
  _MainLegalTransactionEntity.LglCntntMEntityType AS LglCntntMEntityType,
  _MainLegalTransactionEntity.LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _MainLegalTransactionEntity.LglCntntMEntity AS LglCntntMEntity,
  case when I_LegalTransaction.LglCntntMMainOrgType = '04' then _SalesOrganizationText.SalesOrganizationName when I_LegalTransaction.LglCntntMMainOrgType = '05' then _PurchasingOrganization.PurchasingOrganizationName else _CompanyCode.CompanyCodeName end as LglCntntMMainOrgName AS CompanyCodeNameendasLglCntntMMainOrgName,
  case when LegalTransactionHealth = '0002' or LegalTransactionHealth = '0003' then cast (1 as abap.int4(10) ) else cast (0 as abap.int4(10) ) end as LegalTransTotNrOfOpenStatus AS int410endasLegalTransTotNrOfOpenStatus,
  case when LegalTransactionHealth = '0001' then cast (1 as abap.int4(10) ) else cast (0 as abap.int4(10) ) end as LegalTransTotNmbrOfOnTrackSts AS int410endasLegalTransTotNmbrOfOnTrackSts,
  cast( 1 as lcm_totallt ) AS TotalNumberOfLegalTransactions,
  case when _LTRnwlAndTermn.LglCntntMNmbrOfRenewals > 0 then cast (1 as abap.int4(10) ) else cast (0 as abap.int4(10) ) end as LglTransTotNmbrOfAutoRenewed AS int410endasLglTransTotNmbrOfAutoRenewed,
  _LTRnwlAndTermn._LglCntntMRnwlTypeText[1: Language = $session.system_language].LglCntntMRnwlTypeName AS LglCntntMRnwlTypeName,
  _LTRnwlAndTermn.LglCntntMRnwlType AS LglCntntMRnwlType,
  _LegalTrLinkedObjectsTP.LglCntntMLinkdObjTypeName AS LglCntntMLinkdObjTypeName
FROM I_LegalTransaction
LEFT OUTER JOIN I_LegalTransactionDateTP AS _LegalTransactionDateTP ON LegalTransactionUUID = _LegalTransactionDateTP.LegalTransactionUUID AND _LegalTransactionDateTP.LglCntntMDateType = 'SAP1'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDateTP AS _LegalTransactionEndDateTP ON LegalTransactionUUID = _LegalTransactionEndDateTP.LegalTransactionUUID AND _LegalTransactionEndDateTP.LglCntntMDateType = 'SAP2'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDateTP AS _LegalTransactionNxtTermnTP ON LegalTransactionUUID = _LegalTransactionNxtTermnTP.LegalTransactionUUID AND _LegalTransactionNxtTermnTP.LglCntntMDateType = 'SAP3'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionDateTP AS _LegalTransactionNxtRnwlTP ON LegalTransactionUUID = _LegalTransactionNxtRnwlTP.LegalTransactionUUID AND _LegalTransactionNxtRnwlTP.LglCntntMDateType = 'SAP4'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransRnwlAndTermnTP AS _LTRnwlAndTermn ON LegalTransactionUUID = _LTRnwlAndTermn.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalTrLinkedObjectsTP AS _LegalTrLinkedObjectsTP ON LegalTransactionUUID = _LegalTrLinkedObjectsTP.LegalTransactionUUID AND _LegalTrLinkedObjectsTP.LegalTransactionIsTriggerObj = 'X'  -- association [0..1]
LEFT OUTER JOIN I_LCMEntityTypeText AS _LCMEntityTypeText ON LglCntntMEntityType = _LCMEntityTypeText.LglCntntMEntityType AND _LCMEntityTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggr ON LegalTransactionUUID = _LegalTrEntityAggr.LegalTransactionUUID AND LglCntntMEntity = _LegalTrEntityAggr.LglCntntMEntity  -- association [0..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _CreatedBy ON LglCntntMCreatedByUser = _CreatedBy.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_LCMUserAddressAssignment AS _ChangedBy ON LglCntntMChangedByUser = _ChangedBy.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON LglCntntMMainOrgSalesOrg = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON LglCntntMCreatedDate = _CalendarDate.CalendarDate  -- association [1..1]
;