Skip to Content
0

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

Apr 11 at 02:01 AM

26

avatar image

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Apr 11 at 08:14 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

Please accept the correct answer and open a new question!

0