topic Re: extracting date from table, format problems in Application Development and Automation Discussions

extracting date from table, format problems

Former Member — Fri, 01 Feb 2008 11:45:47 GMT

I am working on scm side, where i need to get the creation date of material from table /sapapo/matkey .

The problem is the field has a time stamp .

intially i was using fm : CONVERSION_EXIT_TSTLC_OUTPUT

to get the date , but the problem is this fm is not correct , as it depends upon the user date format , and gets date from display

of the table rather than the server . This is giving me an error

as the date format can be different everytime , it can be yyyymmdd or yyyyddmm.

Which is the way of firstly getting creation date from the time stamp , and in the format stored by databse.

Former Member — Fri, 01 Feb 2008 11:52:01 GMT

Hi,

Use the Write statement. Write statement allways take the User Profile format.

Please let me know if you are not clear.

Regards,

Raja

Former Member — Fri, 01 Feb 2008 11:59:39 GMT

Hi,

try these 2 FMs

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

Cheers,

Will.

Former Member — Fri, 01 Feb 2008 12:03:11 GMT

Hi,

You can make use of the functions

LTRM_TIMESTAMP_CONVERT_FROM.

Reward if helpful.

Former Member — Fri, 01 Feb 2008 18:53:47 GMT

Hi thanks for ur replies.

My exact requirement is , that i need to pass the to a bapi which takes the date in the format : yyyymmdd.

So finally whatever be the user date format , i should use the time stamp and get the date , in one standard format always.

It can either be yyyymmdd or YYYYddmm , so that i can set the input for bapi accordingly.

former_member156446 — Fri, 01 Feb 2008 19:00:05 GMT

HI abaper


ZDD = ZTEMP+3(2). 
ZMMM = ZTEMP+0(3). 
ZYYYY = ZTEMP+5(4). 

concatenate as you like : zyyyy zmm zdd into final_date.