Skip to Content
avatar image
Former Member

BCF appends the data in Periodic Model

Hello Experts,

We are on BPC 10.1 NW SP14

Issue is standard BCF function appends data in periodic model if we re-run the BCF whereas it overwrites data in a YTD model. We want periodic model should behave same like YTD model where we can avoid clearing the accounts and avoid the data duplication.

REgards,

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Can you explain your logic why you are using BCF???? You are working on Consolidation or Planning model?

  • Get RSS Feed

4 Answers

  • Jan 19, 2017 at 02:25 PM

    Just tested the sample from How-To: http://www.sap.com/documents/2015/08/4c19d052-557c-0010-82c7-eda71af511fa.html

    Working absolutely correct!

    Test model (Periodic):

    ACCOUNT (OPENING_ACCOUNT property not used)

    AUDITTRAIL

    CATEGORY (empty properties CATEGORY_FOR_OPE, OPENING_PERIOD, OPENING_YEAR)

    ENTITY
    FLOW

    RPTCURRENCY
    TIME

    Rule:

    Script:

    *RUN_PROGRAM COPYOPENING
    CATEGORY = %CATEGORY_SET%
    CURRENCY = %RPTCURRENCY_SET%
    TID_RA = %TIME_SET%
    *ENDRUN_PROGRAM

    Report before BCF:

    Result after first script run with CATEGORY=Actual, RPTCURRENCY=USD, TIME=2017.01:

    Log:

    LOG BEGIN TIME:2017-01-19 17:20:33
    FILE:\ROOT\WEBFOLDERS\ENV1\ADMINAPP\PERIODPLAN\BCF.LGF
    USER:V.KALININ
    APPSET:ENV1
    APPLICATION:PERIODPLAN
    RUN COPY OPENING
    1  SUBMITTED, 1  SUCCESS, 0  FAIL.
    SCRIPT RUNNING TIME IN TOTAL:1.00 s.
    LOG END TIME:2017-01-19 17:20:33
    File path: \ROOT\WEBFOLDERS\ENV1\PERIODPLAN\PRIVATEPUBLICATIONS\V.KALININ\tempfiles\20170119172033\BCF.LOG

    Second run with the same parameters resulted in no changes! Log:

    LOG BEGIN TIME:2017-01-19 17:50:46
    FILE:\ROOT\WEBFOLDERS\ENV1\ADMINAPP\PERIODPLAN\BCF.LGF
    USER:V.KALININ
    APPSET:ENV1
    APPLICATION:PERIODPLAN
    RUN COPY OPENING
    0  SUBMITTED, 0  SUCCESS, 0  FAIL.
    SCRIPT RUNNING TIME IN TOTAL:1.00 s.
    LOG END TIME:2017-01-19 17:50:47
    File path: \ROOT\WEBFOLDERS\ENV1\PERIODPLAN\PRIVATEPUBLICATIONS\V.KALININ\tempfiles\20170119175046\BCF.LOG

    After I changed the value in 2016.12 to 2000 and run the script again the result was also correct:

    No surprise!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 08:11 AM

    I am using BCF for planning where I need to carry forward certain adjustments made on BS accounts.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 08:16 AM

    Please provide full info: data sample before and after bcf, script used to run bcf, prompt settings for script, rule setup, etc...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Script Used :

      *RUN_PROGRAM COPYOPENING

      CATEGORY = %CATEGORY_SET%

      CURRENCY = %RPTCURRENCY_SET%

      TID_RA = %TIME_SET%

      OTHER = [ENTITY=%ENTITY_SET%] /

      ENDRUN_PROGRAM

      Prompts are standard :

      CATEGORY : ACTUAL

      TIME: JAN.2017

      RPTCURRENCY : USD

      ENTITY : <all>

      Rule :

      Source GL : GL10001 ( dummy GL) Source Audit : ELIM_MANUAL Audit Type : A and rest all are blank.

      C/F Year and C/F Period properties are been maintained in category dimension.

      Sample Data Before BCF :

      DEC.2016 GL10001 1000

      JAN.2017 GL10001 0

      After 1st Run :

      DEC.2016 GL10001 1000

      JAN.2017 GL10001 1000

      After 2nd Run :

      DEC.2016 GL10001 1000

      JAN.2017 GL10001 2000

      After 3rd Run :

      DEC.2016 GL10001 1000

      JAN.2017 GL10001 3000

  • Jan 12, 2017 at 10:22 AM

    Please compare all your settings with this document: http://www.sap.com/documents/2015/08/4c19d052-557c-0010-82c7-eda71af511fa.html

    I do not see all settings in your answers.

    Add comment
    10|10000 characters needed characters exceeded