Data extraction problem

[Former Member]

Hi Gurus,

i am extracting data from a flat file , the date field is in YYYYMMM format , say for example 2006M01 and i am mapping it to 0calmonth , and when i am trying to load it is giving error CONCVERSION EXIT PIER error , can any one suggest me a solution how to load this date field.

Regards,

Abhi

[edwin_harpino]

dear Abhi,

0calmonth has format MMYYYY e.g 032006.

hope this helps.

[Former Member]

Hi AHP

Thanks for ur reply , so can u suggest me a way how to extract the YYYYMMM format into my BW system from the flat file , Thanks in advance.

Regrds,

Abi

[Former Member]

Ogili

In your falt file give the format as example 20060326 and map this to ocalmonth field in BW.

Hope this helps

Thnaks

Sat

[edwin_harpino]

dear Abi,

if you mean you cannot change the flat file format,

and it means month, you can create a new infoobject e.g zmonth data type char and length 7, and use this infoobject in transfer structure then creae routine for 0calmonth and use routine

concatenate tran_structure-/bic/zmonth4(2) tran_structure-/bic/zmonth0(4) into result.

YYYYMMM normally is for 0fiscper.

take a look threads

hope this helps.