CRMS4D_SOM_MRHA
SOM Mass Run - Header Data for Create
CRMS4D_SOM_MRHA is an SAP database table in S/4HANA. SOM Mass Run - Header Data for Create. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_ServiceMassRunHeaderCrteInfo | view_entity | from | EXTENSION | SOM Mass Run Header Create Information |
| I_ServiceMassRunHeaderCreate | view_entity | from | BASIC | SOM Mass Run Header for Create |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | servicemassrunuuid | CRMS4_SOM_MR_GUID | MR GUID | |||
| subscrpncontrstartdatetime | CRMT_DATE_TIMESTAMP_FROM | Time Stamp | ||||
| servicedocumenttype | CRMT_PROCESS_TYPE | Transaction Type | ||||
| product | CRMT_ORDERED_PROD | Product | ||||
| responsibleemployee | CRMT_PERSON_RESP | Employee Resp. | ||||
| subscriptioncontractduration | TIMEDURA | Duration Value | ||||
| subscrpncontrdurationunit | TIMEUNITDU | Time Unit | ||||
| custmgmtmasteragreementuuid | CRMT_ISX_MA_HEADER_REF_MR | MA Header Ref | ||||
| custmgmtmstragreementitemuuid | CRMT_ISX_MA_ITEM_REF_MR | MA Item Ref | ||||
| sharingcontractid | CRM_POOL_AGREEMENT_MR | Sharing Contract | ||||
| soldtoparty | BU_PARTNER | Busn. Partner | ||||
| payerparty | BU_PARTNER | Busn. Partner | ||||
| shiptoparty | BU_PARTNER | Busn. Partner | ||||
| contractaccount | VKONT_KK | Contract Acct | ||||
| isx_mr_h_dummy | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- SOM Mass Run - Header Data for Create
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SOM_MRHA (
CLIENT, -- Client [MANDT]
SERVICEMASSRUNUUID, -- MR GUID [CRMS4_SOM_MR_GUID]
SUBSCRPNCONTRSTARTDATETIME, -- Time Stamp [CRMT_DATE_TIMESTAMP_FROM]
SERVICEDOCUMENTTYPE, -- Transaction Type [CRMT_PROCESS_TYPE]
PRODUCT, -- Product [CRMT_ORDERED_PROD]
RESPONSIBLEEMPLOYEE, -- Employee Resp. [CRMT_PERSON_RESP]
SUBSCRIPTIONCONTRACTDURATION, -- Duration Value [TIMEDURA]
SUBSCRPNCONTRDURATIONUNIT, -- Time Unit [TIMEUNITDU]
CUSTMGMTMASTERAGREEMENTUUID, -- MA Header Ref [CRMT_ISX_MA_HEADER_REF_MR]
CUSTMGMTMSTRAGREEMENTITEMUUID, -- MA Item Ref [CRMT_ISX_MA_ITEM_REF_MR]
SHARINGCONTRACTID, -- Sharing Contract [CRM_POOL_AGREEMENT_MR]
SOLDTOPARTY, -- Busn. Partner [BU_PARTNER]
PAYERPARTY, -- Busn. Partner [BU_PARTNER]
SHIPTOPARTY, -- Busn. Partner [BU_PARTNER]
CONTRACTACCOUNT, -- Contract Acct [VKONT_KK]
ISX_MR_H_DUMMY, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (CLIENT, SERVICEMASSRUNUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA