topic Re: checking MANDT field.. in Application Development and Automation Discussions

checking MANDT field..

Former Member — Tue, 19 Aug 2008 17:11:15 GMT

hi,

i am designing a custom transaction with Z tables and i have a MANDT field in that. Do i have to use it any time ?? Should my select statements have a condition checking this MANDT all the time ? Any tips ??

thks

Re: checking MANDT field..

Former Member — Tue, 19 Aug 2008 17:15:17 GMT

Not required, unless you are trying to fetch records from some other client in the same system.

Re: checking MANDT field..

Former Member — Tue, 19 Aug 2008 17:16:57 GMT

no, only in cases you are using a join statement.

Re: checking MANDT field..

Shafiq_Rehman1 — Tue, 19 Aug 2008 18:10:22 GMT

If your table is client dependent then it has MANDT field, and you should include it in your query's WHERE clause with an AND condition like this

 AND MANDT = SY-MANDT

Re: checking MANDT field..

Former Member — Tue, 19 Aug 2008 18:24:18 GMT

hiiii

that is not required .. i have not seen any select system with where condition with MANDT field ..so i can say only that it is not required..because when you are logon on some client that time you need to enter client ID and as per that only data of that client will be available for you.

regards

twinkal