on 09-22-2005 12:04 AM
Hello,
I have a flat file source data where in the Date is coming as YYYY-MM-DD. Can some one help me on what conversion Routine do I use in the Transfer Structure to convert the date to the Internal format?
They are not willing to give me YYYYMMDD.
Thanks
Srini
Hi Srini,
For your case you make use of ABAP routine in the transfer rules and remove the "-". This should solve yor problem.
Alternatively you can also try writing a macro in your excel OR using excel functions to remove the "-" before loading the file. This would however depend on whether you have access to edit the file.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The foll.code is from a previous posting in SDN. It works for sure.
DATA: ZT1 LIKE SY-DATUM,
S1(4) TYPE C,
S2(2) TYPE C,
S3(2) TYPE C.
SPLIT TRAN_STRUCTURE-/BIC/ZDAT AT '-' INTO S1 S2 S3.
CONCATENATE S1 S2 S3 INTO ZT1.
RESULT = ZT1.
give the field name of ur tranfer structure instead of ZDAT. Yes u can solve this problem by writing a routine in tfr rules.
Message was edited by: ravi raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.