Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from dkandola on Jun 5 at 5:33 PM Hey Louis, I don't believe I can use logical databases through Oracle. With my task at hand, I can only access SAP through the Oracle back-end. However, if I'm wrong and there is a way to access logical databases through Oracle, then can you explain to me how?
Sorry, I should've mentioned in my question that I'm new to SAP.
| | | ---------------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. __.____._ |  | dkandola
Programmer/Developer - Software | |   _.____.__ |
