Skip to Content
0
Former Member
Mar 20, 2009 at 08:08 AM

Can some one help me to customise this start routine

21 Views

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.

______________________________________________________________