Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jun 5 at 7:36 PM Hi. When you say you're going to "go through the Oracle back end", I hope you're not going to access the SAP database directly. You should be going through an SAP logon procedure, and passing your SQL through that. If you go directly against the database, you could get page errors.
You could call an SAP BAPI, (Business Application Programming Interface) which will do the work for you and return an answer set. I will leave it to some of the excellent ABAP folks in this forum to advise you what BAPI would suit your needs. Calling the BAPI is the easiest way to retrieve data. It does all the work for you.
Lou
| | | ---------------Original Message---------------
From: dkandola
Sent: Friday, June 05, 2015 4:39 PM
Subject: Extract Data from Which SAP GL Tables?
Hi everyone,
I need to extract GL data from SAP through Oracle SQL Developer.
I was advised to use the BKPF and BSEG tables, but I notice that the BSEG is a clustered table and I don't have direct access to it via Oracle.
So, I was wondering if someone can please help me identify the SAP tables I need to extract the following fields:
- The journal entry code
- The journal entry label
- The number of the accounting entry (follows a sequential numbering)
- The accounting date
- The account number
- The account label
- The sub ledger account number
- The sub ledger account label
- Reference of the relevant supporting document
- Date of the relevant supporting document
- Label of the accounting entry
- The debit amount
- The credit amount
- The lettering/marking of the accounting entry
- Lettering date
- Validation date for the journal entry
- Amount in currency
- Currency code
Any help is appreciated, thank you :) |
| 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.   _.____.__ |
