Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

WHERE CONDITION

Former Member
0 Kudos

Hi all,

iam trying to populate the fields of table starting with some letter eg : 'D'.

plz let me know syntax .

Regards.

T.srinivas

4 REPLIES 4

Former Member
0 Kudos

select .... into...from.. where fieldname like 'D%'

regards

shiba dutta

Former Member
0 Kudos

Hi,

Internal table:

LOOP AT ITAM into WA_ITAB WHERE field CP 'D*'.

ENDLOOP.

database table:

SELECT...

WHERE FIELD LIKE 'D%'.

Former Member
0 Kudos

Hi,

U can use <b>WHERE <field> LIKE 'D%'</b>.

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>

Former Member
0 Kudos

<b>example in the select query</b>

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ it_bkpf-bukrs AND

<b> belnr EQ 'D%'AND</b>

gjahr EQ it_bkpf-gjahr.

ENDIF.

reward points if it is usefull ....

Girish