Question:
I have customized ODS for which datasource is 2LIS_13_VDITM. Based on content of field bill_qty I need to skip the insertion of record into ODS if bill_qty = 0. What is a way todo this? I tried RECORDMODE variable in transfer routine but it gives eror for entire inforpackage.
Thanx,
Answer:
at the update rule, you can insert your routine that skip records
Answer:
Thanks bigjaw. Can u help with code?
Answer:
both in transfer rules as in update rules you can change RETURNCODE
* returncode <> 0 means skip this record
RETURNCODE = 0.
just do what the comment line tells you (set a value different from 0 in case you wish to skip it)
cheers,
El Belgio
Answer:
Thanks El Belgio.
I have already tried -
if TRAN_STRUCTURE-fkimg = 0.
RETURNCODE = 4 .
else.
RETURNCODE = 0.
endif.
in Transfer Rule Routine for bill_qty.
The result is that it marks the record as incorrect errorneous reciord and infopackage gets aborted.
Answer:
ok, in that case you could do it in a start routine... loop the data_package table and remove the entries where fkimg equals 0 from it
cheers,
El Belgio