i posted a topic yesterday regarding the help.
it got locked by moderator so i couldnt assign
Thanks Sireesha, the code you provided below works
please reply here so i can
-Code
SELECT Zvalue1 Zdate1 FROM /BIC/AZODSTeST100 INTO TABLE IT_ITAB.
Write the below code in field level routine for the field 'Value':
READ TABLE IT_ITAB into wa_itab WITH KEY zdate1 = COMM_STRUCTURE-Zdate2.
IF SY-SUBRC = 0.
Result = wa_itab-zvalue1 .
ENDIF.
Am assuming Zdate2 is available from the source of infocube.
Try writing the above code in update rules and check if it works.