The CRMD_DHR_ISLSAGR table in SAP ERP or S/4HANA stores Sales agreements item buffer table data. There are total 22 fields in CRMD_DHR_ISLSAGR table. The Sales agreements item buffer table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_DHR_ISLSAGR table. It is in Operative Reporting in CRM (CRM_REPORT) ABAP package and is part of the Reporting Framework (CRM-BTX-ANA-RFW) module.
SAP CRMD_DHR_ISLSAGR Table Fields
Following is the list of fields that are available in SAP CRMD_DHR_ISLSAGR table. The primary key fields of the table are CLIENT (Client), HEADER (GUID of a CRM Order Object), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| HEADER | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| NUMBER_INT | Item Number in Document | CRMT_ITEM_NO | NUMC (10) | |
| PRODUCT_ID | Product Name Entered | CRMT_ORDERED_PROD | CHAR (54) | |
| PRODUCT | Internal Unique ID of Product | CRMT_PRODUCT_GUID_DB | RAW (16) | |
| CATEGORY_GUID | Category GUID | COMT_CATEGORY_GUID | RAW (16) | |
| PROD_HIERARCHY | Product Category | CRMT_PROD_HIERARCHY | CHAR (20) | |
| STAT_REJECTED_I | Status: Rejected | CRMT_STATUS_REJECTED | CHAR (1) | |
| STAT_CREDIT_OK_I | Status: Credit Ok | CRMT_STATUS_CREDIT_OK | CHAR (1) | |
| STAT_CRDT_N_OK_I | Status: Credit Not Ok | CRMT_STATUS_CREDIT_NOT_OK | CHAR (1) | |
| TARGET_VALUE | Target Value for Contracts | CRMT_TARGET_VALUE | CURR (19) | |
| TARGET_CURRENCY | Currency | CRMT_CURRENCY | * | CUKY (5) |
| NET_VALUE_MAN | Total Expected Net Value Products in Document Currency | CRMT_NET_VALUE_MAN | CURR (15) | |
| TARGET_QUANTITY | CRM Schedule Line Quantity | CRMT_SCHEDLIN_QUAN | QUAN (13) | |
| TARGET_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | * | UNIT (3) |
| BASE_QTY_UNIT | Base Unit of Measure of Product | COMT_PRODUCT_BASE_UOM | * | UNIT (3) |
| PROCESS_QTY_NUM | Numerator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_NUM | INT4 (10) | |
| PROCESS_QTY_DEN | Denominator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_DEN | INT4 (10) | |
| CANCPARTY_I | Cancelling Party | CRMT_CANC_PARTY | CHAR (4) | |
| CANC_REASON_I | CRM Service : Reason for Cancellation | CRMT_SRV_CANCEL_REASON | * | CHAR (4) |
| CREATEDATDATE_I | Transaction Was Created on This Date | CRMT_CREATED_AT_DATE | DATS (8) |
