chart of accounts for G/L account

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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