|
|
API ADMC
ADMC - G/L Account Determination Criteria - Inventory - History 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 | 6 | 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
ADMC.DmcId AS 'Determination ID',
ADMC.DmcAlias AS 'Determination Alias',
ADMC.Active AS 'Determination Status',
ADMC.Priority AS 'Determination Priority',
ADMC.LogInstanc AS 'Log Instance',
ADMC.UpdateDate AS 'Date of Update',
ADMC.UserSign AS 'User Signature',
ADMC.UserSign2 AS 'Updating User',
ADMC.AdvRulCol AS 'Advanced Rules Column'
FROM ADMC AS ADMC
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