topic Re: wanted functional module in Application Development and Automation Discussions

wanted functional module

Former Member — Thu, 28 Dec 2006 06:46:58 GMT

respected sdn's,

i had requirement of functional module for conversion of created date of vbrk-fkdat into format of 28th november 2006 and country to full name for example in to india like that .

with regards,

vikramreddy t.

Re: wanted functional module

Former Member — Thu, 28 Dec 2006 06:51:49 GMT

for getting the full name of the country use the FM C145_GET_COUNTRY...

with regards

Balasubramanian .S

Re: wanted functional module

Former Member — Thu, 28 Dec 2006 07:06:09 GMT

Use FM DR_GET_COUNTRY_NAME

Re: wanted functional module

jayanthi_jayaraman — Thu, 28 Dec 2006 07:10:50 GMT

Hi,

Check t247 table.

data : d1(8) value '20051215',

c1(2),

c2(10).

c1 = d1+3(2).

select ktx into x_ktx from T247 where spras = 'E'.

concatenate d16(2) x_ktx d10(4) into c2.

write c2.

Re: wanted functional module

Former Member — Thu, 28 Dec 2006 07:11:01 GMT

Hi Vikram,

To get the month name you can use this logic.

for example you date is in the yyyymmdd

then by using offset logic get the month number

w_mnr = date+4(2).

select single * from t247

where spras = language

mnr = w_mnr.

then t247-ltx contains the month full name.

data: w_monthname type string.

conatenate date+6(2) 'th' t247-ltx date(4) into w_monthname seperated by ' '.

Reward points if it is helpful.

Reagrds,

Kiran I

Re: wanted functional module

Former Member — Thu, 28 Dec 2006 07:27:49 GMT

For ur case i dont suppose there is a single Fm to get the job but u can create a logic as suggested .

you want this literal after date also .

28th

22nd

1st

3rd

how are u going about this ?

As suggested the logic from table T247 will work for u .

write a case logic as to supplement the literal for the same

case date.

when 1 -- as 'st'

when 2 - as 'nd'

when 3 - as 'rd'

when 4 or 5 or 6 ... as 'th'.

like that .

how are u fetching the country name ? what is your input or avaliable parameters ?

regards,

vijay