In this post, I will try and describe everything you need to know about the SAP crmd_isa_spl_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_ISA_SPL_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_ISA_SPL_I....Right lets get started!
Object Name: CRMD_ISA_SPL_I
Dictionary Type: Transparent table
Description: Shopping Basket and Purchasing List Item Data
| 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 | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| ITEM_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| ITEM_NO | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | CRM | ||||||
| PRODUCT_GUID | CRMT_OBJECT_GUID_C | CHAR | 32(0) | GUID of a CRM Order Object, 32 Bit Characters | SYSUUID_C | CRM | ||||||
| PRODUCT | COMT_PRODUCT_ID | CHAR | 40(0) | Product ID | COM_PRODUCT_ID | COM_PR_COLLECTION | PRODUCT_ID | CRM | ||||
| QUANTITY | CHAR12 | CHAR | 12(0) | Character Field of Length 12 | CHAR12 | CRM | ||||||
| UNIT | CRMT_PROCESS_QTY_UNIT | UNIT | 3(0) | * | Unit of Measure in Which the Product Is Sold | MEINS | CRM | |||||
| DESCRIPTION | COMT_PRSHTEXTX | CHAR | 40(0) | Product Description | PRSHTEXT40 | CRM | ||||||
| PRICE | CHAR30 | CHAR | 30(0) | 30 Characters | CHAR30 | SAP | CRM | |||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | * | Currency | WAERS | FWS | CRM | ||||
| CREATED_AT | SMWMOSDATI | CHAR | 32(0) | OS datetime(local datetime in micro seconds) | CHAR32 | CRM | ||||||
| CHANGED_AT | SMWMOSDATI | CHAR | 32(0) | OS datetime(local datetime in micro seconds) | CHAR32 | CRM | ||||||
| CUSTOMER_EXT | DUMMY | CHAR | 1(0) | Dummy function in length 1 | DUMMY | SAP | CRM |