SRF_MAPPING

Transparent Table System Table (transport)
11 Fields 2 CDS Views

Mapping of data sources to attributes and simple elements

SRF_MAPPING is an SAP database table in S/4HANA. Mapping of data sources to attributes and simple elements. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_DART_Z3_QUERY_FIELD view from Dart Z3 Field View
srfv_mapping_ddl view from Mapping with element and attribute names

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY report_id srf_report_id Report Definition
KEY report_version srf_report_version Report Version
KEY document_id srf_document_id Document ID
KEY schema_id srf_schema_id Schema Id
KEY element_id srf_element_id Element Id
KEY attribute_id srf_attribute_id Attribute Id
KEY sequence_number srf_sequence_number Number
loop_query_id srf_query_id Query ID
manual_adj_option srf_manual_adj_option Manual Adjustmnt Opt
field_visibility_ind srf_field_visibility_ind Visibility Indicator
param_name_for_num_of_entries srf_param_for_num_of_entries Parameter Name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Mapping of data sources to attributes and simple elements
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRF_MAPPING (
    REPORT_ID,                      -- Report Definition [srf_report_id]
    REPORT_VERSION,                 -- Report Version [srf_report_version]
    DOCUMENT_ID,                    -- Document ID [srf_document_id]
    SCHEMA_ID,                      -- Schema Id [srf_schema_id]
    ELEMENT_ID,                     -- Element Id [srf_element_id]
    ATTRIBUTE_ID,                   -- Attribute Id [srf_attribute_id]
    SEQUENCE_NUMBER,                -- Number [srf_sequence_number]
    LOOP_QUERY_ID,                  -- Query ID [srf_query_id]
    MANUAL_ADJ_OPTION,              -- Manual Adjustmnt Opt [srf_manual_adj_option]
    FIELD_VISIBILITY_IND,           -- Visibility Indicator [srf_field_visibility_ind]
    PARAM_NAME_FOR_NUM_OF_ENTRIES,  -- Parameter Name [srf_param_for_num_of_entries]
    PRIMARY KEY (REPORT_ID, REPORT_VERSION, DOCUMENT_ID, SCHEMA_ID, ELEMENT_ID, ATTRIBUTE_ID, SEQUENCE_NUMBER)
);

Learn More