topic Re: Dmbtr value in Application Development and Automation Discussions

Dmbtr value

Former Member — Thu, 09 May 2019 03:09:50 GMT

Hi,

iam new to sap abap...

in mard select entries

Matnr-210004, lgort-39, pstat-D, lvorm=null, LFGJA=2012 ,LFMON=12, Labst,Umlme,insmeeinme,retme(All Field) =0.000 (only one entries there and one storage location)

mseg table :

Matnr-210004, lgort-Blank, Bwart-303 ,DMBTR-5.19, SHKZA-S (This field i need to join)

Matnr-210004, lgort-39, Bwart-301 ,DMBTR-2593.12, SHKZA-S

Matnr-210004, lgort-39, Bwart-301 ,DMBTR-5186, SHKZA-S

Matnr-210004, lgort- blank, Bwart-301 ,DMBTR-5186, SHKZA-S

My Requirement :

in plant analysis i got difference value of the matnr :5.19

i saw in mseg table but it is stored as lgort as blank in mard the only one location 39 for particular material

how can i join the table,... is there any alternative table

Re: Dmbtr value

former_member596005 — Thu, 09 May 2019 17:43:16 GMT

hi Dhivya Gopal ,

You can join MARD and MSEG as follows,

MSEG-MJAHR = MARD-LFGJA
MSEG-MATNR = MARD-MATNR
MSEG-LGORT = MARD-LGORT
MSEG-WERKS = MARD-WERKS

Re: Dmbtr value

Former Member — Fri, 10 May 2019 00:11:17 GMT

Will check

Re: Dmbtr value

Former Member — Fri, 10 May 2019 00:48:15 GMT

Thanks for the query.. I have another case where mseg table contains dmbtr when storage location is empty... I have to take that entry from mseg where storage location is from mseg to sum it to valuated stock report along with the entries in mard...for a matnr.

And for the same matnr there is no empty storage location entry in mard to join it... please let me know how to get this entry along with mard...

Re: Dmbtr value

Former Member — Fri, 10 May 2019 01:00:07 GMT

Just checked one of my entries not matching for

MSEG-MJAHR = MARD-LFGJA
Please guide how to take records when this condition is not matched.