TABLE CONTROL ISSUE

[Former Member]

Hi all,

I HAVE A TABLE CONTROL IN ONE OF MY SCREEN.

i AM COPYING DATA FROM ZTABLE .

Now data is in my table control . i HAVE TO SAVE IT TO SOME OTHER ZTABLE.

***PAI

loop.

CHAIN.

FIELD ZTEST-MATNR MODULE CHECK_MATNR_9002.

FIELD ZTEST-NOTE MODULE CHECK_NOTE_9002.

FIELD ZTEST-QUANTITY MODULE CHECK_QUANTITY_9002.

ENDCHAIN.

ENDLOOP.

MODULE CHECK_MATNR_9002 INPUT.

DATA : TEST1 LIKE MARA-MATNR.

IF NOT ZTEST-MATNR IS INITIAL.

CLEAR TEST1.

SELECT SINGLE MATNR INTO TEST1 FROM MARA

WHERE MATNR = ZTEST-MATNR.

IF TEST1 IS INITIAL.

MESSAGE E123(00) WITH ' Material Doesnot Exist'.

ENDIF.

ENDIF.

ENDMODULE. " CHECK_MATNR1_9002 INPUT

MODULE CHECK_NOTE_9002 INPUT.

IF ZTEST-NOTE IS INITIAL.

MESSAGE E123(00) WITH ' NOTE Doesnot Exist'.

ENDIF.

ENDIF.

ENDMODULE. " CHECK_NOTE_9002 INPUT

MODULE CHECK_QUANTITY_9002 INPUT.

IF ZTEST-QUANTITY IS INITIAL.

MESSAGE E123(00) WITH ' QUANTITY Doesnot Exist'.

ENDIF.

ENDIF.

ENDMODULE. " CHECK_QUANTITY_9002 INPUT

I HAVE DATA IN MY TABLE CONTROL WHEN I SAVE IT.

LETS SAY THE MATERIAL DOESNOT EXIST IN MARA

I GET AN ERROR MESSAGE SAYING MATERIAL DOESNOT EXIST,IF THAT THE CASE THEN I HAVE A ANOTHER MATERIAL WITH WHICH I HAVE TO REPLACE THIS MATERIAL.

SO I DO THAT BUT THE QUANTITY FIELD IS BLANK TO TOO.

INITIALLY

I HAVE

MAT NOTE QUANTITY

1 ABC 2

WHEN I TRIED TO SAVE I GET MATERIAL DOESNOT EXIST

AND IT DISPLAYS

1 BALNK BLANK. I AM LOOSING NOTE AND QUANTITY WHICH I WANT TO RETAIN,ALL IAM SUPPOSED TO DO IS CHANGE MATERIAL AND SAVE AGAIN.

NOW IT GIVES ME ERROR

NOTE DOESNOT EXIST

WHAT I WANT IS AFTER I SAVE IS

MATERIAL DOESNOT EXIST

1 ABC 2 NOW I WOULD CHANGE 1 TO CORRECT REPLACEABLE MATERIAL FOR 1 IS 2

AND THE NOTE AND QUANTITY SHOULD BE THERE FROM PREVIOUS THING

2 ABC 2

BUT IN MY CASE I AM LOSING ABC AND 2.

THANKS

[Former Member]

Hi,

Try by Specifying Parameter id for those fields in the attributes screen on the screen layout.

Regards,

sksingh

[Former Member]

Hi ,

can you be more clear.

Thanks

[Former Member]

Hi,

When you write the select,

<b>SELECT SINGLE MATNR INTO TEST1 FROM MARA

WHERE MATNR = ZTEST-MATNR.</b>

here you are selecting only 1 field MATNR, so why don't you select MATNR,NOTE and QUANTITY with in this slect, so when this select triggers all the 3 fields will be stored in the variables, and these fields wil be avilable to you

hope this helps

Regards

Sudheer