|
|
DTW Production Order - Base
API Production Orders / Production Orders Sales Order Lines
WOR2 - Production Order - Base Table
Production Orders Sales Order Lines ProductionOrders_SalesOrderLines Object· Table: WOR2
Parent: Production Orders ProductionOrders Object· Table: OWOR
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 | |||||
| BaseLine | Production Order Base Line | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
WOR2.DocEntry AS 'Document Internal Number',
WOR2.BaseEntry AS 'Production Order Base Entry',
WOR2.BaseNum AS 'Production Order Base Number',
WOR2.BaseLine AS 'Production Order Base Line',
WOR2.LogInstanc AS 'Log Instance'
FROM WOR2 AS WOR2
Related information
Production Orders Sales Order Lines ProductionOrders_SalesOrderLines Object· Table: WOR2
The ProductionOrders_SalesOrderLines is a child object of the ProductionOrders object. You can set the sales order to which to link the production order.
Source table: WOR2.
Parent: Production Orders ProductionOrders Object· Table: OWOR Sales Order ORDR SQL Table
Production Order OWOR SQL Table
ProductionOrders
Object
ProductionOrders_SalesOrderLines
Method
Property
BaseAbsEntry
DB
BaseLine
DB
BaseNumber
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
