Use of BPS CCA Retraction via custom Planning Function Type (CL_RSPLFC_BPS_EXITS)

SAP BW,

In this post I describe the step by step process you should use to execute BPS CCA Retraction to R3 thorough an IP Planning Function.

In my business scenario, users want to be able to synchronize R/3 plan data as soon as they save the changes made via a BEx Workbook, so that they can perform some extra steps (ie. they cannot approve a PO if the Plan amount is not available in R3).

  1. Prerequisite: Setup BPS retraction. This means that you have created in BPS:
    a.  Planning Area over the Real Time Infocube that contains the IP CCA data to be retracted.
    b. I am not sure that the Planning Level, Planning Function (calling the BPS CCA Exit) and Parameter Group are necessary. In myu environment they had been setup for BPS based retraction.
  2. Create a set of Infoobjects that will be used to setup the Ip Function Type Parameters that neet to match the BPS Function Parameters. See below for the list of infoobjects. You then need to maintain some values for each infoobject. All infoobjects created should be set ‘without master data’ and with language independent medium text.
  3. Create a Planning Function Type Z_BPS_CCA_RETRACTION.
    Set Class to CL_RSPLFC_BPS_EXIT and Check the Reference Data option.
  4. Add Parameters to the Planning Function as follows.
  5. Prepare an aggregation level. Create a filter that will select the data to be retracted.
  6. Create a planning function using the Function Type Z_BPS_CCA_RETRACTION. Do not set any field as “to be changed”
    Set the Parameters as follows:
  7. Create a Planning Sequence with 1 step to execute the function.
  8. To debug: SE80 class CL_RSPLFC_BPS_EXIT. Put a breakpoint at the start of each method. Check the content of C_TH_DATA and also the content of the other tables that are passed to the Init and Exec BPS functions.

Name of the BPS Exit FM = UPR_COST_PLAN_EXEC – UPR_COST_PLAN_INIT

HowTo call BPS Exit from IP => http://scn.sap.com/docs/DOC-16115

Documentation on Class CL_RSPLFC_BPS_EXITS http://www.consolut.com/en/s/sap-ides-access/d/s/doc/N-CL_RSPLFC_BPS_EXITS

Implementation example by a IP Consultant : http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0b39ee8-cf4a-2d10-e68c-af5a232bfae8?QuickLink=index&overridelayout=true

SAP Help / SEM 3.5 / CCA Retraciton http://help.sap.com/saphelp_sem350bw/helpdata/en/99/97157967e3440a94d199538959cd0b/frameset.htm

SAP Help on BPS Exit functions: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/81/b54aa832e911d4b2c10050dadfb23f/frameset.htm

Links referring to this:

http://scn.sap.com/thread/1239098 (unsolved)

http://scn.sap.com/thread/531339 (2007, unsolved)

http://scn.sap.com/thread/470281 (2007, unsolved)

…

Create InfoObjects to mirror the BPS PF parameters (all with no MD+ Medium Text not lang dep)

ZBPSPN1 / NUMC 1 used to pass all BPS Exit NUMC 1 parameters

ZBPSPBUS, ZBPSPCAS, ZBPSPFLG copies of ZBPSPN1

ZBPSPC1 / CHAR 1 used to pass all BPS Exit CHAR 1 parameters

ZBPSPDLT, ZBPSPTST copies of ZBPSPC1

ZBPSPC3 / CHAR 3 used to pass all BPS Exit CHAR 3 parameters

ZBPCPC30 / CHAR 30 used to pass all BPS Exit CHAR 30 parameters

ZBPSPCAR, ZBPSPCEL, ZBPSPTYP copies of ZBPCPC30

ZBPCPC32 / CHAR 32 used to pass all BPS Exit CHAR 32 parameters

ZBPCPC40 / CHAR 40 used to pass all BPS Exit CHAR 40 parameters

RPSPLF1 settings – Parameters

All Elementary

Parameter / IOBJ / BPS Data Element

AREA / ZBPSPC8 / ???

BUSI / ZBPSPBUS / I_BUSI

CASE / ZBPSPN1 / I_CASE

DELTA / ZBPSPC1 / DEL_BOOK

MAPP / ZBPSPC40 / KCD_REPID

RFC_DEST / ZBPSPC32 / RFCDEST

TEST / ZBPSPTST / TST_X

VERSR3 / ZBPSPC3 / I_VERS

WAIT / ZBPSPFLG / I_WAIT

ZARE / ZBPSPCAR / I_COAR

ZELM / ZBPSPCEL / I_CELM

ZTYP / ZBPSPTYP / I_CTYP

Maintain master data of appropriate element to be able to use a value in RSPLAN in tha Planning Function

ZBPSPBUS

6 Cost Center Accounti
7 Internal Orders
8 Activity-Based Costi
9 Project System

ZBPSPCAS

1 Activities/Prices
2 Activity Input
3 Statistical Key Figu
4 Primary Costs

ZBPSPDLT

0 Add Values to Existing Values
1 Update Values Absolute

ZBPSPTST

0 Execute Update
1 Test Without Update

ZBPSPFLG

0 No
1 Yes

ZBPSPC40

UPB_SND_COPS Retraction of PS  (for MAPP / KCD_REPID)

ZBPSPC32

SI2CLNT111 (for RFC_DEST value)

Leave a Reply