In this post, I will try and describe everything you need to know about the SAP crmd_timerep table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_TIMEREP what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_TIMEREP....Right lets get started!
Object Name: CRMD_TIMEREP
Dictionary Type: Transparent table
Description: Transaction - Time Reporting for Industry Add-On
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| TIME_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| CREATED_AT | CRMT_CREATED_AT_USR | DEC | 15(0) | Created On (Output in User Time Zone) | CRM_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | USER_ADDR | BNAME | CRM | ||||
| CHANGED_AT | CRMT_CHANGED_AT_USR | DEC | 15(0) | Changed On (Output in User Time Zone) | CRM_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | CRM | ||||||
| TEXT_NO | CRMT_TIMEREP_TEXT_NO | NUMC | 3(0) | Text Number for Time Reporting | CRMT_TIMEREP_TEXT_NO | CRM | ||||||
| DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CHAR | 40(0) | Transaction Description | CRM_PROCESS_DESCRIPTION | CRM | ||||||
| STARTED_AT | CRMT_TIMEREP_STARTED_AT | DEC | 15(0) | Timestamp for Service Provided | CRM_TSTMP | CRM | ||||||
| TIME_SPENT | CRMT_TIMEREP_DURATION | DEC | 13(0) | Duration for Time Reporting | TIMEDURA | CRM | ||||||
| TIME_UNIT | CRMT_TIMEREP_DURA_UNIT | UNIT | 3(0) | * | Time Unit for Duration for Time Reporting | MEINS | CRM | |||||
| PARTNER_NO | CRMT_PARTNER_NO | CHAR | 32(0) | Partner Number | CRM_PARTNER_NO | CRM | ||||||
| NO_TYPE | CRMT_PARTNER_NO_TYPE | CHAR | 2(0) | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | COMT_PARTNER_NO_TYPE | CRM | ||||||
| GUID_1O_HEADER | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| GUID_1O_ITEM | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| PROFILE | CRMT_IC_CONFIGPROF | CHAR | 12(0) | IC WebClient Profile | CHAR12 | CRM |