Technical name: BPM_PRINCIPAL_ASSIGNMENT_DS
Field Name |
Description |
Type |
---|---|---|
REFERENCE_ID |
Unique ID of the process or task instance |
VARCHAR |
REFERENCE_TYPE |
Instance type: PROCESS or TASK |
VARCHAR |
ROLE_TYPE |
Role type: PROCESS_INITIATOR, TASK_INVOLVED, and so on |
VARCHAR |
PRINCIPAL_ID |
Principal unique ID |
VARCHAR |
PRINCIPAL_NAME |
Principal unique name |
VARCHAR |
LAST_MODIFIED_D |
Date of last update |
DATE |
LAST_MODIFIED_T |
Time of last update |
TIME |
LAST_MODIFIED |
Time of last update in milliseconds since January 1, 1970, 00:00:00 GMT |
BIGINT |
The following filters are supported:
Date range filter (BETWEEN operator) for date field LAST_MODIFIED_D
OCCURRENCE_D = 3/23/10 - 3/24/10
The date format depends on your locale. The single or multiple values operator is not supported for dates. If you want to filter for a specific day, you have to set a range with the day date as min and max boundary, such as 1/1/10 - 1/1/10. End of the example.
Single (EQUALS) or multiple (IN (...)) values filter for fields REFERENCE_ID, REFERENCE_TYPE, ROLE_TYPE, PRINCIPAL_ID and PRINCIPAL_NAME
REFERENCE_TYPE = PROCESS; TASK;
This multiple values filter selects all assignments with reference type equal to PROCESS or TASK.
For all possible values in fields REFERENCE_TYPE and ROLE_TYPE , see SAP Note 1383528 .