In this post, I will try and describe everything you need to know about the SAP crmd_orderadm_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_ORDERADM_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_ORDERADM_I....Right lets get started!
Object Name: CRMD_ORDERADM_I
Dictionary Type: Transparent table
Description: Business Transaction Item
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | |||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| CREATED_AT | COMT_CREATED_AT_USR | DEC | 15(0) | Created At (Output in User Time Zone) | COM_TSTMP | |||||||
| CREATED_BY | CRMT_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | USER_ADDR | BNAME | |||||
| CHANGED_AT | COMT_CHANGED_AT_USR | DEC | 15(0) | Changed At (Output in User Time Zone) | COM_TSTMP | |||||||
| CHANGED_BY | CRMT_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | |||||||
| OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITM_DB | CHAR | 10(0) | * | CRM Item Object Type | CRM_OJ_NAME_PROCESS_ITEM | ||||||
| DESCRIPTION_UC | CRMT_PRSHTEXTG_DB | CHAR | 40(0) | Product Short Text in Upper Case for F4 Help | CRM_PRSHTEXTG40_DB | |||||||
| HEADER | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| PARENT | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| ALTERNATIVE | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| PRODUCT | CRMT_PRODUCT_GUID_DB | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | |||||||
| PRODUCT_SRC_SYS | CRMT_PRODUCT_SRC_SYS | CHAR | 10(0) | * | Logical System from Which Product Originates | LOGSYS | ||||||
| ORDERED_PROD | CRMT_ORDERED_PROD_DB | CHAR | 54(0) | Product Name Entered | CRM_ORDERED_PROD | |||||||
| PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | CHAR | 40(0) | Product Number of Business Partner | PRSHTEXT40 | |||||||
| DESCRIPTION | CRMT_PRSHTEXTX_DB | CHAR | 40(0) | Product Short Text | CRM_PRSHTEXT40_DB | |||||||
| ITM_LANGUAGE | CRMT_ITEM_LANGU | LANG | 1(0) | Short Text Language for an Item | SYLANGU | |||||||
| NUMBER_INT | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | |||||||
| NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10(0) | External Item Number | ||||||||
| ITM_TYPE | CRMT_ITEM_TYPE_DB | CHAR | 4(0) | * | Item Category | CRM_ITEM_TYPE | ||||||
| ORDER_DATE | CRMT_ORDER_DATE | DEC | 15(0) | Posting Date | BCOS_TSTMP | |||||||
| SUBST_REASON | CRMT_ITEM_SUBSTITUTION | CHAR | 4(0) | * | Reason for Product Substitution | CRM_ITEM_SUBSTITUTION | ||||||
| ITM_USAGE | CRMT_ITEM_USAGE | CHAR | 2(0) | Usage of Higher-Level Item | CRM_ITEM_USAGE | |||||||
| ITM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CHAR | 4(0) | * | Item Category Usage | CRM_IT_TYPE_USAGE | ||||||
| PRODUCT_KIND | CRMT_PRODUCT_KIND | CHAR | 1(0) | Technnical Type of Product | CRM_PRODUCT_KIND | |||||||
| LOG_SYSTEM_EXT | CRMT_LOGSYS | CHAR | 10(0) | * | Logical System | LOGSYS | ||||||
| ORDERADM_I_DUMMY | DUMMY | CHAR | 1(0) | Dummy function in length 1 | DUMMY | SAP |