Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from dkandola on Jun 8 at 10:21 AM Unfortunately, I don't have access to SAP programming, it'll have to be SQL for me. Sorry, I don't have much options.
| | | ---------------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 | |   _.____.__ |
