SAP ABAP Table ADDBEPP (Additional information on VDBEPP)

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	ADDBEPP	Table Relationship Diagram
Short Description	Additional information on VDBEPP

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	INDEXBEPP	☐	NUM8	NUM8	NUMC	8	0	Eight-digit numeric value
2	.INCLUDE	☐				0	0	Drawings on Disbursement
3	.INCLUDE	☐				0	0	Payments: Key Fields
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
7	DTRANS	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
8	TTRANS	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
9	NTRANS	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
10	NVERF	☐	NVERF	NUM2	NUMC	2	0	Disposal number within an outpayment
11	.INCLUDE	☐				0	0	Loans: Payment Data Fields (Not Key Fields)
12	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
13	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
14	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
15	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
16	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
17	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
18	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
19	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
20	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
21	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
22	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
23	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
24	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
25	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
26	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
27	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
28	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
29	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
30	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
31	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
32	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
33	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
34	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
35	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
36	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
37	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
38	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
39	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
40	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
41	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
42	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
43	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
44	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
45	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
46	VCBTR	☐	VCBTR	WERTV7	CURR	13	2	Drawing Amount from Disbursement
47	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
48	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
49	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
50	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
51	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
52	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
53	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
54	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
55	DDISPO	☐	TB_DISB_DDISPO	DATUM	DATS	8	0	Payment Date (Drawing)
56	BUKRS_REPLACE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
57	RANL_REPLACE	☐	RANL	RANL	CHAR	13	0	Contract Number
58	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
59	.INCLUDE	☐				0	0	SEPA Remittance Information
60	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
61	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
62	.INCLUDE	☐				0	0	SEPA Return Information
63	TRANSID	☐	TB_SEPA_TRANSID		CHAR	35	0	SEPA Transaction ID
64	RETURNKEY	☐	TB_SEPA_RETCODES		CHAR	6	0	CML SEPA return codes	VDSEPA_RETCODE
65	RETURNRSN	☐	TB_SEPA_RETRSN		CHAR	4	0	CML: SEPA Return Reasons	VDSEPA_RETRSN
66	POREF	☐	TB_SEPA_PEREF		CHAR	26	0	SEPA Reference Field (Payment Engine)
67	PIREF	☐	TB_SEPA_PEREF		CHAR	26	0	SEPA Reference Field (Payment Engine)
68	SREBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
69	SREBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
70	SREBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
71	HREBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
72	HREBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
73	HREBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
74	SRECTYP	☐	SRECTYP	SRECTYP	CHAR	1	0	ID for controlling reference
75	DTRANS_KL	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
76	TTRANS_KL	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
77	NTRANS_KL	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
78	REFCONCEPT	☐	LO_REFCONC	LO_REFCONC	CHAR	35	0	Unit definition for loan unit
79	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key
80	SVORG_KL	☐	SRECTYP	SRECTYP	CHAR	1	0	ID for controlling reference
81	REFCONCEPT_VOR	☐	LO_REFCONC	LO_REFCONC	CHAR	35	0	Unit definition for loan unit
82	DTRANS_VOR	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
83	TTRANS_VOR	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
84	NTRANS_VOR	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
85	SORDER	☐	VVSORDER	XFELD	CHAR	1	0	Borrower's note via order management
86	ORDER_SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
87	ORDER_RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
88	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
89	NO_ACCOUNT_DET	☐	TB_NO_ACCOUNT_DET	T_NO_ACCOUNT_DET	CHAR	1	0	Indicator, Do Not Carry Out Account Determination?
90	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
91	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
92	DEBTTRANSFER	☐	TB_DEBTTRANSFER	T_DEBTTRANSFER	CHAR	1	0	Indicator - Borrower Change Exists
93	RANL_VOR	☐	RANL	RANL	CHAR	13	0	Contract Number
94	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
95	SOZAHLS	☐	TB_SOZAHLS	ZAHLS	CHAR	1	0	Original Payment Lock	*
96	RREFKONT_VDBEKI	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
97	HKONT_VDBEKI	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
98	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADDBEPP	BANKS	T005	LAND1	KEY	1	1
2	ADDBEPP	BUKRS	T001	BUKRS	KEY	1	1
3	ADDBEPP	DTAWS	T015W	DTAWS
4	ADDBEPP	LAND1	T005	LAND1	KEY	1	1
5	ADDBEPP	MANDT	T000	MANDT	KEY	1	1
6	ADDBEPP	REGIO	T005S	BLAND	KEY	1	1
7	ADDBEPP	RETURNKEY	VDSEPA_RETCODE	RETURNKEY
8	ADDBEPP	RETURNRSN	VDSEPA_RETRSN	RETURNRSN
9	ADDBEPP	SCWHR	TCURC	WAERS	KEY	1	CN
10	ADDBEPP	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in