Skip to Content
avatar image
Former Member

custom general ledger

Dear All master,

could please tell me the initial table for general ledger ? i would like to make report custom of it include balance in it .

Thx b4 all.

Best regards,

Harry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Nov 10, 2016 at 06:26 AM

    Hi Harry,

    There are a lot of tables relating to General Ledger. Prominent among them are GLT0, BSEG, BKPF, BSIS, BSAK, BSAD, etc. You can do a search in se16 with BS* to get the required tables. If you are on New GL, then the additional tables that you need to look into are FAGLFLEXA and FAGLFLEXT tables.

    If you elaborate your requirement, then may be we can answer which tables would be relevant for you.

    Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2016 at 08:40 AM

    Hi Vivek Mohapatra,

    I mean ,i would like to know and show for cumulative balance in Foreign currency. the format coloumn like following :

    Posting date | due date | Trans | Details | debit | credit | balance |

    that format will be appear base on filter of date and account.

    Thx b4.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 09:22 AM

    Hi please check bellow Query

    SELECT T1.[AcctCode],T1.[AcctName],(sum(T0.[Debit])-sum(T0.[Credit])) "Cumulative Balances",T0.[Project] FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode WHERE T1.[AcctCode] =[%0] AND T0.[refdate] >='20160901' AND T0.[refdate] <='20161031' GROUP BY T0.[Project],T1.[AcctName],T1.[AcctCode],T1.[AcctName]

    --Ramudu

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 09:31 AM

    the tables of the journal entries are: JDT1, OJDT

    the tables of th accouns: OACT

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 11, 2016 at 12:22 AM

    Dear All Master,

    I'd ;like to get query to generate foreign balance like following picture :

    .

    thx

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2016 at 08:25 AM

    all the fields and tables are:

    JDT1-lines of journal entries

    OJDT-heads of journal entries

    OACT-accounts master data

    Add comment
    10|10000 characters needed characters exceeded