SAP CMS_STR_DEV_DATA_GET Table in S/4 HANA - Devices GET data - API Layer
CMS_STR_DEV_DATA_GET is a standard SAP Table which is used to store Devices GET data - API Layer data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the CMS_STR_DEV_DATA_GET table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: CMS_STR_DEV_DATA_GET
CMS_STR_DEV_DATA_GET table structure field list
Below is the full CMS_STR_DEV_DATA_GET field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MOV_GUID | GUID for CMS_MOVABLES | CMS_DTE_MOV_GUID | RAW | 16(0) | SYSUUID | CMS_MOV_OBJ_GUID | ||||
| MOV_CATEGORY | Object Category | CMS_DTE_OMS_OBJ_CAT | CHAR | 6(0) | TCMS_MOV_TYP | CMS_OBJ_CAT | CMS_OBJ_CAT | CATEGORYID | ||
| MOV_TYP | Movable types | CMS_DTE_MOV_TYP | CHAR | 6(0) | TCMS_MOV_TYP | CMS_MOV_TYP | ||||
| MOV_ID | Identification Number | CMS_DTE_MOV_ID | CHAR | 40(0) | ALPHA | CMS_MOV_ID | CMS_SRCH_ACR | MOV_ID | ||
| MOV_DESC | Description of the object | CMS_DTE_MOV_DESC | CHAR | 30(0) | CMS_MOV_DESC | |||||
| MOV_IDT_ACC | Identification accessories | CMS_DTE_MOV_IDT_ACC | CHAR | 1(0) | CMS_MOV_IDT_ACC | |||||
| MOV_MODEL_NAM | Technical Category/Category term/Description | CMS_DTE_MOV_MODEL_NAM | CHAR | 30(0) | CMS_MOV_MODEL_NAM | |||||
| MOV_MANUFACTURER | Object Manufacturer Builder | CMS_DTE_MOV_MANUFACTURER | CHAR | 30(0) | CMS_MOV_MANUFACTURER | |||||
| MOV_MANU_DAT | Date of the Manufacture/Purchase | CMS_DTE_MOV_MANU_DAT | DATS | 8(0) | CMS_MOV_MANU_DAT | |||||
| ADDR_ID | Location / Address | CMS_DTE_MOV_LOCATION | CHAR | 10(0) | ALPHA | AD_ADDRNUM | ADMC | ADDRNUMBER | ||
| MOV_LOC_DESC | Location Description | CMS_DTE_MOV_LOC_DESC | CHAR | 6(0) | TCMS_ATT_ID_TY | CMS_ATT_ID_TYP | ||||
| MOV_LOC_DE_RMRK | Remark Field for Location Description | CMS_DTE_MOV_LOC_DESC_RMRK | CHAR | 30(0) | CMS_MOV_LOC_DESC_RMRK | |||||
| MOV_IDEN_TYP | Type of identification / Marking of the collateral material | CMS_DTE_MOV_TYPE_IDENT | CHAR | 6(0) | TCMS_ATT_ID_TY | CMS_ATT_ID_TYP | ||||
| MOV_DESC_COL_MAT | Bank's Own Identifcation | CMS_DTE_OMS_DESC_IDENT_COL_MAT | CHAR | 30(0) | CMS_OMS_DESC_COL_MAT | |||||
| MOV_DOP | Date of Purchase | CMS_DTE_MOV_DOP | DATS | 8(0) | CMS_MOV_DOP | |||||
| MOV_IDENT | Commercial usage | CMS_DTE_MOV_IDENT | CHAR | 2(0) | CMS_MOV_IDENT | |||||
| MOV_UOB | Use of the object | CMS_DTE_MOV_UOB | CHAR | 6(0) | TCMS_ATT_ID_TY | CMS_ATT_ID_TYP | ||||
| MOV_MANU_CNTRY | Manufacturing Country | CMS_DTE_MOV_MANU_CNTRY | CHAR | 3(0) | T005 | LAND1 | ||||
| MOV_TYPE_FEAT | Classification | CMS_DTE_MOV_TYPE_FEAT | CHAR | 6(0) | TCMS_OMS_FEAT | CMS_MOV_TYPE_FEAT | ||||
| EXT_ITM_NO | Ext. Item no / Number for identification of the objects | CMS_DTE_OMS_EXT_ITM_NO | CHAR | 40(0) | ALPHA | CMS_OMS_ID | ||||
| EXT_REFERENCE | Reference number for the legacy system | CMS_DTE_OMS_REF_ID | CHAR | 32(0) | CMS_OMS_REFID | |||||
| IS_TEMPLATE | Type to be used as template | CMS_DTE_MOV_FLG_TEMPLATE | CHAR | 1(0) | CMS_MOV_FLG | |||||
| TEMPLATE_ID | Template ID | CMS_DTE_MOV_TEMPLATE_ID | RAW | 16(0) | SYSUUID | |||||
| DEV_COUNTRY_KEY | Country Key | CMS_DTE_MOV_COUNTRY_KEY | CHAR | 3(0) | T005 | LAND1 | ||||
| DEV_MAC_NO | External Item Number - Machine number | CMS_DTE_MOV_MACHINE_NO | CHAR | 40(0) | ALPHA | CMS_MOV_ID | ||||
| DESCRIPTION | Description | CMS_DTE_AST_DESC | CHAR | 30(0) | CMS_DSC | |||||
| OBJECT_REF_ID | Reference ID for the object | CMS_DTE_OBJ_REFID | CHAR | 40(0) | CMS_OBJ_REFID | |||||
| OBJECT_TYP | Not used | CMS_DTE_OBJ_TYP | CHAR | 32(0) | CMS_OBJ_TYP | |||||
| COUNTRY_KEY | Identification Key for Country | CMS_DTE_AST_COUNTRY_KEY | CHAR | 3(0) | Assigned to domain | LAND1 | ||||
| RISK_CODE | Risk Code | CMS_DTE_RISK_CODE | CHAR | 6(0) | Assigned to domain | CMS_RISK_CODE | ||||
| SFTY_IND | Indicates if the Asset has a Default Safety Discount | CMS_DTE_IND_SFTY_DISC | CHAR | 2(0) | CMS_IND_SFTY | |||||
| SFTY_DSCNT | Percentage of Safety Discount | CMS_DTE_SAFETY_DSCNT | DEC | 10(6) | CMS_SFTY_PCT | |||||
| SFTY_AMOUNT | Amount of Safety Discount | CMS_DTE_SAFETY_AMT | CURR | 17(2) | CMS_AMOUNT | |||||
| SFTY_AMT_CURR | Currency of the Safety Discount Amount | CMS_DTE_SAFETY_AMT_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| OBJSYSID | Object System Reference ID | CMS_DTE_OBJ_SYSID | CHAR | 6(0) | CMS_SYS | CMS_OBJSYSTEMID | CMS_OBJ_SYS | OBJSYSTEMID | ||
| VALUATION_TYP | Type of Valuation Check performed on Collateral Object | CMS_DTE_IND_VALN_TYP | CHAR | 2(0) | CMS_VALN_TYP | |||||
| UNIT_VALN_FREQ | Indicator: Units of time for revaluation of an asset | CMS_DTE_IND_AST_VALN_FREQ_UNIT | CHAR | 2(0) | CMS_IND_AST_VALN_FREQ_UNIT | |||||
| PERIOD_VALN_FREQ | Revaluation Period for an Asset | CMS_DTE_AST_VALN_FREQ_PERIOD | NUMC | 4(0) | CMS_AST_VALN_FREQ_PERIOD | |||||
| PAST_VALUED_DATE | Last Date on which the Asset was Valued | CMS_DTE_VALN_DATE | DATS | 8(0) | CMS_DATE | |||||
| START_DATE | Date on which the First Valuation is Performed on the Asset | CMS_DTE_START_DATE | DATS | 8(0) | CMS_DATE | |||||
| END_DATE | Date on which the Last Valuation is Performed on the Asset | CMS_DTE_END_DATE | DATS | 8(0) | CMS_DATE | |||||
| LENDING_RATE_IND | Indicator to specify if Asset has a Default Lending Rate | CMS_DTE_IND_LND_RTE | CHAR | 2(0) | CMS_IND_LRTE | |||||
| LENDING_RATE1 | Lending Rate 1 | CMS_DTE_LRTE_PCT1 | DEC | 10(6) | CMS_PCT | |||||
| LENDING_RATE2 | Lending Rate 2 | CMS_DTE_LRTE_PCT2 | DEC | 10(6) | CMS_PCT | |||||
| LENDING_RATE3 | Lending Rate 3 | CMS_DTE_LRTE_PCT3 | DEC | 10(6) | CMS_PCT | |||||
| LENDING_RATE4 | Lending Rate 4 | CMS_DTE_LRTE_PCT4 | DEC | 10(6) | CMS_PCT | |||||
| LENDING_RATE5 | Lending Rate 5 | CMS_DTE_LRTE_PCT5 | DEC | 10(6) | CMS_PCT | |||||
| LIQD_TYP | Liquidation Type | CMS_DTE_LIQD_TYP | CHAR | 6(0) | CMS_TYP | CMS_AST_LIQTYP | LIQD_TYP | |||
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CHAR | 6(0) | TCMS_ATT_ID_TY | CMS_ATT_ID_TYP | ||||
| LIQD_DATE | Date on which the Collateral was Liquidated | CMS_DTE_LIQD_DATE | DATS | 8(0) | CMS_DATE | |||||
| LIQD_AMT | Returns from the Liquidation of Collateral | CMS_DTE_LIQD_VALUE | CURR | 17(2) | CMS_AMOUNT | |||||
| LIQD_CURR | Currency of Liquidation Value | CMS_DTE_LIQD_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| EXP_PRCD_AMNT | Expected Proceed Amount | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CURR | 17(2) | CMS_AMOUNT | |||||
| EXP_PRCD_CURR | Currency: Expected Proceed | CMS_DTE_LIQ_EXP_PRCD_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| EXP_ACC_DATE | Expected accrual date | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | DATS | 8(0) | CMS_DATE | |||||
| OBJ_EXP_PRC_TIME | Expected Time of Proceeds | CMS_DTE_LIQ_OBJ_EXP_PRO_DATE | DATS | 8(0) | DATS | |||||
| ACC_NUMBER_LIQ | Account number for liquidation proceeds | CMS_DTE_LIQ_ACC_NUMBER | CHAR | 35(0) | BANKN35 | |||||
| BANK_CNTRY_LIQ | Bank country key | CMS_DTE_LIQ_BNK_CTRY_KY | CHAR | 3(0) | T005 | LAND1 | ||||
| BANK_KEY_LIQ | Bank Key | CMS_DTE_LIQ_BNK_KEY | CHAR | 15(0) | BANKK | BNK | ||||
| BANK_CTRLKEY_LIQ | Bank Control Key | BKONT | CHAR | 2(0) | BKONT | |||||
| UNIT_VERF_FREQ | Indicator: Units of time for verification of an asset | CMS_DTE_IND_AST_VERF_FREQ_UNIT | CHAR | 2(0) | CMS_IND_AST_VERF_FREQ_UNIT | |||||
| PERIOD_VERF_FREQ | Statement Period for an Asset | CMS_DTE_AST_VERF_FREQ_PERIOD | NUMC | 4(0) | CMS_AST_VERF_FREQ_PERIOD | |||||
| LAST_VERF_DATE | Last Verification Date | CMS_DTE_AST_VERF_DATE | DATS | 8(0) | CMS_DATE | |||||
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | RAW | 16(0) | SYSUUID | |||||
| AST_TYP | Asset Type | CMS_DTE_AST_TYP | CHAR | 6(0) | CMS_AST_TYP | CMS_AST_TYP | CMS_AST_TYP | AST_TYP | ||
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | CMS_DTE_SAS_PAR_GUID | RAW | 16(0) | SYSUUID | |||||
| NOM_VALUE | Nominal Value of the Asset | CMS_DTE_AST_NOMINAL_VALUE | CURR | 17(2) | CMS_AMOUNT | |||||
| NOM_VALUE_CURR | Currency of Nominal value | CMS_DTE_AST_NOMINAL_VALUE_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| AST_VALUE | Final Asset Value | CMS_DTE_AST_VALUE | CURR | 17(2) | CMS_AMOUNT | |||||
| AST_VALUE_CURR | Currency of the Final Asset Value | CMS_DTE_AST_VALUE_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| QUANTITY | Quantity | CMS_DTE_QTY | QUAN | 13(3) | CMS_QTY | |||||
| UNIT_OF_MEASURE | Unit of Measure of Quantity | CMS_DTE_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| REC_AT | Asset Value Recording Timestamp | CMS_DTE_REC_AT | DEC | 15(0) | TZNTSTMPS | |||||
| PUR_PRICE | Purchase Price of the Asset | CMS_DTE_AST_PURCHASE_PRICE | CURR | 17(2) | CMS_AMOUNT | |||||
| PUR_PRICE_CURR | Currency of Purchase Price | CMS_DTE_AST_PUR_PRICE_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| PUR_DATE | Date of Purchase | CMS_DTE_AST_PUR_PRICE_DATE | DATS | 8(0) | CMS_DATE | |||||
| ORI_VALUE | Original Protection of the Asset | CMS_DTE_AST_ORIGINAL_VALUE | CURR | 17(2) | CMS_AMOUNT | |||||
| ORI_VALUE_CURR | Currency of the Original Protection Value | CMS_DTE_ORI_VALUE_CURR | CUKY | 5(0) | TCURC | WAERS | ||||
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR | 12(0) | TEXT12 | CMS_ADMINORG | ||||
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CHAR | 4(0) | Assigned to domain | CMS_BANKAREA | CMS_BANKAREA | |||
| ORG_UNIT1 | Organizational Unit 1 | CMS_DTE_ORG_UNIT1 | CHAR | 10(0) | Assigned to domain | CMS_ORG_UNIT | ||||
| ORG_UNIT2 | Organizational Unit 2 | CMS_DTE_ORG_UNIT2 | CHAR | 10(0) | Assigned to domain | CMS_ORG_UNIT | ||||
| ORG_UNIT3 | Organizational Unit 3 | CMS_DTE_ORG_UNIT3 | CHAR | 10(0) | Assigned to domain | CMS_ORG_UNIT | ||||
| ORG_UNIT4 | Organizational Unit 4 | CMS_DTE_ORG_UNIT4 | CHAR | 10(0) | Assigned to domain | CMS_ORG_UNIT | ||||
| ORG_UNIT5 | Organizational Unit 5 | CMS_DTE_ORG_UNIT5 | CHAR | 10(0) | Assigned to domain | CMS_ORG_UNIT | ||||
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 12(0) | CMS_USER | |||||
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 15(0) | TZNTSTMPS | |||||
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 12(0) | CMS_USER | |||||
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 15(0) | TZNTSTMPS | |||||
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 32(0) | CMS_SOURCE | |||||
| BUPR_ID | Business Process ID | CMS_DTE_BUPR_ID | RAW | 16(0) | SYSUUID | |||||
| BUPR_TYPE_CODE | Business Process Type Code | CMS_DTE_BUPR_TYP_CODE | CHAR | 6(0) | CMS_BUPR_TYP_CODE | CMS_SH_BUPR_TYPE_CODE | BUPR_TYPE_CODE |
Search for further information about these or an SAP related objects