|
|
API OUQR / User Queries
OUQR - Queries Table
User Queries UserQueries Object· Table: OUQR
OUQR SQL Table
Query Catagories OQCN SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | IntrnalKey KEY UNIQUE | Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| QCategory | Query Category | Int | 11 | OQCN Query Catagories | ||||
| QName KEY UNIQUE | Query Description | nVarChar | 100 | QNAME_K | Yes | |||
| QString | Query | Text | 16 | |||||
| QType | Query Type | VarChar | R) Regular W) Wizard G) Report Generator S) Stored Procedure | 1 | W | |||
| ColumnSize | Column Size | nVarChar | 100 | |||||
| DBType | DB Type | Int | 11 | |||||
| QLastDate | Last Upload Date | Date | 8 | |||||
| QLastTime | Last Upload Time | Int | 6 | |||||
| Xslt | XSLT Transformation | Text | 16 |
Table relationship map
SELECT statement
SELECT
OUQR.IntrnalKey AS 'Internal Key',
OUQR.QCategory AS 'Query Category',
OUQR.QName AS 'Query Description',
OUQR.QString AS 'Query',
OUQR.QType AS 'Query Type',
OUQR.ColumnSize AS 'Column Size',
OUQR.DBType AS 'DB Type',
OUQR.QLastDate AS 'Last Upload Date',
OUQR.QLastTime AS 'Last Upload Time',
OUQR.Xslt AS 'XSLT Transformation'
FROM OUQR AS OUQR
Related information
User Queries UserQueries Object· Table: OUQR
The UserQueries object enables to define user queries in the Queries Manager.
Source table: OUQR.
OUQR SQL Table
Query Catagories OQCN SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
