Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

performance issue

Hi all,

I have a problem with the following select querey.

 select single a~stktype_ac
                b~stktype
                a~stktype_rec
                a~stktype_effrec
                a~recefffrom
                a~receffto
                a~effrecref

    into (actyp,
          potyp,
          reltyp,
          esto,
          from,
          to,
          agreeref)

    from  z2rlv_rlacct_s35 as a

          left outer join z2rlacct_extit as b
          on a~acctno = b~acctno and
             b~acctpty = potype

   where a~acctno      = acctno
     and a~achol       = partner
     and a~acholty     = partner_type.

where z2rlv_rlacct_s35 is a view which has 3 tables.

Can anybody suggest me better way to handle the query.

Any answers will bw appreciated.

Thanks

Suku.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question