SAP NetWeaver 7.0 Data Retraction in BI Integrated Planning Detlef Wassmuth, SAP NetWeaver PM BI, SAP AG Marc Bernard, SAP NetWeaver RIG US, SAP LABS LLC Version 1.0
Overview Details
Data Retraction in BI Integrated Planning With BI Integrated Planning… No new standard retractors are shipped You can use retractors that work according to the pull principle without changing them You cannot directly use retractors that work according to the push principle You can use retractors that work according to the push principle by configuring them in BW-BPS Planning Application
SAP R/3- Module
Retraction Method
Controlling / Profitability Analysis
CO-PA
SAP R/3-Add-In ("Pull")
Industry-Specific Components / Public Sector / Funds Management / Budget Control System
PSM-FM-BCS
SAP R/3-Add-In ("Pull")
Overhead Cost Controlling / Cost Center Accounting
CO-OM-CCA
Planning function type Exit ("Push")
Project Planning + Investment Management
PS / IM
Planning function type Exit ("Push")
Financial Accounting / Special Purpose Ledger
FI-SL
Planning function type Exit ("Push")
Enterprise Controlling / Profit Center Accounting
EC-PCA
Planning function type Exit ("Push")
© SAP AG 2007
Overview Details
Retractor: CO-PA Documentation
Online documentation in Implementation Guide (transaction SPRO): Profitability Analysis > Tools > Data Transfer Between CO-PA and Other Systems > Data Transfer from SAP BW SAP Note 605208 How-to Paper "CO-PA Retraction"
Source System Release
As of SAP BW 3.0
Target System Release
As of SAP R/3 4.0B, PI 2001.1
Retraction Method
"Pull": BW query and R/3 program RKEBW3RE
Customizing
Transaction KELC (in target system):
Define field assignments
Execution
Transaction KELR (in target system):
Execute data transfer
© SAP AG 2007
Retractor: PSM-FM-BCS Documentation
Online documentation in Implementation Guide (transaction SPRO): BCS Budgeting > Budget Entry > Plan Data Transfer from BW Online documentation: http://help.sap.com/saphelp_erp2005vp/helpdata/en/e0/d8fc3f37c2e369e10000000a155106 /frameset.htm Migration: http://help.sap.com/saphelp_erp2005vp/helpdata/en/76/c128403a97e801e10000000a15510 6/frameset.htm
Source System Release
As of SAP BW 3.0
Target System Release
Old method valid for SAP ERP 2004 Enterprise Add-On Public Sector 2.00 New method valid as of SAP ERP 2005 Enterprise Add-On Public Sector 5.00
Retraction Method
"Pull": BW Query and R/3 program
Customizing – Old and New Method
Transaction SPRO (in target system):
Define field assignments
Execution – Old Method
Transactions FMBPRET_BCS FMBPREVERSE_BCS (in target system):
Execute data transfer / reverse budget entries
Execution – New Method
Transactions FMCYCOPI_BW FMDOCREV (in target system):
Execute data transfer / reverse budget entries
© SAP AG 2007
Retractor: CO-CCA Documentation
Online documentation: http://help.sap.com/saphelp_sem60ep1/helpdata/en/99/97157967e3440a94d199538959cd0 b/frameset.htm See SAP Note 525543 for additional documentation on field mapping.
Source System Release
As of SAP BW 2.0B, SEM 3.0B
Target System Release
As of SAP R/3 4.5B
Retraction Method
"Push": BPS planning function type Exit and R/3 BAPIs
Customizing
Transaction BPS0
Create planning function Init Function Module: UPR_COST_PLAN_INIT Main Function Module: UPR_COST_PLAN_EXEC
Execution
© SAP AG 2007
Transaction UPBR_STRUCT
Maintain field mapping (optional)
Transaction BPS0
Execute planning function
Retractor: PS / IM Documentation
See online documentation of function module UPB_CI_PUSHBACK_MATCH_IP (transaction SE37) See SAP Note 503399 for additional documentation
Source System Release
As of SAP BW 2.0B, SEM 3.0B
Target System Release
As of SAP R/3 4.5B
Retraction Method
"Push": BPS planning function type Exit and R/3 BAPIs
Customizing
Transaction BPS0
Create planning function Init Function Module: Main Function Module: Program positions: Appropriation requests: WBS elements:
Execution
© SAP AG 2007
Transaction BPS0
UPB_CI_PUSHBACK_INIT UPB_CI_PUSHBACK_MATCH_IP UPB_CI_PUSHBACK_IQ UPB_CI_PUSHBACK_PR
Execute planning function
Retractor: FI-SL (unofficial) Documentation
None
Source System Release
As of SAP BW 2.0B, SEM 3.0B
Target System Release
As of SAP R/3 4.5B
Retraction Method
"Push": BPS planning function type Exit and R/3 BAPIs
Customizing
Transaction BPS0
Create planning function Init Function Module: UPR_FISL_PLAN_INIT Main Function Module: UPR_FISL_PLAN_EXEC
Execution
© SAP AG 2007
Transaction BPS0
Execute planning function
Retractor: EC-PCA (unofficial) Documentation
None
Source System Release
As of SAP BW 2.0B, SEM 3.0B
Target System Release
As of SAP R/3 4.5B
Retraction Method
"Push": BPS planning function type Exit and R/3 BAPIs
Customizing
Transaction BPS0
Create planning function Init Function Module: UPR_PCA_PLAN_INIT Main Function Module: UPR_PCA_PLAN_EXEC
Execution
© SAP AG 2007
Transaction BPS0
Execute planning function