topic Re: Conversion normal table fields into primary keys, then TMG & Lock objects? in Application Development and Automation Discussions

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

Former Member — Wed, 29 Nov 2006 21:01:50 GMT

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 ?

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

Former Member — Wed, 29 Nov 2006 21:11:38 GMT

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

Need to do ?

Below are ZXYZ table fields : { 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 ?

Func consultant said as below :

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.

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

Former Member — Wed, 29 Nov 2006 21:13:02 GMT

Could you please read my second message and

Could you explain how can I proceed ?

I can say you ...if I was not clearly said my problem.

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

Former Member — Wed, 29 Nov 2006 21:20:53 GMT

I think all you have to do is move RPT_LOC after ZMONAT, mark ZGJAHR and ZMONAT as key fields and adjust the database (being careful to keep the data).

Rob