dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table CMS_AST

Asset Details

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table CMS_AST (Asset Details) is a standard table in SAP ERP. It belongs to the package CMS_CORE.

Technical Information

Table CMS_AST
Short Text Asset Details
Package CMS_CORE
Table Type Transparent Table

Fields for Table CMS_AST

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
AST_GUID ✔ GUID for Table CMS_AST CMS_DTE_AST_GUID RAW 16
AST_ID Asset ID CMS_DTE_AST_ID CHAR 40
AST_TYP Asset Type CMS_DTE_AST_TYP CHAR 6 TCMS_AST_TYP
PARENT_GUID Asset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUID RAW 16
SUBAST_ID Sub-asset ID CMS_DTE_SAS_ID NUMC 4
SUBAST_TYP Sub-asset Type CMS_DTE_SAS_TYP CHAR 6
DESCRIPTION Description CMS_DTE_AST_DESC CHAR 30
OBJECT_REF_ID Reference ID for the object CMS_DTE_OBJ_REFID CHAR 40
OBJECT_TYP Not used CMS_DTE_OBJ_TYP CHAR 32
COUNTRY_KEY Identification Key for Country CMS_DTE_AST_COUNTRY_KEY CHAR 3 T005
RISK_CODE Risk Code CMS_DTE_RISK_CODE CHAR 6 *
SFTY_IND Indicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISC CHAR 2
SFTY_DSCNT Percentage of Safety Discount CMS_DTE_SAFETY_DSCNT DEC 10
SFTY_AMOUNT Amount of Safety Discount CMS_DTE_SAFETY_AMT CURR 17
SFTY_AMT_CURR Currency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURR CUKY 5 TCURC
OBJSYSID Object System Reference ID CMS_DTE_OBJ_SYSID CHAR 6
VALUATION_TYP Type of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYP CHAR 2
UNIT_VALN_FREQ Indicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNIT CHAR 2
PERIOD_VALN_FREQ Revaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIOD NUMC 4
PAST_VALUED_DATE Last Date on which the Asset was Valued CMS_DTE_VALN_DATE DATS 8
START_DATE Date on which the First Valuation is Performed on the Asset CMS_DTE_START_DATE DATS 8
END_DATE Date on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATE DATS 8
LENDING_RATE_IND Indicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTE CHAR 2
LENDING_RATE1 Lending Rate 1 CMS_DTE_LRTE_PCT1 DEC 10
LENDING_RATE2 Lending Rate 2 CMS_DTE_LRTE_PCT2 DEC 10
LENDING_RATE3 Lending Rate 3 CMS_DTE_LRTE_PCT3 DEC 10
LENDING_RATE4 Lending Rate 4 CMS_DTE_LRTE_PCT4 DEC 10
LENDING_RATE5 Lending Rate 5 CMS_DTE_LRTE_PCT5 DEC 10
LIQD_TYP Liquidation Type CMS_DTE_LIQD_TYP CHAR 6 TCMS_AST_LTYP
LIQD_REASON Liquidation Reason CMS_DTE_ATT_ID_TY_AST004 CHAR 6 TCMS_ATT_ID_TY
LIQD_DATE Date on which the Collateral was Liquidated CMS_DTE_LIQD_DATE DATS 8
LIQD_AMT Returns from the Liquidation of Collateral CMS_DTE_LIQD_VALUE CURR 17
LIQD_CURR Currency of Liquidation Value CMS_DTE_LIQD_CURR CUKY 5 TCURC
EXP_PRCD_AMNT Expected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNT CURR 17
EXP_PRCD_CURR Currency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURR CUKY 5 TCURC
EXP_ACC_DATE Expected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATE DATS 8
ACC_NUMBER_LIQ Account number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBER CHAR 35
BANK_CNTRY_LIQ Bank country key CMS_DTE_LIQ_BNK_CTRY_KY CHAR 3 T005
BANK_KEY_LIQ Bank Key CMS_DTE_LIQ_BNK_KEY CHAR 15
BANK_CTRLKEY_LIQ Bank Control Key BKONT CHAR 2
UNIT_VERF_FREQ Indicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNIT CHAR 2
PERIOD_VERF_FREQ Statement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIOD NUMC 4
LAST_VERF_DATE Last Verification Date CMS_DTE_AST_VERF_DATE DATS 8
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
ADMIN_ORG_UNIT Administration Organizational Unit CMS_DTE_ADMINORG CHAR 12
BANKAREA Bank Area in Collateral Management CMS_DTE_BANKAREA CHAR 4 *
ORG_UNIT1 Organizational Unit 1 of an Asset CMS_DTE_AST_ORG_UNIT1 CHAR 10 *
ORG_UNIT2 Organizational Unit 2 of an Asset CMS_DTE_AST_ORG_UNIT2 CHAR 10 *
ORG_UNIT3 Organizational Unit 3 of an Asset CMS_DTE_AST_ORG_UNIT3 CHAR 10 *
ORG_UNIT4 Organizational Unit 4 of an Asset CMS_DTE_AST_ORG_UNIT4 CHAR 10 *
ORG_UNIT5 Organizational Unit 5 of an Asset CMS_DTE_AST_ORG_UNIT5 CHAR 10 *
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