MY ODS NAME : CW1/FIGL_ODM
0FISCPER
0COMP_CODE
0BA_1ACCSY
MY CUBE NAME : CW1/FIGLODM
0FISCPER
0COMP_CODE
0BA_1ACCSY
MY DATA IS COMMING FROM DSO TO CUBE BEFORE IT COME TO CUBE IT SHOULD DELETE PREVIOUS RECODES
MY DELETION SHOULD BE BASED ON COMBINATION OF 0FISCPER , 0COMP_CODE, 0BA_1ACCSY
CAN SOME ONE HELP ME TO AMEND CUSTOMISE FOLLWING START ROUTINE ACCORDING TO MY CUBE DELETION
__________________________________________________________
/BIC/AZOSCDLVY00 is my base DSO name
Declare internal table and work area for your calculations
Ex: T_SODLVY , WA_SODLVY
DATA: T_SODLVY TYPE TABLE OF /BIC/AZOSCDLVY00
WA_SODLVY TYPE /BIC/AZOSCDLVY00.
REFRESH T_SODLVY.
SELECT * FROM /BIC/AZOSCDLVY00 INTO TABLE T_SODLVY
FOR ALL ENTRIES IN SOURCE_PACKAGE
WHERE /BIC/ZDLVSHP = SOURCE_PACKAGE -/BIC/ZDLVSHP
AND DELIV_ITEM = SOURCE_PACKAGE -DELIV_ITEM.
*=== Sort T_SODLVY data
SORT T_SODLVY BY /BIC/ZSHIP_NUM.
*=== Delete the records
DELETE FROM SOURCE_PACKAGE comparing DOC_NUMBER S_ORD_ITEM.
______________________________________________________________