Date format and invalid text

[Former Member]

Hi all,

This is just example I am going through and I faced with problem in date format and invalid data like hex,and even I changed date format to PDATE, but still it is coming invalid data, any suggestion and also on invalid data like 'hex'and also tried to change in PSA, but still it is coming same problem.Following are the problems in date and invalid data.

1.Record 1 :Value 'Software Engineer ' (hex. ' ') of characteristic DESGTN contains invalid cha

2. Record 1 :Value '02/03/78 ' of characteristic 0DATE is not a number with spaces

regards,

VJ

[Former Member · Accepted solution]

Hi VJ,

Have you checked 'Lowercase letters' flag for DESGTN IO?

Why don't you use 0CALDAY instead of 0DATE?

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

Thank you for reply.How to define 0CALDAY to field as previously have not define 0DATE to the date field.kindly reply me.

thanx,

VJ

[Former Member · Accepted solution]

Hi,

Insert into communication structure of the infource 0CALDAY (just type it in). In transfer rule map it with incoming date field.

To transform incoming date format into 'YYYYMMDD' one, use a routine proposed by Ravi Raj here:

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

Following error is coming while I added 0CALDAY and atttached to DATE field. Program is not generating.help me.

Error generating program

Message no. RSAR245

Diagnosis

An error occurred in the program generation:

Program / Template: RSTMPL80

Error code / Action: 6

Row: 49

Message: Statement concluding with "...LIKE" ended unexpect

Procedure

If the problem occurred during the data load or transport, activate the transfer rule.

If the problem persists, search in the SAP note system under 'RSAR 245'.

regards,

VJ

[Former Member · Accepted solution]

VJ,

You need to map 0CALDAY (in comm structure) with incoming date field and place the code like you see in the previous message link in transfer rules.

0DATE - where is this field located, DS fields, comm structure field?

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

I did what you said, it worked some extent, but field "date of birth" data is not visible in the datatarget though it is successful and I have not type in any 0DATE in either of DS or Communication Structure.

What I did is attached 0CALDAY to Date of Birth Field in transfer rules and attached that routine to that field and it was everything successful but data is not coming into Date of Birth Field only.

help me,

VJ

[Former Member]

Hi VJ,

I think the special cheracter / is incorrect in date format. Check before records in source system and BW system.

[Former Member]

Hi VJ,

The date format for a flatile has to be YYYYMMDD and if possible have all your flatfile data in Upper case.

Bye

Dinesh

[edwin_harpino]

hi VJ,

the date should be in YYYYMMDD format