Skip to Content

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

Failed loading from PSA into Cube

Hello,

I tried to load data from flat file into a cube. I defined the processing as PSA only in Infopackage, the loading was OK, but when I loaded data from PSA to cube, it failed. I checked the PSA, the Status indicator was red, this record is the first record in flat file. The detail error message as follow:

TYPE: Red

Message: Value "01.02.20" of characteristic 0Date is not a number with spaces

ID: BRAIN

NO.: 19

LTxt:

One record in flat file as this:

M-01;GP-01;1000;01.01.2006;2006;K4;20

the corresponded infoobjects:

Material;material group;customer;calend day;fiscal year;fiscal year variant;quantity

I was confused much on the error message, I checked flat file, infosource, transfer and update rules,cube and so on. Could you please help me to solve the problem? thanks advaned!

Ryan

replied

Hi,

0DATE has to be available in internal date fomat to book into the infocube. you have the following options:

-Change the 0DATE-column in your flatfile to the format YYYYMMDD.

-In the transfer structure, choose a conversion routine to convert the external date format to internal date format.

Regards,

Beat

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