CRMC_REQ_TYPE

Transparent Table Customizing (protected)

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)

ViewTypeJoinVDMDescription
CRMS4_PS_REQ_TYPE view from Social Services Request Type
CRMS4V_PS_REQ_TYPE view from CDS View for Request Type

Fields (12)

KeyField Data ElementDescription DomainTypeLength
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)
);