topic Re: WHERE CONDITION in Application Development and Automation Discussions

WHERE CONDITION

Former Member — Tue, 10 Jul 2007 06:15:55 GMT

Hi all,

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

plz let me know syntax .

Regards.

T.srinivas

Former Member — Tue, 10 Jul 2007 06:17:20 GMT

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

regards

shiba dutta

Former Member — Tue, 10 Jul 2007 06:18:30 GMT

Hi,

Internal table:

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

ENDLOOP.

database table:

SELECT...

WHERE FIELD LIKE 'D%'.

Former Member — Tue, 10 Jul 2007 06:19:15 GMT

Hi,

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

Regards,

Ranjit Thakur.

Please Mark The Helpful Answer.

Former Member — Tue, 10 Jul 2007 06:19:32 GMT

example in the select query

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

belnr EQ 'D%'AND

gjahr EQ it_bkpf-gjahr.

ENDIF.

reward points if it is usefull ....

Girish