SRF_TYPE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_StRpSchemaType | view_entity | from | BASIC | Type definition |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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]
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA