SAP ABAP Table CMS_RE_STR_PRT_ACS_OTH_WA_SCR (Part-Accessory details(screen structure)-work area)

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

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	Table Relationship Diagram
Short Description	Part-Accessory details(screen structure)-work area

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 Part accessory
2	PRT_ACS_GUID	☐	CMS_RE_DTE_PRT_ACS_GUID	SYSUUID	RAW	16	0	GUID for part accessory
3	.INCLUDE	☐				0	0	Link structure for Object parts
4	OBJ_PRT_GUID	☐	CMS_RE_DTE_OBJ_PRT_GUID	SYSUUID	RAW	16	0	GUID for Object part
5	.INCLUDE	☐				0	0	Structure for Part ID
6	PART_ID	☐	CMS_RE_DTE_PART_ID	CMS_RE_PRT_ID	NUMC	10	0	Part ID for the Object
7	.INCLUDE	☐				0	0	Structure for Accessory Type
8	ACS_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO010	CMS_ATT_ID_TYP	CHAR	6	0	Accessory Type	TCMS_ATT_ID_TY
9	NO_OF_ACS	☐	CMS_RE_DTE_NO_OF_ACS	CMS_RE_UNITS	INT4	10	0	No of Accessory Units
10	ACS_VALUE	☐	CMS_RE_DTE_ACS_VALUE	CMS_RE_AMOUNT	CURR	17	2	Value of the Accessory
11	ACS_VALUE_CURR	☐	CMS_RE_DTE_ACS_VALUE_CURR	WAERS	CUKY	5	0	Currency for Value of the accessory	TCURC
12	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
13	ACS_DESC	☐	CMS_RE_DTE_CST_DESC	CMS_RE_DESC	CHAR	30	0	Description of the cost
14	ACS_ID	☐	CMS_RE_DTE_ACS_ID	CMS_ACS_ID	NUMC	4	0	Sequence Number of Accessory or Special Equipment
15	.INCLUDE	☐				0	0	Structure for history
16	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
17	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
18	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
19	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
20	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
21	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
22	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
23	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
24	.INCLUDE	☐				0	0	Structure with Asset Details
25	.INCLUDE	☐				0	0	Basic Asset data
26	RISK_CODE	☐	CMS_RE_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	TCMS_RISKCODE
27	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
28	SFTY_DSCNT	☐	CMS_RE_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
29	SFTY_AMOUNT	☐	CMS_RE_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Safety discount as an amount
30	SFTY_AMT_CURR	☐	CMS_RE_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
31	.INCLUDE	☐				0	0	Valuation data
32	VALUATION_TYP	☐	CMS_RE_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Check conducted on the object
33	UNIT_VALN_FREQ	☐	CMS_RE_DTE_IND_FREQUENCY	CMS_RE_IND_FREQUENCY	CHAR	2	0	Indicator : Valuation Period
34	PERIOD_VALN_FREQ	☐	CMS_RE_DTE_VALN_FREQ_PERIOD	CMS_RE_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for a real estate
35	PAST_VALUED_DATE	☐	CMS_RE_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Most Recent Date on which the Real Estate was last Valued
36	START_DATE	☐	CMS_RE_DTE_START_DATE	CMS_DATE	DATS	8	0	Revaluation Start date
37	END_DATE	☐	CMS_RE_DTE_END_DATE	CMS_DATE	DATS	8	0	End date for Revaluation of the Real Estate
38	.INCLUDE	☐				0	0	Lending rate data
39	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
40	.INCLUDE	☐				0	0	Lending rates
41	LENDING_RATE1	☐	CMS_RE_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
42	LENDING_RATE2	☐	CMS_RE_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending rate 2
43	LENDING_RATE3	☐	CMS_RE_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending rate 3
44	LENDING_RATE4	☐	CMS_RE_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending rate 4
45	LENDING_RATE5	☐	CMS_RE_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending rate 5
46	.INCLUDE	☐				0	0	Account for liquidation proceeds
47	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
48	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
49	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
50	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
51	.INCLUDE	☐				0	0	Verfication Data
52	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
53	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
54	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
55	.INCLUDE	☐				0	0	Liquidation Data
56	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
57	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
58	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
59	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
60	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value	TCURC
61	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
62	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed	TCURC
63	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
64	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
65	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
66	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
67	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	ACS_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	ACS_VALUE_CURR	TCURC	WAERS	REF	1	CN
3	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
4	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
5	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	LIQD_CURR	TCURC	WAERS	REF	1	CN
6	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
7	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	RISK_CODE	TCMS_RISKCODE	RISK_CODE	REF	1	CN
8	CMS_RE_STR_PRT_ACS_OTH_WA_SCR	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600