11-13-2007 10:28 PM
These are the select options.
SELECT-OPTIONS:
S_MATNR FOR MARA-MATNR ,
S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H*',
S_WERKS FOR MARC-WERKS OBLIGATORY.
This is the select query
SELECT MARA~MATNR
MARA~MATKL
MARC~WERKS
FROM MARA AS MARA INNER JOIN MARC AS MARC
ON MARA~MATNR = MARC~MATNR INTO TABLE GT_MARA
WHERE MARA~MATNR IN S_MATNR AND
MARA~MATKL IN S_MATKL AND
MARC~WERKS IN S_WERKS.
S_MATKL internal table is having
s_sign = 'I'
s_option = 'EQ'
s_low = H*.
I know this works if <b>S_OPTION = CP</b>.
Let me know how can it be done.
11-13-2007 10:32 PM
11-13-2007 10:36 PM
SELECT-OPTIONS: S_LAEDA FOR MARA-LAEDA OBLIGATORY,
S_MATNR FOR MARA-MATNR ,
S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H*',
* OPTION CP, " adding this option
S_MTART FOR MARA-MTART OBLIGATORY DEFAULT 'FERT',
S_WERKS FOR MARC-WERKS OBLIGATORY.
Solved the problem.
11-13-2007 10:38 PM
Try like this:
SELECT-OPTIONS:
S_MATNR FOR MARA-MATNR ,
S_MATKL FOR MARA-MATKL OBLIGATORY, " DEFAULT 'H*', << Comment
S_WERKS FOR MARC-WERKS OBLIGATORY.
initialization.
s_matkl-sign = 'I'
s_matkl-option = 'CP'
s_maktl-low = 'H*'.
append s_matkl.
Regards,
Naimesh Patel
11-14-2007 2:20 AM
Hi
is not treated as wild character . Instead use %
SELECT-OPTIONS:
S_MATNR FOR MARA-MATNR ,
S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H%',
S_WERKS FOR MARC-WERKS OBLIGATORY.
Hope this work .
Praveen