SRFD_DocumentData

DDL: SRFD_DOCUMENTDATA SQL: SRFV_DOCDATA Type: view
13 Fields 1 Data Sources

Generated Document Data

SRFD_DocumentData is a CDS View that provides data about "Generated Document Data" in SAP S/4HANA. It reads from 1 data source (srf_rep_run_data) and exposes 13 fields with key field StatryRptDocDataUUID.

Data Sources (1)

SourceAliasJoin Type
srf_rep_run_data srf_rep_run_data from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SRFV_DOCDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Generated Document Data view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY StatryRptDocDataUUID srf_rep_run_data db_key UUID
StatryRptDocUUID srf_rep_run_data parent_key UUID
StatryRptTaskUUID srf_rep_run_data root_key UUID
StatryRptSchemaElementId srf_rep_run_data element_id OAN Element ID
StatryRptSchemaAttributeId srf_rep_run_data attribute_id INT4
StatryRptSequenceNumber srf_rep_run_data sequence_no Sqnc No. in Ext File
StatryRptParentSequenceNumber srf_rep_run_data parent_seq_no Sqnc No. in Par File
StatryRptDocDataGeneratedValue srf_rep_run_data generated_value Value
StatryRptDocDataModifiedValue srf_rep_run_data modified_value Value
StatryRptDocDataChangeInd srf_rep_run_data change_indicator Change Type
sequence_noendasStatryRptPreviousSeqNo
StatryRptSubordinalNo srf_rep_run_data subordinal_no Subordinal Number
StatryRptPartitionNo srf_rep_run_data partition_no Partition No.

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_DocumentData.
-- 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: SRFV_DOCDATA

CREATE VIEW SRFD_DocumentData AS
SELECT
  srf_rep_run_data.db_key AS StatryRptDocDataUUID,
  srf_rep_run_data.parent_key AS StatryRptDocUUID,
  srf_rep_run_data.root_key AS StatryRptTaskUUID,
  srf_rep_run_data.element_id AS StatryRptSchemaElementId,
  srf_rep_run_data.attribute_id AS StatryRptSchemaAttributeId,
  srf_rep_run_data.sequence_no AS StatryRptSequenceNumber,
  srf_rep_run_data.parent_seq_no AS StatryRptParentSequenceNumber,
  srf_rep_run_data.generated_value AS StatryRptDocDataGeneratedValue,
  srf_rep_run_data.modified_value AS StatryRptDocDataModifiedValue,
  srf_rep_run_data.change_indicator AS StatryRptDocDataChangeInd,
  case when srf_rep_run_data.subordinal_no is not initial then srf_rep_run_data.previous_seq_no else srf_rep_run_data.sequence_no end as StatryRptPreviousSeqNo AS sequence_noendasStatryRptPreviousSeqNo,
  srf_rep_run_data.subordinal_no AS StatryRptSubordinalNo,
  srf_rep_run_data.partition_no AS StatryRptPartitionNo
FROM srf_rep_run_data
;

Learn More