1. SAP Tutorial
  2. Financial Services

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

    • CMS_RE_PRT_ACS related tables

    • TCMS_RE_APPL_T : Application name(Text table)
    • TCMS_RE_C_CAT : System table for Cost Category
    • CMS_RE_OBJ_SPC : Space Details to describe a real estate object
    • TCMS_VAL_PARGP_T : Text table for parameter groups of valuation
    • CMS_RE_PRT_DOC : Real Estate Document details
    • TCMS_RE_TYP : Customizing table for real estate types
    • TCMS_RE_HER_RG : Customizing table for Heritable building rights
    • TCMS_RE_TR_CON_T : Transport connection types(Text table)
    • TCMS_RE_ST_CAT_T : Object Status category(Text table)
    • TCMS_RE_CST_TY : Customizing table for Object Cost Type
    • TCMS_RE_TYP_T : Object types(Text table)
    • TCMS_RE_LR_ID_T : Land Registers Identifiers Text
    • TCMS_RE_TR_CON : Customizing table for Transport connection types
    • CMS_RE_OBJ_BP : Link between Real estate objects and BuPa is stored here
    • TCMS_RE_OBJ_ACS : Real Estate object type – Accessories relationship
    • TCMS_RE_LOC_MI : Customizing table for Micro location types
    • TCMS_RE_SP_TYP_T : Space Types(Text table)
    • TCMS_RE_SP_TYP : Customizing table for space types
    • TCMS_RE_P_CAT : Building Part Category
    • TCMS_RE_PRT_SAS : Building Part type – Sub Asset relation

    CMS_RE_PRT_ACS related transaction codes under SAP package CMS_RE

    • CMS_CUS_RE_BDT_100 : CMS-RE Cust: Fld Grouping Activity
    • CMS_CUS_RE_BDT_003 : CMS-RE Control: Views
    • CMS_CUS_RE_BDT_013 : CMS-RE Control: BP Roles
    • CMS_CUS_RE_BDT_101 : CMS-RE Cust: BP Role Fld Grouping
    • CMS_CUS_RE_BDT_015 : CMS-RE Control: Appl Transactions
    • CMS_RE_CREATE : Create real estate
    • CMS_CUS_RE_BDT_016 : CMS-RE Control: Tables
    • CMS_CUS_RE_BDT_104 : CMS-RE Cust: Screen Configuration
    • CMS_CUS_RE_BDT_022 : CMS-RE Control:Where used-list
    • CMS_CUS_RE_BDT_006 : CMS-RE Control: Screen Seq.
    • CMS_DEL_SUBAST_RE : Delete wrong subassets for RE
    • CMS_CUS_RE_BDT_107 : CMS-RE Cust: Where used list
    • CMS_RE_COPY : Create real estate
    • CMS_CUS_RE_BDT_018 : CMS-RE Control: Activities
    • CMS_CUS_RE_BDT_017 : CMS-RE Control: External Application
    • CMS_CUS_RE_BDT_023 : CMS-RE Tax: Data Sets
    • CMS_CUS_RE_BDT_001 : CMS-RE Control:Applications
    • CMS_CUS_RE_BDT_008 : CMS-RE Control:GUI Standard Function
    • CMS_CUS_RE_BDT_102 : CMS-RE Cust: Authorization types
    • CMS_RE_CHANGE : Change real estate

    Related References

    Related Tutorials

    CMS_RE_OBJ SAP table for – Real estate header details

    CMS_RE_OBJ table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    CMS_RE_PRT_VAL SAP table for – Real Estate Part value details

    CMS_RE_PRT_VAL table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    CMS_RE_PRT_CST SAP table for – Real Estate Part Cost details

    CMS_RE_PRT_CST table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    CMS_RE_PRT_BP SAP table for – Real Estate Part BP details

    CMS_RE_PRT_BP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    CMS_RE_PRT_LR SAP table for – Real Estate Part LR details

    CMS_RE_PRT_LR table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    TCMS_RE_OBJ_ACS SAP table for – Real Estate object type – Accessories relationship

    TCMS_RE_OBJ_ACS table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    TCMS_RE_OBJ_PRT SAP table for – Real Estate object type – Building Parts relationship

    TCMS_RE_OBJ_PRT table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    «
    »