Skip to Content
Introduction:

In the first blog I have discussed on creating sender structure for CCA Retraction and in this blog I would explain how to configure CCA Retractor in planning function for retracting Primary Costs and Quantity

Pre-requisite:

Steps

  1. Use already created RFC Destination or Create a RFC Destination to R/3 System
    1. Go to SM59 and create a system of type 3, specify RFC destination name, target host
    2. In Login/Security tab, Specify the client, User, Password
    3. Test connection
  2. image
  3. Create a Planning Level – Create a Planning under the planning area

    image

    Select Characteristics and Key Figures as required as shown below.

    image

  4. Create a Package – Create a Package (0-ADHOC)
  5. Create a Planning Function – Create a Planning function as an Exit function by specifying the planning function name and description.

    image

    1. Specify the ‘UPR_COST_PLAN_EXEC’ in Function Module and ‘UPR_COST_PLAN_INIT’ in FM initialization
    2. Move reqd fields into ‘Fields to be changed’ from ‘Field list’.
    3. In Parameter Exit Functions specify the following parameters.
    Parameter
    Data Element
    BUSI
    CASE
    DELTA
    MAPP
    RFC_DEST
    TEST
    VERSR3
    WAIT
    ZARE
    ZELM
    ZTYP
    I_BUSI
    I_CASE
    DEL_BOOK
    KCD_REPID
    RFCDEST
    TST_X
    I_VERS
    I_WAIT
    I_COAR
    I_CELM
    I_CTYP

    image

  6. Create a Parameter Group – Create a Parameter Group, Specify the name and description and maintain parameter values as shown below

    image

    Fields
    Single Value
    Retr. R/3 Comp.
    Retractor Control
    Delta Update
    Sender str.
    Destination
    Test mode Is Active
    R/3 Version
    Wait for Update
    Controlling Area
    Cost Element
    CElem category
    6
    4
    1
    UPB_SND_COPS
    DEVCLNT100
    0
     
     
    01
    02
    03

    image

    For Ret. R/3 Comp – Select 6 (CostCenter Accounting)

    image

    Retractor Control is 4(Primary Cost)

    image

    Delta Update – 0

    image

    Test mode is Active – 0

    image

    Controlling Area – 01, Cost Element – 02, CElem category – 03

    image

Important Steps

  • Avoid including the Fiscal Year / Period (0FISCPER) in the planning Level characteristics. So that aggregation is done for all the periods. (If not retractor will run for each period and only last period is updated and all other period values are blank).
  • Make sure to pass the Unit of Measure when passing the Quantity else retractor wont update the Quantity in R/3. (Either you can map the field or maintain constant in the sender structure)

How to test:

  1. Select Planning Area –> Select Planning Level –> Select Package
  2. Select Planning Function –> Right click on Parameter Group and click on Execute with Trace
  3. image

  4. After successful retraction log is displayed along with the trace
  5. image

Check the retracted data in R/3-

  1. Run Tcode KSBP-Cost Center: Plan Line Items,
  2. Specify the Cost Center, Cost Element, Version , Period, Fiscal Year
  3. Click on Execute
  4. Verify the retracted Total Fixed Value & Total Fixed Qty for the combination of Cost Center, Cost Element, Version, Period, Fiscal Year & Activity Type

Further DocumentationCost Center Planning: Data Retraction

In my next blog I will discuss on retraction of Activities/Prices.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Srinivas Kamireddy
    Dear Praveen,

    We have followed your document in setting up the standard retractors for retractig PS data from BW to ECC 6. We are using the standard retractor with the following function modules: UPR_COST_PLAN_INIT and UPR_COST_PLAN_EXEC.

    The data gets retracted successfuly, but for only one Fiscal year when I have multiple fiscal years. For example, my cube contains the values for the Fiscal year 2007 and 2008. But, the records for fiscal year 2007 are only getting retracted to the COSP table in ECC6.

    If I restrict the fiscal year to an interval of 2007 and 2008 in the planning package, only 2008 values are getting retracted.

    Request your assistance in this regard.

    Regards,
    Srinivas Kamireddy.

    (0) 
  2. Dan J Lafon
    Do you have to have SEM installed on your BW instance for this to work?  We are not able to get the transfer program to generate: KCDSM-PROGN.
    Txs,
    Dan
    (0) 

Leave a Reply