SAP ABAP Table JBIUDER (Batch Input Structure for Derivatives)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ JBA (Package) Application developmnet IS-B General Development

Basic Data

Table Category	INTTAB	Structure
Structure	JBIUDER	Table Relationship Diagram
Short Description	Batch Input 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
4	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
5	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
7	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
8	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
9	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
10	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
11	XVTRAB	☐	TB_XVTRAB	T_XDATUM	CHAR	10	0	Contract conclusion date
12	XLAVO	☐	TB_XLAVO	T_XDATUM	CHAR	10	0	Term from
13	XLABI	☐	TB_XLABI	T_XDATUM	CHAR	10	0	Term to
14	SINCLE	☐	TB_SINCLE	XFELD	CHAR	1	0	End of Term Inclusive Indicator
15	ZUORNR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
16	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
17	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
18	XKAPBET	☐	TB_XKAPBET	CHAR18	CHAR	18	0	Amount
19	XKAPBETN	☐	TB_XKAPBET	CHAR18	CHAR	18	0	Amount
20	WKAPBET	☐	TB_WKAPBET	WAERS	CUKY	5	0	Currency of Principal Amount - Financial Product	*
21	WKAPBETN	☐	TB_WKAPBET	WAERS	CUKY	5	0	Currency of Principal Amount - Financial Product	*
22	XGUEL_KP	☐	TB_XGUEL	CHAR10	CHAR	10	0	Effective from date
23	XGUEL_KPN	☐	TB_XGUEL	CHAR10	CHAR	10	0	Effective from date
24	XEFAELL	☐	TB_XEFAELL	CHAR10	CHAR	10	0	First due date
25	XEFAELLN	☐	TB_XEFAELL	CHAR10	CHAR	10	0	First due date
26	AMMRHY	☐	JBBI_ARHY	CHAR3	CHAR	3	0	Defined Frequency in Days or Months as CHAR Field
27	AMMRHN	☐	JBBI_ARHY	CHAR3	CHAR	3	0	Defined Frequency in Days or Months as CHAR Field
28	PZINSSV	☐	JBBI_PZSV	CHAR12	CHAR	12	0	Agreed interest rate - financial product
29	PZINSSVN	☐	JBBI_PZSV	CHAR12	CHAR	12	0	Agreed interest rate - financial product
30	SZBMETH	☐	JBBI_SZBM	CHAR1	CHAR	1	0	Interest Calculation Method as CHAR Field
31	SZBMETHN	☐	JBBI_SZBM	CHAR1	CHAR	1	0	Interest Calculation Method as CHAR Field
32	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
33	SZSREFN	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
34	PZZSG	☐	JBBI_PZZS	CHAR12	CHAR	12	0	Interest Markup/Interest Markdown as CHAR Field
35	PZZSN	☐	JBBI_PZZS	CHAR12	CHAR	12	0	Interest Markup/Interest Markdown as CHAR Field
36	SZAPPANFG	☐	TI_SZAP1	XFELD	CHAR	1	0	Int.rate adjust. at start of period
37	SZAPSONSTG	☐	TI_SZAP2	XFELD	CHAR	1	0	Other int.rate adjust.
38	SZAPPANFN	☐	TI_SZAP1	XFELD	CHAR	1	0	Int.rate adjust. at start of period
39	SZAPSONSTN	☐	TI_SZAP2	XFELD	CHAR	1	0	Other int.rate adjust.
40	RZINSR	☐	JBBI_RZINS	JBBI_RZINS	CHAR	1	0	Field for Controlling Incoming/Outgoing Interest
41	SKOART	☐	JBBI_SKOAR	CHAR4	CHAR	4	0	Condition Type as CHAR Field
42	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
43	PKOND	☐	JBBI_PKOND	CHAR12	CHAR	12	0	Percentage Rate of Condition Item as CHAR Field
44	PZZUAB	☐	JBBI_PZZS	CHAR12	CHAR	12	0	Interest Markup/Interest Markdown as CHAR Field
45	SWHRKOND	☐	TBSWHRTZ	WAERS	CUKY	5	0	Currency of interest	*
46	SVWERK	☐	JBBI_SVWRK	CHAR1	CHAR	1	0	Shift Value Date to Working Day as CHAR Field
47	SFWERK	☐	JBBI_SFWRK	CHAR1	CHAR	1	0	Shift Due Date to Working Day as CHAR Field
48	INCLEXLC	☐	TB_INCEX	XFELD	CHAR	1	0	Include/Exclude Indicator
49	ATTRHY	☐	JBBI_TRHY	CHAR3	CHAR	3	0	Update Frequency in Calendar Days as CHAR Field
50	ATTRHN	☐	JBBI_MRHY	CHAR3	CHAR	3	0	Update Frequency in Months as CHAR Field
51	AFGSTAGE	☐	JBBI_AFGST	CHAR4	CHAR	4	0	Shift Due Date towards End of Interest Rate Period
52	SDWERK	☐	JBBI_SDWRK	CHAR1	CHAR	1	0	Due Date Correction (Special Field) as CHAR Field
53	SKALID	☐	TBKALETZ	WFCID	CHAR	2	0	Calendar for working day rules	TFACD
54	SKALID2	☐	TBKALETZ	WFCID	CHAR	2	0	Calendar for working day rules	TFACD
55	JAUSW_1	☐	TBFOR1TZ	XFELD	CHAR	1	0	Update calculation/due date: reg./reg.
56	JAUSW_2	☐	TBFOR2TZ	XFELD	CHAR	1	0	Update calculation/due date: regular/relative
57	JAUSW_3	☐	TBFOR3TZ	XFELD	CHAR	1	0	Update calculation/due date: regular/relative w.adjustment
58	JAUSW_4	☐	TBFOR4TZ	XFELD	CHAR	1	0	Update calculation/due date: fixing/relative
59	JAUSW_5	☐	TBFOR5TZ	XFELD	CHAR	1	0	Update calculation/due date: fixing/relative w.adjustment
60	JAUSW_6	☐	TBFOR6TZ	XFELD	CHAR	1	0	Update calculation/due date: annually/relative
61	JAUSW_7	☐	TBFOR7TZ	XFELD	CHAR	1	0	Update calculation/due date: annually/relative w.adjustment
62	JAUSW_8	☐	TBFOR8TZ	XFELD	CHAR	1	0	Update calculation/due date: annually/annually
63	AVGSTAGE	☐	JBBI_AGSTG	CHAR4	CHAR	4	0	No. of Days with Rel.Determination of Interest Fixing Date
64	RTERMIN	☐	JBBI_RTERM	JBBI_RTERM	CHAR	1	0	Indicator for Determination of Individual Dates
65	BKOND	☐	JBBI_BKOND	CHAR18	CHAR	18	0	Interest Rate as Amount as CHAR field
66	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
67	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
68	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
69	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
70	RKONDGR	☐	JBBI_RKOND	CHAR1	CHAR	1	0	Side of Transaction as CHAR Field
71	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
72	XZBETR	☐	TB_XZBETR	T_XBETR	CHAR	18	0	Payment amount
73	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
74	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
75	XZTERM	☐	TB_XZTERM	T_XDATUM	CHAR	10	0	Payment or Delivery Date
76	MODE	☐	JBSBIMODE	JBSBIMODE	NUMC	1	0	Mode for Batch Input Processing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUDER	RDEALER	TZDEA	RDEALER
2	JBIUDER	SKALID	TFACD	IDENT
3	JBIUDER	SKALID2	TFACD	IDENT
4	JBIUDER	SZSREF	T056R	REFERENZ
5	JBIUDER	SZSREFN	T056R	REFERENZ

History

Last changed by/on	SAP	20130529
SAP Release Created in