CMS_RE_STR_RE_AST_DATA_DB SAP (RE DB Asset Details - not used) Structure details

Dictionary Type: Structure
Description: RE DB Asset Details - not used




ABAP Code to SELECT data from CMS_RE_STR_RE_AST_DATA_DB
Related tables to CMS_RE_STR_RE_AST_DATA_DB
Access table CMS_RE_STR_RE_AST_DATA_DB




Structure field list including key, data, relationships and ABAP select examples

CMS_RE_STR_RE_AST_DATA_DB 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 "RE DB Asset Details - not used" 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_RE_STR_RE_AST_DATA_DB TYPE CMS_RE_STR_RE_AST_DATA_DB.

The CMS_RE_STR_RE_AST_DATA_DB table consists of various fields, each holding specific information or linking keys about RE DB Asset Details - not used data available in SAP. These include RISK_CODE (Risk Code), SFTY_IND (Indicates that the asset has a default sfty discount or not), SFTY_DSCNT (Safety discount), SFTY_AMOUNT (Safety discount as an amount).. 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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
RISK_CODERisk Code CMS_RE_DTE_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_RE_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_RE_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_RE_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_RE_DTE_SAFETY_AMT_CURRCUKY5TCURCWAERS
VALUATION_TYPType of Check conducted on the object CMS_RE_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator : Valuation Period CMS_RE_DTE_IND_FREQUENCYCHAR2CMS_RE_IND_FREQUENCY
PERIOD_VALN_FREQPeriod of revaluation for a real estate CMS_RE_DTE_VALN_FREQ_PERIODNUMC4CMS_RE_VALN_FREQ_PERIOD
PAST_VALUED_DATEMost Recent Date on which the Real Estate was last Valued CMS_RE_DTE_VALN_DATEDATS8CMS_DATE
START_DATERevaluation Start date CMS_RE_DTE_START_DATEDATS8CMS_DATE
END_DATEEnd date for Revaluation of the Real Estate CMS_RE_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_RE_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_RE_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending rate 2 CMS_RE_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending rate 3 CMS_RE_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending rate 4 CMS_RE_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending rate 5 CMS_RE_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation type CMS_RE_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate of Liquidation of Collateral CMS_RE_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTProceeds obtained from liquidation of the collateral CMS_RE_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation value CMS_RE_DTE_LIQD_CURRCUKY5TCURCWAERS
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_RE_STR_RE_AST_DATA_DB using ABAP code?

As CMS_RE_STR_RE_AST_DATA_DB 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_RE_STR_RE_AST_DATA_DB as there is no data to select.

How to access SAP table CMS_RE_STR_RE_AST_DATA_DB

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!