cancel
Showing results for 
Search instead for 
Did you mean: 

Production Order Query

Former Member
0 Kudos

Dear Sir,

I want to make one query of production order, where I want Order Qty, Confirmed Qty, order date, material code etc. Please confirm which table I should select.

Please help urgently.

Regards

Ishu

Accepted Solutions (1)

Accepted Solutions (1)

former_member188931
Active Contributor
0 Kudos

Hi Ishu,

Use AFPO, AFKO.

Thanks

Hrishi

Answers (5)

Answers (5)

former_member533946
Active Contributor
0 Kudos

Hi dear,

No need to create query use T. code COOIS order header.

You will get all the fields there.If not go to chage layout and get the required fields in the displayed column.

Production order header data is stored in AFKO table.

Former Member
0 Kudos

Actually, I know the COOIS report, but for some reason, I want to make cutomised query where I want not show some field to the user. and later I will convert the query to some zt-code.

Regards

Ishu

former_member533946
Active Contributor
0 Kudos

HI dear,

Ok, then you can make use of Table AFKO,AUFK - Production Order header table and MARA-For material description.

You will get most of the data from above two tables.

Former Member
0 Kudos

Hi,

You are use

POH Logical Data base table..

in SQVI.

MANOJ

muthusamy_sankaran
Active Contributor
0 Kudos

Hi,

Table AUFK, CAUFV

regards,

sankaran

Former Member
0 Kudos

Hi,

Use Tcode COOIS this is Standard report for Production order.

Production order all inforamtion in this report.

1) Order Header wise,

2) Operations wise

MANOJ

Former Member
0 Kudos

Dear,

Please refer the tables AFPO and AFRU.

regards,

Joseph Charles Vaikathussery