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