designing a table which allows validation and maintainence
hi there is requriemen tto design a table as below kinldy help to understand hte feasiblity and what needs to be done for that it is module programming required for it?
Ship To Char 10 Validate the ship to code against SAP customer master table KNA1
Email Char 50 Validate std email id format if possible.
party Name
Char 35 Retrieve the name 1 value from customer master
(KNA1/NAME1) Avnet Singapore Ptd Ltd
2) aslo need to create a transacton for it to maintain by the users
3) allow sorting basis on all fields and to add new entry and delete existing
please help me to understand the feasiblity what needs to be done for it
if table is created how to take care of validation for that do i need to use module pool programming?
please explaing in detail
i will be rewarding points for each helpful answers
kindly reply asap
regards
Arora