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 |