The CRMS4D_REPA_H table in SAP ERP or S/4HANA stores In-House Repair: Header data. There are total 39 fields in CRMS4D_REPA_H table. The In-House Repair: Header table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMS4D_REPA_H table. It is in In-House Repair Business Object (CRMS4_REPAIR_BO) ABAP package and is part of the S4CRM: In-House Repair (CRM-S4-IHR) module.
SAP CRMS4D_REPA_H Table Fields
Following is the list of fields that are available in SAP CRMS4D_REPA_H table. The primary key fields of the table are CLIENT (Client), OBJTYPE_H (Business Trans. Cat.), OBJECT_ID (Transaction ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| OBJTYPE_H | Business Trans. Cat. | CRMT_SUBOBJECT_CATEGORY_DB | CRMC_SUBOB_CAT | CHAR (10) |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR (10) | |
| HEADER_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | * | CHAR (4) |
| DESCRIPTION_H | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR (40) | |
| DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | * | LANG (1) |
| CREATED_AT_H | Created At | CRMS4_CREATED_AT | DEC (15) | |
| CREATED_BY_H | User that Created the Transaction | CRMT_CREATED_BY | CHAR (12) | |
| CHANGED_AT_H | Changed At | CRMS4_CHANGED_AT | DEC (15) | |
| CHANGED_BY_H | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR (12) | |
| ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR (1) | |
| OBJECT_ID_OK | Indicator That Transaction ID Is Correct | CRMT_OBJECT_ID_OK | CHAR (1) | |
| VERIFY_DATE | Time Period of Last Archiving Attempt | CRMT_VERIFY_DATE | DEC (15) | |
| STAT_LIFECYCLE | Life Cycle Status | CRMS4_STAT_LIFECYCLE | CHAR (4) | |
| STAT_ERROR | Error Status | CRMS4_STAT_ERROR | CHAR (1) | |
| STAT_OPEN | Status “Open” | CRMS4_STAT_OPEN | CHAR (1) | |
| STAT_ARCHIVABLE | Archivable | CRMS4_STAT_ARCHIVABLE | CHAR (1) | |
| STAT_ARCHIVED | Archived | CRMS4_STAT_ARCHIVED | CHAR (1) | |
| SOLD_TO_PARTY | Sold-To Party | CRMT_SOLD_TO_PART | * | CHAR (10) |
| CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | * | CHAR (10) |
| SHIP_TO_PARTY | Ship-To Party | CRMT_SHIP_TO_PART | * | CHAR (10) |
| PERSON_RESP | Employee Responsible | CRMT_PERSON_RESP | * | CHAR (10) |
| SALES_ORG_SD | Sales Organization | VKORG | CHAR (4) | |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| SALES_ORG_ORI | Origin Indicator: Sales Organization | CRMT_SALES_ORG_ORIGIN | CHAR (1) | |
| DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR (2) | |
| DIS_CHANNEL_ORI | Origin Indicator: Distribution Channel | CRMT_DIS_CHANNEL_ORIGIN | CHAR (1) | |
| DIVISION | Division | CRMT_DIVISION | CHAR (2) | |
| DIVISION_ORI | Origin Flag: Division | CRMT_DIVISION_ORIGIN | CHAR (1) | |
| SALES_OFFICE_SD | Sales office | VKBUR | * | CHAR (4) |
| SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR (14) | |
| SALES_OFF_ORI | Origin Indicator: Sales Office | CRMT_SALES_OFFICE_ORIGIN | CHAR (1) | |
| SALES_GROUP_SD | Sales group | VKGRP | * | CHAR (3) |
| SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR (14) | |
| SALES_GROUP_ORI | Origin Indicator: Sales Group | CRMT_SALES_GROUP_ORIGIN | CHAR (1) | |
| SALES_ORG_RESP | Organizational Unit (Sales) | CRMT_SALES_ORG_RESP | CHAR (14) | |
| SALES_ORGR_ORI | Origin Indicator: Sales Scenario Organizational Unit | CRMT_SALES_ORG_RESP_ORIGIN | CHAR (1) | |
| REPA_H_DUMMY_PS | Single-Character Flag | CHAR1 | CHAR (1) |
