|
|
DTW Sales / AR Credit Memo
API OPCI
OPCI - Process Checklist Instance Table
OPCI SQL Table
Process Checklist Template OPCT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | InstancePk KEY UNIQUE | Instance Primary Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TemplateFk | Template Foreign Key | Int | 11 | OPCT Process Checklist Template | ||||
| InstName | Instance Name | nVarChar | 100 | |||||
| InstDesc | Instance Description | nVarChar | 100 | |||||
| Creator | Instance Creator | nVarChar | 100 | |||||
| Status | Instance Status | VarChar | N) New P) In Process F) Finished | 1 | N | |||
| StartDate | Start Date | Date | 8 | |||||
| CloseDate | Close Date | Date | 8 | |||||
| CloPrcnt | Closing Percentage | Num | 20 | |||||
| Memo | Remarks | Text | 16 | |||||
| Attachment | Attachment | Text | 16 | |||||
| AtcEntry | Attachment Entry | Int | 11 |
Table relationship map
SELECT statement
SELECT
OPCI.InstancePk AS 'Instance Primary Key',
OPCI.TemplateFk AS 'Template Foreign Key',
OPCI.InstName AS 'Instance Name',
OPCI.InstDesc AS 'Instance Description',
OPCI.Creator AS 'Instance Creator',
OPCI.Status AS 'Instance Status',
OPCI.StartDate AS 'Start Date',
OPCI.CloseDate AS 'Close Date',
OPCI.CloPrcnt AS 'Closing Percentage',
OPCI.Memo AS 'Remarks',
OPCI.Attachment AS 'Attachment',
OPCI.AtcEntry AS 'Attachment Entry'
FROM OPCI AS OPCI
Related information
OPCI SQL Table
Process Checklist Template OPCT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
