VALIDATION

[Former Member]

i have to upload data from presentation server to internal tabe

1)delivery country komg-hland and country of origin komg-herkl has to be checked from table t005

2)the rate unit konp-konwa has to be checked from tcurc table

how to do it?

preferably the code?

[Former Member]

Hi Sushant,

Can u brief your requirement?

Regards,

Kumar.

[Former Member]

1)delivery country komg-hland and country of origin komg-herkl has to be checked from table t005
    SELECT SINGLE LAND1 FROM T005 INTO T005-LAND1 WHERE LAND1 EQ komg-hland.
   IF SY-SUBRC NE 0.
      *DISPLAY ERROR MESSAGE
   ENDIF.

      SELECT SINGLE LAND1 FROM T005 INTO T005-LAND1 WHERE LAND1 EQ komg-herkl .
   IF SY-SUBRC NE 0.
       *DISPLAY ERROR MESSAGE
   ENDIF.


2)the rate unit konp-konwa has to be checked from tcurc table

   SELECT SINGLE WAERS FROM TCURC INTO TCURC-WARRS WHERE WAERS  EQ konp-konwa .
   IF SY-SUBRC NE 0.
       *DISPLAY ERROR MESSAGE
   ENDIF.