Skip to Content
avatar image
Former Member

Flat File

Hi,

I have Month and Year coming from flat file( like 122007). How should I load this into SAP ( like into Calmonth and Cal year)

Also,

I have scenario where in I have a file with around 200 fields. Its sales data. Do I have to create custom fields for all or I should use sap fields. These fields are a lot diff from R3 sales data.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 04:32 PM

    Hi Sridhar,

    You can use 0CALMONTH and load the data and also you can apply required conversion Routine (PERI6 or ALPHA) if there is any change in the format depending on the requirement.

    It is better to use the SAP defined infoobjects for those fields, all you have to do is map the fields with the same Data type and length, if there are no objects with the required Data type and length, you can create new infoobjects.

    Hope this helps............

    Rgs,

    Ravikanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:10 PM

    Hi,

    BW wants date related objects to be in the format YYYYMMDD, so you need to convert your field to YYYYMM in order to get it to read in successfully.

    Change it in your transfer rules before the data comes in ... here's some of the code:

    Calendar Month/Year field = MONTH (this is the MMYYYY value you receive)

    Year = MONTH+2(4).

    MTH = MONTH+0(2).

    CONCATENATE YEAR MONTH INTO RESULT.

    Of course, since this is a flat file, you can always change the format in the file either at creation or using Excel.

    Also, for you 200+ fields, you will either need to use pre-defined characteristics or create custom characteristics for each field you bring into BW. Good luck on that -and- are you really going to use all of them?

    Brian

    Add comment
    10|10000 characters needed characters exceeded