SAP ABAP Table CMS_STR_BII_AST_DET_SNG (CMS-Basel II: Asset Details Complete)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-IS (Application Component) Information System
⤷ CMS_BASEL (Package) Basel II
⤷ FS-CMS-IS (Application Component) Information System
⤷ CMS_BASEL (Package) Basel II
Basic Data
Table Category | INTTAB | Structure |
Structure | CMS_STR_BII_AST_DET_SNG | Table Relationship Diagram |
Short Description | CMS-Basel II: Asset Details Complete |
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 | AST_DETAILS | CMS_STR_AST_DETAILS_API | STRU | 0 | 0 | ||||
2 | .INCLUDE | 0 | 0 | Primary Key for CMS_AST | |||||
3 | AST_GUID | CMS_DTE_AST_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_AST | ||
4 | .INCLUDE | 0 | 0 | Semantic Key for Table CMS_AST | |||||
5 | AST_ID | CMS_DTE_AST_ID | CMS_AST_ID | CHAR | 40 | 0 | Asset ID | ||
6 | AST_TYP | CMS_DTE_AST_TYP | CMS_AST_TYP | CHAR | 6 | 0 | Asset Type | ||
7 | .INCLUDE | 0 | 0 | Structure with Asset Details for Table CMS_AST | |||||
8 | .INCLUDE | 0 | 0 | Basic Asset data | |||||
9 | DESCRIPTION | CMS_DTE_AST_DESC | CMS_DSC | CHAR | 30 | 0 | Description | ||
10 | OBJECT_REF_ID | CMS_DTE_OBJ_REFID | CMS_OBJ_REFID | CHAR | 40 | 0 | Reference ID for the object | ||
11 | OBJECT_TYP | CMS_DTE_OBJ_TYP | CMS_OBJ_TYP | CHAR | 32 | 0 | Not used | ||
12 | COUNTRY_KEY | CMS_DTE_AST_COUNTRY_KEY | LAND1 | CHAR | 3 | 0 | Identification Key for Country | ||
13 | RISK_CODE | CMS_DTE_RISK_CODE | CMS_RISK_CODE | CHAR | 6 | 0 | Risk Code | ||
14 | SFTY_IND | CMS_DTE_IND_SFTY_DISC | CMS_IND_SFTY | CHAR | 2 | 0 | Indicates if the Asset has a Default Safety Discount | ||
15 | SFTY_DSCNT | CMS_DTE_SAFETY_DSCNT | CMS_SFTY_PCT | DEC | 10 | 6 | Percentage of Safety Discount | ||
16 | SFTY_AMOUNT | CMS_DTE_SAFETY_AMT | CMS_AMOUNT | CURR | 17 | 2 | Amount of Safety Discount | ||
17 | SFTY_AMT_CURR | CMS_DTE_SAFETY_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Safety Discount Amount | ||
18 | OBJSYSID | CMS_DTE_OBJ_SYSID | CMS_SYS | CHAR | 6 | 0 | Object System Reference ID | ||
19 | .INCLUDE | 0 | 0 | Valuation data | |||||
20 | VALUATION_TYP | CMS_DTE_IND_VALN_TYP | CMS_VALN_TYP | CHAR | 2 | 0 | Type of Valuation Check performed on Collateral Object | ||
21 | UNIT_VALN_FREQ | CMS_DTE_IND_AST_VALN_FREQ_UNIT | CMS_IND_AST_VALN_FREQ_UNIT | CHAR | 2 | 0 | Indicator: Units of time for revaluation of an asset | ||
22 | PERIOD_VALN_FREQ | CMS_DTE_AST_VALN_FREQ_PERIOD | CMS_AST_VALN_FREQ_PERIOD | NUMC | 4 | 0 | Revaluation Period for an Asset | ||
23 | PAST_VALUED_DATE | CMS_DTE_VALN_DATE | CMS_DATE | DATS | 8 | 0 | Last Date on which the Asset was Valued | ||
24 | START_DATE | CMS_DTE_START_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the First Valuation is Performed on the Asset | ||
25 | END_DATE | CMS_DTE_END_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Last Valuation is Performed on the Asset | ||
26 | .INCLUDE | 0 | 0 | Lending rate data | |||||
27 | LENDING_RATE_IND | CMS_DTE_IND_LND_RTE | CMS_IND_LRTE | CHAR | 2 | 0 | Indicator to specify if Asset has a Default Lending Rate | ||
28 | .INCLUDE | 0 | 0 | Lending rates structure | |||||
29 | LENDING_RATE1 | CMS_DTE_LRTE_PCT1 | CMS_PCT | DEC | 10 | 6 | Lending Rate 1 | ||
30 | LENDING_RATE2 | CMS_DTE_LRTE_PCT2 | CMS_PCT | DEC | 10 | 6 | Lending Rate 2 | ||
31 | LENDING_RATE3 | CMS_DTE_LRTE_PCT3 | CMS_PCT | DEC | 10 | 6 | Lending Rate 3 | ||
32 | LENDING_RATE4 | CMS_DTE_LRTE_PCT4 | CMS_PCT | DEC | 10 | 6 | Lending Rate 4 | ||
33 | LENDING_RATE5 | CMS_DTE_LRTE_PCT5 | CMS_PCT | DEC | 10 | 6 | Lending Rate 5 | ||
34 | .INCLUDE | 0 | 0 | Liquidation rights data | |||||
35 | LIQD_TYP | CMS_DTE_LIQD_TYP | CMS_TYP | CHAR | 6 | 0 | Liquidation Type | ||
36 | LIQD_REASON | CMS_DTE_ATT_ID_TY_AST004 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Liquidation Reason | ||
37 | LIQD_DATE | CMS_DTE_LIQD_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Collateral was Liquidated | ||
38 | LIQD_AMT | CMS_DTE_LIQD_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Returns from the Liquidation of Collateral | ||
39 | LIQD_CURR | CMS_DTE_LIQD_CURR | WAERS | CUKY | 5 | 0 | Currency of Liquidation Value | ||
40 | EXP_PRCD_AMNT | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CMS_AMOUNT | CURR | 17 | 2 | Expected Proceed Amount | ||
41 | EXP_PRCD_CURR | CMS_DTE_LIQ_EXP_PRCD_CURR | WAERS | CUKY | 5 | 0 | Currency: Expected Proceed | ||
42 | EXP_ACC_DATE | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | CMS_DATE | DATS | 8 | 0 | Expected accrual date | ||
43 | .INCLUDE | 0 | 0 | Account for liquidation proceeds | |||||
44 | ACC_NUMBER_LIQ | CMS_DTE_LIQ_ACC_NUMBER | BANKN35 | CHAR | 35 | 0 | Account number for liquidation proceeds | ||
45 | BANK_CNTRY_LIQ | CMS_DTE_LIQ_BNK_CTRY_KY | LAND1 | CHAR | 3 | 0 | Bank country key | ||
46 | BANK_KEY_LIQ | CMS_DTE_LIQ_BNK_KEY | BANKK | CHAR | 15 | 0 | Bank Key | ||
47 | BANK_CTRLKEY_LIQ | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
48 | .INCLUDE | 0 | 0 | Verfication Data | |||||
49 | 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 | ||
50 | PERIOD_VERF_FREQ | CMS_DTE_AST_VERF_FREQ_PERIOD | CMS_AST_VERF_FREQ_PERIOD | NUMC | 4 | 0 | Statement Period for an Asset | ||
51 | LAST_VERF_DATE | CMS_DTE_AST_VERF_DATE | CMS_DATE | DATS | 8 | 0 | Last Verification Date | ||
52 | .INCLUDE | 0 | 0 | Structure for Asset values | |||||
53 | NOM_VALUE | CMS_DTE_AST_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Asset | ||
54 | NOM_VALUE_CURR | CMS_DTE_AST_NOMINAL_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency of Nominal value | ||
55 | AST_VALUE | CMS_DTE_AST_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Final Asset Value | ||
56 | AST_VALUE_CURR | CMS_DTE_AST_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency of the Final Asset Value | ||
57 | QUANTITY | CMS_DTE_QTY | CMS_QTY | QUAN | 13 | 3 | Quantity | ||
58 | UNIT_OF_MEASURE | CMS_DTE_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure of Quantity | ||
59 | REC_AT | CMS_DTE_REC_AT | TZNTSTMPS | DEC | 15 | 0 | Asset Value Recording Timestamp | ||
60 | .INCLUDE | 0 | 0 | Purchase price data | |||||
61 | PUR_PRICE | CMS_DTE_AST_PURCHASE_PRICE | CMS_AMOUNT | CURR | 17 | 2 | Purchase Price of the Asset | ||
62 | PUR_PRICE_CURR | CMS_DTE_AST_PUR_PRICE_CURR | WAERS | CUKY | 5 | 0 | Currency of Purchase Price | ||
63 | PUR_DATE | CMS_DTE_AST_PUR_PRICE_DATE | CMS_DATE | DATS | 8 | 0 | Date of Purchase | ||
64 | .INCLUDE | 0 | 0 | Administrative organization unit | |||||
65 | ADMIN_ORG_UNIT | CMS_DTE_ADMINORG | TEXT12 | CHAR | 12 | 0 | Administration Organizational Unit | ||
66 | .INCLUDE | 0 | 0 | Bank area | |||||
67 | BANKAREA | CMS_DTE_BANKAREA | CMS_BANKAREA | CHAR | 4 | 0 | Bank Area in Collateral Management | ||
68 | .INCLUDE | 0 | 0 | Organization unit structure | |||||
69 | ORG_UNIT1 | CMS_DTE_ORG_UNIT1 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 1 | ||
70 | ORG_UNIT2 | CMS_DTE_ORG_UNIT2 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 2 | ||
71 | ORG_UNIT3 | CMS_DTE_ORG_UNIT3 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 3 | ||
72 | ORG_UNIT4 | CMS_DTE_ORG_UNIT4 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 4 | ||
73 | ORG_UNIT5 | CMS_DTE_ORG_UNIT5 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 5 | ||
74 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
75 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
76 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
77 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
78 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
79 | SOURCEOFENTRY | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE | CHAR | 32 | 0 | Source of Entry | ||
80 | .INCLUDE | 0 | 0 | Asset IF: Obj Display Details (Instead of AST_TYP+AST_ID) | |||||
81 | AST_DISP_DATA | CMS_DTE_AST_IF_OBJ_ID_SCR | CMS_SCR_TEXT | CHAR | 90 | 0 | Asset IF : Screen Data for Object ID | ||
82 | SAS_DETAILS | CMS_TAB_SAS_DETAILS_API | TTYP | 0 | 0 | ||||
83 | AST_BP | CMS_TAB_AST_BP | TTYP | 0 | 0 | ||||
84 | SAS_BP | CMS_TAB_SAS_BP | TTYP | 0 | 0 | ||||
85 | AST_DOC | CMS_TAB_AST_DOC | TTYP | 0 | 0 | ||||
86 | SAS_DOC | CMS_TAB_SAS_DOC | TTYP | 0 | 0 | ||||
87 | NOTES | CMS_TAB_AST_TXT_LINES | TTYP | 0 | 0 | ||||
88 | SYS_STAT | CMS_TAB_AST_SYS_STAT | TTYP | 0 | 0 | ||||
89 | USR_STAT | CMS_TAB_AST_USR_STAT | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 200 |