Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from sridharca on Jun 26 at 8:21 AM Once you use the logical database in the infoset, the next screen will show you all the tables and fields available- The FI document logical database has BKPF, BSEG and some more.
Hope this helps.
Sridhar
| | | ---------------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.   _.____.__ |
