on 07-29-2015 11:34 AM
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
Hi Roger,
I suggest to go for an alternative approach: DataSource 0FI_GL_14 (New GL Line Items of Leading Ledger). This way you have the Cost Center on line item level (i.e. the right level of granularity). From here you can aggregate and come to the balance figures. The other way around will be very difficult or even impossible.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya,
Please have a look at the following SAP Notes:
Furthermore, you might want to try creating an additional index on table BWFI_AEDAT with the following fields (using t/code SE11):
Last but not least, do not forget to read the attached Word document in SAP Note 1330016 and in addition SAP Note 991429 - Minute Based extraction enhancement for 0FI_*_4 extractors.
Best regards,
Sander
Thank you all! It worked, However, i used 3fi_gl_ol_tt for the GL balances and 0co_om_cca_1 for the cost centers. I put the data into 2 separate DSOs. I appreciate your effort and help. Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.