SAP ABAP Table U_17093 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	PA0009
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
3	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
12	OPKEN	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
13	BETRG	☐	PAD_VGBTR	P_AMT07V	CURR	13	2	Standard value
14	WAERS	☐	PAD_WAERS	WAERS	CUKY	5	0	Payment Currency	TCURC
15	ANZHL	☐	VGPRO	DEC3_2	DEC	5	2	Standard Percentage
16	ZEINH	☐	PT_ZEINH	RPMSH	CHAR	3	0	Time/Measurement Unit	T538A
17	BNKSA	☐	BNKSA	SUBTY_591A	CHAR	4	0	Type of Bank Details Record
18	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
19	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
20	BKPLZ	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
21	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
22	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
23	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
24	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
25	BANKP	☐	BANKP	BANKP	CHAR	2	0	Check Digit for Bank No./Account
26	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
27	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
28	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
29	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
30	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
31	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
32	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
33	ESRRE	☐	ESRRE	ESRRE	CHAR	27	0	POR reference number
34	ESRPZ	☐	ESRPZ	CHAR2	CHAR	2	0	POR check digit
35	EMFSL	☐	EMFSL	EMFSL	CHAR	8	0	Payee key for bank transfers
36	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
37	BTTYP	☐	P09_BTTYP	P09_BTTYP	NUMC	2	0	PBS Transfer Type	T5M3T

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17093	BANKS	T005	LAND1	REF	C	CN
2	U_17093	BTTYP	T5M3T	BTTYP	KEY	1	CN
3	U_17093	MANDT	T000	MANDT	KEY	1	CN
4	U_17093	PERNR	PA0003	PERNR	KEY	1	CN
5	U_17093	PREAS	T530E	PREAS	KEY	1	CN
6	U_17093	WAERS	TCURC	WAERS	REF	C	CN
7	U_17093	ZEINH	T538A	ZEINH	REF	C	CN
8	U_17093	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in