SOURCE
CC,PC,AMT
11,77,400
Result needed
CC,PC,AMT
AA,77,100
BB,77,300
AA and BB new company codes reading from a lool up table and amount needs to be change according to look up tale field-percentage.
CODE:
DATA : IT_JV TYPE STANDARD TABLE OF /BIC/AZGSDJV0100,
IWA_JV TYPE /BIC/AZGSDJV0100.
LV_COUNT = 0.
SELECT * FROM /BIC/AZGSDJV0100 INTO TABLE IT_JV[].
IF SY-SUBRC = 0 .
LOOP AT RESULT_PACKAGE ASSIGNING <RESULT_FIELDS>.
LOOP AT IT_JV INTO IWA_JV WHERE PCOMPANY = <RESULT_FIELDS>-PCOMPANY.
<RESULT_FIELDS>-DEB_CRE_LC = IWA_JV-/BIC/ZGSOJVPAT *
<RESULT_FIELDS>-DEB_CRE_LC.
<RESULT_FIELDS>-COMP_CODE = IWA_JV-/BIC/ZGSOCOMNW.
LV_COUNT = LV_COUNT + 1.
<RESULT_FIELDS>-RECORD = LV_COUNT.
ENDLOOP.
ENDLOOP.
ENDIF.
This code is not working...
Any suggestions?
Edited by: Baazi on Feb 20, 2011 5:46 PM