SAP table JBD14 (Yield Curve Types (Header Information))
SAP table JBD14 has 3 primary key fields being MANDT,SZKART,WWAER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Yield Curve Type
NUMC
4
0
JBD1
JBSZKART
Currency
CUKY
5
0
TCURC
JBWWAER
SZBMETH
Interest Calculation Method
CHAR
1
0
SZBMETH
Possible values
0
Not Specified
1
360E/360
2
act/360
3
act/365
4
act/366
5
act/actP (ICMA)
6
act/actY (ISDA)
7
360/360
8
30.42E/360
9
*365.25/360
A
actW/252
B
360E/365
C
365/365
D
365/360
E
act/364
F
360/360 (ISDA)
G
act/actE (AFB)
H
360/365 (ISDA)
I
360E/actY
J
m+act/360
K
m+30/360
L
360/360 (German)
M
act/365P
N
act/365L
P
1/1
Q
act/actEP (AFB)
R
act/365.25
S
act/365Y
T
act/act[M]
U
actW/actW[M]
SKALID
Factory calendar
CHAR
2
0
SKALID
SQUOTART
Quotation type
NUMC
1
0
SQUOTART
RENDTYP
Yield category
CHAR
1
0
JBRENDTYP
Possible values
0
Par rate
1
Zero bond yield
RINTTYP
Interpolation Procedure
CHAR
1
0
JBRINTTYP
Possible values
0
Linear interpolation
1
Cubic spline interpolation
RINTBASTYP
Interpolation basis
CHAR
1
0
JBRINTBASTYP
Possible values
RWERTZL
Read Procedure for Accessing Ref. Interest Rate Table
CHAR
1
0
JBRWERTZL
Possible values
0
Read back
1
Read directly
2
Read back directly
TIMEDEP
Datafeed: Indicator for intraday rates/prices
CHAR
1
0
TB_TIMEDEP
CCUSE
Use Continuous Compounding
CHAR
1
0
JBDCCUSE
CCEXTRAPOL
Extrapolation Acc. to Last Grid Point (Cont. Compounding)
INT4
10
0
JBDCCEXTRAPOL
Possible values
1
As for yield category
2
Zero rate constant
3
Par rate constant
4
Continuous compounding forward rate constant
JBD14 foreign key relationships
Table
Field
Check Table
Check Field
0 JBD14
MANDT
T000 Clients
MANDT
1 JBD14
WWAER
TCURC Currency Codes
MANDT
1 JBD14
WWAER
TCURC Currency Codes
WAERS