SRF_QUERY_PAR - Definition of database query parameters
Definition of database query parameters information is stored in SAP table SRF_QUERY_PAR.
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_PAR
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 | |
| REPORT_VERSION | Version of a report definition | X | SRF_REPORT_VERSION | CHAR | 6 | |
| QUERY_ID | Database query ID | X | SRF_QUERY_ID | CHAR | 60 | * |
| QUERY_PARAM_NAME | Name of a query parameter | X | SRF_QUERY_PARAM_NAME | CHAR | 60 | |
| .INCLU-_S | S_DATA_SOURCE | SRFS_DATA_SOURCE | 0 | |||
| SOURCE_TYPE_S | Type of a value source | SRF_SOURCE_TYPE | CHAR | 6 | ||
| REP_VAR_ID_S | ID of report variable (parameter or system field) | SRF_REPORT_VARIABLE_ID | CHAR | 60 | ||
| QUERY_ID_S | Database query ID | SRF_QUERY_ID | CHAR | 60 | ||
| COLUMN_NAME_S | Database view column name | SRF_COLUMN_NAME | CHAR | 512 | ||
| ROW_KEY_ID_S | Row key for random access query | SRF_ROW_KEY_ID | CHAR | 32 | * | |
| DOCUMENT_ID_S | Document ID | SRF_DOCUMENT_ID | CHAR | 60 | ||
| ELEMENT_ID_S | Element identificator | SRF_ELEMENT_ID | CHAR | 20 | ||
| ATTRIBUTE_ID_S | Attribute identificator | SRF_ATTRIBUTE_ID | CHAR | 10 | ||
| VALUE_S | Value container | SRF_VALUE | SSTR | 8 |