Skip to Content
0
Former Member
Jan 05, 2012 at 03:24 PM

Comparing with a similar field(not same)??

33 Views

Hi all,

I am having some entries in a table which are unique identified by pernr and comnig from infotype pa0001.

Now, i want to get data from table bsik for the vendor acct. balance, having for all entries, on the first internal table,

The twist is every vendor no. start with E, followed by the pernr. So how can I implement this???

SELECT bukrs lifnr belnr budat dmbtr shkzg INTO TABLE lt_st_bsik

FROM bsik FOR ALL ENTRIES IN lt_st_p1

WHERE bukrs EQ '1000'

AND lifnr LIKE lt_st_p1-pernr AND budat LE iv_date.

I can't use like here, it is against the syntax..

If I make another table with lifnr(vendor id) field, and get all in that from the lt_st_p1 leaded by 'E', then when reading that, from lt_st_p1 into finally final table lt_enf, would take a lot of time, because i have to read lt_st_bsik in that with the help of the new table lt_st_lifnr that i will make, so that is taking a mightly mighty lot of time.

So any solution to this????

Hope you understood my query.

Any help would be appreciated.

Regards

Tarun