Relationships between tables

[Amey-Mogare]

Hiii,

Can anybody tell me do i need to maintain CMR in following scenario... This is the table structure I have:-

Table Division:-

divisioncode (Unique code)

divisionname

$$A Division has many regions and a region belongs to a single Division

Table Region:-

regioncode (Unique code)

divisioncode

regionname

regionalmanagerID

$$A Region has many Units and a Unit belong to single Region

Table Unit:-

unitcode (Unique code)

regioncode

unitname

areamanagerID

salesofficerID

$$ An Unit has many Dealers and a dealer belong to a single Unit

Table Dealer:-

dealercode (Unique code)

unitcode

dealername

$$ An Unit has many Service Centers and a Service Center belong to a single Unit

Table Service Center:-

sccode (Unique code)

scname

scaddress

And also tell me, for example, in table Region, is divisioncode a foregionKey or CompoundKey?

same is the question for other tables...

pls help as soon as possible..

Am waiting for your replies,

reagards,

Amey

[Former Member · Accepted solution]

Think you have posted this msg in the wrong forum. To get better attention move it to the right forum.

check if this note help you Note 697574 - Customizing settings to be done in R3 for CMR replication

[Amey-Mogare · Accepted solution]

Hi,

In which forum shud I post it?

And can u pls tell me where to locate the note which you mentioned?

Thanks and regards,

amey

[Former Member · Accepted solution]

Hi,

You can access the OSS note at the following link

https://websmp207.sap-ag.de/

However, you need to have OSS login to access these.

Regards,

Deepak