MANDT field

[Former Member]

hi,

can anyone tell me what if i don't put MANDT as a part of primary key?

thanx,

maja

Message was edited by: Maja Zugaj

[athavanraja]

if you dont use MANDT as key of the table, table will become client independent.

Regards

Raja

[Former Member]

Thank you so much!

[Former Member]

it is not a mandatory field ... yes you can do that .. but the table will act as a client independenet table

Regards,

Santosh

[Former Member]

Hello Maja,

MANDT is the client field. If a table has MANDT as the first field with dataelement is MANDT then that table is clent dependent. If a table doen't have this filed then it is a client independent table.

If useful reward .

vasanth

[Former Member]

HI ,

That will mean that you don't want a client specific database table.

Manish

[Former Member]

Hi maja,

1. The system won't allow.

2. IF MANDT is the first field,

and u have specified the 2nd field as primary key,

it won't accept.

The key fields of a table must be grouped together at the beginning of the table

regards,

amit m.

[santhosh_patil]

Hi...

I think it will be become client independent..

Check it out...

Regards,

Santhosh

[Former Member]

HELLO,

YOU CAN, BUT MANDT IS THE CLIENT NO. FILED AND EVERY QUERY/SQL COMMANDS, IT FATCH RECORDS OF CURRENT CLIENT(DEFAULT) .

SO, IF U NOT TAKE MANDT AS PART OF PRIMERY KEY THEN YOUR QUERY TAKE MORE TIME TO EXECUTE.

MUKESH AGGARWAL

[Former Member]

hi,

Please check my answer ..... even though i answered second but it was unfortunate that you did not like my answer .. it would be great if you can assign some points to me too..

Regards,

Santosh

[Former Member]

hi,

that is why i checked your answer with 2 points as helpfull answer, from my view i can see it is checked but not grayed also, that is why maybe you cant see it, i'll try to check it right again.

so sorry for this.

maja

[Former Member]

Hi

In BI side MANDT (client) it is the primary (mandatory) why put as a primary key, need to map the filed in transformation so that .. along with primary key will do the success full transformation and get the data properly........

[Former Member]

Hello maja,

many of people tell here that table will become client independent. but i think this concept is wrong. Because table always client independent object. But records of the table is always client dependent object. For this reason it is maintained by mandt field.

Thanks

Sabyasachi

[Former Member]

SCN is not a place where you ask for some points. Dont ask for points. Read SCN rules and engagement.

Thanks

Sabyasachi

[former_member209120]

Hi Karforma,

I agree with your comment, yes table always client independent, if we put MANDT as a key field then the data in that table become client dependent.

if you not put MANDT field as a key field than the data in that table become client independent.

Regards,

Ramesh.T

[former_member209120]

Yes i agree with you Karforma....

Good....

Regards,

Ramesh.T

[Former Member]

Hi Ramesh,

you are right. According to me most of people (Diamond, Topaz contributor) writes wrong. Kindly request to all people that dont write wrong things in SCN. its a great a place to share knowledge. Beginner will become confuse for this type of answer.

Regards

Sabyasachi

[Former Member]

This message was moderated.