Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jun 26 at 12:16 AM You can always use SE12 which displays a table or structure, and ask SAP to tell you "where used". You can further ask it for use in "Logical Databases".
You can also go to transaction SE36 if you have access, and just hit the drop down. If you don't enter an LDB name and click the check, you'll see all LDB's in the SAP realm. Sort them down by description and look at the ones that say things like "document database", "accounting documents" and such. Once you pick one, SE36 can display the structure to you, the selections made in the LDB, and all the fields that are available.
- Lou
| | | ---------------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.   _.____.__ |
