Question Re: Export from Data Manager to Text file: remove HEADER line in Financial Management Q&A

Export from Data Manager to Text file: remove HEADER line

Former Member — Wed, 01 Jul 2015 11:33:43 GMT

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

Re: Export from Data Manager to Text file: remove HEADER line

former_member186338 — Wed, 01 Jul 2015 12:01:13 GMT

Hi Alberto,

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

Vadim

Re: Export from Data Manager to Text file: remove HEADER line

Former Member — Wed, 01 Jul 2015 12:45:48 GMT

Hi Vadim,

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

Re: Export from Data Manager to Text file: remove HEADER line

former_member186338 — Wed, 01 Jul 2015 12:57:36 GMT

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

Vadim

Re: Export from Data Manager to Text file: remove HEADER line

Former Member — Mon, 06 Jul 2015 01:47:30 GMT

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.

Re: Export from Data Manager to Text file: remove HEADER line

Former Member — Mon, 06 Jul 2015 11:36:08 GMT

Hello Bedin,

In the options use OUTPUTDELIMITER = , instead of DELIMITER

Regards,

Saida Reddy Gogireddy

Re: Export from Data Manager to Text file: remove HEADER line

Former Member — Mon, 06 Jul 2015 23:52:23 GMT

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