replace below select with bol query

[former_member747669]

SELECT * FROM but000 AS a

JOIN but100 AS b
ON a~partner = b~partner
INTO CORRESPONDING FIELDS OF TABLE lt_but000
WHERE a~type = lc_bptype
AND a~deathdt EQ '00000000'
AND a~xdele EQ ''
AND b~rltyp = lc_bprole
AND ( a~crdat IN s_date OR a~chdat IN s_date )
AND ( a~crtim IN s_time OR a~chtim IN s_time )
AND a~partner IN s_custid.

[matt]

And what problem, exactly, are you having? At the moment this seems to be a "Can someone do my work for me please" type question.

[former_member747669]

I need to replace given select query with bol query but in this select I have use join on two tables so is it possible to use bol query on given select query???