EWM Tables for Pick HU and Ship HU connection

[ruturaj]

Hello EWM Experts,

I have a custom EWM transaction to pack a Pick HU into Ship HU. I have to incorporate a validation in this transaction to check if the Pick HU already exists in the Ship HU. Can you please advice which EWM tables I can check to find if the Pick HU is already contained in the Ship HU? (I have checked tables /SCWM/HUHDR and /SCWM/HUREF, however, I cannot find this Pick HU - Ship HU connection).

Alternatively, if any specific function module can be used for this purpose, please let me. Thanks.

Regards,

Ruturaj

[former_member230160 · Accepted solution]

Hi Ruturaj,

maybe check function  /SCWM/HU_READ. Use IV_APPL = WME and either use IV_GUID_HU or IV_LGNUM+IV_HUIDENT.

Direct DB selects should if possible be avoided.

Best regards

Markus

[shimank_jain3]

Hi Raj,

There is no direct DB tables in which you get the linkage between HU header and HU items.

I have done this in a way:

Via QUERY method, you will get the delivery HU Header and HU Items contents.

<OBJ> TYPE REF TO /scwm/cl_dlv_management_prd.

CALL METHOD <OBJ>->query
EXPORTING
it_docid        = <docid>
iv_doccat       = <doccat>
is_exclude_data = <exc_data>
IMPORTING
et_hu_top       = <hu_top>
et_hu_headers   = <hu_headers>
et_hu_items     = <hu_items>.

Then:

LOOP AT lt_hu_top INTO ls_hu_top.
     LOOP AT lt_hu_items INTO ls_hu_items
      WHERE guid_parent = ls_hu_top-guid_hu.
     .....

     endloop.

     LOOP AT lt_hu_headers INTO ls_hu_headers
      WHERE higher_guid = ls_hu_top-guid_hu.

                   LOOP AT lt_hu_items INTO ls_hu_items
                WHERE guid_parent = ls_hu_headers-guid_hu.
     ......

          endloop.

      endloop.

endloop.

You will check by passing some dummy delivery data how it works. if suits, implement the same.

If you will find any other solutions or tables, request you to post the same.

Thanks,

Shimank Jain

[ruturaj]

Hello Shimank,

Thanks for your feedback.

I understand that in your code above, it_docid and iv_doccat refer to ODO document number and ODO document category. However, in my custom transaction I have only the Header HU number (Ship HU) and Item HU number (Pick HU). I do not have ODO number to fetch the contained HUs (header and item HUs). Is there a method or function that can be called directly by passing HU number which returns the contained HU items?

Thanks,

Ruturaj

[Former Member]

Hello Ruturaj,

Pick HU and Ship HU don't have different table as I know.

Number range can be a used to differentiate the same.

You have to also check the status of HU to work for this transaction.

Check the below HU Tables :            

BR,

Olet

[ruturaj]

Hello Olet,

Thanks for your answer.

I have checked the recommended tables, however, I cannot find connection between Pick and Ship HU in any of the tables.

For greater clarity, I will explain my business scenario with an example.

I have a Pick HU, say, X and Ship HU, say Y.

I would like to incorporate a validation in my custom repacking transaction to check whether X is already packed into Y, (For e.g. in /SCWM/PACK transaction I can see structure as: Top Level HU is Y inside which HU X is contained)

Is there a standard EWM table that contains this relation/connection between two HUs?

Or is there an FM which can be used to validate this fact?

If the Pick HU is not packed into Ship HU, I would like to allow the repack operation.

If the Pick HU is already paked into Ship HU, I want to throw appropriate error, e.g. 'Pick HU is already packed inside Ship HU.'

Your help on this matter is appreciated.

Thanks.

Ruturaj