2012 Apr 04 7:25 AM
Dear Friends ,
My purpose is to insert the values of internal table into ztable , If ztable does not have any value then insert first time
and vise versa then update the recods of ztable ,
Here I have to insert the values of it_final_age this internal table into ZOUTSTANDING , In debugging mode
| ZOUTSTANDING-KUNNR | = IT_FINAL_AGE-KUNNR. |
i am getting the values in IT_FINAL_AGE-KUNNR but ZOUTSTANDING-KUNNR this is blank .
code is here .
DATA: BEGIN OF it_final_age OCCURS 0,
KUNNR LIKE KNVP-KUNNR,
CURRBAL LIKE bsid-dmbtr,
CRDR(6),
END OF it_final_age.
SELECT * FROM ZDATA INTO CORRESPONDING FIELDS OF TABLE it_final_age .
DATA : IT_OUT TYPE ZOUTSTANDING OCCURS 0 WITH HEADER LINE.
SELECT * FROM ZOUTSTANDING INTO CORRESPONDING FIELDS OF TABLE IT_OUT .
if IT_OUT[] is initial.
LOOP AT IT_FINAL_AGE .
ZOUTSTANDING-KUNNR = IT_FINAL_AGE-KUNNR.
ZOUTSTANDING-CURRBAL = IT_FINAL_AGE-CURRBAL.
ZOUTSTANDING-CRDR = IT_FINAL_AGE-CRDR.
INSERT ZOUTSTANDING .
ENDLOOP.
ELSE.
LOOP AT IT_FINAL_AGE.
UPDATE ZOUTSTANDING set
CURRBAL = IT_FINAL_AGE-CURRBAL
CRDR = IT_FINAL_AGE-CRDR
WHERE KUNNR EQ IT_FINAL_AGE-KUNNR.
ENDLOOP.
ENDIF.
Where is my mistake Pls help me.
Moderator Message: Basic question. Thread locked.
Message was edited by: Suhas Saha
Dear Friends ,
My purpose is to insert the values of internal table into ztable , If ztable does not have any value then insert first time
and vise versa then update the recods of ztable ,
Here I have to insert the values of it_final_age this internal table into ZOUTSTANDING , In debugging mode
| ZOUTSTANDING-KUNNR | = IT_FINAL_AGE-KUNNR. |
i am getting the values in IT_FINAL_AGE-KUNNR but ZOUTSTANDING-KUNNR this is blank .
code is here .
DATA: BEGIN OF it_final_age OCCURS 0,
KUNNR LIKE KNVP-KUNNR,
CURRBAL LIKE bsid-dmbtr,
CRDR(6),
END OF it_final_age.
SELECT * FROM ZDATA INTO CORRESPONDING FIELDS OF TABLE it_final_age .
DATA : IT_OUT TYPE ZOUTSTANDING OCCURS 0 WITH HEADER LINE.
SELECT * FROM ZOUTSTANDING INTO CORRESPONDING FIELDS OF TABLE IT_OUT .
if IT_OUT[] is initial.
LOOP AT IT_FINAL_AGE .
ZOUTSTANDING-KUNNR = IT_FINAL_AGE-KUNNR.
ZOUTSTANDING-CURRBAL = IT_FINAL_AGE-CURRBAL.
ZOUTSTANDING-CRDR = IT_FINAL_AGE-CRDR.
INSERT ZOUTSTANDING .
ENDLOOP.
ELSE.
LOOP AT IT_FINAL_AGE.
UPDATE ZOUTSTANDING set
CURRBAL = IT_FINAL_AGE-CURRBAL
CRDR = IT_FINAL_AGE-CRDR
WHERE KUNNR EQ IT_FINAL_AGE-KUNNR.
ENDLOOP.
ENDIF.
Where is my mistake Pls help me.
Moderator Message: Basic question. Thread locked.
Message was edited by: Suhas Saha
2012 Apr 04 7:34 AM
2012 Apr 04 7:35 AM
hi,
use
MODIFY ztable(database table) from table LIT_FINAL(internal).
Thanks.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |