CRMC_ITEM_TYPE
Business Transaction Item Type
CRMC_ITEM_TYPE is an SAP database table in S/4HANA. Business Transaction Item Type. It contains 37 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_SrvcOrdSrvcConfDocTypeVH | view_entity | inner | CONSUMPTION | Document Types relevant for Billing |
| crms4_fsm_bustype_textproc | view | from | FSM Integration: search help | |
| I_CustMgmtDocItemCategory | view | from | BASIC | Item Category of Service Transactions |
| I_ServiceDocItemCategory | view | from | BASIC | Category of Service Transaction Item |
| I_ServiceOrderTypeVH | view | inner | BASIC | Service Order Type Value Help |
| I_ServiceQuotationType | view | inner | BASIC | Transaction Types relevant to quotation |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | itm_type | crmt_item_type | Item Category | |||
| itm_blocked | crmt_item_blocked | Inactive | ||||
| text_procedure | comt_text_det_procedure | Text Det.Proc. | ||||
| part_determ_proc | comt_partner_determ_proc | PartnerDetProc | ||||
| user_stat_proc | j_stsma | Status Profile | ||||
| object_type | crmt_swo_objtyp_process_item | Object Type | ||||
| atp_profile | abap.char | ATP Profile (Obsolete) | ||||
| weight_relevant | crmt_weight_relevant | Relev.wgt/vol. | ||||
| structure_type | crmt_structure_type | Structure scope | ||||
| org_profilid | abap.char | Organizational Data Profile (obsolete) | ||||
| variant_determin | crmt_variant_determination | Var. matching | ||||
| variant_action | crmt_variant_action | Var.match.act. | ||||
| timeprofile | timecont | Date Profile | ||||
| actionprofile | ppfdcntxt | Action Profile | ||||
| cond_group_name | crmt_cond_group_name | Cond. Group | ||||
| dlv_group_correl | crmt_dlv_group_correl | Delivery Group | ||||
| status_obj_type | crmt_status_object_type | Status object type in Service business transac. | ||||
| conffproc | abap.char | Configuration Restriction/Pricing Agreements: Procedure | ||||
| bw_assign | crmt_bw_assign | Assign CO | ||||
| err_grp | crmt_err_grp | IncompleteGroup | ||||
| date_qty_fixed | crmt_date_qty_fixed | Fixed Date/Qty | ||||
| ind_object | abap.numc | Object Usage | ||||
| objref_prof_id | crmt_objref_profile | Profile | ||||
| no_product_check | crmt_no_product_check | W/out Product | ||||
| maint_profile | crmt_maintenance_profile | Enhancement Prof. | ||||
| ap_det_proc | crmt_ap_det_proc | AP Procedure | ||||
| ref_object_type | crmt_ref_object_type | Mandat. Predec. Ref. | ||||
| printing_view | comt_cfgd_fiid | Filter ID | ||||
| crei_profile | abap.char | Obsolete | ||||
| pred_ref_mand | crmdt_pred_mand | Obj. Ref. Mand. | ||||
| config_dark | crmt_config_dark_execution | Default Config. | ||||
| sc_relevant | abap.char | Transaction Item Can Use Solution Configurator | ||||
| cont_itm_quanval | crmt_contract_item_quan_val | Quantity/Value Item | ||||
| territory_check | xfeld | Checkbox | ||||
| scenario | escenario | Scenario | ||||
| bom_application | capid | BOM Application |
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.
-- Business Transaction Item Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMC_ITEM_TYPE (
CLIENT, -- Client [mandt]
ITM_TYPE, -- Item Category [crmt_item_type]
ITM_BLOCKED, -- Inactive [crmt_item_blocked]
TEXT_PROCEDURE, -- Text Det.Proc. [comt_text_det_procedure]
PART_DETERM_PROC, -- PartnerDetProc [comt_partner_determ_proc]
USER_STAT_PROC, -- Status Profile [j_stsma]
OBJECT_TYPE, -- Object Type [crmt_swo_objtyp_process_item]
ATP_PROFILE, -- ATP Profile (Obsolete) [abap.char]
WEIGHT_RELEVANT, -- Relev.wgt/vol. [crmt_weight_relevant]
STRUCTURE_TYPE, -- Structure scope [crmt_structure_type]
ORG_PROFILID, -- Organizational Data Profile (obsolete) [abap.char]
VARIANT_DETERMIN, -- Var. matching [crmt_variant_determination]
VARIANT_ACTION, -- Var.match.act. [crmt_variant_action]
TIMEPROFILE, -- Date Profile [timecont]
ACTIONPROFILE, -- Action Profile [ppfdcntxt]
COND_GROUP_NAME, -- Cond. Group [crmt_cond_group_name]
DLV_GROUP_CORREL, -- Delivery Group [crmt_dlv_group_correl]
STATUS_OBJ_TYPE, -- Status object type in Service business transac. [crmt_status_object_type]
CONFFPROC, -- Configuration Restriction/Pricing Agreements: Procedure [abap.char]
BW_ASSIGN, -- Assign CO [crmt_bw_assign]
ERR_GRP, -- IncompleteGroup [crmt_err_grp]
DATE_QTY_FIXED, -- Fixed Date/Qty [crmt_date_qty_fixed]
IND_OBJECT, -- Object Usage [abap.numc]
OBJREF_PROF_ID, -- Profile [crmt_objref_profile]
NO_PRODUCT_CHECK, -- W/out Product [crmt_no_product_check]
MAINT_PROFILE, -- Enhancement Prof. [crmt_maintenance_profile]
AP_DET_PROC, -- AP Procedure [crmt_ap_det_proc]
REF_OBJECT_TYPE, -- Mandat. Predec. Ref. [crmt_ref_object_type]
PRINTING_VIEW, -- Filter ID [comt_cfgd_fiid]
CREI_PROFILE, -- Obsolete [abap.char]
PRED_REF_MAND, -- Obj. Ref. Mand. [crmdt_pred_mand]
CONFIG_DARK, -- Default Config. [crmt_config_dark_execution]
SC_RELEVANT, -- Transaction Item Can Use Solution Configurator [abap.char]
CONT_ITM_QUANVAL, -- Quantity/Value Item [crmt_contract_item_quan_val]
TERRITORY_CHECK, -- Checkbox [xfeld]
SCENARIO, -- Scenario [escenario]
BOM_APPLICATION, -- BOM Application [capid]
PRIMARY KEY (CLIENT, ITM_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