Query does not give desired results

[Former Member]

Hi Experts

I have created a query using tables LFA1, LFB1, LFBK and TIBAN.

My requirement is to have list of vendors of a specific country in a company code.

I am getting several records from TIBAN instead of getting list based in LFBK.

I could not join LFBK-BANKN and TIBAN-BANKN. This might be reason for erratic results.

Please advise how to join the above two fields for getting correct results.

Thanks and warm regards

ramSiva

[Former Member]

hi ram ,

try using left join and inner join .

length of bankn field vary in both the tables , so its quite complicated to use join , would like to suggest to use 'for all entries ' .

regards

ranjan

[Former Member]

Hi Ranjan

Thanks for repsonse.

Can you detail more?

warm regards

ramSiva

[surajarafath]

SELECT * FROM LFBK
                 INTO TABLE <ITABL>
                 FOR ALL ENTRIES IN IT_TIBAN
                 WHERE BANKN EQ IT_TIBAN-BANKN.

As the Data element of TIBAN-BANKN and LFBK-BANKN is different, i afraid FOR ALL ENTRIES will also not work.. any way try or else compare with other keys like....

SELECT * FROM LFBK
                 INTO TABLE <ITABL>
                 FOR ALL ENTRIES IN IT_TIBAN
                 WHERE BANKS eq IT_TIBAN-BANKS
                 AND       BANKL eq IT_TIBAN-BANKL
                 AND       BKNOT eq IT_TIBAN-BKNOT.

If you list your requirement clear, then can help with create query with all tables...

Thanks & Regards,

SUJI.

[Former Member]

hi ram ,

i agree with suji's above solution .

regards

ranjan