topic Re: production orders line item data in Application Development and Automation Discussions

production orders line item data

Former Member — Mon, 16 Jul 2007 12:49:58 GMT

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

Re: production orders line item data

Former Member — Mon, 16 Jul 2007 12:54:23 GMT

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

Re: production orders line item data

RichHeilman — Mon, 16 Jul 2007 12:55:26 GMT

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

Re: production orders line item data

Former Member — Mon, 16 Jul 2007 12:59:37 GMT

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

Re: production orders line item data

Former Member — Mon, 16 Jul 2007 14:34:51 GMT

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

Re: production orders line item data

RichHeilman — Mon, 16 Jul 2007 14:38:27 GMT

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

Re: production orders line item data

Former Member — Mon, 16 Jul 2007 14:54:05 GMT

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

Re: production orders line item data

RichHeilman — Mon, 16 Jul 2007 14:56:03 GMT

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

REgards,

Rich Heilman

Re: production orders line item data

Former Member — Mon, 16 Jul 2007 15:07:13 GMT

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

Re: production orders line item data

RichHeilman — Mon, 16 Jul 2007 15:16:18 GMT

Ok, right right right..

Ok, make sure BAUST is = 00.

Regards,

Rich Heilman