SAP CMS_STR_SEC_AST_DATA_DB table - SEC ACC DB Asset Details - not used details in SAP

SAP CMS_STR_SEC_AST_DATA_DB table summary

Object Name: CMS_STR_SEC_AST_DATA_DB
Dictionary Type: Structure
Description: SEC ACC DB Asset Details - not used

Field list for CMS_STR_SEC_AST_DATA_DB table on an S/4 SAP system

Details

CMS_STR_SEC_AST_DATA_DB-RISK_CODE table field - Risk Code ▼

Description: Risk Code
Field Name: RISK_CODE
Data Element: CMS_DTE_SEC_RISK_CODE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CMS_RISK_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RISK_CODE

CMS_STR_SEC_AST_DATA_DB-SFTY_IND table field - Indicates that the asset has a default sfty discount or not ▼

Description: Indicates that the asset has a default sfty discount or not
Field Name: SFTY_IND
Data Element: CMS_DTE_SEC_IND_SFTY_DISC
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CMS_IND_SFTY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SFTY_IND

CMS_STR_SEC_AST_DATA_DB-SFTY_DSCNT table field - Safety discount ▼

Description: Safety discount
Field Name: SFTY_DSCNT
Data Element: CMS_DTE_SEC_SAFETY_DSCNT
Data Type: DEC
length (Dec): 10(6)
Check table:
Conversion Routine:
Domain Name: CMS_SFTY_PCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SFTY_DSCNT

CMS_STR_SEC_AST_DATA_DB-SFTY_AMOUNT table field - Safety discount as an amount ▼

Description: Safety discount as an amount
Field Name: SFTY_AMOUNT
Data Element: CMS_DTE_SEC_SAFETY_AMT
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: CMS_SEC_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SFTY_AMOUNT

CMS_STR_SEC_AST_DATA_DB-SFTY_AMT_CURR table field - Currency of the Safety discount amount ▼

Description: Currency of the Safety discount amount
Field Name: SFTY_AMT_CURR
Data Element: CMS_DTE_SEC_SAFETY_AMT_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SFTY_AMT_CURR

CMS_STR_SEC_AST_DATA_DB-UNIT_VALN_FREQ table field - Indicator : Valuation Frequency of Securities Account ▼

Description: Indicator : Valuation Frequency of Securities Account
Field Name: UNIT_VALN_FREQ
Data Element: CMS_DTE_SEC_IND_FREQUENCY
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CMS_IND_AST_VALN_FREQ_UNIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNIT_VALN_FREQ

CMS_STR_SEC_AST_DATA_DB-PERIOD_VALN_FREQ table field - Period of revaluation for securities ▼

Description: Period of revaluation for securities
Field Name: PERIOD_VALN_FREQ
Data Element: CMS_DTE_SEC_VALN_FREQ_PERIOD
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CMS_AST_VALN_FREQ_PERIOD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERIOD_VALN_FREQ

CMS_STR_SEC_AST_DATA_DB-START_DATE table field - Valuation Start date ▼

Description: Valuation Start date
Field Name: START_DATE
Data Element: CMS_DTE_SEC_START_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CMS_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DATE

CMS_STR_SEC_AST_DATA_DB-END_DATE table field - Valuation End date ▼

Description: Valuation End date
Field Name: END_DATE
Data Element: CMS_DTE_SEC_END_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CMS_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field END_DATE

CMS_STR_SEC_AST_DATA_DB-LENDING_RATE_IND table field - Indicates that the asset has a default lending rate or not ▼

Description: Indicates that the asset has a default lending rate or not
Field Name: LENDING_RATE_IND
Data Element: CMS_DTE_SEC_IND_LND_RTE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CMS_IND_LRTE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENDING_RATE_IND

CMS_STR_SEC_AST_DATA_DB-LENDING_RATE1 table field - Lending rate 1 ▼

Description: Lending rate 1
Field Name: LENDING_RATE1
Data Element: CMS_DTE_SEC_LRTE_PCT1
Data Type: DEC
length (Dec): 10(6)
Check table:
Conversion Routine:
Domain Name: CMS_PCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENDING_RATE1

CMS_STR_SEC_AST_DATA_DB-LIQD_TYP table field - Liquidation type ▼

Description: Liquidation type
Field Name: LIQD_TYP
Data Element: CMS_DTE_SEC_LIQD_TYP
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CMS_TYP
MemoryID:
AppClass:
SHLP: CMS_AST_LIQTYP
SHLP Field: LIQD_TYP
ConvExit:

See all SAP tables containing field LIQD_TYP

CMS_STR_SEC_AST_DATA_DB-LIQD_REASON table field - Liquidation Reason ▼

Description: Liquidation Reason
Field Name: LIQD_REASON
Data Element: CMS_DTE_ATT_ID_TY_AST004
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CMS_ATT_ID_TYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIQD_REASON

CMS_STR_SEC_AST_DATA_DB-LIQD_DATE table field - Date of Liquidation of Collateral ▼

Description: Date of Liquidation of Collateral
Field Name: LIQD_DATE
Data Element: CMS_DTE_SEC_LIQD_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CMS_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIQD_DATE

CMS_STR_SEC_AST_DATA_DB-LIQD_AMT table field - Proceeds obtained from liquidation of the collateral ▼

Description: Proceeds obtained from liquidation of the collateral
Field Name: LIQD_AMT
Data Element: CMS_DTE_SEC_LIQD_VALUE
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: CMS_SEC_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIQD_AMT

CMS_STR_SEC_AST_DATA_DB-LIQD_CURR table field - Currency of Liquidation value ▼

Description: Currency of Liquidation value
Field Name: LIQD_CURR
Data Element: CMS_DTE_SEC_LIQD_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIQD_CURR

CMS_STR_SEC_AST_DATA_DB-EXP_PRCD_AMNT table field - Expected Proceed Amount ▼

Description: Expected Proceed Amount
Field Name: EXP_PRCD_AMNT
Data Element: CMS_DTE_LIQ_EXP_PRCD_AMOUNT
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: CMS_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXP_PRCD_AMNT

CMS_STR_SEC_AST_DATA_DB-EXP_PRCD_CURR table field - Currency: Expected Proceed ▼

Description: Currency: Expected Proceed
Field Name: EXP_PRCD_CURR
Data Element: CMS_DTE_LIQ_EXP_PRCD_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXP_PRCD_CURR

CMS_STR_SEC_AST_DATA_DB-EXP_ACC_DATE table field - Expected accrual date ▼

Description: Expected accrual date
Field Name: EXP_ACC_DATE
Data Element: CMS_DTE_LIQ_EXP_ACCRUAL_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CMS_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXP_ACC_DATE

CMS_STR_SEC_AST_DATA_DB-ACC_NUMBER_LIQ table field - Account number for liquidation proceeds ▼

Description: Account number for liquidation proceeds
Field Name: ACC_NUMBER_LIQ
Data Element: CMS_DTE_LIQ_ACC_NUMBER
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: BANKN35
MemoryID:
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACC_NUMBER_LIQ

CMS_STR_SEC_AST_DATA_DB-BANK_CNTRY_LIQ table field - Key of Bank Country/Region ▼

Description: Key of Bank Country/Region
Field Name: BANK_CNTRY_LIQ
Data Element: CMS_DTE_LIQ_BNK_CTRY_KY
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_CNTRY_LIQ

CMS_STR_SEC_AST_DATA_DB-BANK_KEY_LIQ table field - Bank Key ▼

Description: Bank Key
Field Name: BANK_KEY_LIQ
Data Element: CMS_DTE_LIQ_BNK_KEY
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: BANKK
MemoryID: BNK
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_KEY_LIQ

CMS_STR_SEC_AST_DATA_DB-BANK_CTRLKEY_LIQ table field - Bank Control Key ▼

Description: Bank Control Key
Field Name: BANK_CTRLKEY_LIQ
Data Element: BKONT
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BKONT
MemoryID:
AppClass: FBZ
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANK_CTRLKEY_LIQ

View list of all SAP tables(S4H/ECC)

Select data from SAP table