Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Sustainer on Jun 8 at 12:04 PM Hi,
Could you please check FAGLFLEXA and FAGLFLEXT, these are new GL tables.
Regards,
A Sustainer
| | | ---------------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.   _.____.__ |
