topic Re: MANDT field in Application Development and Automation Discussions

MANDT field

Former Member — Tue, 17 Oct 2006 08:36:39 GMT

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

Re: MANDT field

athavanraja — Tue, 17 Oct 2006 08:38:54 GMT

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

Regards

Raja

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:39:39 GMT

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

Regards,

Santosh

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:39:44 GMT

Thank you so much!

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:39:49 GMT

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

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:40:24 GMT

HI ,

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

Manish

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:40:53 GMT

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.

Re: MANDT field

santhosh_patil — Tue, 17 Oct 2006 08:41:27 GMT

Hi...

I think it will be become client independent..

Check it out...

Regards,

Santhosh

Re: MANDT field

Former Member — Tue, 17 Oct 2006 08:42:00 GMT

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

Re: MANDT field

Former Member — Tue, 17 Oct 2006 09:08:16 GMT

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

Re: MANDT field

Former Member — Tue, 17 Oct 2006 09:31:53 GMT

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

Re: MANDT field

Former Member — Mon, 24 Jun 2013 06:54:44 GMT

This message was moderated.

Re: MANDT field

Former Member — Mon, 24 Jun 2013 07:05:25 GMT

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........

Re: MANDT field

Former Member — Mon, 24 Jun 2013 07:09:44 GMT

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

Re: MANDT field

Former Member — Mon, 24 Jun 2013 07:13:38 GMT

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

Thanks

Sabyasachi

Re: MANDT field

former_member209120 — Mon, 24 Jun 2013 07:16:28 GMT

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

Re: MANDT field

former_member209120 — Mon, 24 Jun 2013 07:19:37 GMT

Yes i agree with you Karforma....

Good....

Regards,

Ramesh.T

Re: MANDT field

Former Member — Mon, 24 Jun 2013 07:30:28 GMT

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