this is my whole code

[Former Member]

if not I_mat is initial.

select * from mara into CORRESPONDING FIELDS OF TABLE IT_MARA WHERE MATNR = I_MAT.

ENDIF.

IF NOT I_MAT IS INITIAL AND I_PLANT IS INITIAL.

*

SELECT * FROM MARC INTO CORRESPONDING FIELDS OF TABLE IT_MARC FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

ENDIF.

if not i_mat is initial and not i_plant is initial .

select * from marc into CORRESPONDING FIELDS OF TABLE it_marc FOR ALL ENTRIES IN IT_MARA where

matnr = it_MARA-matnr and

werks = i_plant.

endif.

IF NOT i_mat IS INITIAL and not i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

and BWKEY = I_VALUATIONAREA.

endif.

if not i_mat is initial and i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

endif.

IF NOT I_MAT IS INITIAL AND NOT I_VALUATIONTYPE IS INITIAL .

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

AND BWTAR = I_VALUATIONTYPE.

endif.

T_MAT[] = it_mara.

t_plant[] = it_marc.

t_val[] = it_mbew.

[Former Member]

If you change the title by giving a more meaningful one, and state the problem you are facing, then I'll keep this thread open.

pk

[Former Member]

IN INPUT I M GIVING MATNR AND PLANT BUT IN OUTPUT I M GETTING WHOLE VALUTAION AREA FOR TAT MATERIAL BUT I SHOULD SHOULD THE OUTPUT WHICH S AVAILABLE IN TAT PARTICULAR PLANT.

if not I_mat is initial.

select * from mara into CORRESPONDING FIELDS OF TABLE IT_MARA WHERE MATNR = I_MAT.

ENDIF.

IF NOT I_MAT IS INITIAL AND I_PLANT IS INITIAL.

*

SELECT * FROM MARC INTO CORRESPONDING FIELDS OF TABLE IT_MARC FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

ENDIF.

if not i_mat is initial and not i_plant is initial .

select * from marc into CORRESPONDING FIELDS OF TABLE it_marc FOR ALL ENTRIES IN IT_MARA where

matnr = it_MARA-matnr and

werks = i_plant.

endif.

IF NOT i_mat IS INITIAL and not i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

and BWKEY = I_VALUATIONAREA.

endif.

if not i_mat is initial and i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

endif.

IF NOT I_MAT IS INITIAL AND NOT I_VALUATIONTYPE IS INITIAL .

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

AND BWTAR = I_VALUATIONTYPE.

endif.

T_MAT[] = it_mara.

t_plant[] = it_marc.

t_val[] = it_mbew.

Moderator Message: Well, I gave you a fair chance, but you chose to ignore it. Please read this first before any further posting: https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement.

You'll be amazed at the number of rules you have managed to break in such a short span.

Edited by: kishan P on Oct 6, 2010 11:27 AM

[Former Member]

IN INPUT I M GIVING MATNR AND PLANT BUT IN OUTPUT I M GETTING WHOLE VALUTAION AREA FOR TAT MATERIAL BUT I SHOULD SHOULD THE OUTPUT WHICH S AVAILABLE IN TAT PARTICULAR PLANT.

if not I_mat is initial.

select * from mara into CORRESPONDING FIELDS OF TABLE IT_MARA WHERE MATNR = I_MAT.

ENDIF.

IF NOT I_MAT IS INITIAL AND I_PLANT IS INITIAL.

*

SELECT * FROM MARC INTO CORRESPONDING FIELDS OF TABLE IT_MARC FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

ENDIF.

if not i_mat is initial and not i_plant is initial .

select * from marc into CORRESPONDING FIELDS OF TABLE it_marc FOR ALL ENTRIES IN IT_MARA where

matnr = it_MARA-matnr and

werks = i_plant.

endif.

IF NOT i_mat IS INITIAL and not i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

and BWKEY = I_VALUATIONAREA.

endif.

if not i_mat is initial and i_valuationarea is initial.

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR.

endif.

IF NOT I_MAT IS INITIAL AND NOT I_VALUATIONTYPE IS INITIAL .

SELECT * FROM MBEW INTO CORRESPONDING FIELDS OF TABLE IT_MBEW FOR ALL ENTRIES IN IT_MARA WHERE

MATNR = IT_MARA-MATNR

AND BWTAR = I_VALUATIONTYPE.

endif.

T_MAT[] = it_mara.

t_plant[] = it_marc.

t_val[] = it_mbew.