SAP ABAP Table JBIUDERIV (Transfer Structure for Derivatives)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-DP (Application Component) Transaction Data Pool
     ⤷ JBD (Package) Application development IS-B Data Pool

Basic Data

Table Category	INTTAB	Structure
Structure	JBIUDERIV	Table Relationship Diagram
Short Description	Transfer Structure for Derivatives

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	Transaction
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
5	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
6	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
7	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
9	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
10	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
11	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
12	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
13	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
14	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
15	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
16	RGATT	☐	TI_RGATT	T_RGATT	CHAR	13	0	Class
17	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
18	RFHAZUNR	☐	TB_RFHAZUN	T_RFHAZU	NUMC	5	0	Number status of activity
19	RFHAZUL	☐	TB_RFHAZUL	T_RFHAZU	NUMC	5	0	Last Active Transaction Activity
20	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
21	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
22	SROLEXT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field	*
23	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
24	RREFKONT	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
25	RREFKONT2	☐	RREFKONT_OBSOLETE	USTRU	CHAR	8	0	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	T037S
26	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
27	WGSCHFT	☐	TB_WGSCHFT	WAERS	CUKY	5	0	Currency of transaction	TCURC
28	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
29	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
30	AMTINPUT	☐	TB_AMTIN	TX_AMTIN	CHAR	1	0	Note field for traded amount forex transactions
31	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
32	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
33	SKALID2	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
34	JLIMIT	☐	TB_JLIMIT	XFELD	CHAR	1	0	Limit indicator
35	AKUEND	☐	TB_AKUEND	T_AKUEND	NUMC	2	0	Period of Notice
36	SKUEND	☐	TB_SKUEND	T_SKUEND	NUMC	1	0	Unit of Period of Notice
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
38	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
39	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
40	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
41	ABWTYP	☐	TB_ABWTYP	T_ABWTYP	CHAR	5	0	Processing Category	AT05
42	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	TRBRG
43	VRFHA	☐	TB_VORFHA	T_RFHA	CHAR	13	0	Reference transaction (Rollover/premature settlement)	*
44	SINCLBE	☐	TB_SINCLBE	T_SINCLBE	CHAR	1	0	Calculation Period: Start Inclusive vs. End Inclusive
45	SNPVCAL	☐	TB_SNPVCAL	T_SNPVCAL	CHAR	1	0	NPV Calculation
46	SRNDNG	☐	TB_SRNDNG	TFM_SROUND	CHAR	1	0	Rounding of Amount from Generated Flows
47	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
48	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
49	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
50	SFRGZUST	☐	TB_FRGZUST	T_FRGZUST	CHAR	1	0	Transaction Release: Release Status
51	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
52	RCOMVALCL	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
53	FACILITYNR	☐	TB_FACILITYNR	T_RFHA	CHAR	13	0	Transaction Number of Facility	VTBFHA
54	FACILITYBUKRS	☐	TB_FACILITYBUKRS	BUKRS	CHAR	4	0	Company Code of Facility	T001
55	POSACC	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
56	RCOMVALCL2	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
57	TIMESTAMP_DEAL	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
58	RPORTB2	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
59	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
60	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
61	SFUNKTV	☐	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	AT60
62	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	AT60
63	ROFHAZU	☐	TB_ROFHAZU	T_RFHAZU	NUMC	5	0	Previous Activity
64	RFHAZUX	☐	TB_RFHAZUX	T_RFHAZU	NUMC	5	0	Previous activity, which is supplemented by current activity
65	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
66	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
67	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
68	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
69	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
70	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
71	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
72	SINCLE	☐	TB_SINCLE	XFELD	CHAR	1	0	End of Term Inclusive Indicator
73	DZSTND	☐	TB_DZSTND	DATUM	DATS	8	0	Last activity transition date (e.g. for rollover)
74	SZNSPRO	☐	TB_SZNSPRO	T_SZNSPRO	NUMC	1	0	Interest Handling with Rollover
75	DZNSSTD	☐	TB_DZNSSTD	DATUM	DATS	8	0	Payment date for deferred interest
76	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
77	KKASSA	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
78	KSWAP	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
79	WLWAERS	☐	TB_WLWAERS	WAERS	CUKY	5	0	Leading currency	TCURC
80	WFWAERS	☐	TB_WFWAERS	WAERS	CUKY	5	0	Following Currency	TCURL
81	LIMITART	☐	TB_LIMITAR	T_LIMITAR	CHAR	2	0	Limit type	ATOR
82	LIMITDAT	☐	TB_LIMITDA	DATUM	DATS	8	0	Limit date
83	LIWAERS	☐	TB_LIWAERS	WAERS	CUKY	5	0	Reference currency for limit	TCURC
84	KWLIQUI	☐	TX_KWLIQ	T_SWKURS	DEC	13	9	Liquidity effect for rollover
85	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
86	RKOND	☐	TB_KOND	T_KOND	NUMC	4	0	Condition
87	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
88	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
89	SALTKOND	☐	TB_SALKOND	SKONDGRP	NUMC	4	0	Unit for supplementary condition items
90	SZINSANP	☐	SZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
91	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
92	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
93	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
94	SBKKLAS	☐	TB_SBKKLAS	T_SBKKLAS	CHAR	1	0	Classification of flows and conditions
95	SBKTYP	☐	TB_SBKTYP	T_SBKTYP	CHAR	2	0	Category of Flows and Conditions	AT08
96	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
97	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
98	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
99	SBASIS	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
100	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
101	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
102	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
103	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	*
104	SVARNAME	☐	TB_VARNAME	T_XFELD04	CHAR	4	0	Variable Name
105	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
106	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
107	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
108	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
109	SVWERK	☐	TB_SVWERK	T_SWERK	NUMC	1	0	Working Day Shift for Calculation Day
110	SVMETH	☐	TB_SVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
111	AVGSTAGE	☐	TB_AVGSTAG	T_GSTAGE	INT4	10	0	Number of Days for Relative Calculation of Value Date
112	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
113	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
114	SFWERK	☐	TB_SFWERK	T_SWERK	NUMC	1	0	Working Day Shift for Due Date
115	SFMETH	☐	TB_SFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
116	AFGSTAGE	☐	TB_AFGSTAG	T_GSTAGE	INT4	10	0	Number of days for rel. determination of due date
117	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
118	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
119	AZGSTAGE	☐	TB_AZGSTAG	T_GSTAGE	INT4	10	0	No. of days for relative determinatn of interest fixing
120	DZSREF	☐	TB_ZSREF	DATUM	DATS	8	0	Reference interest rate fixing date
121	SHERKUNFT	☐	TB_SHERK	T_XFELD04	CHAR	4	0	Display Area of Flow or Condition
122	SRHYTHM	☐	TB_SRHYTHM	T_SRHYTHM	NUMC	1	0	Frequency Indicator
123	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
124	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
125	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
126	SKURSART	☐	TI_KURSART	VVSKURSART	CHAR	2	0	Rate/Price Type - Treasury Instruments	*
127	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
128	SERBTERM	☐	TFMERBTERM	TFMERBTERM	CHAR	1	0	FiMa indicator: Date and frequency inheritance for condition
129	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
130	MODE	☐	JBSMODE	JBSMODE	CHAR	1	0	Mode of Data Flow

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUDERIV	ABWTYP	AT05	ABWTYP
2	JBIUDERIV	BUKRS	T001	BUKRS
3	JBIUDERIV	FACILITYBUKRS	T001	BUKRS	KEY	1	CN
4	JBIUDERIV	FACILITYNR	VTBFHA	RFHA
5	JBIUDERIV	LIMITART	ATOR	LIMITART
6	JBIUDERIV	LIWAERS	TCURC	WAERS
7	JBIUDERIV	MANDT	T000	MANDT
8	JBIUDERIV	OBJNR	ONR00	OBJNR		1	N
9	JBIUDERIV	POSACC	TRFT_POS_ACCOUNT	POS_ACCOUNT
10	JBIUDERIV	RCOMVALCL	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
11	JBIUDERIV	RCOMVALCL2	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
12	JBIUDERIV	RDEALER	TZDEA	RDEALER
13	JBIUDERIV	RFHA	VTBFHA	RFHA
14	JBIUDERIV	RLDEPO	TWD01	RLDEPO		C	CN
15	JBIUDERIV	RMAID	VTBMA	RMAID		C	CN
16	JBIUDERIV	RPORTB	TWPOB	RPORTB
17	JBIUDERIV	RPORTB2	TWPOB	RPORTB
18	JBIUDERIV	RREFKONT	T037S	RREFKONT
19	JBIUDERIV	RREFKONT2	T037S	RREFKONT
20	JBIUDERIV	SANLF	TZAF	SANLF
21	JBIUDERIV	SBERFIMA	AT40	SBERFIMA
22	JBIUDERIV	SBKTYP	AT08	BKTYP
23	JBIUDERIV	SFGTYP	AT01	SFGTYP
24	JBIUDERIV	SFGZUSTT	AT02	SFGZUSTT
25	JBIUDERIV	SFHAART	AT10	SFHAART
26	JBIUDERIV	SFUNKTL	AT60	SFUNKTION
27	JBIUDERIV	SFUNKTV	AT60	SFUNKTION
28	JBIUDERIV	SGSART	TZPA	GSART
29	JBIUDERIV	SKALID	TFACD	IDENT
30	JBIUDERIV	SKALID2	TFACD	IDENT
31	JBIUDERIV	SKOART	TZK01	SKOART
32	JBIUDERIV	SSTOGRD	TZST	SSTOGRD
33	JBIUDERIV	SWHRKOND	TCURC	WAERS
34	JBIUDERIV	SZSREF	T056R	REFERENZ
35	JBIUDERIV	TBEGRU	TRBRG	TBEGRU
36	JBIUDERIV	WFWAERS	TCURL	FWAERS
37	JBIUDERIV	WGSCHFT	TCURC	WAERS
38	JBIUDERIV	WLWAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in