WORK_ITEM_ID in CATSDB
Work Item ID (DE: ID des Workitems)
WORK_ITEM_ID is a field in SAP table CATSDB (CATS: Database Table for Time Sheet). It represents "Work Item ID". Data element: /CPD/PFP_WORKITEM_ID. Available in 11 CDS view(s) as WorkItem.
Business Meaning
| Description (EN) | Work Item ID |
|---|---|
| Beschreibung (DE) | ID des Workitems |
| Data Element | /CPD/PFP_WORKITEM_ID |
| Key Field | No |
CDS Views & Technical Names (11)
CATSDB.WORK_ITEM_ID is exposed in CDS views under the following technical name. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
WorkItem
(11 views)
Work Item ID
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_TimeSheetRecord | direct | BASIC | Time Recording Data | |
| P_CATSDATAWITHCATEGORY | via 2 level | COMPOSITE | ||
| P_TimeSheetApprovedHours | via 2 level | COMPOSITE | ||
| P_TimeSheetRejectedHours | via 2 level | COMPOSITE | ||
| P_TimeShtEntriesForApprvl | via 2 level | COMPOSITE | ||
| P_TimeShtHrsAnlysForProjects | via 2 level | COMPOSITE | ||
| R_TimeSheet | via 2 level | BASIC | Time Sheet | |
| I_TimeSheet | via 3 levels | BASIC | Time Sheet | |
| P_PROJMGRCATSBYPO | via 3 levels | COMPOSITE | ||
| R_TimeSheetTP | via 3 levels | TRANSACTIONAL | Time Sheet - TP | |
| I_TimeSheetTP | via 4 levels | TRANSACTIONAL | Time Sheet - TP |
Other Tables with Field WORK_ITEM_ID (19)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /CPD/D_WORK_ITEM | /CPD/PFP_WORKITEM_ID | Work Item - #GENERATED# | |
| ACCOSTRATE | /CPD/PFP_WORKITEM_ID | Cost Rate | |
| ACDOCA | /CPD/PFP_WORKITEM_ID | Universal Journal Entry Line Items | |
| ACDOCD | /CPD/PFP_WORKITEM_ID | Universal Journal: Aged Details | |
| ACDOCP | /CPD/PFP_WORKITEM_ID | Plan Data Line Items | |
| ACDOCP_DATA | /CPD/PFP_WORKITEM_ID | Staging Area for Plan data in Internal Format | |
| ACDOCTEMP | /CPD/PFP_WORKITEM_ID | Universal Journal: Temporary Data | |
| AD01DLI | /CPD/PFP_WORKITEM_ID | Dynamic items (DI) | |
| ALLOC_RUN_RES | /CPD/PFP_WORKITEM_ID | Allocation run result | |
| CATSMM | /CPD/PFP_WORKITEM_ID | Cross-Application Time Sheet (CATS): Transfer to MM | |
| CTE_D_FIN_T_ITEM | /CPD/PFP_WORKITEM_ID | Target Item mapping table | |
| FINS_PLAN_DELSC | /CPD/PFP_WORKITEM_ID | Table for delete scope | |
| FINSUBVALCOBL | /CPD/PFP_WORKITEM_ID | Metadata Container for FIN Rule engine | |
| FINSUBVALCOBLPSM | /CPD/PFP_WORKITEM_ID | Metadata Container for FIN Rule engine - Public Sector Manag | |
| FINSUBVALFICAPSM | /CPD/PFP_WORKITEM_ID | Metadata Container for FIN Rule engine - Public Sector Manag | |
| MATDOC | /CPD/PFP_WORKITEM_ID | Material Documents | |
| MMIV_SI_D_ITEM | /CPD/PFP_WORKITEM_ID | Item with PO Reference - #GENERATED# | |
| RBCO | /CPD/PFP_WORKITEM_ID | Document Item, Incoming Invoice, Account Assignment | |
| VBSEGS | /CPD/PFP_WORKITEM_ID | Document Segment for Document Parking - G/L Account Database |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA