topic Re: Abap and SQL Request (BKPF / BSEG) in Application Development and Automation Discussions

Abap and SQL Request (BKPF / BSEG)

thillu — Tue, 21 Aug 2018 12:57:32 GMT

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 — Wed, 22 Aug 2018 02:51:11 GMT

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 — Fri, 24 Aug 2018 14:27:20 GMT

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

Thanks a lot !