|
Purpose
Updates the change sequence graph due to changes in usage location table Output
You can view the results in the application log. To do so, call uptransaction SLG1, and choose object CCSEQ.
If the Notify if Cycles Exist indicator is set, and cycles havebeen generated or changed, the relevant user will receive a work item(Business Workplace).Activities
For the update, the system reads all objects in the usage location tablefor which at least one change status has been marked with a changeindicator. The system sorts the change statuses according to rank withinthe object.
The relationship to be checked is created between the predecessor to thechange status with change indicator, and from the change status withchange indicator to the successor (within the object). The system thenchecks if relationships from the change sequence graphs must be deleted,changed, or added. This may have an affect on the cycle tables, whichyou must then also adjust.
Effects of Change Indicator on Relationships in the Change SequenceGraph:
Change Indicator I (Add):
Relationship is added even though it does not exist
Administration data of the relationship is changed when the creationdate of the new relationship is older than the existing relationship.
Change Indicator D (Delete):
Relationship is deleted if no other usages exist
Relationship is changed to the next oldest creation date (with relevantuser) if the administration data of the existing relationship was copiedfrom the relationship to be deleted. Example
See the following example:
Database table CCSEQ:
SEQ_FROM,,SEQ_TO,,SEQ_DATE,,SEQ_USER
AEN_01,,AEN_02,,03.01.2005,,USER_2
AEN_02,,AEN_03,,03.02.2005,,USER_1
AEN_03,,AEN_01,,02.01.2005,,USER_2
Database table CCSSEQ_CYCLE:
SEQ_FROM,,SEQ_TO,,SEQ_DATE,,SEQ-USER
AEN_01,,AEN_02,,03.01.2005,,USER_2
AEN_02,,AEN_03,,03.02.2005,,USER_1
AEN_03,,AEN_01,,02.01.2005,,USER_2
Database table CSSEQ_NODES:
NODE,,OBJEC,,DATE,,RANK,,USER,,UPD_FLAG
AEN_02,,OBJ_1,,02.02.2005,,1,,USER_1
AEN_03,,OBJ_1,,03.02.2005,,2,,USER_1
AEN_03,,OBJ_2,,01.01.2005,,1,,USER_2
AEN_01,,OBJ_2,,02.01.2005,,2,,USER_2,,D
AEN_02,,OBJ_2,,03.01.2005,,3,,USER_2,,D
AEN_01,,OBJ_3,,01.03.2005,,1,,USER_3
AEN_02,,OBJ_3,,02.03.2005,,2,,USER_3,,I
After the update, the database tables contain the following data:
Database table CCSEQ:
SEQ_FROM,,SEQ_TO,,SEQ_DATE,,SEQ_USER
AEN_01,,AEN_02,,02.03.2005,,USER_3
AEN_02,,AEN_03,,03.02.2005,,USER_1
Database table CCSSEQ_CYCLE is empty.
Database table CSSEQ_NODES:
NODE,,OBJEC,,DATE,,RANK,,USER,,UPD_FLAG
AEN_02,,OBJ_1,,02.02.2005,,1,,USER_1
AEN_03,,OBJ_1,,03.02.2005,,2,,USER_1
AEN_03,,OBJ_2,,01.01.2005,,1,,USER_2
AEN_01,,OBJ_3,,01.03.2005,,1,,USER_3
AEN_02,,OBJ_3,,02.03.2005,,2,,USER_3,, |