Skip to content
EWM Reference

/SCWM/CANCPICK

Change

Cancel picking — reverse picking work already created or confirmed for an outbound delivery

Notes

Cancellations are the reason a count of confirmations understates the work that was created: a cancelled task leaves the open table without reaching the confirmed one, and is generally found in the task log.

Tables behind this transaction

Curated: these are the tables an analyst reads to see what this transaction did, and how it touches each of them. Every table page carries its own field list and Databricks SQL.

How these tables connect — join details in the list below. GUID joins and text-table joins are highlighted.

Join details

  • /SCWM/ORDIM_O/SCWM/WHOforeign key · N:1
    ON scwm_ordim_o.MANDT = scwm_who.MANDT AND scwm_ordim_o.WHO = scwm_who.WHO AND scwm_ordim_o.LGNUM = scwm_who.LGNUM
  • /SCWM/ORDIM_C/SCWM/WHOforeign key · N:1
    ON scwm_ordim_c.MANDT = scwm_who.MANDT AND scwm_ordim_c.WHO = scwm_who.WHO AND scwm_ordim_c.LGNUM = scwm_who.LGNUM
  • /SCWM/ORDIM_L/SCWM/WHOforeign key · N:1
    ON scwm_ordim_l.MANDT = scwm_who.MANDT AND scwm_ordim_l.WHO = scwm_who.WHO AND scwm_ordim_l.LGNUM = scwm_who.LGNUM
  • ON scwm_ordim_o.MANDT = scdl_db_proci_o.MANDT AND scwm_ordim_o.RDOCID = scdl_db_proci_o.DOCID AND scwm_ordim_o.RITMID = scdl_db_proci_o.ITEMID -- RAW16 GUID equality — join raw; hex is for display/conformance only · applies when RDOCCAT identifies an outbound delivery order

    applies when RDOCCAT identifies an outbound delivery order

  • ON scwm_ordim_c.MANDT = scdl_db_proci_o.MANDT AND scwm_ordim_c.RDOCID = scdl_db_proci_o.DOCID AND scwm_ordim_c.RITMID = scdl_db_proci_o.ITEMID -- RAW16 GUID equality — join raw; hex is for display/conformance only · applies when RDOCCAT identifies an outbound delivery order

    applies when RDOCCAT identifies an outbound delivery order

  • ON scwm_ordim_l.MANDT = scdl_db_proci_o.MANDT AND scwm_ordim_l.RDOCID = scdl_db_proci_o.DOCID AND scwm_ordim_l.RITMID = scdl_db_proci_o.ITEMID -- RAW16 GUID equality — join raw; hex is for display/conformance only

R read · W write · R/W read + write

Secondary tables

More Warehouse Tasks & Orders t-codes

Maintained by Summit Analytics, a supply chain analytics practice. The tools and references are free — the consulting is selective.

Part of the Summit Analytics reference library.

Work with the practice

Not affiliated with or endorsed by SAP. SAP, SAP S/4HANA, and SAP Extended Warehouse Management are trademarks or registered trademarks of SAP SE.