CMS_RE_PRT_ACS

Real Estate Part accessory details | #masterdata | Component: Real Estate
Column Name Description
MANDT Client
PRT_ACS_GUID GUID for part accessory
Column Name Description
💲 Currency for Value of the accessory (ACS_VALUE_CURR):
ACS_VALUE Value of the Accessory
💲 Currency of the Safety discount amount (SFTY_AMT_CURR):
SFTY_AMOUNT Safety discount as an amount
Column Name Description
Column Name Description
PAST_VALUED_DATE Most Recent Date on which the Real Estate was last Valued
START_DATE Revaluation Start date
END_DATE End date for Revaluation of the Real Estate
CREATED_DATE Created On
CREATED_TIME Created At
LAST_CHG_DATE Last Changed On
LAST_CHG_TIME Last Changed At
Column Name Description
IS_SUB_AST_CREA Indicates whether a Sub-asset is created for Building Part Show values
SFTY_IND Indicates that the asset has a default sfty discount or not Show values
SFTY_DSCNT Safety discount Show values
VALUATION_TYP Type of Check conducted on the object Show values
UNIT_VALN_FREQ Indicator : Valuation Period Show values
LENDING_RATE_IND Indicates that the asset has a default lending rate or not Show values
Column Name Description Domain name
OBJ_PRT_GUID GUID for Object part SYSUUID
PART_ID Part ID for the Object CMS_RE_PRT_ID
NO_OF_ACS No of Accessory Units CMS_RE_UNITS
ACS_DESC Description of the cost CMS_RE_DESC
ACS_ID Sequence Number of Accessory or Special Equipment CMS_ACS_ID
PERIOD_VALN_FREQ Period of revaluation for a real estate CMS_RE_VALN_FREQ_PERIOD
LENDING_RATE1 Lending rate 1 CMS_PCT
LENDING_RATE2 Lending rate 2 CMS_PCT
LENDING_RATE3 Lending rate 3 CMS_PCT
LENDING_RATE4 Lending rate 4 CMS_PCT
LENDING_RATE5 Lending rate 5 CMS_PCT
CREATED_BY Real Estate Add-On User CMS_RE_USER
ENTRY_SRC Sorce of Initial entry CMS_RE_SOURCE
LAST_CHG_BY Last Changed By CMS_RE_USER
PROCESSING_SRC Processing Source CMS_RE_SOURCE
Master Data Relations Join Conditions
Acs type Foreign key
  • ?
  • Client
  • Accessory Type
Foreign key for Currency
  • CMS_RE_PRT_ACS.MANDT == TCURC.MANDT
  • CMS_RE_PRT_ACS.ACS_VALUE_CURR == TCURC.WAERS
Risk Code
  • Risk Code
  • Client
Currency of the Safety discount amount
  • CMS_RE_PRT_ACS.MANDT == TCURC.MANDT
  • CMS_RE_PRT_ACS.SFTY_AMT_CURR == TCURC.WAERS