Z-table row valdiations

[jogeswararao_kavala]

Hi ABAP Experts,

My Z table has 4 fields.

The Conditions for uniqueness are

1. Filed1 value should be unique.

2. The combination of Fields 2,3 and 4 should be unique.

How do I achieve both these, using Primary keys OR in combination of Primary Key and other methods.

Regards

Jogeswara Rao K

[jogeswararao_kavala]

Hi ABAP Experts,

My Z table has 4 fields.

The Conditions for uniqueness are

1. Filed1 value should be unique.

2. The combination of Fields 2,3 and 4 should be unique.

How do I achieve both these, using Primary keys OR in combination of Primary Key and other methods.

Regards

Jogeswara Rao K

[Former Member]

1. For that u will have to use

   EVENTS

   generated in table maintanance.

2. There u can write your own code,

   to validate the entries.

[Former Member]

hi jogeswara,

                        only one ztabel is required or is there option to creation one another z-table?

regard,

vikas

[Former Member]

Hi,

You can do the validation in events of TMG. Just concatentate the 2nd, 3rd and 4th fields and check in the other records similar combination is there or not. If exists, throw one error message.

Regards,

DPM

[VijayaKrishnaG]

Hi all, I have a doubt will this TMG events get triggered if I am updating/modifying table from ABAP Report???

-Vijay

[Former Member]

Hi,

If you are updating in custom report. Do the validations first and once the data is clean, update the database.

Regards,

DPM

[jogeswararao_kavala]

Hi DPM,

Mine is TMG situation.

I'm in need of a sample code, and the event where I put this.

Jogeswara Rao K

[Former Member]

Go to the Table Maintenance Generator Function group in SE80.

Go to the Screen flow logic .

Write your Code in PAI event

e.g

PROCESS AFTER INPUT.

MODULE LISTE_EXIT_COMMAND AT EXIT-COMMAND.

MODULE LISTE_BEFORE_LOOP.

LOOP AT EXTRACT.

   MODULE LISTE_INIT_WORKAREA.

   CHAIN.

    FIELD ZTABLENAME-fldname.

    FIELD ZTABLENAME-fldname .

    FIELD ZTABLENAME-fldname .

    FIELD ZTABLENAME-fldname.

    MODULE SET_UPDATE_FLAG ON CHAIN-REQUEST.

    MODULE validtate.  " This is  custom Module . write your validation logic with in this module.

   ENDCHAIN.

   FIELD VIM_MARKED MODULE LISTE_MARK_CHECKBOX.

   CHAIN.

    MODULE LISTE_UPDATE_LISTE.

   ENDCHAIN.

ENDLOOP.

MODULE LISTE_AFTER_LOOP.

[Former Member]

check this Table Maintenance Generator for event Number 01 and 05 - Contributor Corner - SCN Wiki

[Former Member]

Hi,

Check event 01 for view V_FMFG_T095.

Otherwise, go to table TVIMF, display the entries, check on modules with 'CHECK' or 'VALIDATE' on its description.

Regards,

DPM

[Former Member]

Hi,

The Conditions for uniqueness are

1. Filed1 value should be unique.

2. The combination of Fields 2,3 and 4 should be unique.

1. Create primary key

2. Create unique index in se11 .