topic Re: Process Order number in Application Development and Automation Discussions

Process Order number

Former Member — Mon, 06 Aug 2007 13:47:07 GMT

I have a selection screen that gets matnr werks charg. How to extract the process order number baesd on this information?

Former Member — Mon, 06 Aug 2007 13:50:46 GMT

write a select query based on the values given on the selection screen

select process number f

from table X

into table itab

where matnr = selection screen matnr

werks = ''''''''''''''''''''''''''''''''''''''''''''' werks

charg = '''''''''''''''''''''''''''''''''''''''''' charg

reward if useful

Former Member — Mon, 06 Aug 2007 13:55:46 GMT

Please table AFPO for item details (Matnr + Charg + Werks) and AUFK for header details

Former Member — Mon, 06 Aug 2007 14:02:31 GMT

I cannot get Process Order (AUFNR) from table AFPO because the batch number ( CHARG) is empty for all records.

I need the methodology to extract the process order using batch number. What table to go to?

Former Member — Mon, 06 Aug 2007 15:31:36 GMT

SELECT SINGLE aufnr

FROM mseg

INTO v_aufnr

WHERE charg = charg

AND bwart = '101'.

SELECT SINGLE werks

FROM caufv

INTO v_werks

WHERE aufnr = v_aufnr.