Question Re: Code for invalid date format in Technology Q&A

Code for invalid date format

Former Member — Wed, 09 Mar 2016 09:22:35 GMT

Hi Guys,

invalid date format is coming from R3 system so i want to remove that date -

eg. -Jan-2016 then it should remove date ,

only numeric should accepted in psa.

I want to write routine on field.

Could you please help me in this...

Thanks.

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 09:56:22 GMT

use FM DATE_CHECK_PLAUSIBILITY

regards,

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 10:07:29 GMT

where i can use this FM????

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 10:24:00 GMT

transformation from PSA to Target.

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 10:46:26 GMT

but its updating till PSA only so i need to implement from source to PSA...

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 10:54:41 GMT

PSA data is a copy of source data. First option in BW to change data is in a transformation.

another option would be to implement the code in the user-exit, but this is not so nice.

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 11:05:14 GMT

i would like to implement code in transformation level-

could you please help me --

please find the image

Re: Code for invalid date format

Former Member — Wed, 09 Mar 2016 12:27:36 GMT

check this:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/609eea32-455e-2c10-c08a-c23adf8c934e?QuickLink=index&…

Re: Code for invalid date format

former_member183519 — Wed, 09 Mar 2016 21:30:49 GMT

Hi Atul,

1) implement FM code in start rotuine , and delete those dates which are invalid. or

2) write field routine for this and use FM suggested by M Tibollo.

Hitesh

Re: Code for invalid date format

KodandaPani_KV — Thu, 10 Mar 2016 02:53:26 GMT

Hi,

use the function module and call the FM in start routine.

after write the field routine then call the FM.

Thanks,

Phani.

Re: Code for invalid date format

Former Member — Thu, 25 Aug 2016 06:50:29 GMT

I have written field routine..

and that worked.