BPC:NW - Best practices to load Transaction data from ECC to BW

[Former Member]

I have a very basic question for loading GL transaction data into BPC for variety of purposes, would be great if you can point me towards best practices/standard ways of making such interfaces.

1. For Planning

When we are doing the planning for cost center expenses and need to make variance reports against the budgets, what would be the source Infocube/DSO for loading the data from ECC via BW, if the application is -

YTD entry mode:

Periodic entry mode:

What difference it makes to use 0FI_GL_12 data source or using 0FIGL_C10 cube or 0FLGL_O14 or 0FIGL_D40 DSOs.

Based on the data entry mode of planning application, what is the best way to make use of 0balance or debit_credit key figures on the BI side.

2. For consolidation:

Since we need to have trading partner, what are the best practices for loading the actual data from ECC.

What are the typical mappings to be maintained for movement type with flow dimensions.

I have seen multiple threads with different responses but I am looking for the best practices and what scenarios you are using to load such transactions from OLTP system. I will really appreciate if you can provide some functional insight in such scenarios.

Thanks in advance.

-SM

[Former Member]

Hi Gurus,

Any suggestions.

-SM

[MarkPBurke]

For - planning , please take a look at SAP Extended Financial Planning rapid-deployment solution:  G/L Financial Planning module.   This RDS captures best practice integration from BPC 10 NW to SAP G/L.  This RDS (including content and documentation) is free to licensed customers of SAP BPC.   This RDS leverages the 0FIGL_C10 cube mentioned above.

  https://service.sap.com/public/rds-epm-planning

For consolidation, please take a look at SAP Financial Close & Disclosure Management rapid-deployment solution.   This RDS captures best practice integration from BPC 10 NW to SAP G/L.  This RDS (including content and documentation) is also free to licensed customers of SAP BPC.

https://service.sap.com/public/rds-epm-fcdm

Note:  You will require an SAP ServiceMarketplace ID (S-ID) to download the underlying SAP RDS content and documentation.

The documentation of RDS will discuss the how/why of best practice integration.  You can also contact me direct at mark.p.burke@sap.com for consultation.

We are also in the process of rolling out the updated 2015 free training on these two RDS.  Please register at this link and you will be sent an invite.

https://www.surveymonkey.com/s/878J92K

If the link is inactive at some point after this post, please contact Mark.p.burke@sap.com