The CMS_LIQ table in SAP ERP or S/4HANA stores Liquidation Details data. There are total 36 fields in CMS_LIQ table. The Liquidation Details 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 CMS_LIQ table. It is in Liquidation (CMS_LIQ) ABAP package and is part of the Liquidation (FS-CMS-LIQ) module.
SAP CMS_LIQ Table Fields
Following is the list of fields that are available in SAP CMS_LIQ table. The primary key fields of the table are MANDT (Client), LIQ_GUID (Liquidation GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| LIQ_GUID | Liquidation GUID | CMS_DTE_LIQ_GUID | RAW (16) | |
| OBJ_REF_GUID | Object link GUID for liquidation | CMS_DTE_LIQ_OBJ_LNK_GUID | RAW (16) | |
| OBJSYSID | Object System Reference ID for Liquidation | CMS_DTE_LIQ_OBJ_SYSID | TCMS_LIQ_OBJ_SYS | CHAR (6) |
| LIQ_TYP | Liquidation Measure Type ID | CMS_DTE_LIQ_TYP | TCMS_LIQ_TYP | CHAR (6) |
| LIQ_START_DATE | Start Date for the Liquidation Measure | CMS_DTE_LIQ_START_DATE | DATS (8) | |
| LIQ_END_DATE | End Date of a Liquidation Measure | CMS_DTE_LIQ_END_DATE | DATS (8) | |
| LIQ_INI_BY | Liquidation Initiated By | CMS_DTE_LIQ_INI_BY | CHAR (6) | |
| APPLN_DATE | Application Date for Enforcement Measure | CMS_DTE_LIQ_APPLN_DATE | DATS (8) | |
| ORDER_DATE | Court’s Order Date | CMS_DTE_LIQ_ORDER_DATE | DATS (8) | |
| ORDER_RCVD_ON | Decision of Order Received On | CMS_DTE_LIQ_ORDER_RCVD_DATE | DATS (8) | |
| CLOSE_DCSN_DATE | Date of Decision of Close | CMS_DTE_LIQ_CLOSE_DCSN_DATE | DATS (8) | |
| CLOSE_DN_RCVD_ON | Decision of Close Received On | CMS_DTE_LIQ_CLOSE_DN_RCVD_DATE | DATS (8) | |
| VAL_GUAR_AMT | Value of Guarantee at Time of Liquidation | CMS_DTE_LIQ_VAL_GUAR_AMOUNT | CURR (17) | |
| VAL_GUAR_CURR | Liquidation guarantee value currency | CMS_DTE_LIQ_VAL_GUAR_CURR | TCURC | CUKY (5) |
| CALL_DATE_GUAR | Calling date for guarantees | CMS_DTE_LIQ_GUAR_CALL_DATE | DATS (8) | |
| ENFC_DATE_GUAR | Date of Enforceable Title for Guarantees | CMS_DTE_LIQ_GUAR_ENFC_DATE | DATS (8) | |
| ENFC_OBTAIN_IND | Enforceable Title Obtained | CMS_DTE_ENFC_TITLE_OBTAIN_FLAG | * | CHAR (2) |
| ENFC_TITLE_DESC | Enforceable title description | CMS_DTE_LIQ_ENFC_DESC | CHAR (40) | |
| AFFIDAVIT_DATE | Date of Affidavit | CMS_DTE_LIQ_AFFDVT_DATE | DATS (8) | |
| AFFIDAVIT_DESC | Affidavit description | CMS_DTE_LIQ_AFFDVT_DESC | CHAR (40) | |
| AMICABLE_DATE | Date of the Amicable Settlement | CMS_DTE_LIQ_AMICABLE_DATE | DATS (8) | |
| AMICABLE_DESC | CMS Liquidation Amicable description | CMS_DTE_LIQ_AMICABLE_DESC | CHAR (40) | |
| OBJ_EXP_PRC_TIME | Expected Time of Proceeds | CMS_DTE_LIQ_OBJ_EXP_PRO_DATE | DATS (8) | |
| OBJ_EXP_PROCEEDS | Expected proceeds after liquidating the object | CMS_DTE_LIQ_OBJ_EXP_PRCD | CURR (17) | |
| OBJ_EXP_PRC_CURR | Currency of the expected proceeds | CMS_DTE_LIQ_OBJ_EXP_PRCD_CURR | * | CUKY (5) |
| REG_DATE | Registration Date | CMS_DTE_LIQ_REG_DATE | DATS (8) | |
| REQ_DATE | Date of Request for Admin. Receivership | CMS_DTE_LIQ_REQ_DATE | DATS (8) | |
| ATTCMT_DATE | Date of Attachment | CMS_DTE_LIQ_ATTCMT_DATE | DATS (8) | |
| TITLE_REQ_BEFORE | Date Before Which the Enforcement Title is Required | CMS_DTE_LIQ_TITLE_REQ_BEF_DATE | DATS (8) | |
| SETTLEMENT_DATE | Date of Out-of-Court Settlement | CMS_DTE_LIQ_SMT_DATE | DATS (8) | |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR (12) | |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC (15) | |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR (12) | |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) | |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR (32) |
