srfd_c_mapping

DDL: SRFD_C_MAPPING Type: view_entity Package: GLO_GEN_SRF_AUTHORING
21 Fields 1 Data Sources 1 OData Services

Report Document Mapping

srfd_c_mapping is a CDS View that provides data about "Report Document Mapping" in SAP S/4HANA. It reads from 1 data source (srfd_i_mapping) and exposes 21 fields with key fields ReportId, ReportVersion, DocumentId, SchemaId, ElementId. It is exposed through 1 OData service (UI_SRF_REPORT). Part of development package GLO_GEN_SRF_AUTHORING.

Data Sources (1)

SourceAliasJoin Type
srfd_i_mapping srfd_i_mapping projection

Annotations (6)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_SRF_REPORT UI_SRF_REPORT V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ReportId ReportId Report ID
KEY ReportVersion ReportVersion Report Version
KEY DocumentId DocumentId Routing slip doc. ID
KEY SchemaId SchemaId Status Scheme
KEY ElementId ElementId Element ID
KEY AttributeId AttributeId INT4
KEY SequenceNumber SequenceNumber Sort sequence
LoopQueryId LoopQueryId Query ID
SourceType SourceType Source Type
RepVarId RepVarId Report Variable ID
QueryId QueryId Query ID
ColumnName ColumnName Column name
RowKeyId RowKeyId Row Key ID
DocumentIdS DocumentIdS Document ID
ElementIdS ElementIdS Element Id
AttributeIdS AttributeIdS Attribute Id
Value Value Value from table
ManualAdjOption ManualAdjOption Manual Adjustmnt Opt
FieldVisibilityInd FieldVisibilityInd Visibility Indicator
ParamNameForNumOfEntries ParamNameForNumOfEntries Parameter Name
_Reportredirectedtosrfd_c_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_c_mapping.
-- 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_c_mapping AS
SELECT
  ReportId,
  ReportVersion,
  DocumentId,
  SchemaId,
  ElementId,
  AttributeId,
  SequenceNumber,
  LoopQueryId,
  SourceType,
  RepVarId,
  QueryId,
  ColumnName,
  RowKeyId,
  DocumentIdS,
  ElementIdS,
  AttributeIdS,
  Value,
  ManualAdjOption,
  FieldVisibilityInd,
  ParamNameForNumOfEntries
FROM srfd_i_mapping
;

Learn More