|
|
API WOR2V
WOR2V - Production Order - Base Table
Sales Order ORDR SQL Table
Production Order OWOR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal Number | Int | 11 | OWOR Production Order | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BaseEntry | Production Order Base Entry | Int | 11 | ORDR Sales Order | ||||
| BaseNum | Production Order Base Number | Int | 11 | |||||
| CardCode | Customer Code | nVarChar | 15 | |||||
| PostDate | Posting Date | nVarChar | 8 | |||||
| DueDate | Due Date | nVarChar | 8 | |||||
| DocTotal | Document Total | Num | 20 | |||||
| Remark | Document Remarks | nVarChar | 127 | |||||
| DocCur | Document Currency | nVarChar | 3 |
Table relationship map
SELECT statement
SELECT
WOR2V.DocEntry AS 'Document Internal Number',
WOR2V.BaseEntry AS 'Production Order Base Entry',
WOR2V.BaseNum AS 'Production Order Base Number',
WOR2V.CardCode AS 'Customer Code',
WOR2V.PostDate AS 'Posting Date',
WOR2V.DueDate AS 'Due Date',
WOR2V.DocTotal AS 'Document Total',
WOR2V.Remark AS 'Document Remarks',
WOR2V.DocCur AS 'Document Currency'
FROM WOR2V AS WOR2V
Related information
Sales Order ORDR SQL Table
Production Order OWOR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates