Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from dkandola on Jun 5 at 4:32 PM 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. __.____._ |  | dkandola
Programmer/Developer - Software | |   _.____.__ |
