to get DMBTR value from mseg table

[Former Member]

Hi ,

I working on alv report to get unrestricted and total unrestricted value.

i made a query and matched with plant anaysis.

but i got difference of 82265 value. i checked the table which the value stored in mseg dmbtr.

here i need to take for material number 2823 to get the value of 82260.

but mjahr 2007 and lfgja is 2009 how can i join

here i need to take for 4942100014 for 5.19

here i also lfgja and mjahr not matched

how can i join the table to get the vale.

please help me.

[developerone]

divkar, One small suggestion, never write code to get a certain value. Talk to your business/functional analyst/consultant to understand the business requirement. The inputs you have been asking for the past couple of days should be directed to the afore mentioned individuals on your project. You can find and resolve the technical gaps in your solution with the help of the community.