Skip to Content

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

need help on select statement...

Hi,

I need to fetch from vbfa table those records where vbeln starts with '0800'.

my select statement given below gives a syntax error..pl help.

SELECT * FROM vbfa WHERE vbeln(4) = '0800'.

vbeln(4) is not accepted and i get the message ' field vbeln(4) is unknown' ...what to do?

thks

Tags:
replied

Hi

Use LIKE option in WHERE conditions:

SELECT * FROM vbfa WHERE vbeln LIKE '0800%'.

Max

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question