WHERE CONDITION

[Former Member]

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]

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

regards

shiba dutta

[Former Member]

Hi,

Internal table:

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

ENDLOOP.

database table:

SELECT...

WHERE FIELD LIKE 'D%'.

[Former Member]

Hi,

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

Regards,

Ranjit Thakur.

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

[Former Member]

<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