The CRMS4D_SOM_CHGD table in SAP ERP or S/4HANA stores I_SUBSCRPNPRODSPECTP I_SUBSCRPNPRODUCTCHARGETP data. There are total 25 fields in CRMS4D_SOM_CHGD table. The I_SUBSCRPNPRODSPECTP I_SUBSCRPNPRODUCTCHARGETP 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_CHGD 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_CHGD Table Fields
Following is the list of fields that are available in SAP CRMS4D_SOM_CHGD table. The primary key fields of the table are MANDT (Client), SUBSCRPNPRODCHRGANDDISCUUID (Discount Assignment UUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| SUBSCRPNPRODCHRGANDDISCUUID | Discount Assignment UUID | CRMS4_SOM_DCASSI_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) | |
| SUBSCRPNPRODSPECUUID | Subscription Product-Specific Data UUID | CRMS4_SOM_PROD_SPCFC_UUID | RAW (16) | |
| CABLLBLEITMDISCOUNTKEY | Discount/Charge Key | DISCKEY_KK | CHAR (8) | |
| SUBSCRPNPRODDISCOUNTVALDFRMDTE | Valid From | CRM_ISX_VALID_FROM | DATS (8) | |
| SUBSCRPNPRODDISCVALIDTODATE | Valid To | CRM_ISX_VALID_TO | DATS (8) | |
| SUBSCRPNCONTRACTRELEVANTTYPE | Contract Relevance | CRM_ISX_CONTRACT_REL | CHAR (1) | |
| SUBSCRPNPRODCHRGORDISCHASDURN | Indicator that Object has a Duration | CRMS4_SOM_HAS_DURATION | CHAR (1) | |
| SUBSCRPNPRODCHRGORDISCDURN | Duration | CRM_ISX_DURATION | DEC (3) | |
| DURATIONUNIT | Unit for Time Period | CRMT_ISX_DURA_UNIT | CHAR (1) | |
| SUBSCRPNCHRGANDDISCACTVTNCNDN | Activation | CRMS4_SOM_ACT_COND | CHAR (1) | |
| BRFFUNCTIONUUID | BRFplus Function UUID | CRMS4_SOM_BRF_UUID | CHAR (32) | |
| CHARACTERISTIC | Characteristic Name | ATNAM | CHAR (30) | |
| CHARACTERISTICVALUE | Characteristic Value | ATWRT | CHAR (70) | |
| 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) |
