Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where Condition in SAP

Hi Guys

I am pulling the Data from BranchMaster.

I do not want to pull the data where Branch Code Starts with CT.

So i write the following script;

Load * ;

SQL VKBUR,BEZEI From TVKVT

Where VKBUR <> 'CT*';

But It is not Filtering out ..

4 Replies
Not applicable
Author

TRY THIS

Load * ;

SQL VKBUR,BEZEI From TVKVT

Where VKBUR != 'CT*';

Not applicable
Author

Not working giving Error

Not applicable
Author

try this

Load * ;

SQL  select   VKBUR,BEZEI From TVKVT

Where VKBUR != 'CT*';

*************************************************

try this

Load * ;

SQL  select   VKBUR,BEZEI From TVKVT

Where VKBUR NOT IN ('CT*');

Not applicable
Author

I tried both the syntax but it is not working giving error