BW transformation routine to filter data
I need to load data to DSO from Sales Document (attributes) where PO number from sales starts with either 0002* or 2* and I have created a filter on DTP for PO Number from sales for value 0002*.
this filter on DTP is working fine but the only problem is that it ignores all the PO number which does not have prefix 000. maximum lenght of the PO number is 13 and if the 000 are there then it is ok but user puts different combination of PO numbers like below
due to this my DSO activation fails.
How do I make sure that if the PO number starts from 2* then it also gets updated to the dso but without invalid characters.
e.g from above PO order 2000000000-re then we should only transfer 2000000000
PO order 2111111111-WE then only transfer 2111111111
and we should ignore 211-steam Br
I do not have a ABAP knowlege so any help is appreciated.
Dar vad replied
thank you for your responses.
I tried different solution and it worked.
1st i put 2 ranges in DTP filter as below
000200000000 to 299999999999
200000000000 to 299999999999
and then I created a field level routine to convert source data from lower case to upper case and it worked.
thanks again for your valuable input.