designing a table which allows validation and maintainence

[Former Member]

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.

Lillian.liu@avnet.com

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

[Former Member]

Hi Arora,

You just need to create a DB table with properties display-maintainance allowed.

Then create a maintainace view for that table and assign a transaction code to that maintainace view.

1 Validation against KNA1 -> create a foreign key relationships

2 Validation of E-mail -> we can create events in table maintainance generator. Just search SDN as how to code for these events. You can create your code in ON SAVE event and do validation there.

No need of any module pool program. All other things can easily been taken care by standard method available.

Please revert back if you need further clarificatiom

[Former Member]

hi Atish

the ultimate purpose later is to send email notification to users Once the shipment is shipped details of whihc i get later

Please eloborate more on the needful to be done step by step

1) how to maintain foreign key relation ship for ship to from kna1

2) how to create events on save

3 so i create a table and create a view for it and assign a tcode to it this is clear

please eloborate more step by step things needed to be done

and aslo things needed to be taken care while creating table so that there is no problem later on

thanks & regards

Arora

[Former Member]

also atish u missed the third field

party Name Char 35 Retrieve the name 1 value from customer master

(KNA1/NAME1)

what to do for this?

regards

Arora

[Former Member]

hi Arorra,

Regarding the thirs field also NAME1 you can use foreign key relationship.

What you need to do is first just create a table with all required fields.

Click on foreign key button in SE11 (after creation of table) and assign the foreign keys using KNA1.

Now create a maintainance view and a transaction.

I will send you the links which will guide you for these.

Regards,

Atish

[Former Member]

Hi,

Check below thread

/thread/495515 [original link is broken]

Regards,

Atish

[Former Member]

HI alll

can anyone reply on this query in detail

regards

Arora

[Former Member]

Also check these blogs for code under events

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

/people/sudheer.junnuthula2/blog/2007/07/31/events-in-table-maintenance-generator

Regards,

Atish

[Former Member]

hi Atish

thanks for the help

can u tell me one last q how to take care of sorting? as for sorting on fields what to do

also pls help me in understanding the concepe to foreign key in this cotext how it will help me to acheive validation

regards

Arora

[Former Member]

Hi Arora,

The Sorting stuff is not that necessary. SAP by default sort based on the key fields and you can just ignore it :).

Regarding foreign key, when you try to create entry in your table, if that entry does not exist in base table (in your case KNA1) then system will show error.

Regards,

Atish

[Former Member]

HI Atish

we need to have sorting on basis of all the fields ie user is able to sort up or down the table on the basis of each field that is requirment

please suggest for this.

regards

Arora

[Former Member]

Hi Arora,

This is also a standard feature in SAP.

If you check in SM30 or SE11 the output of table can be seen as an ALV and you can do all the standard functionalitie of ALV there.

Regards,

Atish

[Former Member]

hi Atish

i ahve created a maintainexe tcode for a table

but in maintainece screen i am not able to see sorting icon to sort/

pls suggest

regards

Arora

[Former Member]

hi atish

and for name1 the requiremet is like that if user enter the shipto no.

the name1 should be automatically populated int he name1 field

is is possible by table maintainece or agian module pool we have to use

pls suggest how to do it

thanks in advance:)

regards

Arora