|
|
API UWKO
UWKO - Production Instructions Table
G/L Accounts OACT SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Users OUSR SQL Table
Posting Period OFPR SQL Table
Object Settings - History ADP1 SQL Table
Price Lists OPLN SQL Table
Documents Numbering - Series NNM1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OrderNum KEY UNIQUE | Instruction Key | Int | 11 | 0 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Status | Processing Status | VarChar | O) Work Instructions I) Work Instructions E) Production Completed | 1 | O | |||
| Canceled | Order Canceled Yes/No | VarChar | Y) Canceled N) Not Canceled | 1 | N | |||
| OrderDate | Order Date | Date | 8 | |||||
| ProdctDate | Work Start Date | Date | 8 | |||||
| ExpFinishD | Expected Completion Date | Date | 8 | |||||
| FinishDate | Work Finish Date | Date | 8 | |||||
| FinishUser | Name of Person Receiving Instructions | nVarChar | 8 | OUSR Users | ||||
| CardCode | Sold-To-Party Code | nVarChar | 15 | OCRD Business Partner | ||||
| CustomName | Sold-To-Party Name | nVarChar | 100 | |||||
| NumInCustm | Customer Ref. No. | nVarChar | 16 | |||||
| TotalOrder | Order Total | Num | 20 | |||||
| TotalCurr | Total Currency | nVarChar | 3 | |||||
| DocTime | Generation Time | Int | 6 | |||||
| Memo | Remarks | nVarChar | 127 | |||||
| SerialNum KEY UNIQUE | Instruction Number | Int | 11 | SERIAL | Yes | |||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | 0 | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Transfered | Postponed to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| Series KEY | Series | Int | 6 | NNM1 Documents Numbering - Series | SERIES | No | ||
| ActWorkCod | Active Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| ActWorkSum | Work Total | Num | 20 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 68 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| PriceList | Price List | Int | 6 | OPLN Price Lists | 1 | |||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| SysRate | System Rate | Num | 20 |
Table relationship map
SELECT statement
SELECT
UWKO.OrderNum AS 'Instruction Key',
UWKO.Status AS 'Processing Status',
UWKO.Canceled AS 'Order Canceled Yes/No',
UWKO.OrderDate AS 'Order Date',
UWKO.ProdctDate AS 'Work Start Date',
UWKO.ExpFinishD AS 'Expected Completion Date',
UWKO.FinishDate AS 'Work Finish Date',
UWKO.FinishUser AS 'Name of Person Receiving Instructions',
UWKO.CardCode AS 'Sold-To-Party Code',
UWKO.CustomName AS 'Sold-To-Party Name',
UWKO.NumInCustm AS 'Customer Ref. No.',
UWKO.TotalOrder AS 'Order Total',
UWKO.TotalCurr AS 'Total Currency',
UWKO.DocTime AS 'Generation Time',
UWKO.Memo AS 'Remarks',
UWKO.SerialNum AS 'Instruction Number',
UWKO.CntctCode AS 'Contact Person',
UWKO.UpdateDate AS 'Date of Update',
UWKO.CreateDate AS 'Creation Date',
UWKO.Transfered AS 'Postponed to Next Year',
UWKO.Instance AS 'Instance',
UWKO.Series AS 'Series',
UWKO.ActWorkCod AS 'Active Account Code',
UWKO.ActWorkSum AS 'Work Total',
UWKO.JrnlMemo AS 'Journal Remarks',
UWKO.DataSource AS 'Data Source',
UWKO.ObjType AS 'Object Type',
UWKO.UserSign AS 'User Signature',
UWKO.PriceList AS 'Price List',
UWKO.FinncPriod AS 'Posting Period',
UWKO.SysRate AS 'System Rate'
FROM UWKO AS UWKO
Related information
G/L Accounts OACT SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Users OUSR SQL Table
Posting Period OFPR SQL Table
Object Settings - History ADP1 SQL Table
Price Lists OPLN SQL Table
Documents Numbering - Series NNM1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
