SAP ABAP View BPM_WIHEAD_V (DB View for BW Extractor BPM_WIHEAD)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ XPI_BW (Package) Exchange and Process Infrastructure: Extraction 2 BW

Basic Data

View Type	D	Database View
Database View	BPM_WIHEAD_V
Short Description	DB View for BW Extractor BPM_WIHEAD
Root table	SWWWIHEAD	Workflow Runtime: Header Table for All Work Item Types

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SWWWIHEAD	SWWWIHEAD
2	BPMWITSTP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SWWWIHEAD	CLIENT	JL	EQ				0	0
2	BPMWITSTP	CLIENT	JR	EQ			AND	0	0
3	SWWWIHEAD	WI_ID	JL	EQ				0	0
4	BPMWITSTP	WI_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	SWWWIHEAD	CLIENT		☐	MANDT	☐	Client
2	WI_ID	SWWWIHEAD	WI_ID		☐	SWW_WIID	☐	Work item ID
3	WI_CHCKWI	SWWWIHEAD	WI_CHCKWI		☐	SWW_CHCKWI	☐	Superordinate Work Item
4	TOP_WI_ID	SWWWIHEAD	TOP_WI_ID		☐	SWFRTWIID	☐	Workflow: Unique ID of Top-Level Instance (6.1/get)
5	TIMESTAMP	BPMWITSTP	TIMESTAMP		☐	SWFRMETS	☐	Workflow: Method End Time Stamp
6	WI_TYPE	SWWWIHEAD	WI_TYPE		☐	SWW_WITYPE	☐	Work item type
7	WI_LANG	SWWWIHEAD	WI_LANG		☐	SWW_LANG	☐	Language for Texts of a Work Item
8	WI_STAT	SWWWIHEAD	WI_STAT		☐	SWW_WISTAT	☐	Processing Status of a Work Item
9	WI_AAGENT	SWWWIHEAD	WI_AAGENT		☐	SWW_AAGENT	☐	Actual Agent of Work Item
10	WI_CRUSER	SWWWIHEAD	WI_CRUSER		☐	SWW_CRUSER	☐	User Who Created the Work Item
11	WI_RH_TASK	SWWWIHEAD	WI_RH_TASK		☐	SWW_TASK	☐	Task ID
12	WI_PRIO	SWWWIHEAD	WI_PRIO		☐	SWW_PRIO	☐	Priority of a Work Item
13	WI_FORW_BY	SWWWIHEAD	WI_FORW_BY		☐	SWW_FORWBY	☐	(Last) forwarder of work item
14	RETRY_CNT	SWWWIHEAD	RETRY_CNT		☐	SWW_RETCNT	☐	Retries for Work Items with Temporary Errors
15	WF_TYPE	SWWWIHEAD	WF_TYPE		☐	SWD_WFTYPE	☐	Type of Workflow Definition: Standard, Checklist, Ad Hoc, ..
16	NOTE_EXIST	SWWWIHEAD	NOTE_EXIST		☐	SWW_NOTEEX	☐	Indicator Denoting that At Least One Note Exists for the WI
17	NOTE_COUNT	SWWWIHEAD	NOTE_COUNT		☐	SWFRNOTECN	☐	Number of Attachments
18	CREA_TMP	SWWWIHEAD	CREA_TMP		☐	SWFRCRETS	☐	Workflow: Creation Time Stamp
19	EXEC_TIME	SWWWIHEAD	EXEC_TIME		☐	SWFREXECTM	☐	Workflow: De Facto Execution Time in Sec (6.1/get)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in	2005_1_620