how to filter on sap field VBELN in load statement??

[jhew1234]

Hello All,

I'm trying to only load data where VBLEN is equal to or more than 2070000000.  I have listed below the different things I have tried but none of these have worked and I am lost for ideas.

Any help will be hugely appreciated...

What i've tried:

1.  Num(VBELN) as [Sales Order], 

      where VBELN >= 2070000000

2. Same as above but with NUM# 

3. WildMatch(VBLEN, ' 207******* ') 

4. WildMatch(VBLEN, ' 207??????? ')

5. Num(Evaluate(VBELN) as [Sales Order] 

Full Code: 

LOAD
Num(VBELN)) as [Sales Order],
POSNR as [Sales Item Number],
ETENR as [Delivery Schedule Line Number],
EDATU as [Delivery Date],
WMENG as [Order Quantity]

where
EDATU >= month(today())
and
ETENR = 0001
and
VBELN >= 2070000000

[albertovarela]

Have you tried using num#(VBELN) >= 2070000000  in the where clause?

[jhew1234]

Just tried it, thought for sure that would work but no luck unfortunately. 

Could it be that the field is neither a string or interger? or is that not possible in qlik sense? 

[jhew1234]

I loaded using "isnum" amd it came back as true so must be a syntax problem...