Skip to Content
avatar image
Former Member

Date format in flat file

Hi all:

I want to create a flat file to load data into an IC.

i have cal month data in my flat file. i am having the format as:

200508

200509

200510

200511 and so on.

i used 0calmonth as my time characteristic in my Infosource and i have a flagged for conversion routine also.

but when i tried to preview in the Infopackage its not showing up. it says error: error 1 when loading data some times and also pern1 error also.

i think its the problem with the date format i am using in myflat file. can anybody please tell how to maniatin the format for calday/ calmonth/ calyear data in an flat file..

Thanks

kedar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 18, 2006 at 02:28 AM

    Hi Kedar,

    Format for 0calday in flat file (yearmonthday):

    20051201

    20061102

    Format for 0calmonth in flat file (yearmonth):

    200512

    200611

    I think the problem is not with ur flat file data. It may be due to the format in which it is loaded into ur cube. I mean to ask whether ur flat file is .csv file? If so, whether u ve chosen the settings correctly in the "external data" tab in ur infopackage?

    Hope it helps....let me know

    Regards,

    RV.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi suresh yadav,

      Conversion exits are used mainly to transfer Source system representation of data to BW representation and Vice Versa..

      eg:

      say this is a source system field

      EmployeeNumber: NUMC(7)

      In R/3 Source system A: you may have it like 0000023

      In Source system B:you may have it like 45 only for a 7 digit integer number

      so when you load data to BW.. all the above different formats will be converted to one Single Internal BW representation like 0000023, 0000045.

      this may be the case for any kind of data types that SAP supports between source systems and BW system.

      hope i answered your question, and if you need more info on the conversion exits.. just give me ur mail id. i will send u a document on that..

      Dont forget to assign points if u find it helpful..

      bye..

      kishore

  • avatar image
    Former Member
    Mar 18, 2006 at 02:01 AM

    Kedar

    I did flat file update long back try to do 082005, 092005 and so on.

    I am not sure whether it helps or not

    Thnaks

    Sat

    Add comment
    10|10000 characters needed characters exceeded