CRMC_REQ_TYPE
Antragstyp
CRMC_REQ_TYPE is an SAP database table in S/4HANA. Antragstyp. It contains 12 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CRMS4_PS_REQ_TYPE | view | from | Social Services Request Type | |
| CRMS4V_PS_REQ_TYPE | view | from | CDS View for Request Type |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | req_type | crmt_req_type | Req.Category | |||
| process_type | crmt_process_type | Transaction Type | ||||
| active | crmt_webreq_active | Active | ||||
| textid | comt_text_textid | Text Type | ||||
| change_mode | crmt_change_mode | Change Flag | ||||
| subject_profile | crmt_subject_profile | Subject Profile | ||||
| req_type_group | crmt_reqtype_group | Req.Ctgry Group | ||||
| req_type_guid | crmt_reqtype_guid | Req. Ctgry GUID | ||||
| katalogart | comt_catalog | Catalog | ||||
| codegruppe | crm_qcodegrp | Code Group | ||||
| code | crmt_srv_act_reason | Activity Reason |
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.
-- Antragstyp
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMC_REQ_TYPE (
CLIENT, -- Client [mandt]
REQ_TYPE, -- Req.Category [crmt_req_type]
PROCESS_TYPE, -- Transaction Type [crmt_process_type]
ACTIVE, -- Active [crmt_webreq_active]
TEXTID, -- Text Type [comt_text_textid]
CHANGE_MODE, -- Change Flag [crmt_change_mode]
SUBJECT_PROFILE, -- Subject Profile [crmt_subject_profile]
REQ_TYPE_GROUP, -- Req.Ctgry Group [crmt_reqtype_group]
REQ_TYPE_GUID, -- Req. Ctgry GUID [crmt_reqtype_guid]
KATALOGART, -- Catalog [comt_catalog]
CODEGRUPPE, -- Code Group [crm_qcodegrp]
CODE, -- Activity Reason [crmt_srv_act_reason]
PRIMARY KEY (CLIENT, REQ_TYPE)
);
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