topic Re: Dmbtr value in Application Development and Automation Discussions

Dmbtr value

Former Member — Fri, 10 May 2019 19:48:11 GMT

Hi,

iam new to sap abap...

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

Exaample:

in mard select entries

Matnr-210004, lgort-39, pstat-D, lvorm=null, LFGJA=2012 ,LFMON=12, Labst,Umlme,insmeeinme,retme(All Field) =0.00

mseg table :

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

MSEG-MJAHR = MARD-LFGJA

but mseg-mjahr not matched with mard LFGJA

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

please help me

Re: Dmbtr value

developerone — Sun, 12 May 2019 03:29:12 GMT

Can you please post your code? It helps us understand the problem.

Re: Dmbtr value

Former Member — Sun, 12 May 2019 04:48:18 GMT

Hai sai,

I want to join mard table with mseg table to get dmbtr field value.

Key for two table is

MSEG-MJAHR = MARD-LFGJA

but for particular material number 
mseg and lfgja value not matched......


In mseg table
For Matnr-210004  mjahr is 2017 
dmbtr 14
In mard table 
For Matnr-210004  mjahr is 2015


How can I join the table to get dmbtr?
Pls help me

Re: Dmbtr value

developerone — Sun, 12 May 2019 05:12:21 GMT

SELECT SINGLE DMBTR FROM MSEG as G INTO DATA(lv_mseg) INNER JOIN MARD as D WHERE G~MJAHR = '2017' AND D~MJAHR = '2015' AND G~MATNR = D~MATNR AND G~WERKS = D~WERKS AND G~LGORT = D~LGORT ( All the fields that match ).

** Please excuse the syntax I do not have my computer with me. **

Use the comments button to respond. The answer button is only for providing answers.

Re: Dmbtr value

Former Member — Sun, 12 May 2019 05:27:01 GMT

Hi sai,

Thank for ur reply. But Here plant is input. Year is not input. How can I match these table when year is different in both table.

The above year is just an example.

Re: Dmbtr value

RaymondGiuseppi — Mon, 13 May 2019 09:01:10 GMT

Did you try not to only use MARD without period/year, but also MARDH for past period/year, MARD carry the last period/year when a movement occured.