SAP table PTRV_SCOS (Trip Statistics - Cost Assignment)
SAP table PTRV_SCOS has 5 primary key fields being MANDT,PERNR,REINR,PERIO,COSTSEQNO.
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 | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| REINR | Trip Number | NUMC | 10 | 0 | REINR | ||
| PERIO | Trip Period Number | NUMC | 3 | 0 | PTRV_PEROD | ||
| COSTSEQNO | Sequence Number for Cost Assignment | NUMC | 2 | 0 | PTRV_COSTSEQNO | ||
| COMP_CODE | Company Code | CHAR | 4 | 0 | * | BUKRS | |
| BUS_AREA | Business Area | CHAR | 4 | 0 | * | GSBER | |
| CO_AREA | Controlling Area | CHAR | 4 | 0 | * | KOKRS | |
| COSTCENTER | Cost Center | CHAR | 10 | 0 | * | KOSTL | |
| INTERNAL_ORDER | Order Number | CHAR | 12 | 0 | * | AUFNR | |
| COST_OBJ | Cost Object | CHAR | 12 | 0 | * | KSTRG | |
| WBS_ELEMT | Work Breakdown Structure Element (WBS Element) | CHAR | 24 | 0 | PS_POSID | ||
| NETWORK | Network Number for Account Assignment | CHAR | 12 | 0 | * | NPLNR | |
| ACTIVITY | Operation/Activity Number | CHAR | 4 | 0 | VORNR | ||
| SALES_ORD | Sales Order Number | CHAR | 10 | 0 | KDAUF | ||
| S_ORD_ITEM | Item number in Sales Order | NUMC | 6 | 0 | KDPOS | ||
| CO_BUSPROC | Business Process | CHAR | 12 | 0 | * | CO_PRZNR | |
| FUNDS_CTR | Funds Center | CHAR | 16 | 0 | * | FISTL | |
| CMMT_ITEM | Commitment Item | CHAR | 14 | 0 | * | FIPOS | |
| FUND | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| ALLOC_AMOUNT | Amount per Account Assignment | CURR | 15 | 2 | PTRV_ALLOC_AMOUNT | ||
| CURRENCY | Currency Key | CUKY | 5 | 0 | * | WAERS | |
| FUNC_AREA | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| CMMT_ITEM_LONG | Commitment Item | CHAR | 24 | 0 | * | FM_FIPEX | |
| PROJECT_GUID | Project GUID (cProjects) | RAW | 16 | 0 | PTRV_PROJECT_GUID | ||
| PROJECT_EXT_ID | Project Number (cProjects) | CHAR | 24 | 0 | PTRV_PROJECT_EXT_ID | ||
| TASK_ROLE_GUID | Task GUID (cProjects) | RAW | 16 | 0 | PTRV_TASK_GUID | ||
| TASK_ROLE_EXT_ID | Task Number (cProjects) | CHAR | 24 | 0 | PTRV_TASK_EXT_ID | ||
| OBJECT_TYPE | Object Type (cProjects) | CHAR | 3 | 0 | PTRV_OBJ_TYPE | ||
| BUDGET_PERIOD | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| CATEGORY | Cost Category | CHAR | 5 | 0 | * | GLO_PTRV_COST_CAT | |
| KBLNR | Document Number for Earmarked Funds | CHAR | 10 | 0 | * | KBLNR_FI | |
| KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | 0 | * | KBLPOS | |
| ERLKZ | Used earmarked funds are set to "Completed". | CHAR | 1 | 0 | REFSETERLK |