SAP ABAP Table JBIUPDAB (TR-EDT: Loan flows - transfer with internal fields)

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	JBIUPDAB	Table Relationship Diagram
Short Description	TR-EDT: Loan flows - transfer with internal fields

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in