SRF_MAPPING

Transparent Table System Table (transport)
20 Fields 3 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 20 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_DART_Z3_QUERY_FIELD view from Dart Z3 Field View
I_StRpReportDocMapping view_entity from BASIC Info about Mapping of data sources
srfv_mapping_ddl view from Mapping with element and attribute names

Fields (20)

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
source_type_s SRF_SOURCE_TYPE Source type
rep_var_id_s SRF_REPORT_VARIABLE_ID Report Variable ID
query_id_s SRF_QUERY_ID Query ID
column_name_s SRF_COLUMN_NAME Column name
row_key_id_s SRF_ROW_KEY_ID Row Key ID
document_id_s SRF_DOCUMENT_ID Document ID
element_id_s SRF_ELEMENT_ID Element Id
attribute_id_s SRF_ATTRIBUTE_ID Attribute Id
value_s SRF_VALUE Value
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]
    SOURCE_TYPE_S,                  -- Source type [SRF_SOURCE_TYPE]
    REP_VAR_ID_S,                   -- Report Variable ID [SRF_REPORT_VARIABLE_ID]
    QUERY_ID_S,                     -- Query ID [SRF_QUERY_ID]
    COLUMN_NAME_S,                  -- Column name [SRF_COLUMN_NAME]
    ROW_KEY_ID_S,                   -- Row Key ID [SRF_ROW_KEY_ID]
    DOCUMENT_ID_S,                  -- Document ID [SRF_DOCUMENT_ID]
    ELEMENT_ID_S,                   -- Element Id [SRF_ELEMENT_ID]
    ATTRIBUTE_ID_S,                 -- Attribute Id [SRF_ATTRIBUTE_ID]
    VALUE_S,                        -- Value [SRF_VALUE]
    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