Skip to Content
0
Former Member
Jul 19, 2007 at 12:05 AM

Need help extracting PSCD master data w/ many-to-many relationships

31 Views

Hello all -

We need some help. SBC for PSCD is very light, so we are having to create several custom extractors for master data. We are having trouble figuring out the best way to extract master data for Business Partner and Contract Object when they have a many to many relationship with each other.

The client is for a state Judicial council. The data model is as follows:

Business Partner = County Court (i.e. County of Wonderland) or a Person (John Smith, etc).

Contact Object = Case (i.e. Case # 1111 - John Smith vs. County of Wonderland)

The CO/Case will have multiple parties assigned (i.e. County of Wonderland and John Smith) to it. Additionally, Business Partners can be assigned to multiple cases (Court of Wonderland can have thousands of cases open at a time). Each time a new BP is assigned to a CO, a new line item is created in the table DPSOB_BP_ACC, which is basically used to store these relationships. (Basic CO master data is stored in table DPSOB).

Any advice would be much appreciated. None of us have any experience with many-to-many relationships in master data modeling.