Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from helenrrico on Jun 27 at 12:44 AM You cannot avoid using the key fields in the select statement when you are accessing table bseg although you can forego using bseg-buzei if you have a specific g/l account in mind. You just add bseg-buzei if you need more than one line items from bseg.
| | | ---------------Original Message---------------
From: Tamir Berger
Sent: Monday, June 25, 2012 3:47 PM
Subject: SQ02 on BKPF & BSEG
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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
