Question Re: Date format and invalid text in Technology Q&A

Date format and invalid text

Former Member — Thu, 10 Nov 2005 05:18:49 GMT

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,

Re: Date format and invalid text

edwin_harpino — Thu, 10 Nov 2005 05:28:33 GMT

hi VJ,

the date should be in YYYYMMDD format

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 05:35:31 GMT

Hi VJ,

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

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

Best regards,

Eugene

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 05:55:38 GMT

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

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 06:09:34 GMT

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,

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 06:24:45 GMT

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

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 07:12:13 GMT

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,

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 08:03:13 GMT

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

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 08:25:44 GMT

Hi VJ,

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

Re: Date format and invalid text

Former Member — Thu, 10 Nov 2005 09:25:07 GMT

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,