Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from sridharca on Jun 25 at 4:12 PM Try using BSEG as an additional structure.
Alternatively, use logical database FSM ( take a dropdown on list and get the right one).
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. __.____._ |   _.____.__ |
