SAP CRMC_ITEM_TYPE Business Transaction Item Type Table data and field list

CRMC_ITEM_TYPE is a standard SAP Table which is used to store Business Transaction Item Type data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CRMC_ITEM_TYPE table consists of various fields, each holding specific information or linking keys about Business Transaction Item Type data available in SAP. These include ITM_TYPE (Item Category), ITM_BLOCKED (Active Indicator: Item Category), TEXT_PROCEDURE (Text Schema), PART_DETERM_PROC (ID of a Partner Determination Procedure)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CRMC_ITEM_TYPE table Technical Details:

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMC_ITEM_TYPE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CRMC_ITEM_TYPE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
ITM_TYPEItem Category CRMT_ITEM_TYPECHAR4CRM_ITEM_TYPECRM_ITEM_TYPE
ITM_BLOCKEDActive Indicator: Item Category CRMT_ITEM_BLOCKEDCHAR1CRM_BOOLEAN
TEXT_PROCEDUREText Schema COMT_TEXT_DET_PROCEDURECHAR8COMC_TEXT_PCHAR8
PART_DETERM_PROCID of a Partner Determination Procedure COMT_PARTNER_DETERM_PROCCHAR8CRMC_PARTNER_PDDCOMT_PARTNER_DETERM_PROC
USER_STAT_PROCStatus Profile J_STSMACHAR8TJ20J_STSMA
OBJECT_TYPECRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITEMCHAR10CRMC_SUBOB_CAT_ICRM_OJ_NAME_PROCESS_ITEM
ATP_PROFILEATP Profile (Reference Customizing for ATP Control in APO) CRMT_ATP_PROFILECHAR6CRMC_ATP_PROFILECRM_ATP_PROFILE
WEIGHT_RELEVANTRelevant for Weight/Volume CRMT_WEIGHT_RELEVANTCHAR1CRM_BOOLEAN
STRUCTURE_TYPEStructure Scope CRMT_STRUCTURE_TYPECHAR1CRM_STRUCTURE_TYPE
ORG_PROFILIDOrganizational Data Profile CRMT_ORG_PROFILIDCHAR12CRMC_ORGPROFCHAR12
VARIANT_DETERMINVariant Matching CRMT_VARIANT_DETERMINATIONCHAR1CRM_VARIANT_DETERMINATION
VARIANT_ACTIONAction for Product Variants Found Automatically CRMT_VARIANT_ACTIONCHAR1CRM_VARIANT_ACTION
TIMEPROFILEName of Date Profile TIMECONTCHAR12TIMEPFTIMECONT
ACTIONPROFILEPPF: Name of Action Profile PPFDCNTXTCHAR30PPFTCONDEPPFDCNTXT
COND_GROUP_NAMECondition Group for Price Agreements CRMT_COND_GROUP_NAMECHAR10/SAPCND/GROUP/SAPCND/MAINT_GROUP
DLV_GROUP_CORRELCreate Delivery Group CRMT_DLV_GROUP_CORRELCHAR1CRMT_DLV_GROUP_CORREL
STATUS_OBJ_TYPEStatus object type in CRM business transaction CRMT_STATUS_OBJECT_TYPECHAR3Assigned to domainCRM_STATUS_OBJECT_TYPE
CONFFPROCConfiguration Restriction/Pricing Agreements: Procedure CRMT_CONFIG_FILTER_PROCEDURECHAR4CRMC_CONFFPROCCRM_CONFIG_FILTER_PROCEDURE
BW_ASSIGNAssign BW and CO CRMT_BW_ASSIGNCHAR1CRMT_BW_ASSIGN
ERR_GRPIncompleteness Group: Transaction/Item CRMT_ERR_GRPCHAR4CRMC_ERR_GRPCRM_ERR_GRP
DATE_QTY_FIXEDFixed Date and Quantity CRMT_DATE_QTY_FIXEDCHAR1CRM_BOOLEAN
IND_OBJECTUsage of Individual Object CRMT_INDIVIDUAL_OBJECTNUMC1CRM_INDIVIDUAL_OBJECT
OBJREF_PROF_IDProfile ID for Object Relationships CRMT_OBJREF_PROFILECHAR10CRMC_OBJREF_PFCRM_OBJREF_PROFILE
NO_PRODUCT_CHECKNo Product Check CRMT_NO_PRODUCT_CHECKCHAR1CRM_NO_PRODUCT_CHECK
MAINT_PROFILEEnhancement Profile for Business Transaction CRMT_MAINTENANCE_PROFILECHAR10CRMC_MAINT_PROFCHAR10
AP_DET_PROCAction Profile Determination Procedure CRMT_AP_DET_PROCCHAR6/SAPCND/CTLIST/SAPCND/CTLIST_NAME
REF_OBJECT_TYPEPredecessor Reference (Item Object Type) CRMT_REF_OBJECT_TYPECHAR10Assigned to domainCRM_OJ_NAME_PROCESS_ITEM
PRINTING_VIEWFilter ID COMT_CFGD_FIIDCHAR1COMD_CFGD_CHAR1
CREI_PROFILEEntitlement Profile CRMDT_CREI_PROFILECHAR10CRMC_CREI_IEPDTDCRMDM_CREI_PROFILE
PRED_REF_MANDReference to Preceding Object Is Mandatory CRMDT_PRED_MANDCHAR1CRMDM_PRED_MAND

Key field Non-key field



How do I retrieve data from SAP table CRMC_ITEM_TYPE using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMC_ITEM_TYPE to SELECT all data from the table
DATA: WA_CRMC_ITEM_TYPE TYPE CRMC_ITEM_TYPE.

SELECT SINGLE *
FROM CRMC_ITEM_TYPE
INTO CORRESPONDING FIELDS OF WA_CRMC_ITEM_TYPE
WHERE...

How to access SAP table CRMC_ITEM_TYPE

Within an ECC or HANA version of SAP you can also view further information about CRMC_ITEM_TYPE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).