SAP ABAP Table CMS_RE_STR_PRT_ACS_MAP_GET (MAPI : Stricture for Real Estate Part Accessories)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-MD-RE (Application Component) Real Estate
⤷ CMS_RE (Package) Collateral Management System: Real Esate
⤷ FS-CMS-MD-RE (Application Component) Real Estate
⤷ CMS_RE (Package) Collateral Management System: Real Esate
Basic Data
Table Category | INTTAB | Structure |
Structure | CMS_RE_STR_PRT_ACS_MAP_GET | Table Relationship Diagram |
Short Description | MAPI : Stricture for Real Estate Part Accessories |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Primary key for Object part | |||||
2 | OBJ_PRT_GUID | CMS_RE_DTE_OBJ_PRT_GUID | SYSUUID | RAW | 16 | 0 | GUID for Object part | ||
3 | .INCLUDE | 0 | 0 | Structure for Object GUID | |||||
4 | OBJ_GUID | CMS_RE_DTE_OBJ_GUID | SYSUUID | RAW | 16 | 0 | GUID for Real Estate Object | ||
5 | .INCLUDE | 0 | 0 | Structure for Semantic key for Objects in RE Add-On | |||||
6 | OBJECT_ID | CMS_RE_DTE_OBJECT_ID | CMS_RE_OBJECT_ID | CHAR | 20 | 0 | Object ID | ||
7 | OBJECT_TYPE | CMS_RE_DTE_OBJ_TYP | CMS_RE_TYP | CHAR | 6 | 0 | Real Estate Object Type ID | * | |
8 | .INCLUDE | 0 | 0 | Structure for Part ID | |||||
9 | PART_ID | CMS_RE_DTE_PART_ID | CMS_RE_PRT_ID | NUMC | 10 | 0 | Part ID for the Object | ||
10 | .INCLUDE | 0 | 0 | Structure for Accessory Type | |||||
11 | ACS_TYPE | CMS_RE_DTE_ATT_ID_TY_REO010 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Accessory Type | TCMS_ATT_ID_TY | |
12 | NO_OF_ACS | CMS_RE_DTE_NO_OF_ACS | CMS_RE_UNITS | INT4 | 10 | 0 | No of Accessory Units | ||
13 | ACS_VALUE | CMS_RE_DTE_ACS_VALUE | CMS_RE_AMOUNT | CURR | 17 | 2 | Value of the Accessory | ||
14 | ACS_VALUE_CURR | CMS_RE_DTE_ACS_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency for Value of the accessory | TCURC | |
15 | IS_SUB_AST_CREA | CMS_RE_DTE_CREATE_SUB_AST_FLG | CMS_RE_FLG | CHAR | 1 | 0 | Indicates whether a Sub-asset is created for Building Part | ||
16 | ACS_DESC | CMS_RE_DTE_CST_DESC | CMS_RE_DESC | CHAR | 30 | 0 | Description of the cost | ||
17 | ACS_ID | CMS_RE_DTE_ACS_ID | CMS_ACS_ID | NUMC | 4 | 0 | Sequence Number of Accessory or Special Equipment | ||
18 | .INCLUDE | 0 | 0 | AST PKy and Type and Parent GUID | |||||
19 | AST_GUID | CMS_DTE_AST_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_AST | ||
20 | AST_TYP | CMS_DTE_AST_TYP | CMS_AST_TYP | CHAR | 6 | 0 | Asset Type | * | |
21 | PARENT_GUID | CMS_DTE_SAS_PAR_GUID | SYSUUID | RAW | 16 | 0 | Asset Guid as a parent GUID for a sub-asset | ||
22 | .INCLUDE | 0 | 0 | Structure with Asset Details | |||||
23 | .INCLUDE | 0 | 0 | Basic Asset data | |||||
24 | RISK_CODE | CMS_RE_DTE_RISK_CODE | CMS_RISK_CODE | CHAR | 6 | 0 | Risk Code | * | |
25 | SFTY_IND | CMS_RE_DTE_IND_SFTY_DISC | CMS_IND_SFTY | CHAR | 2 | 0 | Indicates that the asset has a default sfty discount or not | ||
26 | SFTY_DSCNT | CMS_RE_DTE_SAFETY_DSCNT | CMS_SFTY_PCT | DEC | 10 | 6 | Safety discount | ||
27 | SFTY_AMOUNT | CMS_RE_DTE_SAFETY_AMT | CMS_AMOUNT | CURR | 17 | 2 | Safety discount as an amount | ||
28 | SFTY_AMT_CURR | CMS_RE_DTE_SAFETY_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Safety discount amount | TCURC | |
29 | .INCLUDE | 0 | 0 | Valuation data | |||||
30 | VALUATION_TYP | CMS_RE_DTE_IND_VALN_TYP | CMS_VALN_TYP | CHAR | 2 | 0 | Type of Check conducted on the object | ||
31 | UNIT_VALN_FREQ | CMS_RE_DTE_IND_FREQUENCY | CMS_RE_IND_FREQUENCY | CHAR | 2 | 0 | Indicator : Valuation Period | ||
32 | PERIOD_VALN_FREQ | CMS_RE_DTE_VALN_FREQ_PERIOD | CMS_RE_VALN_FREQ_PERIOD | NUMC | 4 | 0 | Period of revaluation for a real estate | ||
33 | PAST_VALUED_DATE | CMS_RE_DTE_VALN_DATE | CMS_DATE | DATS | 8 | 0 | Most Recent Date on which the Real Estate was last Valued | ||
34 | START_DATE | CMS_RE_DTE_START_DATE | CMS_DATE | DATS | 8 | 0 | Revaluation Start date | ||
35 | END_DATE | CMS_RE_DTE_END_DATE | CMS_DATE | DATS | 8 | 0 | End date for Revaluation of the Real Estate | ||
36 | .INCLUDE | 0 | 0 | Lending rate data | |||||
37 | LENDING_RATE_IND | CMS_RE_DTE_IND_LND_RTE | CMS_IND_LRTE | CHAR | 2 | 0 | Indicates that the asset has a default lending rate or not | ||
38 | .INCLUDE | 0 | 0 | Lending rates | |||||
39 | LENDING_RATE1 | CMS_RE_DTE_LRTE_PCT1 | CMS_PCT | DEC | 10 | 6 | Lending rate 1 | ||
40 | LENDING_RATE2 | CMS_RE_DTE_LRTE_PCT2 | CMS_PCT | DEC | 10 | 6 | Lending rate 2 | ||
41 | LENDING_RATE3 | CMS_RE_DTE_LRTE_PCT3 | CMS_PCT | DEC | 10 | 6 | Lending rate 3 | ||
42 | LENDING_RATE4 | CMS_RE_DTE_LRTE_PCT4 | CMS_PCT | DEC | 10 | 6 | Lending rate 4 | ||
43 | LENDING_RATE5 | CMS_RE_DTE_LRTE_PCT5 | CMS_PCT | DEC | 10 | 6 | Lending rate 5 | ||
44 | .INCLUDE | 0 | 0 | Account for liquidation proceeds | |||||
45 | ACC_NUMBER_LIQ | CMS_DTE_LIQ_ACC_NUMBER | BANKN35 | CHAR | 35 | 0 | Account number for liquidation proceeds | ||
46 | BANK_CNTRY_LIQ | CMS_DTE_LIQ_BNK_CTRY_KY | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
47 | BANK_KEY_LIQ | CMS_DTE_LIQ_BNK_KEY | BANKK | CHAR | 15 | 0 | Bank Key | ||
48 | BANK_CTRLKEY_LIQ | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
49 | .INCLUDE | 0 | 0 | Verfication Data | |||||
50 | UNIT_VERF_FREQ | CMS_DTE_IND_AST_VERF_FREQ_UNIT | CMS_IND_AST_VERF_FREQ_UNIT | CHAR | 2 | 0 | Indicator: Units of time for verification of an asset | ||
51 | PERIOD_VERF_FREQ | CMS_DTE_AST_VERF_FREQ_PERIOD | CMS_AST_VERF_FREQ_PERIOD | NUMC | 4 | 0 | Statement Period for an Asset | ||
52 | LAST_VERF_DATE | CMS_DTE_AST_VERF_DATE | CMS_DATE | DATS | 8 | 0 | Last Verification Date | ||
53 | .INCLUDE | 0 | 0 | Liquidation Data | |||||
54 | LIQD_TYP | CMS_DTE_LIQD_TYP | CMS_TYP | CHAR | 6 | 0 | Liquidation Type | ||
55 | LIQD_REASON | CMS_DTE_ATT_ID_TY_AST004 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Liquidation Reason | TCMS_ATT_ID_TY | |
56 | LIQD_DATE | CMS_DTE_LIQD_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Collateral was Liquidated | ||
57 | LIQD_AMT | CMS_DTE_LIQD_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Returns from the Liquidation of Collateral | ||
58 | LIQD_CURR | CMS_DTE_LIQD_CURR | WAERS | CUKY | 5 | 0 | Currency of Liquidation Value | TCURC | |
59 | EXP_PRCD_AMNT | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CMS_AMOUNT | CURR | 17 | 2 | Expected Proceed Amount | ||
60 | EXP_PRCD_CURR | CMS_DTE_LIQ_EXP_PRCD_CURR | WAERS | CUKY | 5 | 0 | Currency: Expected Proceed | TCURC | |
61 | EXP_ACC_DATE | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | CMS_DATE | DATS | 8 | 0 | Expected accrual date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMS_RE_STR_PRT_ACS_MAP_GET | ACS_TYPE | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
2 | CMS_RE_STR_PRT_ACS_MAP_GET | ACS_VALUE_CURR | TCURC | WAERS | REF | 1 | CN |
3 | CMS_RE_STR_PRT_ACS_MAP_GET | BANK_CNTRY_LIQ | T005 | LAND1 | REF | 1 | CN |
4 | CMS_RE_STR_PRT_ACS_MAP_GET | EXP_PRCD_CURR | TCURC | WAERS | REF | 1 | CN |
5 | CMS_RE_STR_PRT_ACS_MAP_GET | LIQD_CURR | TCURC | WAERS | REF | 1 | CN |
6 | CMS_RE_STR_PRT_ACS_MAP_GET | LIQD_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
7 | CMS_RE_STR_PRT_ACS_MAP_GET | SFTY_AMT_CURR | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 500 |