CRMS4D_SRV_SUBJ

Transparent Table Application Table
20 Fields 3 CDS Views

Customer Mgmt Add-on S4 Subject

CRMS4D_SRV_SUBJ is an SAP database table in S/4HANA. Customer Mgmt Add-on S4 Subject. It contains 20 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_IU_I_IR_REASON view_entity from Interaction Record Reason
CRMS4_STATUS_REASON view from Status reason
I_ServiceDefect view from BASIC Service Defect

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY objtype_h crmt_subobject_category_db Trans. Cat.
KEY object_id crmt_object_id_db Transaction ID
KEY number_int crms4_number_int Item Number in Doc.
KEY profile_type crmt_subject_profile_type SubjPrfileCtgry
KEY sort crmt_sort Sort Field
subject_profile crmt_subject_profile Subject Profile
username syuname User Name
timestamp crmt_timestamp Time stamp
katalogart comt_catalog Catalog
codegruppe crm_qcodegrp Code Group
code crm_qcode Code
defectclass crmt_defectclass Defect Class
quality crmt_quality Quality Defect
defquantity crmt_defquantity Defect Count
guid_hierarchy crmt_object_guid Object GUID
ext_code crmt_tsrv_ext_code Code
asp_id crms4_erms_cat_as_id Schema ID
cat_id crms4_erms_cat_as_id Schema ID
katalog_type crmt_catalogtype Catalog Categ.

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.

-- Customer Mgmt Add-on S4 Subject
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SRV_SUBJ (
    CLIENT,           -- Client [mandt]
    OBJTYPE_H,        -- Trans. Cat. [crmt_subobject_category_db]
    OBJECT_ID,        -- Transaction ID [crmt_object_id_db]
    NUMBER_INT,       -- Item Number in Doc. [crms4_number_int]
    PROFILE_TYPE,     -- SubjPrfileCtgry [crmt_subject_profile_type]
    SORT,             -- Sort Field [crmt_sort]
    SUBJECT_PROFILE,  -- Subject Profile [crmt_subject_profile]
    USERNAME,         -- User Name [syuname]
    TIMESTAMP,        -- Time stamp [crmt_timestamp]
    KATALOGART,       -- Catalog [comt_catalog]
    CODEGRUPPE,       -- Code Group [crm_qcodegrp]
    CODE,             -- Code [crm_qcode]
    DEFECTCLASS,      -- Defect Class [crmt_defectclass]
    QUALITY,          -- Quality Defect [crmt_quality]
    DEFQUANTITY,      -- Defect Count [crmt_defquantity]
    GUID_HIERARCHY,   -- Object GUID [crmt_object_guid]
    EXT_CODE,         -- Code [crmt_tsrv_ext_code]
    ASP_ID,           -- Schema ID [crms4_erms_cat_as_id]
    CAT_ID,           -- Schema ID [crms4_erms_cat_as_id]
    KATALOG_TYPE,     -- Catalog Categ. [crmt_catalogtype]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, PROFILE_TYPE, SORT)
);

Learn More