Problem in checking value in file field having format like DDMMMYYYY:HH:MM:
It is inbound interface and i am getting file that is to be updated in database table.
i need to check whether the values in file are coming in DDMMMYYYY:HH:MM:SS and its length is 18 with character CHAR type format. if not i need to provide error message.
also when i need to store in database i should store as DDMMYYYY - sap format. what function module i should use.
kindly help me in this regard.
thanks and regards,