SAP Knowledge Base Article - Public

2230752 - Remove Position Matrix Relationships through import

Symptom

This article is intended to explain how Position Matrix Relationships can be removed through import. Often it is need to delete/remove the relationships when trying to Inactivate a Position that has Matrix Relationships.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

Environment

Employee Central -Position Management

Resolution

1. Export position data from the instance from Admin Center --> Import and Export Data and find the file for position matrix relationships.
2. Filter the file for the particular position that you want to remove in column positionMatrixRelationship.relatedPosition.code
3. Please note that there may be a position code present more than once under the column “code”.
4. For each position code, consider only the record with the latest date. A new record should be added to this position with effective date after the latest date in the file. This new record should not have the current position mentioned in the Matrix Relationships field.
Date.JPG

5. Once step 4 is completed for all the codes, the position can be made inactive with effective date after the latest date for all the codes. In our example, the effective date should be after 6/19/2015 and we should use DELIMIT operator to achieve our objective. The Position Matrix Relationship import can be done from Admin Center --> Import and Export Data. 
import_MR.jpg

FAQ:

  • Only the DELIMIT operator should be used for this action. 
  • If you wish to remove the Matrix Relationship in all records, you should DELMIT it in the first record you wish to remove and then it will be removed from all other records via future propagation. Do not include all records in the import file. 

Keywords

Position, Matrix, Relationship, DELIMIT, Import, Inactive, Deactive, remove , KBA , LOD-SF-EC-POS , Position Management , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Core all versions