CRMC_IT_ASSIGN

Transparent Table Customizing (protected)
29 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 29 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 (29)

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
itm_type_alt12 crmt_item_type_alternative AltrntveItemCty
itm_type_alt13 crmt_item_type_alternative AltrntveItemCty
itm_type_alt14 crmt_item_type_alternative AltrntveItemCty
itm_type_alt15 crmt_item_type_alternative AltrntveItemCty
itm_type_alt16 crmt_item_type_alternative AltrntveItemCty
itm_type_alt17 crmt_item_type_alternative AltrntveItemCty
itm_type_alt18 crmt_item_type_alternative AltrntveItemCty
itm_type_alt19 crmt_item_type_alternative AltrntveItemCty
itm_type_alt20 crmt_item_type_alternative AltrntveItemCty
itm_type_alt21 crmt_item_type_alternative AltrntveItemCty
itm_type_alt22 crmt_item_type_alternative AltrntveItemCty
itm_type_alt23 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]
    ITM_TYPE_ALT12,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT13,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT14,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT15,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT16,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT17,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT18,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT19,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT20,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT21,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT22,  -- AltrntveItemCty [crmt_item_type_alternative]
    ITM_TYPE_ALT23,  -- AltrntveItemCty [crmt_item_type_alternative]
    PRIMARY KEY (CLIENT, PROCESS_TYPE, ITEM_CAT_GROUP, IT_TYPE_USAGE, ITEM_TYPE_MAIN)
);

Learn More