DRFD_APPL_FILT_C
FilterCriteria
DRFD_APPL_FILT_C is an SAP database table in S/4HANA. FilterCriteria. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DRFFilterItem | view_entity | from | BASIC | DRF Filter Criteria Item |
| R_MDODRFAPPLFILTERBASE | view_entity | inner | DRF Filters Base View |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_name_long | CHAR32 | Character field, length 32 | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| parent_key | /BOBF/CONF_KEY | NodeID | ||||
| node_cat_key | /BOBF/CONF_KEY | NodeID | ||||
| filter_id | DRF_FILTER | Filter | ||||
| table_name | DRF_TABNAME | Table Name | ||||
| field_name | DRF_FIELDNAME | Field Name | ||||
| sign | DRF_TVARV_SIGN | INCL/EXCL | ||||
| opt | DRF_TVARV_OPTI | Option | ||||
| low | DRF_RSDSSELOP | Selection | ||||
| high | DRF_RSDSSELOP | Selection | ||||
| creation_date | TIMESTAMP | Time Stamp | ||||
| created_by | XUBNAME | User | ||||
| change_date | TIMESTAMP | Time Stamp | ||||
| changed_by | XUBNAME | User |
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.
-- FilterCriteria
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRFD_APPL_FILT_C (
MANDT, -- Client [MANDT]
DB_NAME_LONG, -- Character field, length 32 [CHAR32]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
PARENT_KEY, -- NodeID [/BOBF/CONF_KEY]
NODE_CAT_KEY, -- NodeID [/BOBF/CONF_KEY]
FILTER_ID, -- Filter [DRF_FILTER]
TABLE_NAME, -- Table Name [DRF_TABNAME]
FIELD_NAME, -- Field Name [DRF_FIELDNAME]
SIGN, -- INCL/EXCL [DRF_TVARV_SIGN]
OPT, -- Option [DRF_TVARV_OPTI]
LOW, -- Selection [DRF_RSDSSELOP]
HIGH, -- Selection [DRF_RSDSSELOP]
CREATION_DATE, -- Time Stamp [TIMESTAMP]
CREATED_BY, -- User [XUBNAME]
CHANGE_DATE, -- Time Stamp [TIMESTAMP]
CHANGED_BY, -- User [XUBNAME]
PRIMARY KEY (MANDT, DB_NAME_LONG, DB_KEY)
);
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