srfd_i_mapping

DDL: SRFD_I_MAPPING Type: view_entity Package: GLO_GEN_SRF_AUTHORING
22 Fields 1 Data Sources 1 Associations

Report Mapping Data

srfd_i_mapping is a CDS View that provides data about "Report Mapping Data" in SAP S/4HANA. It reads from 1 data source (srf_mapping) and exposes 22 fields with key fields ReportId, ReportVersion, DocumentId, SchemaId, ElementId. It has 1 association to related views. Part of development package GLO_GEN_SRF_AUTHORING.

Data Sources (1)

SourceAliasJoin Type
srf_mapping Mapping from

Associations (1)

CardinalityTargetAliasCondition
[1..1] srfd_i_report _Report $projection.ReportId = _Report.ReportId and $projection.ReportVersion = _Report.ReportVersion

Annotations (6)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ReportId srf_mapping report_id Report ID
KEY ReportVersion srf_mapping report_version Report Version
KEY DocumentId srf_mapping document_id Snapshot ID
KEY SchemaId srf_mapping schema_id Status Scheme
KEY ElementId srf_mapping element_id OAN Element ID
KEY AttributeId srf_mapping attribute_id INT4
KEY SequenceNumber srf_mapping sequence_number Sort Sequence
LoopQueryId srf_mapping loop_query_id Query ID
SourceType srf_mapping source_type_s Source type
RepVarId srf_mapping rep_var_id_s Report Variable ID
QueryId srf_mapping query_id_s Query ID
ColumnName srf_mapping column_name_s Column name
RowKeyId srf_mapping row_key_id_s Row Key ID
DocumentIdS srf_mapping document_id_s Document ID
ElementIdS srf_mapping element_id_s Element Id
AttributeIdS srf_mapping attribute_id_s Attribute Id
Value srf_mapping value_s Value
ManualAdjOption srf_mapping manual_adj_option Manual Adjustmnt Opt
FieldVisibilityInd srf_mapping field_visibility_ind Visibility Indicator
ParamNameForNumOfEntries srf_mapping param_name_for_num_of_entries Parameter Name
_Document _Document
_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_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_i_mapping AS
SELECT
  Mapping.report_id AS ReportId,
  Mapping.report_version AS ReportVersion,
  Mapping.document_id AS DocumentId,
  Mapping.schema_id AS SchemaId,
  Mapping.element_id AS ElementId,
  Mapping.attribute_id AS AttributeId,
  Mapping.sequence_number AS SequenceNumber,
  Mapping.loop_query_id AS LoopQueryId,
  Mapping.source_type_s AS SourceType,
  Mapping.rep_var_id_s AS RepVarId,
  Mapping.query_id_s AS QueryId,
  Mapping.column_name_s AS ColumnName,
  Mapping.row_key_id_s AS RowKeyId,
  Mapping.document_id_s AS DocumentIdS,
  Mapping.element_id_s AS ElementIdS,
  Mapping.attribute_id_s AS AttributeIdS,
  Mapping.value_s AS Value,
  Mapping.manual_adj_option AS ManualAdjOption,
  Mapping.field_visibility_ind AS FieldVisibilityInd,
  Mapping.param_name_for_num_of_entries AS ParamNameForNumOfEntries
FROM srf_mapping AS Mapping
LEFT OUTER JOIN srfd_i_report AS _Report ON ReportId = _Report.ReportId AND ReportVersion = _Report.ReportVersion  -- association [1..1]
;

Learn More