Skip to Content
0
Former Member
Jul 29, 2015 at 10:34 AM

Extracting G/L Account data Balances and distinguishing by Cost Center

369 Views

Hi

I have a requirememnt where i should create a structure that has G/L Accounts, Aggregated Total and the Cost Center that distinguishes the Gl Accounts. What is my best bet? Currently i have tried two methods: 1) using a generic datasource like 0fi_gl_10 but it doesn't have cost center information(located in table COEP. Also 2) i have tried to create a customized structure in which i do get the 'cost centers' but i cant get the 'accumulated balance field'(which is in 0fi_gl_10). Only fields such as TSL01, TSL02 up to TSL12. The leading ledger is FMGLFLEXT

Please Note i only want to extract the balance from fmglflext and the cost centers. i don't want the actual costs in monetary value. The goal is to separate GL Accounts by Cost Centers. I have attached shots of the structure.

Any assistance will be fully appreciated

Regards,

Roger

Attachments

Structure2.jpg (247.8 kB)
Structure.jpg (242.5 kB)
join.jpg (179.3 kB)