SRFD_DocumentDataFilterBase

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 SRFD_DocumentDataFilterBase.
-- 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.
-- Parameters: p_partition_no : srf_partition_no, p_element_id : srf_element_id, p_schema_id : srf_schema_id, p_log_version : srf_dmlg_version

CREATE VIEW SRFD_DocumentDataFilterBase AS
SELECT
  RunData.StatryRptDocUUID AS StatryRptDocUUID,
  RunData.StatryRptTaskUUID AS StatryRptTaskUUID,
  RunData.StatryRptSchemaElementId AS StatryRptSchemaElementId,
  RunData.StatryRptSchemaAttributeId AS StatryRptSchemaAttributeId,
  RunData.StatryRptSequenceNumber AS StatryRptSequenceNumber,
  RunData.StatryRptParentSequenceNumber AS StatryRptParentSequenceNumber,
  RunData.StatryRptDocDataChangeInd AS StatryRptDocDataChangeInd,
  RunData.StatryRptPreviousSeqNo AS StatryRptPreviousSeqNo,
  RunData.StatryRptSubordinalNo AS StatryRptSubordinalNo,
  $parameters.p_log_version AS StatryRptLogVersion,
  $parameters.p_partition_no AS StatryRptPartitionNo,
  SchElem.parent_element_id AS StatryRptSchemaParentElementId,
  SchElem.reference_element_id AS StatryRptSchemaRefElementId,
  RunData.StatryRptDocDataValue AS StatryRptDocDataValue
FROM SRFD_DocumentData AS RunData
INNER JOIN srf_element AS SchElem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN srf_rep_run_dmlg AS _RunLog ON RunData.StatryRptDocUUID = _RunLog.parent_key AND RunData.StatryRptSchemaElementId = _RunLog.element_id AND RunData.StatryRptSequenceNumber = _RunLog.sequence_no AND RunData.StatryRptParentSequenceNumber = _RunLog.parent_seq_no AND _RunLog.dmlg_version = $parameters.p_log_version AND (_RunLog.change_indicator = '' OR _RunLog.change_indicator = 'N' )  -- association [0..*]
LEFT OUTER JOIN srf_rep_run_data AS _RunDataParent ON _RunDataParent.parent_key = RunData.StatryRptDocUUID AND _RunDataParent.root_key = RunData.StatryRptTaskUUID AND _RunDataParent.element_id = SchElem.parent_element_id AND _RunDataParent.attribute_id is initial AND _RunDataParent.sequence_no = RunData.StatryRptParentSequenceNumber AND _RunDataParent.partition_no = $parameters.p_partition_no  -- association [1]
LEFT OUTER JOIN SRFD_DocumentData AS _RefElem ON RunData.StatryRptDocUUID = _RefElem.StatryRptDocUUID AND RunData.StatryRptTaskUUID = _RefElem.StatryRptTaskUUID AND SchElem.reference_element_id = _RefElem.StatryRptSchemaElementId AND RunData.StatryRptSequenceNumber = _RefElem.StatryRptSequenceNumber AND RunData.StatryRptParentSequenceNumber = _RefElem.StatryRptParentSequenceNumber  -- association [0..1]
;