BCF appends the data in Periodic Model

[Former Member]

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,

[Former Member]

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

[former_member186338]

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!

[former_member186338]

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.

[Former Member]

could you please share what other details are required ? I have configured the same config for legal model with added flows in BR, and it is working fine.

[former_member186338]

If you configured the same settings as in the provided document then it will work correctly.

[Former Member]

I have configured as per the document and the same I have also mentioned in the post.

[former_member186338]

Screenshot of rule setup and properties!

[Former Member]

bcf.png KFA for the business setup and properties for audittrail and category.

[former_member186338]

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

[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

[Former Member]

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

[Former Member]

I dont think...in case of re run, periodic model will overwrite!

[Former Member]

no..it is not..it is adding up the values as we execute BCF.