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