3 Replies Latest reply: Sep 23, 2010 8:54 AM by Prashanth Konduru RSS

GL Account Master data table

Sunil Kumar
Currently Being Moderated

Dear All,

 

I want to see the masterdata information related to GL account like

 

Gl account, Description, recon account for account type(Control data), Field status group etc....all details related to GL account.

 

I tried table SKA1 but could not get all details, especially i am looking for control data.

 

Thanks

Sunil.

  • Re: GL Account Master data table
    Saurabh Choudhary
    Currently Being Moderated

    Hi,

     

    Check the standard extractor for GL account from R/3.

    It will come FI-master data.

     

    It will satisfy your all need.

     

    I hope it will help.

     

    Thanks,

    S

  • Re: GL Account Master data table
    Srivandana Yadamreddy
    Currently Being Moderated

    Hi Sunil,

     

     

    U can check the GL master data in table SKB1.

     

     

    Regards,

    Vandana.

  • Re: GL Account Master data table
    Prashanth Konduru
    Currently Being Moderated

    HI,

     

    you can use the below  standard MD datasources to get the required data that you are looking for

     

    -Chart of Accounts

    -G/L account number

    -Company Code

    -Business area

    -Version

     

    Try below tables

    Table name :  SKB1 : G/L Account Master ( Company Code)

    Fields:

         BUKRS : Company Code 

         SAKNR : G/L Account

        

    Table name :  SKA1 : G/L Account Master ( Chart of Accounts )

    Fields:  

         KTOPL : Char of Accounts 

         SAKNR : G/L Account

       

    Table name :  SKAT : G/L Account Master Record ( Chart of Accounts : Description )

    Fields:

         SPRAS : Language

         KTOPL : Char of Accounts 

         SAKNR : G/L Account             

    KP

     

    Edited by: prashanthk on Sep 23, 2010 12:23 PM

Actions