Skip to Content
0
Former Member
Sep 06, 2009 at 09:40 AM

Modify Key Field Values of a table through Table Maintenance Generator

689 Views

Hi All,

I have created a z table with below structure. In this fields upto Valid To are all key fields. This is to ensure that consistant valid record get stored in the table.

MANDT MANDT CLNT 3 0 Client

VKORG VKORG CHAR 4 0 Sales Organization

VTWEG VTWEG CHAR 2 0 Distribution Channel

SPART SPART CHAR 2 0 Division

SKU MATNR CHAR 18 0 Material Number

LZONE LZONE CHAR 10 0 Transportation zone to or from which the goods are delivered

VALID_FROM ZVALID_FROM DATS 8 0 Valid From

VALID_TO ZVALID_TO DATS 8 0 Valid To

PLANT WERKS_D CHAR 4 0 Plant

SNP_TZONE ZSNP_TZONE CHAR 20 0 APO Transportation Zone

ERDAT ERDAT DATS 8 0 Date on Which Record Was Created

ERNAM ERNAM CHAR 12 0 Name of Person who Created the Object

AEDAT AEDAT DATS 8 0 Changed On

AENAME AENAME CHAR 12 0 Last changed by

I have created a Table Maintance program through the Table Maintenance Generator. And for that I have assigned a t code.

I can able to create new entires but i can not able to modify Valid_from and Valid_to entries of existing records.

Initially those two fields were in display mode but i went to its module pool program and made then as input enabled. But what the vales I was entering, its not getting saved in database. When we change the values of those fields and save it, the system is saying No Data Change.

Any inputs how to solve this issue. I can not make VALID_FROM and VALID_TO fields as non key.

Regards,