| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | /BA1/TF4_YCURVE | /BA1/F4_DTE_MDCODE | Allow NULL? |
| 3 | YCTYPE | Yield Curve Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | /BA1/TF4_YCURVE | /BA1/F4_DTE_YCTYPE | Allow NULL? |
| 4 | CCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | /BA1/TF4_YCURVE | WAERS | Allow NULL? |
| 5 | SPRDTYPE | Spread Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BA1/TF4_SPRDTYP | /BA1/F4_DTE_SPRDTYPE | Allow NULL? |
| 6 | DAY_CNT_METH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH_NEW | Allow NULL? |
| 7 | CALC_METHOD | Calculation Procedure for Yield Curve | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_CALC_METH | Allow NULL? |
| 8 | EXTRAPOL_METH | Extrapolation Method for Yield Curves | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_XTRP_METH | Allow NULL? |
| 9 | MAX_AGE | Maximum Age of Interest Rate | int | 10 | 0 | INT4 | ((0)) | Yes | | /BA1/F4_DTE_MAX_AGE_IR | Allow NULL? |
| 10 | MAX_AGE_SPREAD | Maximum Age of Spread | int | 10 | 0 | INT4 | ((0)) | Yes | | /BA1/F4_DTE_MAX_AGE_SPRD | Allow NULL? |
| 11 | SKALID | Factory calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | SKALID | Allow NULL? |
| 12 | PAYMNT_RHYTHM | Payment Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_PAYMNT_RHYTHM | Allow NULL? |
| 13 | COMP_FREQ | Compounding Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_COMP_FREQ | Allow NULL? |
| 14 | DAY_SHIFT | Working Day Shift for Yield Curve | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /BA1/F4_DTE_DAY_SHIFT | Allow NULL? |
| 15 | WRK_DAY_SHIFT | Working Day Shift for Due Date | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SFWERK | Allow NULL? |
| 16 | MONTH_END_MAT | Maturity Dates at Month End | char | 1 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_MONTH_END_MATURITY | Allow NULL? |
| 17 | PAR_CALC_METH | Process for Calculating Par Bond Yields | char | 1 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_PAR_CALC_METH | Allow NULL? |
| 18 | PAR_CALC_SWITCH | Max. Term (Years) for Exponential Calc. of Par Bond Yield | decimal | 3 | 0 | DEC | ((0)) | Yes | | /BA1/F4_DTE_PAR_CALC_SWITCH | |
| 19 | YC_MODEL | External Model for Yield Curve | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | /BA1/F4_DTE_YC_MODEL | Allow NULL? |
| 20 | XINTRAD | Yield Curve: Can be Used for Intraday Interest Rates | char | 1 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_YC_XINTRAD | Allow NULL? |
| 21 | MAX_TIME | Maximum Time Interval for Intraday Interest Rates (Seconds) | int | 10 | 0 | INT4 | ((0)) | Yes | | /BA1/F4_DTE_MAX_TIME_IR | Allow NULL? |
