KSR_CFG_SQL
KSR: SQL Trace Filters
KSR_CFG_SQL is an SAP database table in S/4HANA. KSR: SQL Trace Filters. It contains 9 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_KSR_CFG_SQL_M | view_entity | from | KSR-CFG: SQL Trace Filters View |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | profile_id | KSR_CFG_V_PROFILE_ID | Profile ID | |||
| KEY | field_id | KSR_CFG_V_FIELD_ID | Field ID | |||
| KEY | range_line | KSR_CR_V_POSITION | Position | |||
| sign | DDSIGN | Type of SIGN component in row type of a Ranges type | ||||
| range_option | DDOPTION | Type of OPTION component in row type of a Ranges type | ||||
| range_option_hlp | KSR_CFG_V_OP | Operator ID | ||||
| low | KSR_CFG_V_FILTER_VALUE | Filter Value | ||||
| high | KSR_CFG_V_FILTER_VALUE | Filter Value |
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.
-- KSR: SQL Trace Filters
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_CFG_SQL (
CLIENT, -- Client [MANDT]
PROFILE_ID, -- Profile ID [KSR_CFG_V_PROFILE_ID]
FIELD_ID, -- Field ID [KSR_CFG_V_FIELD_ID]
RANGE_LINE, -- Position [KSR_CR_V_POSITION]
SIGN, -- Type of SIGN component in row type of a Ranges type [DDSIGN]
RANGE_OPTION, -- Type of OPTION component in row type of a Ranges type [DDOPTION]
RANGE_OPTION_HLP, -- Operator ID [KSR_CFG_V_OP]
LOW, -- Filter Value [KSR_CFG_V_FILTER_VALUE]
HIGH, -- Filter Value [KSR_CFG_V_FILTER_VALUE]
PRIMARY KEY (CLIENT, PROFILE_ID, FIELD_ID, RANGE_LINE)
);
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