on 03-17-2007 9:08 AM
Hi Gurus,
We are getting an R/3 field(2 fields) as "YYYY.MM.DD HH:MM:SS". And we have mapped that fields to a Two IO (CHAR).Data is getting loaded fine,but not getting it in the same format (with required DOTS and COLONS).Is there any routine that I can write for this IO.If any one have it ,please pass it on.
The two info objects are : ZCREATE & CHANGEDAT are mapped to "created_at" & "changed_at".
Please tell me step by step code.
Points wil be assured.
No idea on how to write a routine .
Urs,
Rakesh.
Hi,
Currently what format your getting? Please let me know...... so that i can give the correct ABAP code to you...
In my perspective, the time will be loaded properly!!!! because it is standard object... it will take automatically its own format..... (if this also not in your format, let me know)...
I will assume that the time is coming to BW like this : YYYYMMDD.
Then the ZCREATE info object update rule routine is as follows:
DATA : date_only(10) type c.
concatenate COMM_STRUCTURE-ZCREATE+0(4) '.'
COMM_STRUCTURE-ZCREATE+4(2) '.'
COMM_STRUCTURE-ZCREATE+5(2)
into date_only.
result = date_only.
Please verify it and let me know!!!!!!!!!!!!!!!!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.