CMS_AST SAP table for – Asset Details

Here we would like to draw your attention to CMS_AST 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 is a SAP standard transp table used for storing Asset Details related data in SAP. It comes under the package CMS_CORE.

SAP CMS_AST table

Table CMS_AST technical data

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

SAP CMS_AST 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 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
    Its a key field.
  • AST_GUID : GUID for Table CMS_AST
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic Key for Table CMS_AST
  • AST_ID : Asset ID
    Its data type is CHAR (Character String) with field length 40
  • AST_TYP : Asset Type
    Its data type is CHAR (Character String) with field length 6
  • .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 : Sub-asset Identification
  • SUBAST_ID : Sub-asset ID
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SUBAST_TYP : Sub-asset Type
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Structure with Asset Details for Table CMS_AST
  • .INCLUDE : Basic Asset data
  • DESCRIPTION : Description
    Its data type is CHAR (Character String) with field length 30
  • OBJECT_REF_ID : Reference ID for the object
    Its data type is CHAR (Character String) with field length 40
  • OBJECT_TYP : Not used
    Its data type is CHAR (Character String) with field length 32
  • COUNTRY_KEY : Identification Key for Country
    Its data type is CHAR (Character String) with field length 3
  • RISK_CODE : Risk Code
    Its data type is CHAR (Character String) with field length 6
  • SFTY_IND : Indicates if the Asset has a Default Safety Discount
    Its data type is CHAR (Character String) with field length 2
  • SFTY_DSCNT : Percentage of Safety Discount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SFTY_AMOUNT : Amount of Safety Discount
    Its data type is CURR (Currency Field) with field length 17
  • SFTY_AMT_CURR : Currency of the Safety Discount Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • OBJSYSID : Object System Reference ID
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Valuation data
  • VALUATION_TYP : Type of Valuation Check performed on Collateral Object
    Its data type is CHAR (Character String) with field length 2
  • UNIT_VALN_FREQ : Indicator: Units of time for revaluation of an asset
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VALN_FREQ : Revaluation Period for an Asset
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PAST_VALUED_DATE : Last Date on which the Asset was Valued
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • START_DATE : Date on which the First Valuation is Performed on the Asset
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_DATE : Date on which the Last Valuation is Performed on the Asset
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Lending rate data
  • LENDING_RATE_IND : Indicator to specify if Asset has a Default Lending Rate
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Lending rates structure
  • LENDING_RATE1 : Lending Rate 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE2 : Lending Rate 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE3 : Lending Rate 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE4 : Lending Rate 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE5 : Lending Rate 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Liquidation rights data
  • LIQD_TYP : Liquidation Type
    Its data type is CHAR (Character String) with field length 6
  • LIQD_REASON : Liquidation Reason
    Its data type is CHAR (Character String) with field length 6
  • LIQD_DATE : Date on which the Collateral was Liquidated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LIQD_AMT : Returns from the Liquidation of Collateral
    Its data type is CURR (Currency Field) with field length 17
  • LIQD_CURR : Currency of Liquidation Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXP_PRCD_AMNT : Expected Proceed Amount
    Its data type is CURR (Currency Field) with field length 17
  • EXP_PRCD_CURR : Currency: Expected Proceed
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXP_ACC_DATE : Expected accrual date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Account for liquidation proceeds
  • ACC_NUMBER_LIQ : Account number for liquidation proceeds
    Its data type is CHAR (Character String) with field length 35
  • BANK_CNTRY_LIQ : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANK_KEY_LIQ : Bank Key
    Its data type is CHAR (Character String) with field length 15
  • BANK_CTRLKEY_LIQ : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Verfication Data
  • UNIT_VERF_FREQ : Indicator: Units of time for verification of an asset
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VERF_FREQ : Statement Period for an Asset
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LAST_VERF_DATE : Last Verification Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .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 : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Organization unit structure: Assets
  • ORG_UNIT1 : Organizational Unit 1 of an Asset
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT2 : Organizational Unit 2 of an Asset
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT3 : Organizational Unit 3 of an Asset
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT4 : Organizational Unit 4 of an Asset
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT5 : Organizational Unit 5 of an Asset
    Its data type is CHAR (Character String) with field length 10
  • .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