CMS_SEC_ACC

Securities account details | #masterdata | Component: Securities
Column Name Description
MANDT Client
SEC_ACC_GUID GUID for securities account
Column Name Description
💲 Currency of Securities Account Value (SEC_ACC_VAL_CURR):
SEC_ACC_VAL Value of the Securities Account
💲 Currency of the Safety discount amount (SFTY_AMT_CURR):
SFTY_AMOUNT Safety discount as an amount
💲 Currency of Liquidation value (LIQD_CURR):
LIQD_AMT Proceeds obtained from liquidation of the collateral
💲 Currency: Expected Proceed (EXP_PRCD_CURR):
EXP_PRCD_AMNT Expected Proceed Amount
Column Name Description
Column Name Description
VAL_DATE Date of last valuation
START_DATE Valuation Start date
END_DATE Valuation End date
LIQD_DATE Date of Liquidation of Collateral
EXP_ACC_DATE Expected accrual date
CREATED_DATE Created On
CREATED_TIME Created At
LAST_CHG_DATE Last Changed on
LAST_CHG_TIME Last Changed At
Column Name Description
SFTY_IND Indicates that the asset has a default sfty discount or not Show values
SFTY_DSCNT Safety discount Show values
UNIT_VALN_FREQ Indicator : Valuation Frequency of Securities Account Show values
LENDING_RATE_IND Indicates that the asset has a default lending rate or not Show values
Column Name Description Domain name
DEPO_BANK_ID Depository Bank Identification CMS_SEC_DEPO_BNK_ID
ACCOUNT_NUMBER Securities Account Identification Number CMS_SEC_ACC_ID
SEC_ACC_DESC Description of the Securities Account CMS_SEC_DESC
ACC_OLD_REF_NO ID of a Securities Account Referenced from External System CMS_SEC_EXT_REFID
ADMIN_ORG_UNIT Administration Organizational Unit TEXT12
BANKAREA Bank Area in Collateral Management CMS_BANKAREA
RISK_CODE Risk Code CMS_RISK_CODE
PERIOD_VALN_FREQ Period of revaluation for securities CMS_AST_VALN_FREQ_PERIOD
LENDING_RATE1 Lending rate 1 CMS_PCT
LIQD_TYP Liquidation type CMS_TYP
LIQD_REASON Liquidation Reason CMS_ATT_ID_TYP
ACC_NUMBER_LIQ Account number for liquidation proceeds BANKN35
BANK_KEY_LIQ Bank Key BANKK
BANK_CTRLKEY_LIQ Bank Control Key BKONT
ORG_UNIT1 Organizational Unit 1: Assets CMS_ORG_UNIT
ORG_UNIT2 Organizational Unit 2: Assets CMS_ORG_UNIT
ORG_UNIT3 Organizational Unit 3: Assets CMS_ORG_UNIT
ORG_UNIT4 Organizational Unit 4: Assets CMS_ORG_UNIT
ORG_UNIT5 Organizational Unit 5: Assets CMS_ORG_UNIT
CREATED_BY Securities Add-On User CMS_USER
LAST_CHG_BY Last Changed By CMS_USER
BUPR_ID Business Process ID SYSUUID
BUPR_TYPE_CODE Business Process Type Code CMS_BUPR_TYP_CODE
Master Data Relations Join Conditions
Key of Bank Country/Region
  • Key of Bank Country/Region
  • Client
  • CMS_SEC_ACC.BANK_CNTRY_LIQ == T005.LAND1
  • CMS_SEC_ACC.MANDT == T005.MANDT
Currency: Expected Proceed
  • CMS_SEC_ACC.MANDT == TCURC.MANDT
  • CMS_SEC_ACC.EXP_PRCD_CURR == TCURC.WAERS
Currency of Liquidation value
  • CMS_SEC_ACC.MANDT == TCURC.MANDT
  • CMS_SEC_ACC.LIQD_CURR == TCURC.WAERS
currency field check
  • CMS_SEC_ACC.MANDT == TCURC.MANDT
  • CMS_SEC_ACC.SEC_ACC_VAL_CURR == TCURC.WAERS
Currency of the Safety discount amount
  • CMS_SEC_ACC.MANDT == TCURC.MANDT
  • CMS_SEC_ACC.SFTY_AMT_CURR == TCURC.WAERS