CMS_RE_PRT_ACS - Real Estate Part accessory details
Real Estate Part accessory details information is stored in SAP table CMS_RE_PRT_ACS.
It is part of development package CMS_RE in software component FS-CMS-MD-RE. This development package consists of objects that can be grouped under "Collateral Management System: Real Esate".
It is part of development package CMS_RE in software component FS-CMS-MD-RE. This development package consists of objects that can be grouped under "Collateral Management System: Real Esate".
Fields for table CMS_RE_PRT_ACS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
.INCLUDE | X | CMS_RE_STR_PRT_ACS_PKY | 0 | |||
PRT_ACS_GUID | GUID for part accessory | X | CMS_RE_DTE_PRT_ACS_GUID | RAW | 16 | |
.INCLUDE | CMS_RE_STR_OBJ_PRT_LKY | 0 | ||||
OBJ_PRT_GUID | GUID for Object part | CMS_RE_DTE_OBJ_PRT_GUID | RAW | 16 | ||
.INCLUDE | CMS_RE_STR_PRT_SKY | 0 | ||||
PART_ID | Part ID for the Object | CMS_RE_DTE_PART_ID | NUMC | 20 | ||
.INCLUDE | CMS_RE_STR_OBJ_ACS_DATA | 0 | ||||
ACS_TYPE | Accessory Type | CMS_RE_DTE_ATT_ID_TY_REO010 | CHAR | 12 | TCMS_ATT_ID_TY | |
NO_OF_ACS | No of Accessory Units | CMS_RE_DTE_NO_OF_ACS | INT4 | 4 | ||
ACS_VALUE | Value of the Accessory | CMS_RE_DTE_ACS_VALUE | CURR | 9 | ||
ACS_VALUE_CURR | Currency for Value of the accessory | CMS_RE_DTE_ACS_VALUE_CURR | CUKY | 10 | TCURC | |
IS_SUB_AST_CREA | Indicates whether a Sub-asset is created for Building Part | CMS_RE_DTE_CREATE_SUB_AST_FLG | CHAR | 2 | ||
ACS_DESC | Description of the cost | CMS_RE_DTE_CST_DESC | CHAR | 60 | ||
ACS_ID | Sequence Number of Accessory or Special Equipment | CMS_RE_DTE_ACS_ID | NUMC | 8 | ||
.INCLUDE | BASIC_ASSET_DATA | CMS_RE_STR_RE_AST_BASIC_DATA | 0 | |||
RISK_CODE | Risk Code | CMS_RE_DTE_RISK_CODE | CHAR | 12 | TCMS_RISKCODE | |
SFTY_IND | Indicates that the asset has a default sfty discount or not | CMS_RE_DTE_IND_SFTY_DISC | CHAR | 4 | ||
SFTY_DSCNT | Safety discount | CMS_RE_DTE_SAFETY_DSCNT | DEC | 6 | ||
SFTY_AMOUNT | Safety discount as an amount | CMS_RE_DTE_SAFETY_AMT | CURR | 9 | ||
SFTY_AMT_CURR | Currency of the Safety discount amount | CMS_RE_DTE_SAFETY_AMT_CURR | CUKY | 10 | TCURC | |
.INCLUDE | BASIC_VALUATION_DATA | CMS_RE_STR_VALUATION_DATA | 0 | |||
VALUATION_TYP | Type of Check conducted on the object | CMS_RE_DTE_IND_VALN_TYP | CHAR | 4 | ||
UNIT_VALN_FREQ | Indicator : Valuation Period | CMS_RE_DTE_IND_FREQUENCY | CHAR | 4 | ||
PERIOD_VALN_FREQ | Period of revaluation for a real estate | CMS_RE_DTE_VALN_FREQ_PERIOD | NUMC | 8 | ||
PAST_VALUED_DATE | Most Recent Date on which the Real Estate was last Valued | CMS_RE_DTE_VALN_DATE | DATS | 16 | ||
START_DATE | Revaluation Start date | CMS_RE_DTE_START_DATE | DATS | 16 | ||
END_DATE | End date for Revaluation of the Real Estate | CMS_RE_DTE_END_DATE | DATS | 16 | ||
.INCLUDE | LENDING_RATES | CMS_RE_STR_LND_RTE_DATA | 0 | |||
LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | CMS_RE_DTE_IND_LND_RTE | CHAR | 4 | ||
.INCLUDE | LENDING_RATE | CMS_RE_STR_LENDING_RATE | 0 | |||
LENDING_RATE1 | Lending rate 1 | CMS_RE_DTE_LRTE_PCT1 | DEC | 6 | ||
LENDING_RATE2 | Lending rate 2 | CMS_RE_DTE_LRTE_PCT2 | DEC | 6 | ||
LENDING_RATE3 | Lending rate 3 | CMS_RE_DTE_LRTE_PCT3 | DEC | 6 | ||
LENDING_RATE4 | Lending rate 4 | CMS_RE_DTE_LRTE_PCT4 | DEC | 6 | ||
LENDING_RATE5 | Lending rate 5 | CMS_RE_DTE_LRTE_PCT5 | DEC | 6 | ||
.INCLUDE | CMS_RE_STR_HIST | 0 | ||||
CREATED_BY | Real Estate Add-On User | CMS_RE_DTE_CR_BY | CHAR | 24 | ||
CREATED_DATE | Created On | CMS_RE_DTE_CR_ON | DATS | 16 | ||
CREATED_TIME | Created At | CMS_RE_DTE_CR_AT | TIMS | 12 | ||
ENTRY_SRC | Sorce of Initial entry | CMS_RE_DTE_SRC_INIT | CHAR | 64 | ||
LAST_CHG_BY | Last Changed By | CMS_RE_DTE_CHG_BY | CHAR | 24 | ||
LAST_CHG_DATE | Last Changed On | CMS_RE_DTE_CHG_ON | DATS | 16 | ||
LAST_CHG_TIME | Last Changed At | CMS_RE_DTE_CHG_AT | TIMS | 12 | ||
PROCESSING_SRC | Processing Source | CMS_RE_DTE_PRC_SRC | CHAR | 64 | ||
.INCLUDE | CI_CMS_RE_STR_OBJ_ACS_OTHERS | 0 |