SAP Table CMS_AST_HIST
Asset Value History
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table CMS_AST_HIST (Asset Value History) is a standard table in SAP ERP. It belongs to the package CMS_CORE.
Technical Information
| Table | CMS_AST_HIST |
| Short Text | Asset Value History |
| Package | CMS_CORE |
| Table Type | Transparent Table |
Fields for Table CMS_AST_HIST
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| AST_HIST_GUID | ✔ | Asset history Guid | CMS_DTE_AST_HIST_GUID | RAW | 16 | |
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | RAW | 16 | ||
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | CMS_DTE_SAS_PAR_GUID | RAW | 16 | ||
| NOM_VALUE | Nominal Value of the Asset | CMS_DTE_AST_NOMINAL_VALUE | CURR | 17 | ||
| NOM_VALUE_CURR | Currency of Nominal value | CMS_DTE_AST_NOMINAL_VALUE_CURR | CUKY | 5 | TCURC | |
| AST_VALUE | Final Asset Value | CMS_DTE_AST_VALUE | CURR | 17 | ||
| AST_VALUE_CURR | Currency of the Final Asset Value | CMS_DTE_AST_VALUE_CURR | CUKY | 5 | TCURC | |
| QUANTITY | Quantity | CMS_DTE_QTY | QUAN | 13 | ||
| UNIT_OF_MEASURE | Unit of Measure of Quantity | CMS_DTE_UNIT | UNIT | 3 | T006 | |
| REC_AT | Asset Value Recording Timestamp | CMS_DTE_REC_AT | DEC | 15 | ||
| PUR_PRICE | Purchase Price of the Asset | CMS_DTE_AST_PURCHASE_PRICE | CURR | 17 | ||
| PUR_PRICE_CURR | Currency of Purchase Price | CMS_DTE_AST_PUR_PRICE_CURR | CUKY | 5 | TCURC | |
| PUR_DATE | Date of Purchase | CMS_DTE_AST_PUR_PRICE_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 |