The CRMS4D_SOM_TESRD table in SAP ERP or S/4HANA stores I_SUBSCRPNPRODSPECTP I_CHRGPLNTECHSERVICETP data. There are total 16 fields in CRMS4D_SOM_TESRD table. The I_SUBSCRPNPRODSPECTP I_CHRGPLNTECHSERVICETP 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_SOM_TESRD table. It is in SOM: Model for Subscription Product-Specific Data (CRMS4_SOM_PROD_SPEC_MODEL) ABAP package and is part of the S4CRM: Subscription Order Management (CRM-S4-SOM) module.
SAP CRMS4D_SOM_TESRD Table Fields
Following is the list of fields that are available in SAP CRMS4D_SOM_TESRD table. The primary key fields of the table are MANDT (Client), CHARGEPLANTECHNICALSERVICEUUID (Technical Service UUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CHARGEPLANTECHNICALSERVICEUUID | Technical Service UUID | CRMS4_SOM_TECHSERVICE_UUID | RAW (16) | |
| CREATEDBYUSER | Created By (User) | CRMS4_SOM_CREATED_BY | CHAR (12) | |
| CREATIONDATETIME | Created At | CRMS4_SOM_CREATED_AT | DEC (21) | |
| LASTCHANGEDBYUSER | Changed By (User) | CRMS4_SOM_CHANGED_BY | CHAR (12) | |
| LASTCHANGEDATETIME | Changed At | CRMS4_SOM_CHANGED_AT | DEC (21) | |
| CHRGPLANTECHNICALRESOURCEUUID | Technical Resource UUID | CRMS4_SOM_TECRES_UUID | RAW (16) | |
| SUBSCRPNPRODSPECUUID | Subscription Product-Specific Data UUID | CRMS4_SOM_PROD_SPCFC_UUID | RAW (16) | |
| CHARGEPLANTECHNICALSERVICEID | Technical Data Name from SAP Convergent Charging | CRM_ISX_TECH_DATA_ID | CHAR (80) | |
| ACTIVEUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
