Skip to Content
0
Former Member
Sep 19, 2007 at 03:48 AM

EXTRACTing to TEXT file in Data Warehouse - Simple doubts!

25 Views

Hi Experts,

Pls. clarify my simple doubts, in data EXTRACTing prog.,(data extract from SAP to text file in Application server, prog. runs in back ground)

For the Dataware house mapping, I hv been asked to make the following changes,

1) Presently, there is NO column headings in Text file, so I need to add the column Headings - How to get it done?

2) presently, its NOT tab deliminated, so, I need to make it to TAB deliminated- How to achieve it?

I am here paste some piece of code, so that U will get understand well.

PERFORM open_dataset_zdata_whouse_04.

DESCRIBE FIELD i_tab LENGTH tfr_length IN BYTE MODE.

LOOP AT i_itab.

TRANSFER i_itab TO transfer_file1 LENGTH tfr_length.

ENDLOOP.

CLOSE DATASET transfer_file1.

ThaNQ.