SRF_QUERY_FILTER - Query filter definition
Query filter definition information is stored in SAP table SRF_QUERY_FILTER.
It is part of development package GLO_GEN_SRF_AUTHORING in software component FI-LOC-SRF-DEF. This development package consists of objects that can be grouped under "Statutory Reporting Framework Authoring".
It is part of development package GLO_GEN_SRF_AUTHORING in software component FI-LOC-SRF-DEF. This development package consists of objects that can be grouped under "Statutory Reporting Framework Authoring".
Fields for table SRF_QUERY_FILTER
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | SRFS_REPORT_QUERY_ID | 0 | |||
| REPORT_ID | Report Definition | X | SRF_REPORT_ID | CHAR | 60 | SRF_QUERY |
| REPORT_VERSION | Version of a report definition | X | SRF_REPORT_VERSION | CHAR | 6 | |
| QUERY_ID | Database query ID | X | SRF_QUERY_ID | CHAR | 60 | SRF_QUERY |
| SEQUENCE_NUMBER | Technical Enumerator for Key Fields | X | SRF_SEQUENCE_NUMBER | NUMC | 8 | |
| COLUMN_NAME | Database view column name | SRF_COLUMN_NAME | CHAR | 512 | ||
| SIGN | Type of SIGN component in row type of a Ranges type | DDSIGN | CHAR | 2 | ||
| OPTI | Type of OPTION component in row type of a Ranges type | DDOPTION | CHAR | 4 | ||
| .INCLU-_L | S_DATA_SOURCE_LOW | SRFS_DATA_SOURCE | 0 | |||
| SOURCE_TYPE_L | Type of a value source | SRF_SOURCE_TYPE | CHAR | 6 | ||
| REP_VAR_ID_L | ID of report variable (parameter or system field) | SRF_REPORT_VARIABLE_ID | CHAR | 60 | ||
| QUERY_ID_L | Database query ID | SRF_QUERY_ID | CHAR | 60 | ||
| COLUMN_NAME_L | Database view column name | SRF_COLUMN_NAME | CHAR | 512 | ||
| ROW_KEY_ID_L | Row key for random access query | SRF_ROW_KEY_ID | CHAR | 32 | * | |
| DOCUMENT_ID_L | Document ID | SRF_DOCUMENT_ID | CHAR | 60 | ||
| ELEMENT_ID_L | Element identificator | SRF_ELEMENT_ID | CHAR | 20 | ||
| ATTRIBUTE_ID_L | Attribute identificator | SRF_ATTRIBUTE_ID | CHAR | 10 | ||
| VALUE_L | Value container | SRF_VALUE | SSTR | 8 | ||
| .INCLU-_H | S_DATA_SOURCE_HIGH | SRFS_DATA_SOURCE | 0 | |||
| SOURCE_TYPE_H | Type of a value source | SRF_SOURCE_TYPE | CHAR | 6 | ||
| REP_VAR_ID_H | ID of report variable (parameter or system field) | SRF_REPORT_VARIABLE_ID | CHAR | 60 | ||
| QUERY_ID_H | Database query ID | SRF_QUERY_ID | CHAR | 60 | ||
| COLUMN_NAME_H | Database view column name | SRF_COLUMN_NAME | CHAR | 512 | ||
| ROW_KEY_ID_H | Row key for random access query | SRF_ROW_KEY_ID | CHAR | 32 | * | |
| DOCUMENT_ID_H | Document ID | SRF_DOCUMENT_ID | CHAR | 60 | ||
| ELEMENT_ID_H | Element identificator | SRF_ELEMENT_ID | CHAR | 20 | ||
| ATTRIBUTE_ID_H | Attribute identificator | SRF_ATTRIBUTE_ID | CHAR | 10 | ||
| VALUE_H | Value container | SRF_VALUE | SSTR | 8 |