CMS_AST_HIST - Asset Value History
Asset Value History information is stored in SAP table CMS_AST_HIST.
It is part of development package CMS_CORE in software component FS-CMS-MD. This development package consists of objects that can be grouped under "Collateral Management System".
It is part of development package CMS_CORE in software component FS-CMS-MD. This development package consists of objects that can be grouped under "Collateral Management System".
Fields for table CMS_AST_HIST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | X | CMS_STR_AST_HIST_PKY | 0 | |||
| AST_HIST_GUID | Asset history Guid | X | CMS_DTE_AST_HIST_GUID | RAW | 16 | |
| .INCLUDE | CMS_STR_AST_LKY | 0 | ||||
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | RAW | 16 | ||
| .INCLUDE | CMS_STR_SAS_PAR_GUID | 0 | ||||
| PARENT_GUID | Asset Guid as a parent GUID for a sub-asset | CMS_DTE_SAS_PAR_GUID | RAW | 16 | ||
| .INCLUDE | CMS_STR_AST_VALUE | 0 | ||||
| NOM_VALUE | Nominal Value of the Asset | CMS_DTE_AST_NOMINAL_VALUE | CURR | 9 | ||
| NOM_VALUE_CURR | Currency of Nominal value | CMS_DTE_AST_NOMINAL_VALUE_CURR | CUKY | 10 | TCURC | |
| AST_VALUE | Final Asset Value | CMS_DTE_AST_VALUE | CURR | 9 | ||
| AST_VALUE_CURR | Currency of the Final Asset Value | CMS_DTE_AST_VALUE_CURR | CUKY | 10 | TCURC | |
| QUANTITY | Quantity | CMS_DTE_QTY | QUAN | 7 | ||
| UNIT_OF_MEASURE | Unit of Measure of Quantity | CMS_DTE_UNIT | UNIT | 6 | T006 | |
| REC_AT | Asset Value Recording Timestamp | CMS_DTE_REC_AT | DEC | 8 | ||
| .INCLUDE | PURCHASE_PRICE_DATA | CMS_STR_AST_PUR_PRICE_DATA | 0 | |||
| PUR_PRICE | Purchase Price of the Asset | CMS_DTE_AST_PURCHASE_PRICE | CURR | 9 | ||
| PUR_PRICE_CURR | Currency of Purchase Price | CMS_DTE_AST_PUR_PRICE_CURR | CUKY | 10 | TCURC | |
| PUR_DATE | Date of Purchase | CMS_DTE_AST_PUR_PRICE_DATE | DATS | 16 | ||
| ORI_VALUE | Original Protection of the Asset | CMS_DTE_AST_ORIGINAL_VALUE | CURR | 9 | ||
| ORI_VALUE_CURR | Currency of the Original Protection Value | CMS_DTE_ORI_VALUE_CURR | CUKY | 10 | TCURC | |
| .INCLUDE | CHG_HISTORY | CMS_STR_CHG_HISTORY | 0 | |||
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 24 | ||
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 8 | ||
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 24 | ||
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 8 | ||
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 64 |