Online Tutorials & Training Materials | STechies.com
Register Login

Writing Files On Application Server AL11

|| || 10

Writing Files On Application Server AL11
Stechies

Hi all,

I am writing file onto application server AL11.

constants : c_tab type x value '09'.

concatenate w_matnr
w_werks
w_date
w_name2
into lv_data separated by c_tab.

When I checked in AL11, I am getting # symbol between each field.
When I download it to .xls file I am getting the entire record in single column of Excel file.

How to get matnr, werks, date and name in each column of Excel file.
Please help.

Thanks


Comments

  • 22 Aug 2013 6:39 am
    Hi,

    Are you specifying that your file is tab delimited when you are opening it
    in Excel?
  • 22 Aug 2013 6:39 am
    Hi,

    Try using constant CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB in stead of your own defined constant.

    How are you opening the file? Do you specify the proper code page, byte order mark?
  • amit butola
    22 Aug 2013 6:39 am
    Hi,

    I have used
    constants : c_tab type x value '09'.
    In AL11, I am using Download push button on application toolbar.

    Where do we specify tab delimiter? Could you explain in detail?

    Thanks
  • 22 Aug 2013 6:39 am
    Hi,
    Replace c_tab with CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

    Furthermore, check how the OPEN DATASET statement has been specified. Check the documentation of the statement to read up on options for opening datasets on application server.
  • 22 Aug 2013 6:40 am
    Hopefully when you downloaded the file, you didn't specify an Excel file
    extension. That way when you open Excel and select your file Excel will
    recognise that you are opening a non-Excel file and you will get a popup
    window "Text Import Wizard" where you specify in Step 1 that your file is
    Delimited. Click Next >, then in Step 2 you choose Tab from the list of
    Delimiters. Either go on to Step 3 or Finish. Your file will open with
    each field in its own column.
  • amit butola
    22 Aug 2013 6:40 am
    Hi,

    I am developing this in 4.0B version and no OOPs concept.
    I am opening the file using OPEN DATASET P_FILE FOR OUTPUT.

    Please advise.

    Thanks
  • 22 Aug 2013 6:43 am
    Maybe as a tip for next time you put a question on this forum, provide us with this important piece of information.
  • 22 Aug 2013 12:45 pm
    Change the file type to .csv and then try to open it open it. Tell us what
    happens...
  • amit butola
    23 Aug 2013 6:49 am
    Hi,

    Thank you all for your replies. Now I am getting the data separated by tab delimiter with each value in each column.

    Thanks
  • 23 Aug 2013 6:49 am
    The open data set statement has an encoding default or other option for output in text mode or binary mode etc. You should be able to see your line
    The encoding controls the end-of-line which varies from unix to windows etc.

    Then when you open the file since it will be txt mode You will import into excel and will have to use the character that you have used for delimitting.
    Try hard coded ',' for the field separator. The output mode being text it is best to use .txt extension or none.

    Then you should see the file as you want in columns in excel.
    Most of the time you should find 1001 successful code excerpts on the net.
    Good luck.