Skip to Content
author's profile photo Former Member
Former Member

chart of accounts for G/L account

Hi

we have a report in BI which gets data from table RESB . here in RESB table (Reservation/dependent requirements) we have G/L account number which we are bringing to BI , but this G/L account number is compounded to Chart of accounts in BI , and we dont have chart of accounts field in RESB table becoz of this in our report for all the rows where it has G/L Account number it is displaying like this..

Chartofaccounts/(G/L account no)

notassigned/50000030

notassigned/50000039

notassigned/50000050

Can we get Chart of accounts for the G/L Account from RESB table by writing some cmod enhancements

or Is there any way to hide the compounded infoobject display in report.

like instead of

notassigned/50000030

display just

50000030

please suggest

thanks & regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 06:16 AM

    Hi Krishna,

    I will suggest to take a help of FI functional team on this.

    Please ask them how chart of account can be derived for data available in RESB? They will be able to give you proper logic.

    and then apply that logic to write a code in CMOD to fetch the Chart of account information.

    Regards,

    Ashish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 06:19 AM

    Hi,

    As per my suggestion and knowledge if you dont required chart of A/C in reporting level and remove the compounding then according your requirement the output will display .

    Regards

    sivaraju

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 06:41 AM

    Hi Krishna

    You have Plant - WERKS in RESB.

    Using this you will be able to get Company code BUKRS from table T001K.( matching WERKS to BWKEY)

    Using this BUKRS in table T001, you will be able to get chart of acounts KTOPL.

    GL acount without chart of acounts will not have any meaning.

    Hence you need to enhance the extractor with above logic.

    Thanks,

    Krishnan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 07:21 AM

    thanks all for your valuable answers..

    for now my issue is resolved

    I put chart of accounts in rows before g/l account and in display properties for chart of accounts i put it to no display and for g/l i put it to key..

    now i see only g/l account number

    prviously #/50000030

    now 50000030

    though i know g/l account number doesn't make sense without chart of accounts for now our issue is solved.

    thanks & regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.