SAP ABAP Table JBIUGEL (Batch Input Structure for Money Market Trading)

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	JBIUGEL	Table Relationship Diagram
Short Description	Batch Input Structure for Money Market Trading

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	Financial transactions from money market view
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	*
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	.INCLUDE	☐				0	0	Financial transaction: Screen fields
61	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
62	XGSART	☐	TB_XGSART	TEXT30	CHAR	30	0	Name of product type
63	XFHAART	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
64	XABWTYP	☐	TB_XABRBEZ	TEXT60	CHAR	60	0	Name: Processing Category
65	SKUENDT	☐	TM_SKUENDT	XFELD	CHAR	1	0	Period of notice in days
66	SKUENDM	☐	TM_SKUENDM	XFELD	CHAR	1	0	Period of notice in months
67	XRFHA	☐	TB_XRFHA	T_XRFHA	CHAR	13	0	Financial transaction number
68	XAKTIV	☐	TM_XAKTIV	TEXT60	CHAR	60	0	Active status: description
69	XFRGZUST	☐	TB_XFRGZUST	TEXT60	CHAR	60	0	Transaction release: Release status
70	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
71	XGARANT	☐	TB_XGARANT	TEXT80	CHAR	80	0	Name and address of guarantor
72	SNOTE	☐	TB_SNOTE	XFELD	CHAR	1	0	Memo exists
73	SINCLB	☐	TB_SINCLBB	XFELD	CHAR	1	0	Calculation Period: Start Inclusive - End Exclusive
74	SINCLE	☐	TB_SINCLEB	XFELD	CHAR	1	0	Calculation Period: Start Exclusive - End Inclusive
75	SNPVCALY	☐	TB_SNPVCALY	XFELD	CHAR	1	0	NPV calculation via yield
76	SNPVCALD	☐	TB_SNPVCALD	XFELD	CHAR	1	0	NPV calculation via discounting
77	SRNDNGB	☐	TB_SRNDNGB	XFELD	CHAR	1	0	Round Up or Down to the Nearest Whole Number
78	SRNDNGD	☐	TB_SRNDNGD	XFELD	CHAR	1	0	Round down
79	SRNDNGU	☐	TB_SRNDNGU	XFELD	CHAR	1	0	Round up
80	SFHAZBA	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
81	SFHAZBAB	☐	TB_SFHAZBA	SBEWART	CHAR	4	0	Flow Type	*
82	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
83	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
84	XZBETR	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
85	XZBETRB	☐	TM_XBETRAG	T_XBETRG18	CHAR	18	0	Amount as text field
86	XZTERM	☐	TM_XZTERM	T_XDATUM	CHAR	10	0	Payment date
87	PKOND	☐	JBBI_PKOND	CHAR12	CHAR	12	0	Percentage Rate of Condition Item as CHAR Field
88	SZBMETH	☐	JBBI_SZBM	CHAR1	CHAR	1	0	Interest Calculation Method as CHAR Field
89	SRHYTHM	☐	JBBI_SRHY	CHAR1	CHAR	1	0	Frequency Indicator as CHAR Field
90	ARHYTM	☐	JBBI_ARHY	CHAR3	CHAR	3	0	Defined Frequency in Days or Months as CHAR Field
91	SFWERK	☐	JBBI_SFWRK	CHAR1	CHAR	1	0	Shift Due Date to Working Day as CHAR Field
92	SVWERK	☐	JBBI_SVWRK	CHAR1	CHAR	1	0	Shift Value Date to Working Day as CHAR Field
93	XBLFZ	☐	TM_XLFZBEG	T_XDATUM	CHAR	10	0	Term Start
94	XELFZ	☐	TM_XLFZEND	T_XDATUM	CHAR	10	0	End of Term
95	SZNSPRO	☐	JBBI_SZNSP	CHAR1	CHAR	1	0	Interest Handling with Rollover as CHAR Field
96	XVTRAB	☐	TM_XABSCHL	T_XDATUM	CHAR	10	0	Close Date
97	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
98	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
99	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
100	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
101	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	JBIUGEL	ABWTYP	AT05	ABWTYP	KEY	1	CN
2	JBIUGEL	BUKRS	T001	BUKRS	KEY	1	CN
3	JBIUGEL	FACILITYBUKRS	T001	BUKRS	KEY	1	CN
4	JBIUGEL	FACILITYNR	VTBFHA	RFHA
5	JBIUGEL	MANDT	T000	MANDT	KEY	1	CN
6	JBIUGEL	OBJNR	ONR00	OBJNR		1	N
7	JBIUGEL	POSACC	TRFT_POS_ACCOUNT	POS_ACCOUNT
8	JBIUGEL	RCOMVALCL	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
9	JBIUGEL	RCOMVALCL2	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
10	JBIUGEL	RLDEPO	TWD01	RLDEPO		C	CN
11	JBIUGEL	RMAID	VTBMA	RMAID		C	CN
12	JBIUGEL	RPORTB	TWPOB	RPORTB	KEY	1	CN
13	JBIUGEL	RPORTB2	TWPOB	RPORTB
14	JBIUGEL	RREFKONT	T037S	RREFKONT	KEY	1	CN
15	JBIUGEL	RREFKONT2	T037S	RREFKONT	REF	C	CN
16	JBIUGEL	SANLF	TZAF	SANLF	KEY	1	CN
17	JBIUGEL	SFGTYP	AT01	SFGTYP	KEY	1	CN
18	JBIUGEL	SFHAART	AT10	SFHAART	KEY	1	CN
19	JBIUGEL	SGSART	TZPA	GSART	KEY	1	CN
20	JBIUGEL	SKALID	TFACD	IDENT	KEY	1	CN
21	JBIUGEL	SKALID2	TFACD	IDENT	KEY	1	CN
22	JBIUGEL	TBEGRU	TRBRG	TBEGRU
23	JBIUGEL	WGSCHFT	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in