production orders line item data

[Former Member]

Hello All,

I am working on production orders co03 rite now.

I want to access the line item data for a particular order,

AUFK and AFPO are not giving the details i need,

please advise,

thanks,

Gaurav

[Former Member]

Hi

Use the following tables

AFKO: PP Order Header Data(AUFNR)

AFPO: PP Order Item data(AUFNR,POSNR,PROJN)

AUFK: Order Master data(AUFNR,AUART,BUKRS,GSBER,WERKS)

AFIH: Maintenance Order Header(AUFNR,EQUNR,ILOAN)

AUFM: Goods Movement for Order(MBLNR,MJAHR,ZEILE,MATNR)

AFVV: Order Operations data Qty/Date/Values(AUFPL,APLZL)

AFVC: Operations within an Order(AUFPL,APLZL,VORNR)

AFRU: Order Completion Confirmation(RUECK,

also you can use the views

VIAUFKS

VIAUF_AFVC

which data fields you need write clearly so that I will give the correct table name

<b>Reward points for useful Answers</b>

Regards

Anji

[RichHeilman]

Production order line items are in AFPO, if you are talking about the components within an order, then this would be in table RESB.

Regards,

Rich Heilman

[Former Member]

Hi,

The components of the production order are stored in the RESB table. You will need to get the RSNUM from AFKO and hit against RESB. These are your components.

<b>Reward points</b>

Regards

[Former Member]

thanks all the data m looking for is

the one that comes as a list when we click the "viewer" icon or ctrl +shift + f7.

i m looking for all those details,

thanks,

Gaurav

[RichHeilman]

Yes, those are the components and can be found in table RESB. You need to get the RSNUM from the AFKO table and then hit RESB with this RSNUM. All components will be there with the item number POSNR, and MATNR fields.

Regards,

RIch Heilman

[Former Member]

thanks rich,

the problem m facing is the resb comes up with all entries, for eg i have 200 different entries in resb, but i m looking for only those that come as main list parent nodes and not the child nodes, m sounding confusing but believe me its how my reqmnt is,

thanks

gaurav

[RichHeilman]

Sure, the make sure that the AUFST(order level) in RESB = 0.

REgards,

Rich Heilman

[Former Member]

ok Rich, you gonna kill me for this,

wat i m looking is, let me cite an example,

lets say my order has 10 items in list , of which 4 dont have child nodes and 6 do have

then i want output with only 10 entries, it means if a parent has a child entry then it shud give me only parent entry,

the order level one gives me only those cases where there are no childs,

thanks for tolerating me!!

Gaurav

[RichHeilman]

Ok, right right right..

Ok, make sure BAUST is = 00.

Regards,

Rich Heilman