topic Re: Inserting Spaces? in Application Development and Automation Discussions

Inserting Spaces?

Former Member — Thu, 28 Jun 2007 17:22:18 GMT

Hi Guys,

I am downloading data from SAP database.For ex consider BKPF table.Before transferring the data into a Text file in Application Server.Can anybody tell how to insert spaces in the internal table for all the fileds with no value

for ex : if a field has length of 15 and i was able to fill only tha value upto 10 length and how to fill the remaining 5 length with spaces like that for all the fileds in an Internal Table?

Thanks,

Gopi.

Re: Inserting Spaces?

Former Member — Thu, 28 Jun 2007 17:29:03 GMT


    CALL FUNCTION 'GUI_DOWNLOAD'
      EXPORTING
        FILENAME                = FILENAME
        FILETYPE                = 'ASC'
        WRITE_FIELD_SEPARATOR   = 'X'
        TRUNC_TRAILING_BLANKS   = 'X'

Greetings,

Blag.

Re: Inserting Spaces?

Former Member — Thu, 28 Jun 2007 17:31:03 GMT

define a new internal table with all char fields like

Data: Begin of ITAB_NEW occurs 0,

f1(10),

f2(15),

f3(20),

End Of ITAB_NEW.

pass the value to this ITAB_NEW and use this ITAB to download the data to application server

this ll solve your space problem

Thanks & regards

vinsee

Re: Inserting Spaces?

Former Member — Thu, 28 Jun 2007 17:31:26 GMT

Hi Alvaro,

I have to download the data into Application Server , so can u tell me for Application Server is there any FM for inserting spaces into null values and also for fields whose length is not completely used?

Thanks,

Gopi.

Re: Inserting Spaces?

Former Member — Thu, 28 Jun 2007 22:48:08 GMT

I think that the answer from Vinod Bokade is correct -:)

Greetings,

Blag.

Re: Inserting Spaces?

Former Member — Thu, 28 Jun 2007 23:00:52 GMT

Hi alvaro,

I had done like that only i declared character type internaltable but alos same result.

can u tell me how to insert spaces in to a character filed of length 20.

suppose if it get filled only upto 10 how to fill the other 10 with Spaces?

Thanks,

Gopi.