EWM Reference
/SCWM/RSRC
ChangeMaintain resources — the operators, vehicles, and devices that execute warehouse orders, with their group, type, and assigned queue
Notes
The name is shared with the resource table, deliberately: this reference keeps the transaction and the table at separate URLs rather than renaming either.
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
ON scwm_rsrc.MANDT = scwm_t346.MANDT AND scwm_rsrc.QUEUE = scwm_t346.QUEUE AND scwm_rsrc.LGNUM = scwm_t346.LGNUM -- the queue the resource is assigned to; ACT_QUEUE (the one it is actually working) resolves against the same masterthe queue the resource is assigned to; ACT_QUEUE (the one it is actually working) resolves against the same master
ON scwm_rsrc.MANDT = scwm_trsrc_grp.MANDT AND scwm_rsrc.RSRC_GRP = scwm_trsrc_grp.RSRC_GRP AND scwm_rsrc.LGNUM = scwm_trsrc_grp.LGNUMON scwm_rsrc.MANDT = scwm_trsrc_typ.MANDT AND scwm_rsrc.RSRC_TYPE = scwm_trsrc_typ.RSRC_TYPE AND scwm_rsrc.LGNUM = scwm_trsrc_typ.LGNUM
R read · W write · R/W read + write
Secondary tables
- /SCWM/T346Queue definition — the execution queues warehouse tasks, warehouse orders, and resources are routed through, with the operating environment each queue serves and the material-flow controller behind it where the queue drives automationRead accessSemantic keyconfig
- /SCWM/TRSRC_GRPResource groups — the grouping of resources that share a queue sequence; three columns, all keyRead accessSemantic keyconfig
- /SCWM/TRSRC_TYPResource types — the physical characteristics of a class of resource: travel velocities and their unit, position management, RF task-interleaving behavior, and the layout type used for automated aislesRead accessSemantic keyconfig