C_LegalTransactionSgntrDoc

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_LegalTransactionSgntrDoc.
-- 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: CLGLTRSGNDOC

CREATE VIEW C_LegalTransactionSgntrDoc AS
SELECT
  LglCntntMSignatureDocUUID,
  LglCntntMSignatureGroupUUID,
  LegalTransactionUUID,
  LglCntntMDocumentUUID,
  LglCntntMDocument,
  _Document.DocumentDescription AS DocumentDescription,
  cast( _Document.DocumentVersion as dokvr ) AS DocumentVersion,
  _Document.LegalDocumentVersion AS LegalDocumentVersion,
  _Document.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  _Document.LglCntntMTmplUUID AS LglCntntMTmplUUID,
  LglCntntMSgntrProcgStatus,
  LglCntntMSignatureDocStatus,
  cast( '' as dokar ) AS DocumentInfoRecordDocType,
  cast( '' as abap.char(25) ) AS DocumentInfoRecordDocNumber,
  cast( '' as abap.char(3) ) AS DocumentInfoRecordDocPart,
  cast( '' as abap.char(2) ) AS DocumentInfoRecordDocVersion,
  cast( '' as abap.char(32) ) AS LogicalDocument,
  cast( '' as abap.char(32) ) AS PhysicalDocument,
  _Document.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  cast( '' as abap.char(200) ) AS FileName,
  cast('' as ad_namtext) AS LglCntntMCreatedByFullName,
  _Document.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  _Document.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  cast('' as ad_namtext) AS LglCntntMChangedByFullName,
  _Document.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  _Document.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  case _Document.LglCntntMDocumentIsTopVersion when 'X' then _VersionText[1: LglCntntMVersionTypeCode= '02'].LglCntntMVersionTypeText else concat_with_space(_VersionText[1: LglCntntMVersionTypeCode= '01'].LglCntntMVersionTypeText, _Document.DocumentVersion, 1) end as LglCntntMObjTitle AS DocumentVersion1endasLglCntntMObjTitle,
  _LglCntntMDocTmplInfoVersion.LglCntntMDocTemplateName AS LglCntntMDocTemplateName,
  _LglCntntMDocTmplInfoVersion.LglCntntMDocTemplateVersion AS LglCntntMDocTemplateVersion,
  _LglCntntMDocTmplInfoVersion.LglCntntMDocTemplateDate AS LglCntntMDocTemplateDate
FROM I_LglCntntMSgntrDocTP
LEFT OUTER JOIN C_LegalTransactionDocSgntrGrp AS _LegalTransactionDocSgntrGrp ON LglCntntMDocumentUUID = _LegalTransactionDocSgntrGrp.LglCntntMDocumentUUID  -- association [1..*]
LEFT OUTER JOIN C_LglCntntMSgntrDocStatusVH AS _LglCntntMSgntrDocStatusVH ON LglCntntMSignatureDocStatus = _LglCntntMSgntrDocStatusVH.LglCntntMSignatureDocStatus  -- association [0..1]
LEFT OUTER JOIN I_LcmDocument AS _Document ON LglCntntMDocumentUUID = _Document.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMDocumentVersion AS _LglCntntMDocument ON LglCntntMDocumentUUID = _LglCntntMDocument.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMDocTmplInfoVersion AS _LglCntntMDocTmplInfoVersion ON LglCntntMDocumentUUID = _LglCntntMDocTmplInfoVersion.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMDocOblgnVersion AS _LglCntntMDocOblgnVersion ON LglCntntMDocumentUUID = _LglCntntMDocOblgnVersion.LglCntntMDocumentUUID  -- association [1..*]
LEFT OUTER JOIN C_LegalTransactionDocStamp AS _LegalTransactionDocStamp ON LglCntntMDocumentUUID = _LegalTransactionDocStamp.LglCntntMDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMVersionText AS _VersionText ON _VersionText.LglCntntMVersionTypeCode = '01' OR _VersionText.LglCntntMVersionTypeCode = '02'  -- association [1..*]
;