How to write Select statement for this codition

You should be able to use CS (Contains operator). If you know that BELNR is going to be the starting or ending of the field SGTXT, then you can use a wild card like %BELNR, BELNR%.

Regards,

Ravi

Note : Please reward points if you think this was helpful.

Hi Sumi,

You can pass the value of Belnr to a variable of same length of SGTXT using <b>MOVE</b>.

For Example,

Data: W_BELNR like BSAD-SGTXT.

MOVE BELNR to W_BELNR.

Select AUGBL AUGDT into t_BSAD

from BSAD

where SGTXT = W_BELNR.

Regards,

Baburaj

Please Give the Reward points.

DATA WA_SGTXT LIKE BSAD-SGTXT.

MOVE BELNR TO WA_SGTXT.

Select AUGBL AUGDT into t_BSAD

from BSAD

where SGTXT eq WA_SGTXT

...

Cheers

Hi,

Try this.

data t_bsad type bsad.

select AUGBL AUGDT into (t_BSAD-AUGBL, t_BSAD-AUGDT)

from BSAD where SGTXT = BSAD~BELNR.

endselect.

Svetlin

data w_belnr like bsad-sgtxt.

concatenate 'belnr' '%' into w_belnr.

Select * from bsad where sgtxt like w_belnr.

Note: This SQL will be expensive

Ravi

u can't do a comparison in a select statement where both the fields on the left as well as on the right are from the database table. U probably have to go for one of these options...

1) compare with sgtxt that is previously determined in the program...this could be like retrieving in a separate internal table and then using 'FOR ALL ENTRIES' on it...like ....

select augbl augdt from bsad into table t_bsad

for all entries in t_bsad1

where belnr eq t_bsad1-sgtxt+0(10)...(followed by other conditions)

2) not recommended but u can try and go for a nested select.

rgds,

PJ

2)

hi,

try with this code,i am not sure about this but i think it could be helpful to you,

Data: duplicate_BELNR like BSAD-SGTXT.

WRITE BELNR to duplicate_BELNR.

Select AUGBL AUGDT into t_BSAD

from BSAD

where SGTXT = duplicate_BELNR.

Hi Sumi,

U can also create the another data type with type 'C' and length 50. Move belnr value into that.

Then in select use that field in where clause.

Reg,

Arpit

Hi,

data temp(12).

concatenate '%' belnr '%' into temp.

Select AUGBL AUGDT into t_BSAD

from BSAD

where SGTXT like temp.

If belnr is having multiple values,just create a internal table as follows.

types : begin of ty,

belnr....

temp(12),

end of ty.

data itab_ type standard table of ty.

data wa type ty.

loop at itab into wa.

concatenate '%' wa-belnr '%' into wa-temp.

modify itab from wa index sy-tabix transporting temp.

endloop.

Change your select statement accordingly.

Kindly reward poits if it helps.

1. Like is not working

2. I cannot use EQ. Coz SGTXT will have chars other than BELNR.

IF

BELNR = 123

SGTXT can be like this

TEST123TEST.