on 09-22-2023 7:01 PM
hello, I'm new to this and I wanted to make a query that shows me each production order and its variance, due to the variance cell in production order not a column in the OWOR table I'm unable to do it, I think the logical way is to make a query that calculate issued materials in each production order and multiple it with its cost then sum them all up giving me actual component cost, then another that calculate completed quantity and multiple it with item cost to give me actual product cost, then for the variance we subtract the total issued component cost from product completed cost.
is that right? And how do you go around making something like that?
System: SAP B1 HANA
Hi,
There are 2 views that contain detail of Production Order' transactions.
You can query data from them.
Hope this helps,
Son Tran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In SAP B1, you can use query generator
How to create simple querie:
example
User | Count |
---|---|
95 | |
7 | |
7 | |
6 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.