Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which extractors are available to extract data from the new General Ledger to BI (Business Warehouse)?

April 26, 2017Bi Business Data Extract extractors ledger warehouse

0

Posted

Which extractors are available to extract data from the new General Ledger to BI (Business Warehouse)?

1 Answer

0

Posted

In ECC 5.0 (=> SAP ERP 2004) and ECC 6.0 (=> SAP ERP 6.0), there is an extractor for extracting totals records from the new General Ledger to BI: 0FI_GL_10. Important: As of Enhancement Pack 3 (=> EhP3) / Business Function FIN_GL_CI_1 (=> New General Ledger Accounting), you can also use the line item extractor 0FI_GL_14 (=> DataSource: BWBCT_DS_0FI_GL_14). This also allows you to extract single documents of the leading ledger for BI reporting. You can also generate extractors for non-leading ledgers (=> transaction code FAGLBW03). The generated extractors are called 3FI_GL_XX_SI, where XX is the name of the ledger. For further information, see (for example) the SAP Library under “General Ledger (New): Line Items of Leading Ledger” or the documentation for the FIN_GL_CI_1 Business Function (=> transaction code SFW5).