Export from Data Manager to Text file: remove HEADER line

[Former Member]

Hi experts,

I'm exporting BPC 10.0 data from Data Manager to text file using this transformation:

*OPTIONS

FORMAT = DELIMITED (also tried FIXED)

HEADER = NO

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=7

OUTPUTHEADER=

OUTPUTDELIMITER=

EXPORTFORMAT = MULTIWITHNOHEADER (also tried removing this line)

SPECIFICMAPPING=No

STARTROUTINE=

ENDROUTINE=Z_MY_ROUTINE

*MAPPING

ACCOUNT = *COL(1)

AUDITTRAIL = *COL(2)

BRAND = *COL(3)

CATEGORY=*COL(4)

...

*CONVERSION

CATEGORY=TRANS_DATA\EXPORT_CONVERSION_CATEGORY.XLS

....

Z_MY_ROUTINE is an ABAP endroutine that processes my data. The export table <et_data> contains only 1 column called "output". This column has a long text string with my data correctly formatted.

The problem is that the output file contains an HEADER row called "output" that is the same name of the abap internal table column.

Is there a way to remove that header line?

Thank you

[Former Member]

Hi Alberto,

You need to modify your BADI to remove the header in your code.

take a screen shot of the data in your routine.

Andy

[former_member193143]

Hello Bedin,

In the options use OUTPUTDELIMITER = , instead of DELIMITER

Regards,

Saida Reddy Gogireddy

[Former Member]

For export packages it should be OUTPUTHEADER, not HEADER. Please take a look at Note 2151158 and check if it's applicable to your SP.

[former_member186338]

Hi Alberto,

Test export to text file without ENDROUTINE=Z_MY_ROUTINE. What about header?

Vadim

[Former Member]

Hi Vadim,

Data Manager returns a generic "BW Error" If I run the transformation removing the endroutine.

[former_member186338]

Then there is something wrong with your cube or with the transformation/conversion file. But it's impossible to help without detailed info!

Vadim