checking MANDT field..

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Shafiq_Rehman1]

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 

[Former Member]

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