Skip to Content
-2
Sep 29, 2019 at 12:11 AM

Query with SQVI

187 Views

Dear Expert.

I am creating a Query with SQVI, with joining 4 tables LFA1,LFB1,LFBK,TIBAN. Input fields are LFA1 LIFNR & LFB1 BUKRS and output fields are LFA1 LIFNR, LFA1 NAME1, LFB1 BUKRS, TIBAN IBAN, LFBK BANKL, LFBK BANKN, LFBK BKREF, LFBK BVTYP, LFA1 DTAWS, LFA1 SPERZ, LFBK EBPP_ACCNAME, LFB1 ZWELS, LFB1 INTAD, LFB1 AD_HASH, LFB1 ZTERM, LFA1 STCEG.

Joining with 4 tables LFA1 inner join LFB1 inner join LFBK left outer join TIBAN.

Question: when i do this for one client Query result is OK, but same thing when i do for another client output is not coming (data not selected)

Thanks & Regards

Debasish