SRF_ELEMENT

Transparent Table System Table (transport)
19 Fields 3 CDS Views

Element definition

SRF_ELEMENT is an SAP database table in S/4HANA. Element definition. It contains 19 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_StRpSchemaElement view_entity from BASIC Element definition
SRFD_DocumentDataFilterBase view_entity inner Base view for preview filter grouping
SRFD_SchemaElement view from Schema Elements Metadata

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY schema_id SRF_SCHEMA_ID Schema Id
KEY schema_version SRF_SCHEMA_VERSION Schema Version
KEY element_id SRF_ELEMENT_ID Element Id
ordinal_number SRF_ORDINAL_NUMBER Number
element_name SRF_ELEMENT_NAME Element Name
parent_element_id SRF_PARENT_ELEMENT_ID Parent Id
namespace_id SRF_NAMESPACE_ID Namespace Id
min_occurs SRF_MIN_OCCURS Minimal Occurs
max_occurs SRF_MAX_OCCURS Maximum Occurs
is_nillable SRF_IS_NILLABLE Is nillable
is_abstract SRF_IS_ABSTRACT Abstract
default_value SRF_DEFAULT_VALUE Default value
fixed_value SRF_FIXED_VALUE Fixed value
type_id SRF_TYPE_ID Type Id
collection_type SRF_XSD_EL_COLL_TYPE collection type
substitutiongroup SRF_SUBSTITUTION_GROUP Subs. Group
period_type SRF_PERIOD_TYPE Period Type
balance SRF_BALANCE Balance
reference_element_id SRF_REFERENCE_ELEMENT_ID Reference element Id

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.

-- Element definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRF_ELEMENT (
    SCHEMA_ID,             -- Schema Id [SRF_SCHEMA_ID]
    SCHEMA_VERSION,        -- Schema Version [SRF_SCHEMA_VERSION]
    ELEMENT_ID,            -- Element Id [SRF_ELEMENT_ID]
    ORDINAL_NUMBER,        -- Number [SRF_ORDINAL_NUMBER]
    ELEMENT_NAME,          -- Element Name [SRF_ELEMENT_NAME]
    PARENT_ELEMENT_ID,     -- Parent Id [SRF_PARENT_ELEMENT_ID]
    NAMESPACE_ID,          -- Namespace Id [SRF_NAMESPACE_ID]
    MIN_OCCURS,            -- Minimal Occurs [SRF_MIN_OCCURS]
    MAX_OCCURS,            -- Maximum Occurs [SRF_MAX_OCCURS]
    IS_NILLABLE,           -- Is nillable [SRF_IS_NILLABLE]
    IS_ABSTRACT,           -- Abstract [SRF_IS_ABSTRACT]
    DEFAULT_VALUE,         -- Default value [SRF_DEFAULT_VALUE]
    FIXED_VALUE,           -- Fixed value [SRF_FIXED_VALUE]
    TYPE_ID,               -- Type Id [SRF_TYPE_ID]
    COLLECTION_TYPE,       -- collection type [SRF_XSD_EL_COLL_TYPE]
    SUBSTITUTIONGROUP,     -- Subs. Group [SRF_SUBSTITUTION_GROUP]
    PERIOD_TYPE,           -- Period Type [SRF_PERIOD_TYPE]
    BALANCE,               -- Balance [SRF_BALANCE]
    REFERENCE_ELEMENT_ID,  -- Reference element Id [SRF_REFERENCE_ELEMENT_ID]
    PRIMARY KEY (SCHEMA_ID, SCHEMA_VERSION, ELEMENT_ID)
);

Learn More