Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BW transformation routine to filter data

Hi,

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

2000000000-re

211-steam Br

2111111111-WE

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.

regards,

Dar Vad

replied

Hi All

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.

regards,

Dar

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question