CRMC_IT_ASSIGN

Transparent Table Customizing (protected)
17 Fields 4 CDS Views

Transaction Item Type - Determination

CRMC_IT_ASSIGN is an SAP database table in S/4HANA. Transaction Item Type - Determination. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_SrvcOrdSrvcConfDocTypeVH view_entity inner CONSUMPTION Document Types relevant for Billing
I_ServiceOrderTypeVH view inner BASIC Service Order Type Value Help
I_ServiceQuotationType view inner BASIC Transaction Types relevant to quotation
I_SrvcDocItmCatDetermination view from BASIC Item Category Determ of Srvc Transaction

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_type CRMT_PROCESS_TYPE Transaction Type
KEY item_cat_group MTPOS Item Cat. Group
KEY it_type_usage CRMT_IT_TYPE_USAGE Item Cat. Usage
KEY item_type_main CRMT_ITEM_TYPE_MAIN Main item cat.
itm_type CRMT_ITEM_TYPE Item Category
itm_type_alt1 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt2 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt3 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt4 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt5 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt6 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt7 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt8 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt9 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt10 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty
itm_type_alt11 CRMT_ITEM_TYPE_ALTERNATIVE AltrntveItemCty

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.

-- Transaction Item Type - Determination
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMC_IT_ASSIGN (
    CLIENT,          -- Client [MANDT]
    PROCESS_TYPE,    -- Transaction Type [CRMT_PROCESS_TYPE]
    ITEM_CAT_GROUP,  -- Item Cat. Group [MTPOS]
    IT_TYPE_USAGE,   -- Item Cat. Usage [CRMT_IT_TYPE_USAGE]
    ITEM_TYPE_MAIN,  -- Main item cat. [CRMT_ITEM_TYPE_MAIN]
    ITM_TYPE,        -- Item Category [CRMT_ITEM_TYPE]
    ITM_TYPE_ALT1,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT2,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT3,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT4,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT5,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT6,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT7,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT8,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT9,   -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT10,  -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    ITM_TYPE_ALT11,  -- AltrntveItemCty [CRMT_ITEM_TYPE_ALTERNATIVE]
    PRIMARY KEY (CLIENT, PROCESS_TYPE, ITEM_CAT_GROUP, IT_TYPE_USAGE, ITEM_TYPE_MAIN)
);

Learn More