for one particular material, i have checked in MMBE for reserved Quantity
it is showing reserved qty as 392 Nos
but where as i checked in SE16, in RESB table, inputting this material
it's giving so many values, but it is not showing anyware 392
in which table i will get this value 392 Nos
All reservation data is available in RESB table only, but you need to apply some logic to find open reservation, because what you see in MMBE is only open reservations. You wont get this value directly in any table as it is an internally calculated field.
Open reservation for a material plant would be sum of RESB-BDMNG minus RESB-ENMNG where RESB-SHKZG = "H", eliminating records where RESB-XLOEK = " "(Blank), and RESB-KZEAR = " "(Blank)