| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Production Order - Rows API Production Orders / Production Orders Lines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
WOR1 - Production Order - Rows Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
WOR1.DocEntry AS 'Document Internal Number',
WOR1.LineNum AS 'Row Number',
WOR1.ItemCode AS 'Item No.',
WOR1.BaseQty AS 'Base Quantity',
WOR1.PlannedQty AS 'Planned Quantity - Rows',
WOR1.IssuedQty AS 'Issued Quantity',
WOR1.IssueType AS 'Production Order Issue Type',
WOR1.wareHouse AS 'Warehouse',
WOR1.VisOrder AS 'Visual Order',
WOR1.WipActCode AS 'WIP Account Code',
WOR1.CompTotal AS 'Total Completed Sum',
WOR1.OcrCode AS 'Distribution Rule',
WOR1.OcrCode2 AS 'Distribution Rule2',
WOR1.OcrCode3 AS 'Distribution Rule3',
WOR1.OcrCode4 AS 'Distribution Rule4',
WOR1.OcrCode5 AS 'Distribution Rule5',
WOR1.LocCode AS 'Location Code',
WOR1.LogInstanc AS 'Log Instance',
WOR1.LoadFrBOM AS 'Child qty was loaded from BOM',
WOR1.Project AS 'Project Code',
WOR1.UomEntry AS 'UoM Entry',
WOR1.UomCode AS 'UoM Code',
WOR1.ItemType AS 'Item Type',
WOR1.AdditQty AS 'Additional Quantity',
WOR1.LineText AS 'Row Text',
WOR1.PickStatus AS 'Pick Status',
WOR1.PickQty AS 'Pick Quantity',
WOR1.PickIdNo AS 'Pick List ID Number',
WOR1.ReleaseQty AS 'Released Quantity',
WOR1.ResAlloc AS 'Resource Allocation'
FROM WOR1 AS WOR1 Related informationProduction Orders Lines ProductionOrders_Lines Object· Table: WOR1 The ProductionOrders_Lines is a child object of the ProductionOrders object. Each line represents a component (item) of the product.
Source table: WOR1. ![]() Production Order OWOR SQL Table Location OLCT SQL Table Distribution Rule OOCR SQL Table Project Codes OPRJ SQL Table UoM Master Data OUOM SQL Table Warehouses OWHS SQL Table G/L Accounts OACT SQL Table |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |