how to derive a date from a numeric value?!

[Former Member]

Hello SAP-Experts,

I have created a generic data source containing the field: “Period”  which is defined as a numeric value (MM.YYYY).

In order to fill the InfoObjects “0CALMONTH” and “0CALYEAR” we have developed a formula with the formula editor.

This formula does not work because if you want to use the LEFT, RIGHT and CONCATENATE functions of the formula editor it is necessary that the value in with the date is provided is a string value.

Does anybody know how to convert a numeric value into a string value?

Or does anybody know an alternative to the RIGHT, LEFT and CONCATENATE functions

RIGHT( 4, 'SPBUP' )

CONCATENATE( RIGHT( 4, 'SPBUP' ), LEFT( 2, 'SPBUP' ) )

Thank you for your help!

Holger

[Former Member]

Hello SAP-Experts,

I have created a generic data source containing the field: “Period”  which is defined as a numeric value (MM.YYYY).

In order to fill the InfoObjects “0CALMONTH” and “0CALYEAR” we have developed a formula with the formula editor.

This formula does not work because if you want to use the LEFT, RIGHT and CONCATENATE functions of the formula editor it is necessary that the value in with the date is provided is a string value.

Does anybody know how to convert a numeric value into a string value?

Or does anybody know an alternative to the RIGHT, LEFT and CONCATENATE functions

RIGHT( 4, 'SPBUP' )

CONCATENATE( RIGHT( 4, 'SPBUP' ), LEFT( 2, 'SPBUP' ) )

Thank you for your help!

Holger

[Former Member]

hello,

try using FM "CONVERT_DATE_TO_EXTERNAL"

best regards,

swanand

[kesavadas_thekkillath]

Hi,

String accepts any kind of value, no matter it is of type c or type N

data:date(5) type n.
 data:begin of wa,
     dd(2) type n,
     yy(4) type n,
     end of wa.
 data:lv_str type string.
 concatenate '01' '.' '2013' into date.
 wa = date.   
lv_str = date.

If this did not answer your question, could you provide more details, I am not sure about the formula editor ( is it related to Bex Analyzer  functions ? )which is mentioned, but before entering the formula editor the value can be passed to string as above.

[peng_tang]

hi

one question for you. why my thread is deleted. I am aware of my question is very basic. but why? because you have the authority??!

peng tang

[kesavadas_thekkillath]

Hi peng tang,

Some of us here are provided with some rights to keep the forum clean, please read the ROE before posting a question

[Former Member]

Hi Holger,

                Try passing the numeric value to a string variable as below  .

data : lv_num TYPE n LENGTH 6  VALUE '201301',

        lv_char TYPE c LENGTH 8.

lv_char = lv_num.

lv_char+6(2) = '01'.

Regards,

Vikram

[Venkat_Sesha]

Hi Holger,

Check the below mentioned Function Modules list.

All are related to date and time calculations. That would help you.

http://wiki.sdn.sap.com/wiki/display/ABAP/Function+Module+related+on+Date+calculations

Hope this helps.

[Former Member]

Hi Holger,

You can simply create a new variable like :

data : l_char_date tyep char8

and do the casting operation , as;

l_char_date = numeric date

This will convert the numeric date to character

I hope this will work fine !

regards,

nitin

[sahai]

Hi,

Try having a char type instead of numeric.

Let me know if this is mandatory for you to not have the char values.

Regards,

Shitanshu Sahai