‎2007 Aug 06 2:47 PM
I have a selection screen that gets matnr werks charg. How to extract the process order number baesd on this information?
‎2007 Aug 06 2:50 PM
Hi
write a select query based on the values given on the selection screen
like
select process number f
from table X
into table itab
where matnr = selection screen matnr
werks = ''''''''''''''''''''''''''''''''''''''''''''' werks
charg = '''''''''''''''''''''''''''''''''''''''''' charg
reward if useful
‎2007 Aug 06 2:55 PM
Please table AFPO for item details (Matnr + Charg + Werks) and AUFK for header details
‎2007 Aug 06 3:02 PM
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?
‎2007 Aug 06 4:31 PM
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.