SAP CMS_STR_AST_DATA Structure with Asset Details for Table CMS_AST Table data and field list

CMS_STR_AST_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure with Asset Details for Table CMS_AST" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_AST_DATA TYPE CMS_STR_AST_DATA.

The CMS_STR_AST_DATA table consists of various fields, each holding specific information or linking keys about Structure with Asset Details for Table CMS_AST data available in SAP. These include DESCRIPTION (Description), OBJECT_REF_ID (Reference ID for the object), OBJECT_TYP (Not used), COUNTRY_KEY (Identification Key for Country)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_STR_AST_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_STR_AST_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_STR_AST_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3Assigned to domainLAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5TCURCWAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5TCURCWAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5TCURCWAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3T005LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_AST_DATA using ABAP code?

As CMS_STR_AST_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_AST_DATA as there is no data to select.

How to access SAP table CMS_STR_AST_DATA

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_AST_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).