SAP Need to relation between with EBELN AND VBELN

[former_member780881]

Hi everyone,

İ need a function or something to how to find or see between CusOrd and POitem in MD04. (Like in picture).

I can see the record with "MD_PEGGING_NODISPLAY" after mrp run. But how can i see the past record for CusOrd ?

For example I want to learn ; CusOrd Number have a created date 01.01.2021. Which Poİtem number related with it ?

[DominikTylczyn · Accepted solution]

Hello myilmaz03

You are in the make-to-order environment. So there is a direct link between sales order item and purchase order item, through PO item account assignment. Have a look at the details of the PO items, "Account Assignment" tab. Technically the link is in EKKN-VBELN, EKKN-VBELP fields.

Best regards

Dominik Tylczynski

[former_member780881 · Accepted solution]

Thanks a lot for your comment 3a9e4ce873a94034b33dc62b0ce600ee

I checked the link is in EKKN-VBELN, EKKN-VBELP, and u right I saw connection .

[former_member780881 · Accepted solution]

Also,

I found a new solution about this situtation. I could do relationship between functions.

First function , find to all request list in MD04 based on material and werks,

After We can see the DELKZ in T_MDPS,

if delkz equal 'BE' , this mean is ; This material has a request in MD04

,

Second Function, again based on material and DELNR number in first function's tdmps , theese values will import the function.

if delkkz equal 'VC' this mean is ;

we can earn a CusOrd number in MD04.

.

So thanks to theese functions we can see to relationship EBELN-VBELN based on MD04.

but has a little problem : ) ;

This relationship can see day by day: after a few days this relationship doesn't appear.

 call function 'MD_STOCK_REQUIREMENTS_LIST_API'
      exporting
        plscn                    = gs_stock-plscn
        matnr                    = gs_stock-matnr
        werks                    = gs_stock-werks
      tables
        mdpsx                    = t_mdps
        mdezx                    = t_mdez
        mdsux                    = t_mdsu
      exceptions
        material_plant_not_found = 1
        plant_not_found          = 2

        others                   = 3

call function 'MD_PEGGING_NODIALOG'
        exporting
          edelet                = 0001
          edelkz                = lv_delkz
          edelnr                = lv_delnr
          edelps                = s_mdps-delps
          eplscn                = lv_plscn
          ematnr                = lv_matnr
          ewerks                = lv_werks
        tables
          imdrqx                = t_mdrq
        exceptions
          error                 = 1
          no_requirements_found = 2
          order_not_found       = 3
          others                = 4.