CMS_AST_HIST SAP table for – Asset Value History

Here we would like to draw your attention to CMS_AST_HIST table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_AST_HIST is a SAP standard transp table used for storing Asset Value History related data in SAP. It comes under the package CMS_CORE.

SAP CMS_AST_HIST table

Table CMS_AST_HIST technical data

TableCMS_AST_HIST
Data storingAsset Value History
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_AST_HIST Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_AST_HIST table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for CMS_AST_HIST
    Its a key field.
  • AST_HIST_GUID : Asset history Guid
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link to CMS_AST Table
  • AST_GUID : GUID for Table CMS_AST
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Asset Guid as a parent GUID for a sub-asset
  • PARENT_GUID : Asset Guid as a parent GUID for a sub-asset
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Asset values
  • NOM_VALUE : Nominal Value of the Asset
    Its data type is CURR (Currency Field) with field length 17
  • NOM_VALUE_CURR : Currency of Nominal value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AST_VALUE : Final Asset Value
    Its data type is CURR (Currency Field) with field length 17
  • AST_VALUE_CURR : Currency of the Final Asset Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • QUANTITY : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • UNIT_OF_MEASURE : Unit of Measure of Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • REC_AT : Asset Value Recording Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Purchase price data
  • PUR_PRICE : Purchase Price of the Asset
    Its data type is CURR (Currency Field) with field length 17
  • PUR_PRICE_CURR : Currency of Purchase Price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PUR_DATE : Date of Purchase
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32