SAP ABAP Table V_521B_E (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_521B_E	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EMFSL	☑	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers
3	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
4	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
5	EMFNA	☐	EMFNA	TEXT25	CHAR	25	0	Payee name
6	DEBIT	☐	P00_XDEBIT_EMFSL	XFELD	CHAR	1	0	Automatic Debit Authorization Indicator
7	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
8	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
9	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
10	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
11	BKKTO	☐	BANKN	BANKN	CHAR	18	0	Bank account number
12	USBKZ	☐	USBKZ	XFELD	CHAR	1	0	Overwrite indicator
13	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
14	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
15	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
16	ETEXT	☐	EMTXT	TEXT25	CHAR	25	0	Payee designation
17	CTRAN	☐	CTRAN	XFELD	CHAR	1	0	Collective transfer
18	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
19	PBSNR	☐	PBSNR	CHAR8	CHAR	8	0	Transfer customer number
20	TRANS	☐	OSIUB	XFELD	CHAR	1	0	OSI transfer (Denmark)
21	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
22	BTTYP	☐	P09_BTTYP	P09_BTTYP	NUMC	2	0	PBS Transfer Type	T5M3T
23	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
24	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
25	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
26	CTRNS	☐	HRPAY00_COLDME_CTRNS	XFELD	CHAR	1	0	Coll. Bank Transfer Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_521B_E	BANKS	T005	LAND1	REF	1	CN
2	V_521B_E	BTTYP	T5M3T	BTTYP	REF	C	CN
3	V_521B_E	MANDT	T000	MANDT	KEY	1	CN
4	V_521B_E	STATE	T005S	BLAND	REF	C	CN
5	V_521B_E	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in