SAP BPC 10.1 NW - Transformation File Account Range & Currency Type

[former_member226891]

Hello,

I am facing a challenge where I need to load the BW data into BPC based on below condition

If Account Range (00010000000 to 00059999999)

Then Load data only for 0CURTYPE = *STR(10) skip *STR(00) records

Else

Then Load data only for 0CURTYPE = *STR(00) skip *STR(10) records

Is this possible to achieve using Transformation File probably using multiple IF conditions or SKIPIF. Below is the current transformation File

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = , AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT=-1 ROUNDAMOUNT=

*MAPPING COST_CTR=0COSTCENTER ACCOUNT=0GL_ACCOUNT__ZBILKT(3:10) T_CURRENCY=*STR(T_)+0CURRENCY ENTITY=*STR(C)+0COMP_CODE INTERCO=*IF(ZTR_PART = *STR(NONE) then *STR(I_NONE) ; *STR(I_C) + ZTR_PART) FLOW=*STR(F)+ZTRTYPE PROFIT_CTR=0PROFIT_CTR CATEGORY=ZBPCATEG DATASOURCE=*NEWCOL(INPUT) RPTCURRENCY=*IF(0CURTYPE = *STR(00) then *STR(TC) ; *STR(LC)) TIME=Z_TIME SIGNEDDATA=ZBALANCE

[former_member186338 · Accepted solution]

"If Account Range (00010000000 to 00059999999)" - only using ROUTINE BADI!

[former_member226891 · Accepted solution]

Hello Vadim,

We are basically facing issue while loading transaction data from BW to BPC for some currencies such as JPY, VND, IDR where key figure length is flowing with more than 13 digits before decimal.

Note : We are already on production and not sure what impact it will have if we modify the Model to large keyfigure.

While I understand when I see data in BW Infocube I see data with less than 13 digits, this is because I select "Do Not Use any Conversion". But when same data flows to BPC it is coming with more than 13 digits.

So is there any way where I can load data from BW on the assumption of "Do No Use any Conversion"?

Thanks & Regards,

Ravi

[former_member186338 · Accepted solution]

Sorry, but your comment is not related to original question.

Please accept the correct answer and open a new question!