New GL Reporting with EHP3

[Former Member]

Hi Folks,

Reference:

I am having an issue to find the right BW Content for Financial Reporting. I am confused if I should be using the New GL Datasources are 0FI_GL_14 and 0FI_GL_10 or EHP3 New GL Datasources.

I was reading SDN regarding the EHP3 BW Business Content for Reporting Financials.

I have a question of SAP GL Reporting. I understand there is New GL and the extractions are from FLAGFLEXA and FLAGFLEXT.

Our SAP ECC is on EHP3 and SAP BW has delivered BW Standard content for EHP3 Reporting Financials and on NEW GL. And its a one stop shop for reporting for Finance users - ie no need to use R3 and BW for the same information.

I have read in SAP Forums that there are post implementation issues such as Deltas:

and there is a need for a DSO between the 0FI_GL_20 and 0FIGL_C20. If I do have to create a DSO between the datasource and the cube, what do you recommend the keys as:

http://help.sap.com/saphelp_nw70/helpdata/en/30/44593167d447198995bed770d70ddf/frameset.htm

Please recommed if you came across any challenges doing the EHP3 GL Reports.

Appreciate all your help!

[dennis_scoville4 · Accepted solution]

Here is what I'd recommend as the DSO keys, if you require a DSO in between 0FI_GL_20 and 0FIGL_C20:

InfoObject (DataSource Field)

0VERSION (RVERS)

0COMP_CODE (RBUKRS)

0FISCPER (FISCPER)

0CHRT_ACCTS (CHARTACCTS)

0GL_ACCOUNT (RACCT)

0FUNC_AREA (RFAREA)

0COSTCENTER (RCNTR)

0VTYPE (VALUETYPE)

0PROFIT_CTR (PRCTR)

0SEGMENT (SEGMENT)

0FISCVARNT (FISCVAR)

0CURTYPE (CURTYPE)

0VALUATION (VALUTYPE)

0CURKEY_TC (RTCUR)

0UNIT (CURRUNIT)

[Former Member · Accepted solution]

Dennis,

Thank you for the response.

As for EHp3, reports and extractors delivered as part of BW content. And is more to do with reconciliation at real-time and pertains to the requirements of data governance.

http://help.sap.com/saphelp_nw70/helpdata/en/30/44593167d447198995bed770d70ddf/frameset.htm

We are on EHp3, What is SAP Recommendation to use 0FI_GL_14 (Line Item) and 0FI_GL_10(SUmmary). My Primary Requirement is P&L Statements. Other than the Realtime Reporting, are there any other difference between the 0FI_GL_14/10 and 0FI_GL_20/40/50. Eventually we will also be doing the complete Reporting Financials.

Appreciate your help!!

[dennis_scoville4 · Accepted solution]

What is SAP Recommendation to use 0FI_GL_14 (Line Item) and 0FI_GL_10(SUmmary).

0FL_GI_14 is a delta-enabled DataSource that extracts the general ledger line items for only one ledger, the one that's defined as the 'leading ledger' in your source system. All other ledgers, if you require that data, would require separate DataSources be created for each ledger. These would be named 3FI_GL_XX_SI, where XX would be replaced with the ledger name.

0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. All other ledgers, again if required, would require separate DataSources be created for each ledger. These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. This would be the most appropriate DataSource for your Balance Sheet and Income Statement (P&L) reporting requirements, if you only use one ledger. If you have more than one ledger, you can still use this and add the 3FI_GL_XX_TT DataSources. These would then be integrated into one InfoCube for reporting.

Are there any other difference between the 0FI_GL_14/10 and 0FI_GL_20/40/50?

Yes, there are differences between these DataSources:

0FI_GL_10 - Extracts general ledger balances for only the 'leading ledger'

0FI_GL_14 - Eextracts general ledger line items for only the 'leading ledger'

0FI_GL_20 - Extracts account activity for all ledgers

0FI_GL_21 - Extracts account cumulated activity, for each Fiscal Year/Period, for all ledgers

0FI_GL_40 - Extracts general ledger line items for all ledgers. It differs also from 0FI_GL_14 in that it pulls from mroe tables.

0FI_GL_50 - Extracts general ledger planned line items for all ledgers.

[Former Member · Accepted solution]

Thank You for the responses.

[Former Member]

Hello,

I have a question about FAGLFLEXT (or BSEG).

I wanted to know if in the standard SAP, there is an option/possibility to have the alternative account registered/stored in the posting on the operational chart of account ? Or is it just a display which can help the users.

I hope my question is clear.

Best regards,

Abdel