|
|
SQL Reports / Query Catagories
API OQCN / / Query Categories
OQCN - Query Catagories Table
Query Categories QueryCategories Object· Table: OQCN
OQCN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CategoryId KEY UNIQUE | Category ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CatName KEY | Category Name | nVarChar | 50 | CAT_NAME_K | No | |||
| PermMask | Permissions | nVarChar | 20 | NNNNNNNNNNNNNNNNNNNN | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OQCN.CategoryId AS 'Category ID',
OQCN.CatName AS 'Category Name',
OQCN.PermMask AS 'Permissions',
OQCN.DataSource AS 'Data Source',
OQCN.UserSign AS 'User Signature'
FROM OQCN AS OQCN
Related information
Query Categories QueryCategories Object· Table: OQCN
QueryCategories is a business object that represents the query categories in the Queries Manager.
This object enables you to:
Add a query category.
Retrieve a query category by its key.
Update a query category.
Save the object in XML...
OQCN SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
