topic Re: table in Application Development and Automation Discussions

table

Former Member — Fri, 02 Feb 2007 06:58:11 GMT

Can anybody tell me table for date to month conversion?

Former Member — Fri, 02 Feb 2007 06:59:28 GMT

check <b>t247</b>

EX-

parameters: date like sy-datum.

data: begin of itab occurs 0,

SPRAS type SPRAS,

MNR LIKE T247-MNR,

KTX LIKE T247-KTX,

LTX LIKE T247-LTX,

end of itab.

DATA : month LIKE T247-MNR.

DATA: YEAR(4).

DATA: FINAL(18).

DATA: DAY(2).

DAY = DATE+6(2).

MONTH = DATE+4(2).

YEAR = DATE+0(4).

select SINGLE * from t247 into itab where mnr = month

AND SPRAS = 'E'.

APPEND ITAB.

CONCATENATE DAY ITAB-LTX YEAR INTO FINAL SEPARATED BY '-'.

WRITE: FINAL.

kishan negi

Former Member — Fri, 02 Feb 2007 06:59:29 GMT

try table T247

amit

Former Member — Fri, 02 Feb 2007 07:01:24 GMT

t247 - table for date to month -> sample code -

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.