topic Re: Simple transformation formatting in Application Development and Automation Discussions

Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:41:05 GMT

Dear Expert,

I would like to know how can I format my transformation result using simple transformation. I have an attribute that is supposed to display a date in the format YYYYMMDD. However, the default format is YYYY-MM-DD. How can I change this behavior in simple transformation? Thanks!

Regards,

Alex

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:45:21 GMT

you may use EDITMASK.

FOLLOW the link http://www.sap-basis-abap.com/sapab015.htm

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:45:25 GMT

HI ,

you split (keyword) the variable at '-' and collect iinto three different variable and make the required format.

Thanks

Shambhu

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:46:22 GMT

HI ,

you split (keyword) the variable at '-' and collect iinto three different variable and make the required format.

Thanks

Shambhu

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:46:43 GMT

hi,

you can use concatenate in that case :

CONCATENATE: zdate+6(02)

'-'

zdate+4(02)

'-'

zdate(04) INTO date.

hope this will surely help you!!!

Thanks & Regards,

Punit Raval.

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 10:48:25 GMT

USE EDIT-MASK command in your program.

EDIT-MASK 'YYYYMMDD'.

Re: Simple transformation formatting

former_member189420 — Mon, 06 Jul 2009 10:52:17 GMT

Hi,

data: gv_chars TYPE char100.

gv_chars = '2009-07-06'.

replace all occurrences of substring '-' in gv_chars with ''.

Hope this helps.

Regards,

Anand Patil

Re: Simple transformation formatting

Former Member — Mon, 06 Jul 2009 12:21:30 GMT

use edit-mask a EDIT-MASK - 'YYYYMMDD'.

Re: Simple transformation formatting

Former Member — Tue, 07 Jul 2009 01:42:04 GMT

Dear Experts,

Thanks for all the previous input. However, I think my title is not clear enough. "Simple transformation" is a SAP terminology that help developer to export / transform data in XML. The above suggestion cannot be applied in simple transformation.

I am looking for way to apply date format in the XSLT used in simple transformation. Thanks!

Regards,

Alex

Re: Simple transformation formatting

Former Member — Wed, 28 May 2014 06:57:51 GMT

Hey Alex,

do you have a solution already? I have the same problem, the format of the date in the XML-File is "20140101" and I can´t transform it with Simple Transformation to the ABAP Type DATS which waits for "2014-01-01" or "2014.01.01".

the Transformation looks like this in the moment:

...

...

The ABAP type of the field DATE is DATS. And the XML looks at this part like this:

Regards,

Christoph

Re: Simple transformation formatting

JerryWang — Sat, 28 Jun 2014 08:45:27 GMT

Hello Alex,

in the simple transformation an external ABAP class could be used to do date format manually. See my solution in this document: http://scn.sap.com/docs/DOC-56211

Best regards,

Jerry

Re: Simple transformation formatting

JerryWang — Sat, 28 Jun 2014 08:46:37 GMT

Hi Christoph,

as I demonstrate in my document, this could be done via an external ABAP class call within the simple transformation.

Best regards,

Jerry

Re: Simple transformation formatting

Former Member — Mon, 07 Jul 2014 06:46:14 GMT

Thanks Jerry !!

I think that will work for me, I will test it later, but this looks like the solution I searched for

I have not tested it yet, but I think, it will only work for the output of the XML file, or? If it should work for both (output/input of xml <=> itab), with same Transformation, the method "GET_NEW_DATE" should be extended a bit

But this sould be possible without problems.

best regards,

Christoph

Re: Simple transformation formatting

Astashonok — Thu, 30 Jul 2020 13:19:38 GMT

the correct link now is https://blogs.sap.com/2014/06/26/change-date-format-in-web-service-response-for-crm-attachments/

Re: Simple transformation formatting

munaji_id — Tue, 07 Jan 2025 01:51:29 GMT

hi,

change data type from dats to char.

Thanks,