SAP ABAP Table CMS_STR_CAG_SCR (Collateral Agreement Screen)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE_UI (Package) User interface for CMS Core
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE_UI (Package) User interface for CMS Core
Basic Data
Table Category | INTTAB | Structure |
Structure | CMS_STR_CAG_SCR | Table Relationship Diagram |
Short Description | Collateral Agreement Screen |
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 CMS_CAG | |||||
2 | CAG_GUID | CMS_DTE_CAG_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_CAG | ||
3 | .INCLUDE | 0 | 0 | Semantic Key for Table CMS_CAG | |||||
4 | CAGMTID | CMS_DTE_CAGID | CMS_CAGID | CHAR | 40 | 0 | Collateral Agreement ID | ||
5 | CAGMT_TYPE | CMS_DTE_CAG_TYP | CMS_CAG_TYP | CHAR | 6 | 0 | Collateral Agreement Type | * | |
6 | .INCLUDE | 0 | 0 | Collateral Agreement Details | |||||
7 | .INCLUDE | 0 | 0 | Nominal Value for Collateral Agreement | |||||
8 | NOM_VALUE | CMS_DTE_CAG_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Collateral Agreement | ||
9 | NOM_VALUE_CURR | CMS_DTE_CAG_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Currency for Nominal Value of the Collateral Agreement | TCURC | |
10 | .INCLUDE | 0 | 0 | Assessment Value details for a Collateral Agreement | |||||
11 | ASMT_AMT | CMS_DTE_CAG_ASMT_AMT | CMS_AMOUNT | CURR | 17 | 2 | Assessment Amount | ||
12 | ASMT_CURR | CMS_DTE_CAG_ASMT_CURR | WAERS | CUKY | 5 | 0 | Currency of Assessment Value | TCURC | |
13 | ASMT_DATE | CMS_DTE_CAG_ASMT_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Assessment Value was Calculated | ||
14 | .INCLUDE | 0 | 0 | Collateral Agreement Dates (DB Format ) | |||||
15 | CAGMT_DATE | CMS_DTE_CAG_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Collateral Agreement was Concluded | ||
16 | VALID_FROM | CMS_DTE_CAG_VALID_FROM | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-from Date | ||
17 | VALID_TO | CMS_DTE_CAG_VALID_TO | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-to Date | ||
18 | .INCLUDE | 0 | 0 | Basic data for a Collateral Agreement | |||||
19 | .INCLUDE | 0 | 0 | Administrative organization unit | |||||
20 | ADMIN_ORG_UNIT | CMS_DTE_ADMINORG | TEXT12 | CHAR | 12 | 0 | Administration Organizational Unit | ||
21 | .INCLUDE | 0 | 0 | Bank area | |||||
22 | BANKAREA | CMS_DTE_BANKAREA | CMS_BANKAREA | CHAR | 4 | 0 | Bank Area in Collateral Management | * | |
23 | COUNTRY_KEY | CMS_DTE_COUNTRY_KEY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | T005 | |
24 | FLG_GLOBAL | CMS_DTE_FLG_CAG_GLOBAL | CMS_FLG_GLOBAL_CAGMT | CHAR | 1 | 0 | Flag to indicate a Global Collateral Agreement | ||
25 | SPL_MARKDOWN_PCT | CMS_DTE_CAG_SPL_MARKDOWN_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Special Markdown | ||
26 | SPL_MARKDOWN_AMT | CMS_DTE_CAG_SPL_MARKDOWN_AMT | CMS_AMOUNT | CURR | 17 | 2 | Amount of Special Markdown | ||
27 | SPL_MRKDOWN_CURR | CMS_DTE_CAG_SPL_MRKDWN_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Special Markdown | * | |
28 | DESCRIPTION | CMS_DTE_CAG_DESC | CMS_DSC | CHAR | 30 | 0 | Description of Collateral Agreement | ||
29 | UNIT_REL_FREQ | CMS_DTE_IND_CAG_REL_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The unit for period of Release Frequency | ||
30 | PERIOD_REL_FREQ | CMS_DTE_CAG_REL_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Release of Collateral Agreement | ||
31 | OLD_CAGMTID | CMS_DTE_OLD_CAGID | CMS_OLD_CAGID | CHAR | 40 | 0 | External/Old Collateral Agreement ID | ||
32 | .INCLUDE | 0 | 0 | Basel II relevant data | |||||
33 | MIN_QL_EXCEP_TYP | CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP | CMS_CAG_MIN_QUAL_EXCEP_TYP | CHAR | 6 | 0 | Exceptions for Minimum Risk Weight | TCMS_CAG_MQEXP | |
34 | MIN_QL_REASON | CMS_DTE_CAG_ATT_ID_TY_CAG001 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Reason for the Minimum Qualitative Criterion | TCMS_ATT_ID_TY | |
35 | FLG_MIN_QL_REQMT | CMS_DTE_FLG_CAG_MIN_QUAL_REQMT | CMS_FLG_MIN_QUAL_REQMT | CHAR | 1 | 0 | Flag:Minimum requirements fulfilled for CAG(for Basel II) | ||
36 | MIN_QL_CRITE | CMS_DTE_CAG_MIN_QUAL_CRITERION | CMS_CAG_MIN_QUAL_CRITERION | CHAR | 6 | 0 | MInimum Qualitative Criterion | TCMS_CAG_MQCRT | |
37 | .INCLUDE | 0 | 0 | Asset details for a Collateral Agreement | |||||
38 | PCT_ASSET_VAL | CMS_DTE_PCT_AST_VAL | CMS_PCT | DEC | 10 | 6 | Percentage of the Asset Value used in Collateral Agreement | ||
39 | .INCLUDE | 0 | 0 | Termination rights data | |||||
40 | TERM_RIGHT_TYP | CMS_DTE_TERM_RIGHT_TYP | CMS_CAG_TERM_RIGHT_TYP | CHAR | 6 | 0 | Termination Right Type | * | |
41 | FIRST_TERM_DATE | CMS_DTE_CAG_TERM_FSTPOS_DATE | CMS_DATE | DATS | 8 | 0 | First possible date of termination | ||
42 | UNIT_TERM_FREQ | CMS_DTE_IND_CAG_TERM_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The Unit for Period of Termination Frequency | ||
43 | PERIOD_TERM_FREQ | CMS_DTE_CAG_TERM_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Termination of Collateral Agreement | ||
44 | NOTICE_PRD_UNIT | CMS_DTE_IND_CAG_NOTICE_UNIT | CMS_IND_CAG_TIME_PRD_UNIT | CHAR | 2 | 0 | The Unit for the Termination Notice Period | ||
45 | REQ_NOTICE_PRD | CMS_DTE_CAG_NOTICE_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Notice Period Required to Terminate Collateral Agreement | * | |
46 | TERM_NOTICE_DATE | CMS_DTE_CAG_TERM_NOTICE_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Termination Notice was Sent | ||
47 | TERM_REASON | CMS_DTE_CAG_ATT_ID_TY_CAG002 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Termination Type | TCMS_ATT_ID_TY | |
48 | TERM_GUAR_AMT | CMS_DTE_CAG_TERM_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Amount of Guarantee in the event of Termination | ||
49 | TERMINATION_CURR | CMS_DTE_CAG_TERM_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Guarantee in the event of Termination | * | |
50 | .INCLUDE | 0 | 0 | Guarantee specific data | |||||
51 | .INCLUDE | 0 | 0 | Guarantee specific details | |||||
52 | GUAR_RATE | CMS_DTE_CAG_GUAR_RATE | CMS_PCT | DEC | 10 | 6 | Guarantee Rate | ||
53 | FLG_COUNTER_GUAR | CMS_DTE_FLG_CAG_CNTR_GUAR | CMS_FLG_CNTR_GUAR | CHAR | 1 | 0 | Flag for Counter Guarantee | ||
54 | FLG_CO_GUAR | CMS_DTE_FLG_CAG_CO_GUAR | CMS_FLG_CO_GUAR | CHAR | 1 | 0 | Flag for Co-guarantee | ||
55 | FLG_FIXED_LIABTY | CMS_DTE_FLG_CAG_FIXED_LIABILTY | CMS_FLG_FIXED_LIABILITY | CHAR | 1 | 0 | Flag for Fixed Liability | ||
56 | FLG_DEF_LIABTY | CMS_DTE_FLG_CAG_DEF_LIABILITY | CMS_FLG_DEF_LIABILITY | CHAR | 1 | 0 | Flag for Default Liability | ||
57 | PCT_DEF_LIABTY | CMS_DTE_FLG_CAG_PCT_DEF_LIABTY | CMS_PCT | DEC | 10 | 6 | Default Liability in % | ||
58 | FLG_INCL_CAG_LNK | CMS_DTE_FLG_CAG_INCL_LINKED | CMS_FLG_CAG_INCL_LINKED | CHAR | 1 | 0 | Flag for back-up guarantee to be used in calculations or not | ||
59 | IND_APPR_AUTH | CMS_DTE_IND_CAG_APPR_AUTH | CMS_IND_CAG_APPR_AUTH | CHAR | 2 | 0 | Approval from authorities | ||
60 | FLG_ENFORCEABLE | CMS_DTE_FLG_CAG_ENFORCEABLE | CMS_FLG_DIR_ENFC | CHAR | 1 | 0 | Agreement directly enforceable | ||
61 | LENDING_RATE | CMS_DTE_CAG_LRTE_PCT | CMS_PCT | DEC | 10 | 6 | Lending Rate of a Guarantee | ||
62 | .INCLUDE | 0 | 0 | Reduction relation data | |||||
63 | UNIT_REDU_FREQ | CMS_DTE_IND_CAG_RED_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | Unit for Period of Frequency for Reduction in Guarantee Valu | ||
64 | PERIOD_REDU_FREQ | CMS_DTE_CAG_RED_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Reduction in Value of Guarantee | ||
65 | REDU_AMT | CMS_DTE_CAG_REDU_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reduction in Amount of Guarantee | ||
66 | REDU_CURR | CMS_DTE_CAG_REDU_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Reduced Amount of the Guarantee | * | |
67 | REDU_PCT | CMS_DTE_CAG_REDU_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Reduction in the Value of a Guarantee | ||
68 | REDU_START_DATE | CMS_DTE_CAG_REDU_START_DATE | CMS_DATE | DATS | 8 | 0 | Date from which Guarantee Value is Reduced | ||
69 | REDU_END_DATE | CMS_DTE_CAG_REDU_END_DATE | CMS_DATE | DATS | 8 | 0 | End Date for Reduction in Amount of Guarantee | ||
70 | REDU_LAST_DATE | CMS_DTE_CAG_REDU_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of reduction of value | ||
71 | .INCLUDE | 0 | 0 | Transfer specific details | |||||
72 | FLG_LEASING_TXN | CMS_DTE_FLG_CAG_LEASING_TXN | CMS_FLG_LEASING_TRANSACTION | CHAR | 1 | 0 | Flag: Transfer is part of a leasing transaction | ||
73 | IND_LESSOR_LIEN | CMS_DTE_IND_CAG_LESSOR_LIEN | CMS_IND_CAG_LESSOR_LIEN | CHAR | 2 | 0 | Indicator for Lessor Lien on Collateral Agreement | ||
74 | IND_ACC_LIABLE | CMS_DTE_IND_CAG_ACC_LIABLE | CMS_IND_CAG_ACC_LIABLE | CHAR | 2 | 0 | Specifies the applicability of accessories liability | ||
75 | FLG_ASGMT_AR | CMS_DTE_FLG_CAG_AR_FRM_SALE | CMS_FLG_ASGMT_RBL_FROM_SALE | CHAR | 1 | 0 | Flag for Assignment of Accounts Receivables(AR) from Sale | ||
76 | .INCLUDE | 0 | 0 | Minimum stock data | |||||
77 | MIN_STOCK_AMT | CMS_DTE_CAG_MIN_STOCK_AMT | CMS_AMOUNT | CURR | 17 | 2 | Minimum stock Amount agreed in the Collateral Agreement | ||
78 | MIN_STOCK_CURR | CMS_DTE_CAG_MIN_STOCK_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Minimum Stock Amount | TCURC | |
79 | FLG_ADDNL_RBL | CMS_DTE_FLG_CAG_ADDNL_RBL | CMS_FLG_ADDNL_RBL | CHAR | 1 | 0 | Flag for Additional receivable | ||
80 | ADDNL_RBL_DATE | CMS_DTE_CAG_DATE_ADDNL_RBL | CMS_DATE | DATS | 8 | 0 | Date on which Additional Receivable was Accepted | ||
81 | .INCLUDE | 0 | 0 | Pledge/Assignment details | |||||
82 | IND_GBC_LIEN | CMS_DTE_IND_CAG_GBC_LIEN | CMS_IND_CAG_GBC_LIEN | CHAR | 2 | 0 | GBC Lien on Agreement | ||
83 | FLG_DISCL | CMS_DTE_FLG_CAG_DISCL_PLEDGE | CMS_FLG_DISCL_PLEDGE | CHAR | 1 | 0 | Flag to indicator whether the Agreement is disclosed or not | ||
84 | DISCL_DATE | CMS_DTE_CAG_DISCL_DATE | CMS_DATE | DATS | 8 | 0 | Date of Disclosure to Third-party Debtor | ||
85 | .INCLUDE | 0 | 0 | Assignment reason | |||||
86 | ASGMT_REASON | CMS_DTE_CAG_ATT_ID_TY_CAG006 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Reason for Assignment | TCMS_ATT_ID_TY | |
87 | .INCLUDE | 0 | 0 | Land Charge specific data | |||||
88 | .INCLUDE | 0 | 0 | Land Charge specific interest details | |||||
89 | INT_RATE | CMS_DTE_CAG_LCHG_INT_RATE | CMS_PCT | DEC | 10 | 6 | Land Charge Interest Rate | ||
90 | INCIDENTAL_PAYMT | CMS_DTE_CAG_LCHG_INCD_PAYMT | CMS_PCT | DEC | 10 | 6 | Incidental Payments in Percentage | ||
91 | UNIT_PMT_FREQ | CMS_DTE_IND_CAG_PYMT_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The unit for period of payment frequency | ||
92 | PERIOD_PMT_FREQ | CMS_DTE_CAG_PYMT_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Payment of Land Charge Interest | ||
93 | INT_START_DATE | CMS_DTE_CAG_LCHG_INT_START_DAT | CMS_DATE | DATS | 8 | 0 | Start Date for Land Charge Interest Calculation | ||
94 | NUM_YR_LCHG_INT | CMS_DTE_CAG_LCHG_INT_YR | CMS_CAG_LCHG_INT_YR | NUMC | 4 | 0 | Number of Years the Land Charge Interest can be Capitalized | ||
95 | .INCLUDE | 0 | 0 | Enforcement details for a land charge | |||||
96 | IND_ENFORCMT_TYP | CMS_DTE_IND_CAG_LCHG_ENFC_TYP | CMS_IND_CAG_LCHG_ENFC_TYP | CHAR | 2 | 0 | Enforcement Type | ||
97 | ENFORCMT_AMT | CMS_DTE_CAG_LCHG_ENFC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Enforcement Amount | ||
98 | ENFORCMT_CURR | CMS_DTE_CAG_LCHG_ENFC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Enforcement Amount of Land Charge | * | |
99 | REF_ENFORCMT_AMT | CMS_DTE_CAG_LCHG_ENFC_REF_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reference amount for part (Equal,Secondar) enforcebility | ||
100 | RANK | CMS_DTE_CAG_LCHG_ENFC_RANK | CMS_CAG_LCHG_ENFC_RANK | NUMC | 4 | 0 | Rank of the Land Charge Enforceable Amount | ||
101 | ENFORCMT_TITLE | CMS_DTE_IND_CAG_LCHG_ENFC_TITL | CMS_IND_CAG_LCHG_ENFC_TITLE | CHAR | 2 | 0 | Indicator for Enforcement Title | ||
102 | .INCLUDE | 0 | 0 | Heritable building right (HBR) details | |||||
103 | UNIT_INT_FREQ | CMS_DTE_IND_CAG_HBR_INT_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | Unit for period of Payment Frequency of HBR interest | ||
104 | PERIOD_INT_FREQ | CMS_DTE_CAG_HBR_INT_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Payment Frequency Period for HBR interest | ||
105 | FLG_INTEREST_INC | CMS_DTE_FLG_LCHG_INC_INT | CMS_FLG_LCHG_INC_INT | CHAR | 1 | 0 | Flag for increase in HBR interest | ||
106 | UNIT_INC_FREQ | CMS_DTE_IND_CAG_HBR_INC_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | Unit for Frequency Period of Increase in HBR Interest | ||
107 | PERIOD_INC_FREQ | CMS_DTE_CAG_HBR_INC_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Frequency Period for Increase in HBR Interest | ||
108 | INC_PCT | CMS_DTE_CAG_LCHG_INC_PCT | CMS_PCT | DEC | 10 | 6 | Percentage Increase in Heritable Building Rights Amount | ||
109 | INC_AMT | CMS_DTE_CAG_LCHG_INC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Increase in Heritable Building Rights Amount | ||
110 | INC_CURR | CMS_DTE_CAG_LCHG_INC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Increase in HBR amount | * | |
111 | INC_START_DATE | CMS_DTE_CAG_LCHG_INC_START_DAT | CMS_DATE | DATS | 8 | 0 | Start date for Increase in Heritable Building Right Interest | ||
112 | IND_HBR_WAIVER | CMS_DTE_IND_CAG_LCHG_HBR_WAIVE | CMS_IND_CAG_LCHG_HBR_WAIVER | CHAR | 2 | 0 | Indicator for Waiver of HBR Enforcement | ||
113 | INC_LAST_DATE | CMS_DTE_CAG_LCHG_INC_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of Increase in Heritable Building Right Interest | ||
114 | .INCLUDE | 0 | 0 | Land Charge specific details | |||||
115 | FLG_COLL_LCHG | CMS_DTE_FLG_CAG_LCHG_COLL | CMS_FLG_CAG_LCHG_COLLECTIVE | CHAR | 1 | 0 | Flag: Collective Land Charge | ||
116 | FLG_CHARGE_CERT | CMS_DTE_FLG_CAG_LCHG_CERT | CMS_FLG_LCHG_CERT | CHAR | 1 | 0 | Flag: Land Charge certificate exists | ||
117 | CHARGE_CERT_NUM | CMS_DTE_CAG_LCHG_CERT_NUM | CMS_LCHG_CERT_NUM | CHAR | 30 | 0 | Charge Certificate Number | ||
118 | FILE_NUM | CMS_DTE_CAG_LCHG_FILE_NUM | CMS_LCHG_FILE_NUM | CHAR | 30 | 0 | File Number | ||
119 | .INCLUDE | 0 | 0 | Insurance Coverage data | |||||
120 | SCOPE_INS_COVER | CMS_DTE_CAG_ATT_ID_TY_CAG004 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Scope of Cover of Credit Insurance | TCMS_ATT_ID_TY | |
121 | .INCLUDE | 0 | 0 | Organization unit structure: Collateral Agreements | |||||
122 | ORG_UNIT1 | CMS_DTE_CAG_ORG_UNIT1 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 1: Collateral Agreement | * | |
123 | ORG_UNIT2 | CMS_DTE_CAG_ORG_UNIT2 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 2: Collateral Agreement | * | |
124 | ORG_UNIT3 | CMS_DTE_CAG_ORG_UNIT3 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 3: Collateral Agreement | * | |
125 | ORG_UNIT4 | CMS_DTE_CAG_ORG_UNIT4 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 4: Collateral Agreement | * | |
126 | ORG_UNIT5 | CMS_DTE_CAG_ORG_UNIT5 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 5: Collateral Agreement | * | |
127 | .INCLUDE | 0 | 0 | Liquidation data | |||||
128 | LIQD_MODE | CMS_DTE_LIQD_MODE | CMS_LIQD_MODE | CHAR | 6 | 0 | Mode of Liquidation decision for the pool agreement | TCMS_LIQD_MODE | |
129 | .INCLUDE | 0 | 0 | Correspondence related attributes for CAG | |||||
130 | COR_ROLE | CMS_DTE_COR_ROLE | CORR_ROLE_KK | CHAR | 4 | 0 | Correspondence role | TFK070M | |
131 | .INCLUDE | 0 | 0 | Agreement Thresholds | |||||
132 | REL_THRESHOLD | CMS_DTE_CAG_RELEASE_THRESHOLD | CMS_PCT | DEC | 10 | 6 | Limit above which the Collaterals can be Released from Pool | ||
133 | .INCLUDE | 0 | 0 | Additional Costs used in the calculation of Prior Charges | |||||
134 | ADDITIONAL_COST | CMS_DTE_CAG_ADDL_COST | CMS_AMOUNT | CURR | 17 | 2 | Additional Costs for Calculation of Prior Charges | ||
135 | CURRENCY | CMS_DTE_CAG_ADDL_COST_CURR | WAERS | CUKY | 5 | 0 | Currency for Additional Cost used in Calc of Prior Charges | * | |
136 | .INCLUDE | 0 | 0 | Currencies for Agreement | |||||
137 | REF_ENFORCMT_CURR | CMS_DTE_CAG_LCHG_ENFC_REF_CURR | WAERS | CUKY | 5 | 0 | Currency for reference amount for part enforcebility | * | |
138 | HOUSE_CURR | CMS_DTE_HOUSE_CURR | WAERS | CUKY | 5 | 0 | House Currency | * | |
139 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
140 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
141 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
142 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
143 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
144 | SOURCEOFENTRY | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE | CHAR | 32 | 0 | Source of Entry | ||
145 | .INCLUDE | 0 | 0 | Dates for timestamp fields | |||||
146 | VALID_FROM_SCR | CMS_DTE_CAG_SCR_VALID_FROM | CMS_DATE | DATS | 8 | 0 | Collateral Agreement Document Valid-from Date | ||
147 | VALID_TO_SCR | CMS_DTE_CAG_SCR_VALID_TO | CMS_DATE | DATS | 8 | 0 | Collateral Agreement Document Valid-to Date | ||
148 | .INCLUDE | 0 | 0 | Active System Statuses | |||||
149 | SYS_STAT | CMS_DTE_SYS_STAT_LINE | TEXT40 | CHAR | 40 | 0 | System Status | ||
150 | .INCLUDE | 0 | 0 | Active User Statuses | |||||
151 | USR_STAT | CMS_DTE_USR_STAT_LINE | TEXT40 | CHAR | 40 | 0 | User Status | ||
152 | .INCLUDE | 0 | 0 | New System Statuses | |||||
153 | SYS_STAT_NEW | CMS_DTE_SYS_STAT_LINE | TEXT40 | CHAR | 40 | 0 | System Status | ||
154 | .INCLUDE | 0 | 0 | New User Statuses | |||||
155 | USR_STAT_NEW | CMS_DTE_USR_STAT_LINE | TEXT40 | CHAR | 40 | 0 | User Status | ||
156 | NAME | CMS_DTE_CAG_TYP_NAME | CMS_NAME | CHAR | 40 | 0 | Name of Collateral Agreement Type | ||
157 | CREATED_DATE | CMS_DTE_DATE | CMS_DATE | DATS | 8 | 0 | Date | ||
158 | CREATED_TIME | CMS_DTE_TIME | CMS_TIME | TIMS | 6 | 0 | Time | ||
159 | CHANGED_DATE | CMS_DTE_DATE | CMS_DATE | DATS | 8 | 0 | Date | ||
160 | CHANGED_TIME | CMS_DTE_TIME | CMS_TIME | TIMS | 6 | 0 | Time | ||
161 | ADMIN_ORG_SCR | CMS_DTE_ADMINORG_KEY | CMS_ADMINORG_KEY | CHAR | 12 | 0 | Administration Organizational Unit (Key conversion) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMS_STR_CAG_SCR | ASGMT_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
2 | CMS_STR_CAG_SCR | ASMT_CURR | TCURC | WAERS | |||
3 | CMS_STR_CAG_SCR | COR_ROLE | TFK070M | CORR_ROLE | |||
4 | CMS_STR_CAG_SCR | COUNTRY_KEY | T005 | LAND1 | |||
5 | CMS_STR_CAG_SCR | LIQD_MODE | TCMS_LIQD_MODE | LIQD_MODE | |||
6 | CMS_STR_CAG_SCR | MIN_QL_CRITE | TCMS_CAG_MQCRT | MIN_QL_CRITERION | REF | 1 | CN |
7 | CMS_STR_CAG_SCR | MIN_QL_EXCEP_TYP | TCMS_CAG_MQEXP | MIN_QL_EXCEP_TYP | REF | 1 | CN |
8 | CMS_STR_CAG_SCR | MIN_QL_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | |||
9 | CMS_STR_CAG_SCR | MIN_STOCK_CURR | TCURC | WAERS | |||
10 | CMS_STR_CAG_SCR | NOM_VALUE_CURR | TCURC | WAERS | |||
11 | CMS_STR_CAG_SCR | SCOPE_INS_COVER | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
12 | CMS_STR_CAG_SCR | TERM_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 110 |