Deleting datapackages where the string starts with Z*
I am ABAP-ing a bit in BI and need some help.
I am making a start routing when uploading data from a DSO to an InfoCube. What I would like it to do is to only upload rows where field x starts with Z. If the field contains anything else it can be deleted. Everything starting with Z should be transfered to the InfoCube.
The syntax should be something like:
DELETE source_package WHERE "InfoObject" NOT LIKE 'Z'.*