Skip to Content

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

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 11 at 08:14 AM

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

    Add comment
    10|10000 characters needed characters exceeded