cancel
Showing results for 
Search instead for 
Did you mean: 

Production Order

Former Member
0 Kudos

Hi experts,

I have a production order with "Issue Method" = "BackFlush. The order is closed.

Now i want to make a query that retrives the items used in the Production Order.

Does anyone now in which table Sap B1 saves this information?

Regards,

Augusto Silva

Accepted Solutions (1)

Accepted Solutions (1)

lucas_fischer
Active Participant
0 Kudos

Augusto,

SAP saves the production order at document level in table OWOR and at the row level WOR1

hope this helps,

regards,

Lucas

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Use this query:

select t0.issuetype, t0.itemcode from WOR1 T0 inner join OWOR T1 on t0.docentry = t1.docentry where t1.itemcode = '[%0]'

Rajh

helen_sun
Active Participant
0 Kudos

Hi

I think if you would like to get a list of items that is used you could add more conditions like:

SELECT T0.ItemCode FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =[%0] and T1.IssuedQty =[%1]

or

SELECT T0.ItemCode FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =[%0] and T1.IssuedQty <> 0

Hope this can be helpful

Helen Sun

SAP Business One Forums Team

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

The details regarding the Production Order can be retrieved from OWOR and WOR1.

Cheers~

Jitin Chawla