P_LegalDocLatestVersionCube

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_LegalDocLatestVersionCube.
-- 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: PLCMPLGLDOC

CREATE VIEW P_LegalDocLatestVersionCube AS
SELECT
  LglCntntMDocumentUUID,
  LglCntntMDocument,
  DocumentDescription,
  LglCntntMDocumentLinkedObject,
  LglCntntMDocumentLinkedObjKey,
  LglCntntMDocumentIsTopVersion,
  LegalTransaction,
  _LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  LegalTransactionUUID,
  LglCntntMSignatureDocStatus,
  LglCntntMDocLowTouchLevel,
  LglCntntMDocType,
  _LglCntntMDocTemplateInfo.LglCntntMDocTemplateName AS LglCntntMDocTemplateName,
  _LglCntntMDocTemplateInfo.LglCntntMDocTemplateInfoUUID AS LglCntntMTmplUUID,
  _LglCntntMDocTemplateInfo.LglCntntMDocTemplateVersion AS LglCntntMDocTemplateVersion,
  LegalDocumentVersion,
  InternalDocumentStatus,
  _LGLCNTNTMDOCSTATUSTEXT.LglCntntMDocStatusName AS LglCntntMDocStatusName,
  LglCntntMDocContentType,
  _ContentTypeText.LglCntntMDocContentTypeName AS LglCntntMDocContentTypeName,
  LglCntntMDocAccessLvl,
  LglCntntMLanguage,
  IsEndOfPurposeBlocked,
  cast(SUBSTRING(cast( LglCntntMCreatedUTCDateTime as abap.char(28)),1,8) as abap.dats) AS LglCntntMCreatedDate,
  cast(SUBSTRING(cast( LglCntntMChangedUTCDateTime as abap.char(28)),1,8) as abap.dats) AS LglCntntMChangedDate,
  LglCntntMVirtualDocVersKey,
  LglCntntMDocReferenceNumber,
  _LglCntntMDocAssemblyInfo.LglCntntMDocAssemblyStatus AS LglCntntMDocAssemblyStatus,
  _LegalTransaction.LglCntntMProfile AS LglCntntMProfile,
  _LegalTrEntityAggr.LglCntntMEntityName AS LglCntntMEntityName,
  _LegalTransaction.LglTransAccessLvl AS LglTransAccessLvl,
  _LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalTransaction._LegalTransactionHealthText.LegalTransactionHealthName AS LegalTransactionHealthName,
  _LegalTransaction._LglCntntMMainOrgTypeText.LglCntntMMainOrgTypeName AS LglCntntMMainOrgTypeName,
  _LegalTransaction._MainLegalTransactionEntity.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTransaction._MainLegalTransactionEntity.LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _LglCntntMDocLowTouchLvlTxt.LglCntntMDocLowTouchLevelTxt AS LglCntntMDocLowTouchLevelTxt,
  case when _LegalTransaction.LglCntntMMainOrgType = '04' then _LegalTransaction._SalesOrganizationText.SalesOrganizationName when _LegalTransaction.LglCntntMMainOrgType = '05' then _LegalTransaction._PurchasingOrganization.PurchasingOrganizationName else _LegalTransaction._CompanyCode.CompanyCodeName end as LglCntntMMainOrgName AS CompanyCodeNameendasLglCntntMMainOrgName,
  case when InternalDocumentStatus = 'AC' then cast (1 as abap.int4(10) ) else cast (0 as abap.int4(10) ) end as LegalDocTotNrOfAcceptedStatus AS int410endasLegalDocTotNrOfAcceptedStatus
FROM I_LegalDocument AS _LegalDocument
LEFT OUTER JOIN I_LglCntntMDocTemplateInfo AS _LglCntntMDocTemplateInfo ON LglCntntMDocumentUUID = _LglCntntMDocTemplateInfo.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMTemplate AS _LglCntntMTemplate ON LglCntntMTmplUUID = _LglCntntMTemplate.LglCntntMTmplUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocContentTypeText AS _ContentTypeText ON LglCntntMDocContentType = _ContentTypeText.LglCntntMDocContentType AND LglCntntMLanguage = _ContentTypeText.Language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMProfileText AS _LglCntntMProfileText ON LglCntntMProfile = _LglCntntMProfileText.LglCntntMProfile AND _LglCntntMProfileText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocAssemblyInfo AS _LglCntntMDocAssemblyInfo ON LglCntntMDocumentUUID = _LglCntntMDocAssemblyInfo.LglCntntMDocumentUUID AND LglCntntMVirtualDocVersKey = _LglCntntMDocAssemblyInfo.LglCntntMVirtualDocVersKey  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocAssemblyStsText AS _AssemblyStsText ON LglCntntMDocAssemblyStatus = _AssemblyStsText.LglCntntMDocAssemblyStatus AND _AssemblyStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocLowTouchLvlTxt AS _LglCntntMDocLowTouchLvlTxt ON LglCntntMDocLowTouchLevel = _LglCntntMDocLowTouchLvlTxt.LglCntntMDocLowTouchLevel AND _LglCntntMDocLowTouchLvlTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LegalTrEntityAggr AS _LegalTrEntityAggr ON LegalTransactionUUID = _LegalTrEntityAggr.LegalTransactionUUID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMDocStatusText AS _LGLCNTNTMDOCSTATUSTEXT ON InternalDocumentStatus = _LGLCNTNTMDOCSTATUSTEXT.InternalDocumentStatus AND _LGLCNTNTMDOCSTATUSTEXT.Language = $session.system_language  -- association [0..1]
;