sq00 relationship /SCDL/DB_PROCH_Iwith ordim_o

[Former Member]

Hi all,

I am doing an query with sq01 and I need relationsh /scdl/db/proch_i or /SCDL/DB_PROCI_I

with warehouse tasks open table (/scdl/ordim_o), that fields i have to use for join the inbound delivery tables with warehouse tables.

Thanks and advance,

Tomas.

[katrin_kraemer]

Hello Tomas,

when you write your own programs in EWM it is better not to program on DB table level but to reuse the existing code. In this case you can use class /SCWM/CL_DLV_MANAGEMENT_PRD, method QUERY (documentation available) to read the warehouse requests. The document flow for an item contains the links to the warehouse tasks (and other successor documents). In interface /SCWM/IF_DOCFLOW_C you can find the constants that describe the document flow nodes. In your case the most important one will probably be 'Putawqay Planned'.

Regards,
Katrin