Can we fetch HU/nHU from EWM by passing Material document number from ECC.

[shashirv6]

Hi EWM Experts,

I have a requirement to write an FS , For fetching NHU/HU(from EWM) details for Material document in ECC.

(In Simple , The report in MB51 should have HU/NHU details).

Please suggest on how to write FS for the same as am a new bee in EWM and not aware of Tables much.

Thanks,

Shashi

[gabor_villas]

Hi Shashi,

"GUID_COLL" field is not relevant for your process as per my understanding, use other table fields to read from this table.

Best regards,
Gabor

[EszterN]

Hi Shashi,

Material Document in ERP = Warehouse Task (WT) in EWM.

The EWM WT number can be found in MKPF table, SPE_MDNUM_EWM, but it contains the warehouse number. On the EWM side it does not contain the WH number, so you have to split the value that you find in the field.

/SCWM/ORDIM_C table contains the confirmed WTs in EWM.
/SCWM/ORDIM_O table contains the open WTs in EWM.
/LIME/COLL_W2IM can be also relevant.

/SCWM/HUHDR = HU header, where the Goods Movement is not completed yet.
/SCWM/GMHUHDR = HU header, where the GM is already completed.

Best regards,

Eszter

[shashirv6]

Hi Ester,

Thank you so much for your inputs. I will look into the same.

Thanks,

Shashi

[shashirv6]

Hi Eszter,

I tried to fetch the details of WT from MKPF table and would like to pass the same to table /LIME/COLL_W2IM (which has all HU details relevant to material document) to fetch all the HU details relevant for Material document. But am not sure about the field GUID Coll. in the above table and where to fetch this detail of input from. Any inputs here please.

Thanks,

Shashi

[shashirv6]

Hi Eszter,