Skip to Content
0

Start routine inputs required

Jun 12, 2017 at 12:20 PM

57

avatar image

Hi Experts,

i have a need that dont want to load zzalkey NE 0 into BW data. zzalkey is source field . can we achieve this through start routine?

in start routine i wrote ; DELETE source_package where zzalkey NE 0. no errors. But still i can see otehr values apart from 0 for the field zzalkey.

awaiting your valuable inputs.

Regards,

Raki.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mario Tibollo Jun 12, 2017 at 12:35 PM
0

what type of field is zzalkey? maybe you need to use quotes.

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hi Tibollo,

it is Labeling System for Functional Location. cahr ( length : 1).

0

if it's a char, you need to use quotes.

0

DELETE SOURCE_PACKAGE WHERE ZZALKEY NE '0'. this is the only line am using.

0

hI Mario,

did the same but still i can see toehr values in masterdata. am writing this code between data source and masterdata object.

0

ah, you are loading master data... you should really put all the info in your question. Else it's a waste of time .

once data has been loaded in master data it stays in the master data even if you delete the requests in the manage tab of the master data. So to be sure your code works, you can debug and check that lines are getting deleted. To be sure you can delete all the master data and reload from psa.

and when you say 0, does this mean the actual figure 0 or are you talking about the initial value?

1

HI Mario,

Issue resolved. Mine is dev system. I just deleted master data using se14 ( not used in any other) and i can see code is working fine. Now we are getting ALKEy = 0 records only.

Thanks for your time.

Regards,

Raki.

0