Skip to Content
0
Apr 26, 2018 at 02:20 PM

Workflow Table Relationships

404 Views

Hello,

I know it is not standard practice to directly query the back-end tables but is unavoidable in my situation. See attached. I need to join data from the /SAPSRM/D_WF_003 table to the /SAPSRM/D_WF_004 table. I am basically trying to reproduce this header status panel in SQL and I can see the Level Status column is in the /SAPSRM/D_WF_003 and the Status column is in the /SAPSRM/D_WF_004 table, but I haven't figured out how to relate them directly together through the GUIDs in the various workflow tables. I can see how to join to them separately from the /SAPSRM/D_WF_000 table through the PROCESS ID GUID for the /SAPSRM/D_WF_003 table and the Document GUID for the /SAPSRM/D_WF_004 table, but I'm having problems lining up the /SAPSRM/D_WF_003 and /SAPSRM/D_WF_004 table directly together, row for row, like this Header Status Panel does in the actual application. Thanks much for any help.