|
|
DTW Sales / Sales Quotation
API OPQW
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| SetName KEY UNIQUE | Set Name | nVarChar | 20 | SET_NAME | Yes | |||
| SetDesc | Set Description | nVarChar | 100 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| ModifyDate | Last Modified Date | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreatDraft | Create Drafts | VarChar | Y) Yes N) No | 1 | N | |||
| GroupBy | Group By | VarChar | B) Business Partner I) Item | 1 | B | |||
| ValidUntil | Valid Until Date | Date | 8 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| ReqDate | Required Date | Date | 8 | |||||
| BaseOn | Base On Type | VarChar | 1 |
Table relationship map
SELECT statement
SELECT
OPQW.AbsEntry AS 'Internal Number',
OPQW.SetName AS 'Set Name',
OPQW.SetDesc AS 'Set Description',
OPQW.CreateDate AS 'Creation Date',
OPQW.ModifyDate AS 'Last Modified Date',
OPQW.UserSign AS 'User Signature',
OPQW.CreatDraft AS 'Create Drafts',
OPQW.GroupBy AS 'Group By',
OPQW.ValidUntil AS 'Valid Until Date',
OPQW.BPLId AS 'Branch',
OPQW.ReqDate AS 'Required Date',
OPQW.BaseOn AS 'Base On Type'
FROM OPQW AS OPQW
Related information
OPQW SQL Table
Business Place OBPL SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates