First you are doing a find first on empty temp tables after which you put the entire contents of pt_mstr and in_mstr and later you put a not equal to condition between the temp tables and pt_mstr and in_mstr where no records will be found since the temp tables will have all records of pt_mstr...
your required code might be something like this:
FOR EACH in_mstr WHERE <<selection criteria>>
BREAK BY in_domain
BY in_site
BY in_part:
IF FIRST-OF(in_domain) THEN
DISPLAY in_domain in_site.
DISPLAY in_part in_qty_oh.
ACCUMULATE in_qty_oh(TOTAL BY in_domain).
IF LAST-OF(in_domain) THEN...
Is there a way or a query to display the fields of a table like in the data dictionary. My purpose itself is to create something like a data dictionary which will allow the users to select fields from the desired tables.
In sales order maintenance 7.1.1 goto the third frame of the order you want to delete (order date starts here) and then press ctrl-d to delete the entire sales order.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.