SAP table TWFNS (Workflow: control table status transfers (next status))
SAP table TWFNS has 5 primary key fields being MANDT,PRCTP,RULNUM,RCODE,NUM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| PRCTP | Workflow: Process type | CHAR | 10 | 0 | TWFPT | WF_PRCTP | |
| RULNUM | Workflow: Transition rule: Seq. number | NUMC | 6 | 0 | TWFSA | WF_RULENUM | |
| RCODE | Workflow: Return code of process FM for selecting new state | NUMC | 5 | 0 | WF_RCODE | ||
| NUM | Workflow: Transition rule: Seq. no. of subseq. status/agent | NUMC | 2 | 0 | WF_NSNUM | ||
| NSYST | Workflow: SystemID of next system | CHAR | 10 | 0 | WF_NSYSTEM | ||
| NMANDT | Workflow: Client in new system | NUMC | 3 | 0 | TWFSY | WF_NMANDT | |
| NPRCTP | Workflow: Next process type | CHAR | 10 | 0 | TWFPT | WF_NPRCTP | |
| NSTAT | Workflow: Transition rule: Next state (template) | CHAR | 14 | 0 | WF_NRULE | ||
| NUSERESC | Workflow: Flag for specifying agent type | CHAR | 1 | 0 | WF_USERESC | ||
| NUSERNAM | Workflow: Next agent | CHAR | 12 | 0 | WF_NUSERNM | ||
| NRLORIG | Workflow: Always get processing rule from original system? | CHAR | 1 | 0 | WF_RULORIG | ||
| STOP | Workflow: Transition rule: Determine further processing type | CHAR | 1 | 0 | WF_STOP | ||
| OVERRIDE | Workflow: Next status and process type overridable | CHAR | 1 | 0 | WF_RLOVRRI |
TWFNS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TWFNS | NMANDT | TWFSY | Workflow: Systems and clients that are workflow partners | MANDT |
| 1 TWFNS | NPRCTP | TWFPT | Workflow: process type directory | MANDT |
| 1 TWFNS | NPRCTP | TWFPT | Workflow: process type directory | PRCTP |
| 0 TWFNS | PRCTP | TWFPT | Workflow: process type directory | MANDT |
| 0 TWFNS | PRCTP | TWFPT | Workflow: process type directory | PRCTP |
| 1 TWFNS | RULNUM | TWFSA | Workflow: transfer rule: actions in current status | MANDT |
| 1 TWFNS | RULNUM | TWFSA | Workflow: transfer rule: actions in current status | PRCTP |
| 1 TWFNS | RULNUM | TWFSA | Workflow: transfer rule: actions in current status | RULNUM |