Abap and SQL Request (BKPF / BSEG)

[thillu]

Hello, I'm beginner in Abap and I have a question about a query on the table BKPF and BSEG.

I need the list of accounting documents (BKPF) which have accounting entry for a project given in parameter (Field Projk of table BSEG).

Since it's impossible to make a "JOIN" with tables BKPF and BSEG, how can I write my SQL query ?

[DoanManhQuynh]

You may using sub ledger tables that comprise BSEG:

BSIS/BSAS - open/cleared items for G/L
BSIK/BSAK - for vendors
BSID/BSAD - for customers

or you can select from BSEG to internal table then use FOR ALL ENTRIES to select from BKBF.

[thillu]

It works, I made it with BSEG to internal table and FOR ALL ENTRIES to select from BKBF.

Thanks a lot !