Relationship between 109 MVT document number for a perticular 107 document

[Former Member]

Hi Guru's

We need to fetch some details from the material document which are generated for the MVT 107 and 109. We need to fetch GR date from 107 document and un restricted quanity from 109 document. but there is aa issue to find the right relation between this documents. Developers questine is that, How the system will find the right 109 document against the perticualr 107 document. Please advise the table or relationship which connect these two document.

Thanks

Regards

Raja

[gurunathkumar_dadamu]

Hi Raja,

Try to use this selection statement.

in this case try to pass the both plants in the 101 and 107 movement types.

SELECT-OPTIONS: s_werks FOR t001w-werks,

                 s_matnr FOR mara-matnr.

SELECT a~matnr a~mtart a~matkl b~maktx e~werks g~kalnr

          h~bdatj h~poper h~untper h~meins h~lbkum h~umkumo h~abkumo h~zukumo

          j~curtp j~waers j~salk3

     FROM mara AS a

     INNER JOIN makt AS b ON b~matnr = a~matnr

     INNER JOIN marc AS e ON e~matnr = a~matnr

     INNER JOIN ckmlhd AS g ON g~matnr = a~matnr   AND

                               g~bwkey = e~werks

     INNER JOIN ckmlpp AS h ON h~kalnr = g~kalnr

     INNER JOIN ckmlcr AS j ON j~kalnr = g~kalnr   AND

                               j~bdatj = h~bdatj   AND

                               j~poper = h~poper   AND

                               j~untper = h~untper

     INTO CORRESPONDING FIELDS OF TABLE it_mara

     WHERE a~matnr IN s_matnr  AND

           e~werks IN s_werks  AND

           j~curtp EQ '10'.

Hope may your problem will solve.

Regards,

Gurunath

[former_member182575]

5 inner joins is going to kill performance.

Regards

Waza

[JL23]

I think you find the relationship as well in purchase order history table EKBE

[Prasoon]

Hi,

   The reference document (107 document) will be updated in MSEG-LFBNR against the 109 movement document. You can see it in MIGO display mode also.

Regards,

AKPT

[Former Member]

HI AKPT,

Thank you for your reply. in my system ref. document field is showing empty. Is there any config. settings thet need to be done for getting dispalyed this field. Please advise.

Thanks

Regards

Raja

[Prasoon]

Hi,
  Please ensure that you are doing 109 with respect to the 107 movement. Means you have to do 109 movement through MIGO-Release GR Blocked Stock - Material Document. In this case, the reference field will be updated.

Regards,
AKPT