Skip to Content
avatar image
Former Member

writing flat file

Hi

what are the prerequisite we need to take care writing falt file or exce sheet to upload the data for any transaction

with example plz EXPLAIN ME like t code FS00 ,

many thanks tou

raju

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2008 at 11:54 AM

    HI..

    let if u want to make flat file for the tcode fs00 ...

    go to tcode fsoo then according to the requairment of the fields select the value of the feild from fsoo n put it in excel sheet ..if the feild is optional then there is no need to put the feild u can just keep a empty cell..then atlast when u hav made entries for all the feilds do it tab delemeted..

    hope this will help....

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 07:42 AM

    Hi,

    You have prepare your flat file considering your fields that you are going to upload into database.

    Here the field length palce sthe major role wise you have format your excel sheet such tht all the rows will be properly shifted into your workarea using.

    If you are instructed to uplaod use a .txt file then declare a structure of the fields u r going to upload and prepare a sample notepad so that spaces will be clear.

    In case of EXCEL formate with Text and restrict the column lengths to the corrosponding fields length.

    Hope this helps you.

    Thks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      Suppose i want to upload my Material master records of MM01.

      I am taking 5 fields as example.

      Material no field length - 18.

      Industry sector - 1.

      Materail type - 4.

      Materail description - 40.

      Unit - 3.

      So for uploading this records your excel sheet should be like enter all your records of the 5 fields after that select all oyu records and right click there you select format cells, we are doing this because according to the length of the field we are uplaoding the data.Last thing which u have to do is select each column in EXCEL file and right click there u can see column width there u restrict the field length for ex material number column right click and column wif=dth set as 18 and so on......

      Hope you got it.

      Cheers!!!

  • avatar image
    Former Member
    Sep 22, 2008 at 06:07 AM

    Hi

    Understand your requirement, go to T-code FS00 create it maually.Note down all required and optional fields for that creation. Now make a text tabdelimited flat file with all those fields in the same sequence.

    This will be enough to write a flat file. Hope you got the answer.

    Regards,

    Tirumala Reddy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 07:26 AM

    Hi

    U discuss ur functional consulatant.Because according to ur recording only u have to prepare ur Flat file..

    Regards:

    Prabu

    Add comment
    10|10000 characters needed characters exceeded