Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from tberger on Jun 25 at 3:46 PM Hi,
I try to use BKPF & BSEG in order to extract journal entries.
I understand that using JOIN is not possible because BSEG is a cluster table.
I tried to use BSEG as Additional Table and the problem is that in the SELECT statement I need to provide parameters for all the key fields.
There are 4 key fields in BSEG, 3 of them are filled automatically like JOIN with BKPF fields, but the last field - the line number field is empty and I need to provide a parameter.
What is the parameter for choosing all the lines?
Can I just delete this line from the SELECT query?
I have one more question regarding using Additional Table.
Is it a join or direct read from BKPF and then select again from BSEG using the first select data?
Where is the join of the data take place?
Thank you in advanced.
| Reply to this email to post your response. __.____._ |   _.____.__ |
