|
|
SQL Administration / NCM Code
DTW Others / WorkOrders
API ANCM
ANCM - NCM Code Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| NcmCode KEY UNIQUE | NCM Code | nVarChar | 15 | CODE | Yes | |||
| Descrip | Description | nVarChar | 127 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| GroupCode | Group Code | VarChar | 1 | 0 |
SELECT statement
SELECT
ANCM.AbsEntry AS 'ID',
ANCM.NcmCode AS 'NCM Code',
ANCM.Descrip AS 'Description',
ANCM.LogInstanc AS 'Log Instance',
ANCM.UserSign2 AS 'Updating User',
ANCM.UpdateDate AS 'Update Date',
ANCM.GroupCode AS 'Group Code'
FROM ANCM AS ANCM
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
