Skip to Content
0
Former Member
Nov 29, 2006 at 09:01 PM

Conversion normal table fields into primary keys, then TMG & Lock objects?

47 Views

My task is to make two normal fields of the data base table into primary keys.

Func specs are below :

<i>The lock object can continue to lock on profit center even though we are adding period/year to the key, if that is technically possible. If not, I'll need to know because there may be additional changes needed to the programs to pass the period/year information when locking and unlocking.</i>

Need to do ?

<b>Below are ZXYZ table fields</b> : { MANDT, ZPRCTR are primary key fields at this moment, But I need to make ZGJAHR , ZMONAT as primary key fields by moving to be positioned after the ZPRCTR field . Regenerate the associated Maintenance View and check the associated Lock object for impact (EZXYZ). }

MANDT ZMANDT CLNT 3 0 Client

ZPRCTR ZPRCTR CHAR 10 0 SAP Profit Center

RPT_LOC ZRPT_LOC CHAR 10 0 Reporting Location Number

ZGJAHR ZGJAHR NUMC 4 0 Year

ZMONAT ZMONAT NUMC 2 0 Period

Z500_XMIT Z500_XMIT CHAR 1 0 0500 Transmit

Can you tell me is it technically possible ?

If so how can ?