topic Re: delete record from Datapackage in Application Development and Automation Discussions

delete record from Datapackage

Former Member — Thu, 09 Mar 2006 21:29:43 GMT

hello all experts,

One simple question.

I have an internal table and one ODS/InfoCube datapackage.

which statement should I use to let datapackage only keep the records in that internal table, delete all others?

Appreciate it!

Linda

Re: delete record from Datapackage

Former Member — Thu, 09 Mar 2006 21:34:46 GMT

Pls find attached code of fm to delete data from ODS in BW.

CALL FUNCTION 'RSDRI_ODSO_DELETE_RFC'

EXPORTING

I_ODSOBJECT = 'ZTXHDCNT'

TABLES

I_T_RANGE = i_range

EXCEPTIONS

DATA_TARGET_NOT_ODS = 1

ODS_TYPE_NOT_TRANSACTIONAL = 2

CONFLICTING_DELETION_CRITERIA = 3

DELETE_FAILED = 4

INTERNAL_ERROR = 5

OTHERS = 6.

if sy-subrc eq 0.

write: / 'success'.

endif.

You can populate range of desired data to be deleted and it will delete data from ODS which satisfies the criteria.

In you case you need to compare data with internal table. So i suggest you following solution -

Loop at datapackage.

read Internal table and check if record exist.

if does not exist, delete record from datapackage.

endloop.

Re: delete record from Datapackage

RichHeilman — Thu, 09 Mar 2006 21:36:41 GMT

In ABAP there is not single statement to do that. You can do that if you were deleting all records that are in the internal table, but not the other way around.

You will have to get all the records of the database that you want to delete into an internal table, then you can do the statement...

DELETE ZTABLE FROM TABLE itab.

This statement deletes all of the records from the database table ZTABLE where the record matches in the ITAB internal table.

Regards,

Rich Heilman

Re: delete record from Datapackage

Former Member — Thu, 09 Mar 2006 21:40:22 GMT

Hi Linda,

Loop at datapackage.

read Internal table and check if record exist.

if does not exist, delete record from datapackage.

endloop.

LOOP AT <DATAPAC NAME>.

READ TABLE ITAB <WHERE CONDITION>.

IF SY-SUBRC = 0.

CONTINUE.

ELSE.

DELETE ITAB.

ENDIF.

ENDLOOP.

Re: delete record from Datapackage

Former Member — Thu, 09 Mar 2006 21:52:33 GMT

Thank you very much!

Points awarded.

Linda