SAP ABAP Table CMS_CAG (Collateral Agreement Details)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE (Package) Collateral Management System
⤷ FS-CMS-MD (Application Component) Master Data
⤷ CMS_CORE (Package) Collateral Management System
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CMS_CAG | Table Relationship Diagram |
Short Description | Collateral Agreement Details |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | Primary Key for CMS_CAG | |||||
3 | CAG_GUID | CMS_DTE_CAG_GUID | SYSUUID | RAW | 16 | 0 | GUID for Table CMS_CAG | ||
4 | .INCLUDE | 0 | 0 | Semantic Key for Table CMS_CAG | |||||
5 | CAGMTID | CMS_DTE_CAGID | CMS_CAGID | CHAR | 40 | 0 | Collateral Agreement ID | ||
6 | CAGMT_TYPE | CMS_DTE_CAG_TYP | CMS_CAG_TYP | CHAR | 6 | 0 | Collateral Agreement Type | TCMS_CAG_TYP | |
7 | .INCLUDE | 0 | 0 | Collateral Agreement Details | |||||
8 | .INCLUDE | 0 | 0 | Nominal Value for Collateral Agreement | |||||
9 | NOM_VALUE | CMS_DTE_CAG_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Collateral Agreement | ||
10 | NOM_VALUE_CURR | CMS_DTE_CAG_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Currency for Nominal Value of the Collateral Agreement | TCURC | |
11 | .INCLUDE | 0 | 0 | Assessment Value details for a Collateral Agreement | |||||
12 | ASMT_AMT | CMS_DTE_CAG_ASMT_AMT | CMS_AMOUNT | CURR | 17 | 2 | Assessment Amount | ||
13 | ASMT_CURR | CMS_DTE_CAG_ASMT_CURR | WAERS | CUKY | 5 | 0 | Currency of Assessment Value | TCURC | |
14 | ASMT_DATE | CMS_DTE_CAG_ASMT_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Assessment Value was Calculated | ||
15 | .INCLUDE | 0 | 0 | Collateral Agreement Dates (DB Format ) | |||||
16 | CAGMT_DATE | CMS_DTE_CAG_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Collateral Agreement was Concluded | ||
17 | VALID_FROM | CMS_DTE_CAG_VALID_FROM | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-from Date | ||
18 | VALID_TO | CMS_DTE_CAG_VALID_TO | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-to Date | ||
19 | .INCLUDE | 0 | 0 | Basic data for a Collateral Agreement | |||||
20 | .INCLUDE | 0 | 0 | Administrative organization unit | |||||
21 | ADMIN_ORG_UNIT | CMS_DTE_ADMINORG | TEXT12 | CHAR | 12 | 0 | Administration Organizational Unit | ||
22 | .INCLUDE | 0 | 0 | Bank area | |||||
23 | BANKAREA | CMS_DTE_BANKAREA | CMS_BANKAREA | CHAR | 4 | 0 | Bank Area in Collateral Management | * | |
24 | COUNTRY_KEY | CMS_DTE_COUNTRY_KEY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | * | |
25 | FLG_GLOBAL | CMS_DTE_FLG_CAG_GLOBAL | CMS_FLG_GLOBAL_CAGMT | CHAR | 1 | 0 | Flag to indicate a Global Collateral Agreement | ||
26 | SPL_MARKDOWN_PCT | CMS_DTE_CAG_SPL_MARKDOWN_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Special Markdown | ||
27 | SPL_MARKDOWN_AMT | CMS_DTE_CAG_SPL_MARKDOWN_AMT | CMS_AMOUNT | CURR | 17 | 2 | Amount of Special Markdown | ||
28 | SPL_MRKDOWN_CURR | CMS_DTE_CAG_SPL_MRKDWN_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Special Markdown | * | |
29 | DESCRIPTION | CMS_DTE_CAG_DESC | CMS_DSC | CHAR | 30 | 0 | Description of Collateral Agreement | ||
30 | 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 | ||
31 | PERIOD_REL_FREQ | CMS_DTE_CAG_REL_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Release of Collateral Agreement | ||
32 | OLD_CAGMTID | CMS_DTE_OLD_CAGID | CMS_OLD_CAGID | CHAR | 40 | 0 | External/Old Collateral Agreement ID | ||
33 | .INCLUDE | 0 | 0 | Basel II relevant data | |||||
34 | 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 | |
35 | 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 | |
36 | 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) | ||
37 | MIN_QL_CRITE | CMS_DTE_CAG_MIN_QUAL_CRITERION | CMS_CAG_MIN_QUAL_CRITERION | CHAR | 6 | 0 | MInimum Qualitative Criterion | TCMS_CAG_MQCRT | |
38 | .INCLUDE | 0 | 0 | Asset details for a Collateral Agreement | |||||
39 | PCT_ASSET_VAL | CMS_DTE_PCT_AST_VAL | CMS_PCT | DEC | 10 | 6 | Percentage of the Asset Value used in Collateral Agreement | ||
40 | .INCLUDE | 0 | 0 | Termination rights data | |||||
41 | TERM_RIGHT_TYP | CMS_DTE_TERM_RIGHT_TYP | CMS_CAG_TERM_RIGHT_TYP | CHAR | 6 | 0 | Termination Right Type | * | |
42 | FIRST_TERM_DATE | CMS_DTE_CAG_TERM_FSTPOS_DATE | CMS_DATE | DATS | 8 | 0 | First possible date of termination | ||
43 | 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 | ||
44 | PERIOD_TERM_FREQ | CMS_DTE_CAG_TERM_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Termination of Collateral Agreement | ||
45 | 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 | ||
46 | REQ_NOTICE_PRD | CMS_DTE_CAG_NOTICE_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Notice Period Required to Terminate Collateral Agreement | * | |
47 | TERM_NOTICE_DATE | CMS_DTE_CAG_TERM_NOTICE_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Termination Notice was Sent | ||
48 | TERM_REASON | CMS_DTE_CAG_ATT_ID_TY_CAG002 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Termination Type | TCMS_ATT_ID_TY | |
49 | TERM_GUAR_AMT | CMS_DTE_CAG_TERM_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Amount of Guarantee in the event of Termination | ||
50 | TERMINATION_CURR | CMS_DTE_CAG_TERM_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Guarantee in the event of Termination | * | |
51 | .INCLUDE | 0 | 0 | Guarantee specific data | |||||
52 | .INCLUDE | 0 | 0 | Guarantee specific details | |||||
53 | GUAR_RATE | CMS_DTE_CAG_GUAR_RATE | CMS_PCT | DEC | 10 | 6 | Guarantee Rate | ||
54 | FLG_COUNTER_GUAR | CMS_DTE_FLG_CAG_CNTR_GUAR | CMS_FLG_CNTR_GUAR | CHAR | 1 | 0 | Flag for Counter Guarantee | ||
55 | FLG_CO_GUAR | CMS_DTE_FLG_CAG_CO_GUAR | CMS_FLG_CO_GUAR | CHAR | 1 | 0 | Flag for Co-guarantee | ||
56 | FLG_FIXED_LIABTY | CMS_DTE_FLG_CAG_FIXED_LIABILTY | CMS_FLG_FIXED_LIABILITY | CHAR | 1 | 0 | Flag for Fixed Liability | ||
57 | FLG_DEF_LIABTY | CMS_DTE_FLG_CAG_DEF_LIABILITY | CMS_FLG_DEF_LIABILITY | CHAR | 1 | 0 | Flag for Default Liability | ||
58 | PCT_DEF_LIABTY | CMS_DTE_FLG_CAG_PCT_DEF_LIABTY | CMS_PCT | DEC | 10 | 6 | Default Liability in % | ||
59 | 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 | ||
60 | IND_APPR_AUTH | CMS_DTE_IND_CAG_APPR_AUTH | CMS_IND_CAG_APPR_AUTH | CHAR | 2 | 0 | Approval from authorities | ||
61 | FLG_ENFORCEABLE | CMS_DTE_FLG_CAG_ENFORCEABLE | CMS_FLG_DIR_ENFC | CHAR | 1 | 0 | Agreement directly enforceable | ||
62 | LENDING_RATE | CMS_DTE_CAG_LRTE_PCT | CMS_PCT | DEC | 10 | 6 | Lending Rate of a Guarantee | ||
63 | .INCLUDE | 0 | 0 | Reduction relation data | |||||
64 | 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 | ||
65 | 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 | ||
66 | REDU_AMT | CMS_DTE_CAG_REDU_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reduction in Amount of Guarantee | ||
67 | REDU_CURR | CMS_DTE_CAG_REDU_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Reduced Amount of the Guarantee | * | |
68 | REDU_PCT | CMS_DTE_CAG_REDU_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Reduction in the Value of a Guarantee | ||
69 | REDU_START_DATE | CMS_DTE_CAG_REDU_START_DATE | CMS_DATE | DATS | 8 | 0 | Date from which Guarantee Value is Reduced | ||
70 | REDU_END_DATE | CMS_DTE_CAG_REDU_END_DATE | CMS_DATE | DATS | 8 | 0 | End Date for Reduction in Amount of Guarantee | ||
71 | REDU_LAST_DATE | CMS_DTE_CAG_REDU_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of reduction of value | ||
72 | .INCLUDE | 0 | 0 | Transfer specific details | |||||
73 | FLG_LEASING_TXN | CMS_DTE_FLG_CAG_LEASING_TXN | CMS_FLG_LEASING_TRANSACTION | CHAR | 1 | 0 | Flag: Transfer is part of a leasing transaction | ||
74 | IND_LESSOR_LIEN | CMS_DTE_IND_CAG_LESSOR_LIEN | CMS_IND_CAG_LESSOR_LIEN | CHAR | 2 | 0 | Indicator for Lessor Lien on Collateral Agreement | ||
75 | IND_ACC_LIABLE | CMS_DTE_IND_CAG_ACC_LIABLE | CMS_IND_CAG_ACC_LIABLE | CHAR | 2 | 0 | Specifies the applicability of accessories liability | ||
76 | 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 | ||
77 | .INCLUDE | 0 | 0 | Minimum stock data | |||||
78 | MIN_STOCK_AMT | CMS_DTE_CAG_MIN_STOCK_AMT | CMS_AMOUNT | CURR | 17 | 2 | Minimum stock Amount agreed in the Collateral Agreement | ||
79 | MIN_STOCK_CURR | CMS_DTE_CAG_MIN_STOCK_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Minimum Stock Amount | TCURC | |
80 | FLG_ADDNL_RBL | CMS_DTE_FLG_CAG_ADDNL_RBL | CMS_FLG_ADDNL_RBL | CHAR | 1 | 0 | Flag for Additional receivable | ||
81 | ADDNL_RBL_DATE | CMS_DTE_CAG_DATE_ADDNL_RBL | CMS_DATE | DATS | 8 | 0 | Date on which Additional Receivable was Accepted | ||
82 | .INCLUDE | 0 | 0 | Pledge/Assignment details | |||||
83 | IND_GBC_LIEN | CMS_DTE_IND_CAG_GBC_LIEN | CMS_IND_CAG_GBC_LIEN | CHAR | 2 | 0 | GBC Lien on Agreement | ||
84 | 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 | ||
85 | DISCL_DATE | CMS_DTE_CAG_DISCL_DATE | CMS_DATE | DATS | 8 | 0 | Date of Disclosure to Third-party Debtor | ||
86 | .INCLUDE | 0 | 0 | Assignment reason | |||||
87 | ASGMT_REASON | CMS_DTE_CAG_ATT_ID_TY_CAG006 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Reason for Assignment | TCMS_ATT_ID_TY | |
88 | .INCLUDE | 0 | 0 | Land Charge specific data | |||||
89 | .INCLUDE | 0 | 0 | Land Charge specific interest details | |||||
90 | INT_RATE | CMS_DTE_CAG_LCHG_INT_RATE | CMS_PCT | DEC | 10 | 6 | Land Charge Interest Rate | ||
91 | INCIDENTAL_PAYMT | CMS_DTE_CAG_LCHG_INCD_PAYMT | CMS_PCT | DEC | 10 | 6 | Incidental Payments in Percentage | ||
92 | 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 | ||
93 | 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 | ||
94 | INT_START_DATE | CMS_DTE_CAG_LCHG_INT_START_DAT | CMS_DATE | DATS | 8 | 0 | Start Date for Land Charge Interest Calculation | ||
95 | 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 | ||
96 | .INCLUDE | 0 | 0 | Enforcement details for a land charge | |||||
97 | IND_ENFORCMT_TYP | CMS_DTE_IND_CAG_LCHG_ENFC_TYP | CMS_IND_CAG_LCHG_ENFC_TYP | CHAR | 2 | 0 | Enforcement Type | ||
98 | ENFORCMT_AMT | CMS_DTE_CAG_LCHG_ENFC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Enforcement Amount | ||
99 | ENFORCMT_CURR | CMS_DTE_CAG_LCHG_ENFC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Enforcement Amount of Land Charge | * | |
100 | REF_ENFORCMT_AMT | CMS_DTE_CAG_LCHG_ENFC_REF_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reference amount for part (Equal,Secondar) enforcebility | ||
101 | RANK | CMS_DTE_CAG_LCHG_ENFC_RANK | CMS_CAG_LCHG_ENFC_RANK | NUMC | 4 | 0 | Rank of the Land Charge Enforceable Amount | ||
102 | ENFORCMT_TITLE | CMS_DTE_IND_CAG_LCHG_ENFC_TITL | CMS_IND_CAG_LCHG_ENFC_TITLE | CHAR | 2 | 0 | Indicator for Enforcement Title | ||
103 | .INCLUDE | 0 | 0 | Heritable building right (HBR) details | |||||
104 | 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 | ||
105 | PERIOD_INT_FREQ | CMS_DTE_CAG_HBR_INT_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Payment Frequency Period for HBR interest | ||
106 | FLG_INTEREST_INC | CMS_DTE_FLG_LCHG_INC_INT | CMS_FLG_LCHG_INC_INT | CHAR | 1 | 0 | Flag for increase in HBR interest | ||
107 | 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 | ||
108 | PERIOD_INC_FREQ | CMS_DTE_CAG_HBR_INC_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Frequency Period for Increase in HBR Interest | ||
109 | INC_PCT | CMS_DTE_CAG_LCHG_INC_PCT | CMS_PCT | DEC | 10 | 6 | Percentage Increase in Heritable Building Rights Amount | ||
110 | INC_AMT | CMS_DTE_CAG_LCHG_INC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Increase in Heritable Building Rights Amount | ||
111 | INC_CURR | CMS_DTE_CAG_LCHG_INC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Increase in HBR amount | * | |
112 | INC_START_DATE | CMS_DTE_CAG_LCHG_INC_START_DAT | CMS_DATE | DATS | 8 | 0 | Start date for Increase in Heritable Building Right Interest | ||
113 | 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 | ||
114 | INC_LAST_DATE | CMS_DTE_CAG_LCHG_INC_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of Increase in Heritable Building Right Interest | ||
115 | .INCLUDE | 0 | 0 | Land Charge specific details | |||||
116 | FLG_COLL_LCHG | CMS_DTE_FLG_CAG_LCHG_COLL | CMS_FLG_CAG_LCHG_COLLECTIVE | CHAR | 1 | 0 | Flag: Collective Land Charge | ||
117 | FLG_CHARGE_CERT | CMS_DTE_FLG_CAG_LCHG_CERT | CMS_FLG_LCHG_CERT | CHAR | 1 | 0 | Flag: Land Charge certificate exists | ||
118 | CHARGE_CERT_NUM | CMS_DTE_CAG_LCHG_CERT_NUM | CMS_LCHG_CERT_NUM | CHAR | 30 | 0 | Charge Certificate Number | ||
119 | FILE_NUM | CMS_DTE_CAG_LCHG_FILE_NUM | CMS_LCHG_FILE_NUM | CHAR | 30 | 0 | File Number | ||
120 | .INCLUDE | 0 | 0 | Insurance Coverage data | |||||
121 | 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 | |
122 | .INCLUDE | 0 | 0 | Organization unit structure: Collateral Agreements | |||||
123 | ORG_UNIT1 | CMS_DTE_CAG_ORG_UNIT1 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 1: Collateral Agreement | * | |
124 | ORG_UNIT2 | CMS_DTE_CAG_ORG_UNIT2 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 2: Collateral Agreement | * | |
125 | ORG_UNIT3 | CMS_DTE_CAG_ORG_UNIT3 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 3: Collateral Agreement | * | |
126 | ORG_UNIT4 | CMS_DTE_CAG_ORG_UNIT4 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 4: Collateral Agreement | * | |
127 | ORG_UNIT5 | CMS_DTE_CAG_ORG_UNIT5 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 5: Collateral Agreement | * | |
128 | .INCLUDE | 0 | 0 | Liquidation data | |||||
129 | LIQD_MODE | CMS_DTE_LIQD_MODE | CMS_LIQD_MODE | CHAR | 6 | 0 | Mode of Liquidation decision for the pool agreement | * | |
130 | .INCLUDE | 0 | 0 | Correspondence related attributes for CAG | |||||
131 | COR_ROLE | CMS_DTE_COR_ROLE | CORR_ROLE_KK | CHAR | 4 | 0 | Correspondence role | TFK070M | |
132 | .INCLUDE | 0 | 0 | Agreement Thresholds | |||||
133 | REL_THRESHOLD | CMS_DTE_CAG_RELEASE_THRESHOLD | CMS_PCT | DEC | 10 | 6 | Limit above which the Collaterals can be Released from Pool | ||
134 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
135 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
136 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
137 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
138 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
139 | SOURCEOFENTRY | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE | CHAR | 32 | 0 | Source of Entry |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMS_CAG | ASGMT_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
2 | CMS_CAG | ASMT_CURR | TCURC | WAERS | REF | 1 | CN |
3 | CMS_CAG | CAGMT_TYPE | TCMS_CAG_TYP | CAGMT_TYPE | REF | 1 | CN |
4 | CMS_CAG | COR_ROLE | TFK070M | CORR_ROLE | |||
5 | CMS_CAG | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | CMS_CAG | MIN_QL_CRITE | TCMS_CAG_MQCRT | MIN_QL_CRITERION | REF | 1 | CN |
7 | CMS_CAG | MIN_QL_EXCEP_TYP | TCMS_CAG_MQEXP | MIN_QL_EXCEP_TYP | REF | 1 | CN |
8 | CMS_CAG | MIN_QL_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | |||
9 | CMS_CAG | MIN_STOCK_CURR | TCURC | WAERS | REF | 1 | CN |
10 | CMS_CAG | NOM_VALUE_CURR | TCURC | WAERS | REF | 1 | CN |
11 | CMS_CAG | SCOPE_INS_COVER | TCMS_ATT_ID_TY | INDICATOR_TYPE | |||
12 | CMS_CAG | TERM_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 110 |