CMS_RE_PRT_ACS SAP table for – Real Estate Part accessory details

Here we would like to draw your attention to CMS_RE_PRT_ACS table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_RE_PRT_ACS is a SAP standard transp table used for storing Real Estate Part accessory details related data in SAP. It comes under the package CMS_RE.

SAP CMS_RE_PRT_ACS table

Table CMS_RE_PRT_ACS technical data

TableCMS_RE_PRT_ACS
Data storingReal Estate Part accessory details
ModuleFS
Sub ModuleFS-CMS-MD-RE
SAP PackageCMS_RE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_RE_PRT_ACS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_RE_PRT_ACS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for Part accessory
    Its a key field.
  • PRT_ACS_GUID : GUID for part accessory
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for Object parts
  • OBJ_PRT_GUID : GUID for Object part
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Part ID
  • PART_ID : Part ID for the Object
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Structure for Accessory Type
  • ACS_TYPE : Accessory Type
    Its data type is CHAR (Character String) with field length 6
  • NO_OF_ACS : No of Accessory Units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ACS_VALUE : Value of the Accessory
    Its data type is CURR (Currency Field) with field length 17
  • ACS_VALUE_CURR : Currency for Value of the accessory
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • IS_SUB_AST_CREA : Indicates whether a Sub-asset is created for Building Part
    Its data type is CHAR (Character String) with field length 1
  • ACS_DESC : Description of the cost
    Its data type is CHAR (Character String) with field length 30
  • ACS_ID : Sequence Number of Accessory or Special Equipment
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Basic Asset data
  • RISK_CODE : Risk Code
    Its data type is CHAR (Character String) with field length 6
  • SFTY_IND : Indicates that the asset has a default sfty discount or not
    Its data type is CHAR (Character String) with field length 2
  • SFTY_DSCNT : Safety discount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SFTY_AMOUNT : Safety discount as an amount
    Its data type is CURR (Currency Field) with field length 17
  • SFTY_AMT_CURR : Currency of the Safety discount amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Valuation data
  • VALUATION_TYP : Type of Check conducted on the object
    Its data type is CHAR (Character String) with field length 2
  • UNIT_VALN_FREQ : Indicator : Valuation Period
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VALN_FREQ : Period of revaluation for a real estate
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PAST_VALUED_DATE : Most Recent Date on which the Real Estate was last Valued
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • START_DATE : Revaluation Start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_DATE : End date for Revaluation of the Real Estate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Lending rate data
  • LENDING_RATE_IND : Indicates that the asset has a default lending rate or not
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Lending rates
  • LENDING_RATE1 : Lending rate 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE2 : Lending rate 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE3 : Lending rate 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE4 : Lending rate 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE5 : Lending rate 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Structure for history
  • CREATED_BY : Real Estate Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ENTRY_SRC : Sorce of Initial entry
    Its data type is CHAR (Character String) with field length 32
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PROCESSING_SRC : Processing Source
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes