|
|
DTW Production / NCM Code
API NCM Codes Setup Service / NCM Code Setup
ONCM - NCM Code Table
NCM Code Setup NCMCodeSetup Object· Table: ONCM
Parent: NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM
NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM
ONCM SQL 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 | L |
Table relationship map
SELECT statement
SELECT
ONCM.AbsEntry AS 'ID',
ONCM.NcmCode AS 'NCM Code',
ONCM.Descrip AS 'Description',
ONCM.LogInstanc AS 'Log Instance',
ONCM.UserSign2 AS 'Updating User',
ONCM.UpdateDate AS 'Update Date',
ONCM.GroupCode AS 'Group Code'
FROM ONCM AS ONCM
Related information
NCM Code Setup NCMCodeSetup Object· Table: ONCM
Represents an NCM code that can be assigned to an item.
Source table: ONCM
Mandatory properties: NCMCode, Description
Parent: NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM
The NCMCodesSetupService service enables you to add, look up and remove NCM codes in the NCM codes master data table. NCM codes can be assigned to items via the NCMCode field of the Items object.
To see the list of NCM codes, select Inventory...
ONCM SQL Table
Users OUSR SQL Table
NCMCodesSetupService
Object
NCMCodeSetup
Method
Property
AbsEntry
DB
Description
DB
NCMCode
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
