|
|
SQL Administration / Folder
DTW Human Resources / Employee Master Data
API CUMF
CUMF - Folder Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FolderId KEY UNIQUE | Folder Key | Int | 11 | 0 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FolderName | Folder Name | nVarChar | 50 | |||||
| SortNum | Sort Number | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| FatherId | Parent Key | Int | 11 | -1 |
SELECT statement
SELECT
CUMF.FolderId AS 'Folder Key',
CUMF.FolderName AS 'Folder Name',
CUMF.SortNum AS 'Sort Number',
CUMF.UserSign AS 'User Signature',
CUMF.FatherId AS 'Parent Key'
FROM CUMF AS CUMF
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates