SAP ABAP Table JBIUDAB (TR-EDT: Loan flows transfer)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	INTTAB	Structure
Structure	JBIUDAB	Table Relationship Diagram
Short Description	TR-EDT: Loan flows transfer

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	TR-EDT: Data Transfer for loans - flows
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	STYPE	☐	STYPE_BEW	STYPE_BEW	CHAR	1	0	Record Category for TR-EDT: Loan Flows
6	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
7	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
8	VVSBBEZ	☐	VVSBBEZ	VVSBBEZ	NUMC	3	0	Indicator for the relevance of the relationship	TZB07
9	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
10	RPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
11	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	DBLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
13	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
14	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
15	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
16	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
17	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
18	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
19	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
20	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
21	NO_SINCL_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
23	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
24	BHWHR	☐	UEBBWHR	NUMC13	NUMC	13	0	Amount that Changes Position in Local Currency
25	N_BHWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
26	BBWHR	☐	UEBBBHR	NUMC13	NUMC	13	0	Amount that Changes the Position
27	N_BBWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
28	SBWHR	☐	UB_SBWHR	CHAR5	CHAR	5	0	Currency of position amount	*
29	BNWHR	☐	UEBBWHR	NUMC13	NUMC	13	0	Amount that Changes Position in Local Currency
30	N_BNWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
31	SNWHR	☐	UB_SNWHR	CHAR5	CHAR	5	0	Currency of nominal amount	*
32	BCWHR	☐	UEBBCHR	NUM13	NUMC	13	0	Settlement amount in foreign currency
33	N_BCWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
34	SCWHR	☐	UB_SCWHR	CHAR5	CHAR	5	0	Currency of payment amount	*
35	BBASIS	☐	UEBBASIS	NUM13	NUMC	13	0	Calculation base for conditions
36	N_BBASIS	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
37	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	TD21
38	RBELKPFD	☐	RBELKPFD	RBELKPFD	CHAR	10	0	Document Number of Document Header (Loan)	VDBEKI
39	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
40	DGUEL_KP	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
41	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
42	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
43	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
44	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
45	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
46	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
47	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
48	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	TZB0A
49	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
51	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
52	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
53	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
54	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
55	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
56	STICHTAG	☐	VVSTICHTAG	DATUM	DATS	8	0	Key date for data transfer
57	OP_BBWHR	☐	UEBBBHR	NUMC13	NUMC	13	0	Amount that Changes the Position
58	N_OP_BBWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
59	OP_BHWHR	☐	UEBBWHR	NUMC13	NUMC	13	0	Amount that Changes Position in Local Currency
60	N_OP_BHWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
61	OP_BNWHR	☐	UEBBWHR	NUMC13	NUMC	13	0	Amount that Changes Position in Local Currency
62	N_OP_BNWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
63	OP_BCWHR	☐	UEBBCHR	NUM13	NUMC	13	0	Settlement amount in foreign currency
64	N_OP_BCWHR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
65	OP_DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
66	OP_DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
67	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
68	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
69	SZART	☐	SZART_LO	SZART_LO	CHAR	1	0	Payment transaction for loans
70	KURS2	☐	UB_KURSF	KURSC	NUMC	9	0	Exchange rate
71	N_KURS2	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
72	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
73	DFAELL_OLD_EXT	☐	TB_EXTENS_DFAELL_OLD	DATUM	DATS	8	0	Old Due Date
74	DDISPO_OLD_EXT	☐	TB_EXTENS_DDISPO_OLD	DATUM	DATS	8	0	Old Payment Date
75	RBO_EXT	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
76	SVORGANG	☐	SVORFALL	SVORFALL	CHAR	4	0	Business Operation (Activity)
77	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
78	PKOND	☐	UB_PKOND	NUM10	NUMC	10	0	Percentage rate for condition items
79	N_PKOND	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
80	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
81	ALT_BUCHEN	☐	VVJAUSWA	JANEI	CHAR	1	0	Control whether field selection from TZPA or TZPAB is used
82	SDBMODE	☐	TRUBMODBEW	TRUBMODBEW	CHAR	1	0	Transfer mode - flow data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUDAB	BUKRS	T001	BUKRS
2	JBIUDAB	GSBER	TGSB	GSBER
3	JBIUDAB	MANDT	T000	MANDT
4	JBIUDAB	MANSP	T040S	MANSP
5	JBIUDAB	RBELKPFD	VDBEKI	RBELKPFD
6	JBIUDAB	RHABEN	SKA1	SAKNR
7	JBIUDAB	RPARTNR	BUT000	PARTNER
8	JBIUDAB	RREFKONT	T037S	RREFKONT
9	JBIUDAB	RSOLL	SKA1	SAKNR
10	JBIUDAB	SBEWART	TZB0A	SBEWART
11	JBIUDAB	SKOART	TZK01	SKOART	REF
12	JBIUDAB	SREFBEW	TZB0A	SBEWART
13	JBIUDAB	SSTOGRD	TZST	SSTOGRD
14	JBIUDAB	SZEGEN	TD21	SZEGEN
15	JBIUDAB	VVSBBEZ	TZB07	VVSBBEZ
16	JBIUDAB	ZAHLS	T008	ZAHLS

History

Last changed by/on	SAP	20130529
SAP Release Created in