srfd_i_document

DDL: SRFD_I_DOCUMENT Type: view_entity Package: GLO_GEN_SRF_AUTHORING

Report Definition Document

srfd_i_document is a CDS View that provides data about "Report Definition Document" in SAP S/4HANA. It reads from 1 data source (srf_document) and exposes 26 fields with key fields ReportId, ReportVersion, DocumentId. It has 2 associations to related views. Part of development package GLO_GEN_SRF_AUTHORING.

Data Sources (1)

SourceAliasJoin Type
srf_document srf_document from

Associations (2)

CardinalityTargetAliasCondition
[0..*] srfd_i_mapping _Mapping
[0..*] srfd_i_mapping_t _MappingText

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Report Definition Document view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ReportId report_id Report ID
KEY ReportVersion report_version Report Version
KEY DocumentId document_id Snapshot ID
DocumentFormat document_format Format
SchemaId schema_id Status Scheme
FormTemplate form_template PO Layout Tmpl.
RecipientType recipient_type Forms Recipient Type: Business partner or Govt agent
OutputType output_type Output Type
CodePage code_page Code Page
DocumentVisualization document_visualization Doc. Visualization
ReferenceDocumentId reference_document_id Ref. Document ID
SplitQueryId split_query_id Split Query ID
SchemaQueryId schema_query_id Query ID for Schema
FieldArrangement field_arrangement Arrangement
IsSelectable is_selectable Document Selection
QueriesForAnalytics queries_for_analytics Query IDs for Ana
ChangedOn changed_on Variant Changed on
SplitQryColForPackageSize split_qry_col_for_package_size Column name
SplitPackageSize split_package_size Split package size
ParallelizationGroup parallelization_group Document Group ID
NumOfFilesPerSession num_of_files_per_session No.of files per sess
IsComparisonRelevant is_comparison_relevant
SubmissionRelevant submission_relevant
_Mapping _Mapping
_MappingText _MappingText
_Report _Report

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_i_document.
-- 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.

CREATE VIEW srfd_i_document AS
SELECT
  report_id AS ReportId,
  report_version AS ReportVersion,
  document_id AS DocumentId,
  document_format AS DocumentFormat,
  schema_id AS SchemaId,
  form_template AS FormTemplate,
  recipient_type AS RecipientType,
  output_type AS OutputType,
  code_page AS CodePage,
  document_visualization AS DocumentVisualization,
  reference_document_id AS ReferenceDocumentId,
  split_query_id AS SplitQueryId,
  schema_query_id AS SchemaQueryId,
  field_arrangement AS FieldArrangement,
  is_selectable AS IsSelectable,
  queries_for_analytics AS QueriesForAnalytics,
  changed_on AS ChangedOn,
  split_qry_col_for_package_size AS SplitQryColForPackageSize,
  split_package_size AS SplitPackageSize,
  parallelization_group AS ParallelizationGroup,
  num_of_files_per_session AS NumOfFilesPerSession,
  is_comparison_relevant AS IsComparisonRelevant,
  submission_relevant AS SubmissionRelevant
FROM srf_document
LEFT OUTER JOIN srfd_i_mapping AS _Mapping ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN srfd_i_mapping_t AS _MappingText ON /* condition not available in parsed metadata */  -- association [0..*]
;