Routine: Get Charact. between Quotation Marks on a Flat File

[Former Member]

Hi there,

I am trying to fulfill the following requirement.

Download to a Flat File from a DSO to App Server using Open Hub and get:

- a constant u201C1234u201D

- plus a u201Ccharacteristicu201D

Though both values need to be on the Flat File generated with Quotation Marks that is to get the value u201C1234u201D as a constant and u201Ccharactu201D.

Both values including the u201C (Quot Marks).

For the constant I already managed.

But for the characteristic coming from the DSO I cannot see any other way rather than implementing a routine.

Can we amend directly the GP* report generated on the Transformation? Think not.

Any suggestion for that little routine that adds a Quotation Mark u201C u201C ant the beginning and end of the Characteristic would be very very much appreciated.

Thank you in advance for your input.

Alex

Edited by: Alex M on Jan 24, 2011 11:17 AM

[Former Member · Accepted solution]

concatenate '"' <source field> '"' into <target field>.

'"' = ' " '

a " (double quote) in ABAP means comment... so you need to put it in between ' ' (single quotes)

[Former Member · Accepted solution]

Thank you RB !

found out the way you mentioned -using Routine - being something like:

 DATA: L_NUMC(6) TYPE N.

    L_NUMC = SOURCE_FIELDS-QUANTITY.
    CONCATENATE '"' L_NUMC '"' INTO RESULT.

(Example from above is for a Key Figure)

And also found out that could be achieved using Fox Fomula Editor:

 '"' & characteristic  & '"'