SAP Table CRMD_ORDERADM_I

Business Transaction Item

CRMD_ORDERADM_I (Business Transaction Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CRMD_ORDERADM_I to other SAP tables.

CRMD_ORDERADM_I table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
GUID GUID of a CRM Order Object CRMT_OBJECT_GUID RAW 16 0
CREATED_AT Created At (Output in User Time Zone) COMT_CREATED_AT_USR DEC 15 0
CREATED_BY User that Created the Transaction CRMT_CREATED_BY CHAR 12 0
CHANGED_AT Changed At (Output in User Time Zone) COMT_CHANGED_AT_USR DEC 15 0
CHANGED_BY Transaction Last Changed By CRMT_CHANGED_BY CHAR 12 0
OBJECT_TYPE CRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITM_DB CHAR 10 0
DESCRIPTION_UC Product Short Text in Upper Case for F4 Help CRMT_PRSHTEXTG_DB CHAR 40 0
HEADER GUID of a CRM Order Object CRMT_OBJECT_GUID RAW 16 0
PARENT GUID of a CRM Order Object CRMT_OBJECT_GUID RAW 16 0
ALTERNATIVE GUID of a CRM Order Object CRMT_OBJECT_GUID RAW 16 0
PRODUCT Internal Unique ID of Product CRMT_PRODUCT_GUID_DB RAW 16 0
PRODUCT_SRC_SYS Logical System from Which Product Originates CRMT_PRODUCT_SRC_SYS CHAR 10 0
ORDERED_PROD Product Name Entered CRMT_ORDERED_PROD_DB CHAR 54 0
PARTNER_PROD Product Number of Business Partner CRMT_ITEM_DESCR_PARTNER CHAR 40 0
DESCRIPTION Product Short Text CRMT_PRSHTEXTX_DB CHAR 40 0
ITM_LANGUAGE Short Text Language for an Item CRMT_ITEM_LANGU LANG 1 0
NUMBER_INT Item Number in Document CRMT_ITEM_NO NUMC 10 0
NUMBER_EXT External Item Number CRMT_ITEM_NO_EXT NUMC 10 0
ITM_TYPE Item Category CRMT_ITEM_TYPE_DB CHAR 4 0
ORDER_DATE Posting Date CRMT_ORDER_DATE DEC 15 0
SUBST_REASON Reason for Product Substitution CRMT_ITEM_SUBSTITUTION CHAR 4 0
ITM_USAGE Usage of Higher-Level Item CRMT_ITEM_USAGE CHAR 2 0
01 Configuration
02 Billing Request from Billing Plan
03 Complaint
04 Rules-Based ATP
05 Option
06 Credit / Debit Memo
07 Return Deliveries
08 Bill of Material
09 Free Goods (Inclusive Bonus)
10 Free Goods (Exclusive Bonus)
11 Competitor Product
12 Item from Service Plan
13 1-to-N Substitution
14 Kit
15 Grid Product Variant
16 Solution Configurator: Sales Component
17 Solution Configurator: Tariff Combination
18 Solution Configurator: Dependent Components
20 Structure Item for Claim
21 Sheet of Claim Structure
22 Item Distribution
23 Result of Item Distribution
24 Structure Item for Multiple Customers with Funds
25 Utilities Industry: Main Item
26 Utilities Industry: Subitem
27 Utilities Industry: Package Component
28 Item for Claim Submission/Validated Accounts
ITM_TYPE_USAGE Item Category Usage CRMT_IT_TYPE_USAGE CHAR 4 0
PRODUCT_KIND Technnical Type of Product CRMT_PRODUCT_KIND CHAR 1 0
NULL Reserved for Legacy Data
A Product
B Product Variant
C Individual Object
D External Product
X Unknown
G Grid Product
LOG_SYSTEM_EXT Logical System CRMT_LOGSYS CHAR 10 0
ORDERADM_I_DUMMY Dummy function in length 1 DUMMY CHAR 1 0