SRF_TYPE

Transparent Table System Table (transport)

Type definition

SRF_TYPE is an SAP database table in S/4HANA. Type definition. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StRpSchemaType view_entity from BASIC Type definition

Fields (16)

KeyField Data ElementDescription DomainTypeLength
namespace_id srf_namespace_id Namespace Id
type_name srf_type_name Type Name
xsd_built_in_type srf_xsd_built_in_type XSD built-in type
validation_pattern srf_validation_pattern_expr Pattern expression
min_length srf_value_min_length Minimal length
max_length srf_value_max_length Maximal Length
total_digits srf_total_digits Total digits
fraction_digits srf_fraction_digits Fraction digits
parent_type_id srf_type_id Type Id
st_type srf_xsd_st_coll_type collection type
minexclusive srf_xsd_minexcl lower bound (excl.)
mininclusive srf_xsd_minincl lower bound (incl.)
maxexclusive srf_xsd_maxexcl upper bound (excl.)
maxinclusive srf_xsd_maxincl upper bound (incl.)
length srf_value_length Length
whitespace srf_xsd_whitespace whitespace handling

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.

-- Type definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRF_TYPE (
    NAMESPACE_ID,        -- Namespace Id [srf_namespace_id]
    TYPE_NAME,           -- Type Name [srf_type_name]
    XSD_BUILT_IN_TYPE,   -- XSD built-in type [srf_xsd_built_in_type]
    VALIDATION_PATTERN,  -- Pattern expression [srf_validation_pattern_expr]
    MIN_LENGTH,          -- Minimal length [srf_value_min_length]
    MAX_LENGTH,          -- Maximal Length [srf_value_max_length]
    TOTAL_DIGITS,        -- Total digits [srf_total_digits]
    FRACTION_DIGITS,     -- Fraction digits [srf_fraction_digits]
    PARENT_TYPE_ID,      -- Type Id [srf_type_id]
    ST_TYPE,             -- collection type [srf_xsd_st_coll_type]
    MINEXCLUSIVE,        -- lower bound (excl.) [srf_xsd_minexcl]
    MININCLUSIVE,        -- lower bound (incl.) [srf_xsd_minincl]
    MAXEXCLUSIVE,        -- upper bound (excl.) [srf_xsd_maxexcl]
    MAXINCLUSIVE,        -- upper bound (incl.) [srf_xsd_maxincl]
    LENGTH,              -- Length [srf_value_length]
    WHITESPACE           -- whitespace handling [srf_xsd_whitespace]
);