Skip to Content
0
Former Member
Apr 01, 2008 at 01:40 AM

Need Help in writing or modifing the start routine, (Update routine)

11 Views

Hi all,

Please help me with the following Update routine code.. We are loading data from 2 ODS on BW side to APO cube using data marts and on APO cube for update rules there is a update routine. The main purpose of the routine here is to load the data only for particular materials to cube('1013','1020','1021','1022','1023','1024','1042', '1043','1121','1123','1124','1142','1143') we load the data only for these materials to APO cube which appears in Planning book.. At the same time if we get any other materials from BW to APO the load should be succesful but it shouldnt show in the Cube.. I think it should show upto PSA or the load should be succesful and using start routine i need to filter those materials and display only the necessary ones.. please help me in this. my proj go live date is in 1 week..

This following code is working in opposite way, it is loading other materials and not the above in the list.

loop at DATA_PACKAGE.

CLEAR: ZMATERIAL.

select MATERIAL INTO ZMATERIAL

FROM

/BI0/PMATERIAL

where matl_type in ('1013','1020','1021','1022','1023','1024','1042',

'1043','1121','1123','1124','1142','1143')

AND MATERIAL = DATA_PACKAGE-MATERIAL.

ENDSELECT.

IF ZMATERIAL IS INITIAL.

DELETE DATA_PACKAGE.

ENDIF.

ENDLOOP.

Thank you very much and waiting for the response..

Arya