Current Position:Home > Production Order Report - System Query

Production Order Report - System Query

Update:11-30Source: network consolidation
Advertisement
The Production Order Report in v2005A SP01 is not implemented in v2007A.
This report is important to some of our B1 user customers.
If the 2005A report is copied and pasted into the Query Generator in 2007A, it appears to work correctly, but the risk is that:-
(a) table changes which have been made have effects which aren't apparent on normal inspection, and
(b) it will eventually be lost during upgrades and users will have to recreate it themselves, for which many don't have the expertise.
Please verify that the functionality of the 2005A query remains correct in 2007A, and reinstate it as a system query in a future release.
Regards,
Mike Burmeister

The Best Answer

Advertisement
Hi,
In SAP B1 2007A SP01 PL10, there is a change log. You can check all the differences made by user in the pass in the change log.
the table is AWOR. The product no. is taken from OITM. You can use both table in order to find out the comparison
JimM
  • Production Order Report - System Query Update:11-30

    The Production Order Report in v2005A SP01 is not implemented in v2007A. This report is important to some of our B1 user customers. If the 2005A report is copied and pasted into the Query Generator in 2007A, it appears to work correctly, but the risk

  • Production order information system Update:11-30

    Hi All, We use the standard production order information system COOIS t-code. There is a option to include/exclude system statuses in the selection. But this is restricted to two options. Can this field be increased to higher number to have more filt

  • User Exit For production Order Information System Update:11-30

    Dear All, I am looking for an User Exit,BADi's for production order Information System where i can see the Quantity which is already produced & The Quantity which is already passed from Quality.I mean the GR Quantity against the Production Order and

  • Creation of production order report as per format Update:10-11

    Hi!!!! Gurus!!!!! I want production order report in some required format. How to see the format on production order How to see the report in the following format. Company name:- Material requirement Number:- date :- Time:- Due Date:- Plan Date:- Prod

  • Creation of production order report Update:10-11

    Dear, Gurus !!!!! I am working on production order report. Could you give me some idea how to create a production order ,stock overview report and    work center reports. How I see it . Regards, NitinDear Nitin, use std report availble 1. production

  • Production order report Update:11-30

    Can any suggest me the SAP Standard production order report apart from COOIS . Thanks JJhi  jj OPtoin 1 .    you will get the data for production in AFRU table. and afpo table for material. you can use the following code. select     aufnr            

  • Production Order Report with Cost Update:10-11

    Hi, I am trying to create a report using query to show the production order details, including the components item code (can be inventory or non-inventory), issued qty, component cost of each component and product cost. Can anyone help? Thanks.Hi, Tr

  • Production order report on Daily Update:10-11

    Hi gurus, I tried to create a report for production orders. it contain four selection parameters. Here i am using four tables 1) crhd 2)  caufv 3) aufk 4) afru 5) zbreak ( this is a ztable created by me ) .  i need the fields like date,work centre, p

  • Open production orders report Update:10-11

    Dear Experts, Please what are the standard tcodes I can use to get a report on all open production orders from the system?Hi Vincent, You can use the T code COOIS for the comprehensive report of production report. As you say you need to check the ope

  • COOIS : Production Order Information System Update:11-30

    Hi, In COOIS Report at header level, Report has a column order Type. Where as in Component level report does not have order type. Is there is any logic that order type has to be at header level not at component level. If not then there is any  report