|
|
API ODRC
ODRC - G/L Account Determination Criteria - Resources Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DmcId KEY UNIQUE | Determination ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DmcAlias | Determination Alias | nVarChar | 100 | |||||
| Active | Determination Status | VarChar | Y) Yes N) No | 1 | N | |||
| Priority | Determination Priority | Int | 6 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| AdvRulCol | Advanced Rules Column | Int | 6 |
SELECT statement
SELECT
ODRC.DmcId AS 'Determination ID',
ODRC.DmcAlias AS 'Determination Alias',
ODRC.Active AS 'Determination Status',
ODRC.Priority AS 'Determination Priority',
ODRC.LogInstanc AS 'Log Instance',
ODRC.UpdateDate AS 'Date of Update',
ODRC.UserSign AS 'User Signature',
ODRC.UserSign2 AS 'Updating User',
ODRC.AdvRulCol AS 'Advanced Rules Column'
FROM ODRC AS ODRC
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
