SAP BI DATE FORMAT

[former_member301036]

Hello Experts,

I have made a flat file extractor .  Flat file is coming from Another third part database.

Date format in flat file is in form DD/MM/YYYY  .  but in BI we do not have date dormat DD/MM/YYYY.

My Question is how we can add this date format in BI.

I cannot change the flat file date format because this file comes daily and placed in AL11 automatically.

its also very difficult first downlaod file from AL11 change the datw format in another form  then load the file.

dates Format in SAP BI are available.

Thanks,

Mohit.

[ccc_ccc]

Hi,

You use routine to update DATE required format

Data: w_day(2) type n,

         w_month(2) type n,

         w_year(4) type n.

Clear: w_day,w_month, w_year.

w_day = DATE+0(2).

w_month = DATE+2(2).

w_year = DATE+4(4).

and then CONCATENATE required format.

Examples

1 CONCATENATE  w_month w_day w_year into REQ_DATE

2 CONCATENATE  w_Year w_day w_month into REQ_DATE

Write this routine in transformation for DATE infoobject.

Thank you,

Nanda

[ccc_ccc]

Hi,

You use routine to update DATE required format

Data: w_day(2) type n,

         w_month(2) type n,

         w_year(4) type n.

Clear: w_day,w_month, w_year.

w_day = DATE+0(2).

w_month = DATE+2(2).

w_year = DATE+4(4).

and then CONCATENATE required format.

Examples

1 CONCATENATE  w_month w_day w_year into REQ_DATE

2 CONCATENATE  w_Year w_day w_month into REQ_DATE

Write this routine in transformation for DATE infoobject.

Thank you,

Nanda

[Former Member]

Hi,

In general conversion routine in data source should work but I had few issue in the conversion routine using 'PDATE'  and ended with an Error Msg "Invalid date of birth".

For some reason function module Conversion_Exit_PDATE_INPUT doesn't like the input 30/01/2015 but it works with 30.01.2015 and contradicts with the description of the function module.

So we chose to date as character in data source and handled the date format in the transformation. 

Thanks,

Shakthi Raj Natarajan.