SAP ABAP Table TRDABE (TR-EDT: Data Transfer for loans - flows)

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	TRDABE	Table Relationship Diagram
Short Description	TR-EDT: Data Transfer for loans - flows

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in