‎2006 Dec 28 6:46 AM
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.
‎2006 Dec 28 6:51 AM
hi
for getting the full name of the country use the FM C145_GET_COUNTRY...
with regards
Balasubramanian .S
‎2006 Dec 28 6:51 AM
hi
for getting the full name of the country use the FM C145_GET_COUNTRY...
with regards
Balasubramanian .S
‎2006 Dec 28 7:06 AM
‎2006 Dec 28 7:10 AM
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.
‎2006 Dec 28 7:11 AM
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
‎2006 Dec 28 7:27 AM
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 .
28<b>th</b>
22<b>nd</b>
1<b>st</b>
3<b>rd</b>
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