Work center wise production order infomation report

[Former Member]

Hi all,

i have a requirement that workcenter wise (with date) production order information with quantity details (plan and actual).

Eg: My production order quantity - 40 nos. (it takes 4 days to finish).

i have three operation in production order.

my order scheduled start date - todays date.

In standard, when enter my first operation work center, system showing production order and its quantity (40 nos) . but i need to split that order quantity in report.. means on todays date for particular production order - order quantity = 10 nos.

Clent want like that (with quantity break) report..

Any standard report ???

If customization.... How it can be mapped in SAP.??

Thanks in advance

[Former Member · Accepted solution]

Hi,

you can use the query like this:

This will give you all the orders for workcenter with system status:

SELECT caufv_{aufnr tj02t}txt04 tj02t~txt30

INTO TABLE tmp_e_order

FROM ( ( ( ( caufv

INNER JOIN aufk ON aufk_{aufnr = caufv}aufnr )

INNER JOIN jest ON aufk_{objnr = jest}objnr )

INNER JOIN tj02t ON jest_{stat = tj02t}istat )

INNER JOIN crhd ON crhd_{werks = caufv}werks )

WHERE ( caufv~autyp = lv_autyp_prod "#EC CI_BUFFJOIN "10

OR caufv~autyp = lv_autyp_proc ) "40

AND caufv~werks IN lt_range_plant

AND crhd~arbpl IN lt_range_workcenter

AND jest~inact NE abap_true.

in CAUFV~GAMNG you will get the order quantity: Operation and Order you 'll get 1:1 quantity for Finish product. For the

component you 'll get the detail in RESB_{RSNUM wich has a join RESB}AUFPL = AFVC_{AUFPL = CAUFV}AUFPL and in Caufv you will have AUFNR ( Order No). At CAUFV~GSUZS you get the schedule start date. So aftre selecting the orders you do a filtering on GSUZS and show it with a split.

The solution is for both PP/PI order. So please use it according to your requirement.

You can try COHV transaction as well.

Thanks and regards,

Pradip

[Former Member · Accepted solution]

Hi Pradip

Thanks for your reply ..

I will check that and get back you..

Thanks

[Former Member · Accepted solution]

Hi,

You can use the FM COIS_SELECT_ORDER_DATA_READ.

CALL FUNCTION 'COIS_SELECT_ORDER_DATA_READ'
      EXPORTING
        iv_prod_order_sel       = lv_prod_order_sel 
        iv_proc_order_sel       = lv_proc_order_sel
        iv_planned_order_sel    = lv_planned_order_sel
        iv_rem_objects_only_sel = lv_rem_objects_only_sel
        is_objects_to_read      = ls_objects_to_read
        it_parameter            = lt_parameter  "General Structure for PARAMETERS and SELECT-OPTIONS
        it_status_hdr           = lt_status_hdr
        it_status_opr           = lt_status_opr
        it_status_cmp           = lt_status_cmp
      TABLES
        ct_ioheader             = lt_ioheader
        ct_ioitem               = lt_ioitem
        ct_iodocl               = lt_iodocl
        ct_ioopdocl             = lt_ioopdocl
        ct_iomamo               = lt_iomamo
        ct_ioconf               = lt_ioconf
        ct_ioopconf             = lt_ioopconf
        ct_iosoconf             = lt_iosoconf
        ct_iogomo               = lt_iogomo
        ct_ioopgomo             = lt_ioopgomo
        ct_iosogomo             = lt_iosogomo
        ct_iogmer               = lt_iogmer
        ct_ioopgmer             = lt_ioopgmer
        ct_iosogmer             = lt_iosogmer
        ct_iosequen             = lt_iosequen
        ct_iooper               = lt_iooper
        ct_iosoper              = lt_iosoper
        ct_ioopcomp             = lt_ioopcomp
        ct_iooppreq             = lt_iooppreq
        ct_iosopreq             = lt_iosopreq
        ct_iooppord             = lt_iooppord
        ct_iosopord             = lt_iosopord
        ct_ioopmst              = lt_ioopmst
        ct_ioopprt              = lt_ioopprt
        ct_ioopcap              = lt_ioopcap
        ct_ioopscap             = lt_ioopscap
        ct_iosocap              = lt_iosocap
        ct_iososcap             = lt_iososcap
        ct_ioopsccf             = lt_ioopsccf
        ct_iososccf             = lt_iososccf
        ct_ioprodlist           = lt_ioprodlist
        ct_iomatver             = lt_iomatver.

This FM get data from the report used by transaction COOIS. If you needed the header data then you can use lt_ioheader table and seperate the data with the date. If you need at operation basis the you can use lt_iosoper table. You can use this FM to create custom report even with the checks like material availability, PRT availability, capacity requirement etc.

Thanks and regards,

Pradip

Edited by: Pradip Ray on Aug 26, 2009 8:26 AM

Edited by: Pradip Ray on Aug 26, 2009 8:26 AM

Edited by: Pradip Ray on Aug 26, 2009 8:26 AM

Edited by: Pradip Ray on Aug 26, 2009 8:27 AM

[Former Member]

hi buddy

there is STD report CO28 then go to confirmation radio button, select the profile as std. give ur prod. order no, plant, put actual finish date, at operation level put work center & execute, u will get the work center & operation wise confirmation, else customize report on the basis of confirmation posg date & GR posting date.

Regards

NISHJ

[Former Member]

hi,

Thanks for your reply..

from confirmation we can get actual.. but i want (production order qty) planned quantity on particular date

thanks in advance

[Former Member]

GO to COOIS...

Here you have the option of getting production orders with respect to the work centers..

Please check

[Former Member]

Hai experts,,

i have requirement to get per day plan quantity and order number details

my input fields are worcenter and date

so on particular work center on date what will be the plan and actual production quantity with order number details

Eg: My production order quantity - 40 nos. (it takes 4 days to finish).

i have single operation in production order.

my order scheduled start date - todays date.

In standard, when enter my first operation work center, system showing production order and its quantity (40 nos) . but i need to split that order quantity in report.. means on todays date for particular production order - order quantity = 10 nos.

[former_member184655]

Dear Prakash,

Check reports COOIS for the profile operation or else CO28,or else MCP7.

Regards

Mangalraj.S

[Former Member]

In COOIS select confirmations in the list...FOr the particular order or the order type you can get a list by executing..

Then in the change layout option you can add the date,time to the existing layout..

then by Sorting the date column, you can get the details of how many qty are confirmed on a particular day..

Hope this helps...

karthick

[Former Member]

hi karthick,

thanks for your reply..

actual production qty i can get from coois.

but im in need of plan production qty datewise...???

thanks in advance

[former_member196398]

Prakash,

If you are looking at just Planned Operation Qty Versus Actual Confirmed Quantity, then you would be able to get the details in COOIS transaction with List Operations. But here the operation details are not split date wise, if you need this you need to go for a custom report, to my knowledge there is no standard report available for this.

Regards,

Prasobh

[Former Member]

Hi Prasobh,

Thanks for your reply,,

If i need to go into customization. How can i map this requirement

As of my understanding

Production scheduled start date and time and Finish scheduled date and time.

between days .. we can make average quantity per day..

but the problem is first operation set up time in 3hrs .. how can i include that and also holidays!!

Any simple method to map this req to get for particular workcenter date wise planned production qty???

Thanks in advance