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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in