Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC loading BW trans data to BPC with selection on 0FISCPER

Hello ,

I am trying to load the data from BW to BPC with the selection on 0FISCPER  format example : 2012012 . However whenever i load with this selection the package in BPC fails with the error message "The current value in the selection is not in the format required" . Can someone help me resolve and load the transcation data ?

Transformation file :

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=NO
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=
CONVERTAMOUNTWDIM=CENTROCUSTO
*MAPPING
CATEGORY=0VTYPE
EMPRESA=0COMP_CODE
CENTROCUSTO=0CO_AREA+0PROFIT_CTR
CLASSE=0ACCOUNT
TIME=0FISCPER
VERSAO=*STR(INICIAL)
SIGNEDDATA=0CREDIT
*CONVERSION
TIME=FISCPER.XLS
AMOUNT=inverte_sinal.xls

CONVERSION file : FISCPER.XLS

EXTERNAL     INTERNAL

????001     ????.JAN

????002     ????.FEB

????003     ????.MAR

????004     ????.APR

????005     ????.MAY

????006     ????.JUN

????007     ????.JUL

????008     ????.AUG

????009     ????.SEP

????010     ????.OCT

????011     ????.NOV

????012     ????.DEC

Former Member
Former Member replied

Hi Gersh,

Thanks for all the help .  Looks like 1695530 did resolve the issue . The below example does work .

0FISCPER  -  2013001

0FISCPER  -  2012001

0FISCVARNT - K4


My last update  on  Mar 13, 2015 3:20 PM  was due to the fact that ..the period which i selected had blank records causing the package failure. I tried a different period and it worked fine .


Thanks once again .


Best Regards

Ram

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question