SAP ABAP Table DPAYH (Payment program - data for payment)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DPAYH	Table Relationship Diagram
Short Description	Payment program - data for payment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	LAUFD	☑	LAUFD_KK	DATUM	DATS	8	0	Date ID
3	LAUFI	☑	LAUFI_PAY	LAUFI_PAY	CHAR	5	0	Identification for the payment run
4	ORIGN	☑	ORIGN_PAY	LAUFK_F110	CHAR	1	0	Source of the payment data
5	XVORL	☑	XVORL	XFELD	CHAR	1	0	Indicator: Only Proposal Run?
6	PAYNO	☑	PAYNO_PAY	INT4_NOS	INT4	10	0	Sequential payment number
7	SUBNO	☑	SUBNO_PAY	CHAR6	CHAR	6	0	Additional distinguishing criterion from payments
8	GRPNO	☐	GRPNO_PAY	GRPNO_PAY	INT4	10	0	Grouping criterium for payments
9	PMF_KEY	☐	PMFKEY_PAY	CHAR15	CHAR	15	0	Redundant Key for Payment Medium Print
10	SRTF1	☐	SRTF1_PAY	CHAR20	CHAR	20	0	Format-specific sorting of payment data
11	SRTF2	☐	SRTF2_PAY	CHAR48	CHAR	48	0	User-defined sorting of payment data
12	XAVIS	☐	XAVIS_PAY	XFELD	CHAR	1	0	Output payment advice
13	ORG1T	☐	ORG1T_PAY	ORGTP_PAY	CHAR	2	0	Type of Organization
14	ORG1R	☐	ORG1R_PAY	CHAR8	CHAR	8	0	Reference for Organization
15	ORG2T	☐	ORG2T_PAY	ORGTP_PAY	CHAR	2	0	Type of organization for which the payment is made
16	ORG2R	☐	ORG2R_PAY	CHAR8	CHAR	8	0	Reference to the Organization for Which the Payment is Made
17	GPA1T	☐	GPA1T_PAY	GPATP_PAY	CHAR	2	0	Business Partner Category
18	GPA1R	☐	GPA1R_PAY	CHAR12	CHAR	12	0	Business Partner Reference
19	ACC1T	☐	ACC1T_PAY	ACCTP_PAY	CHAR	2	0	Contract Account Category
20	ACC1R	☐	ACC1R_PAY	CHAR18	CHAR	18	0	Reference to Contract Account
21	DOC1T	☐	DOC1T_PAY	DOCTP_PAY	CHAR	2	0	Payment document category
22	DOC1R	☐	DOC1R_PAY	CHAR24	CHAR	24	0	Reference to Payment Document
23	MASTT	☐	MASTT_KK	MASTT_KK	CHAR	2	0	Master record type for payment items
24	MASTR	☐	MASTR_KK	MASTR_KK	CHAR	20	0	Master Record Reference for Payment Item
25	ZADNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
26	ZNME1	☐	NAMEZ_KK	TEXT40	CHAR	40	0	Name of the Payee
27	ZNME2	☐	NAMEZ_KK	TEXT40	CHAR	40	0	Name of the Payee
28	ZSPRA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
29	ZLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
30	ZREGI	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
31	ZORT1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
32	ZORT2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
33	ZORTP	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
34	ZPST1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
35	ZPST2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
36	ZPST3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
37	ZPFAC	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
38	ZSTRA	☐	AD_STREET	TEXT60	CHAR	60	0	Street
39	ZSTR1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
40	ZSTR2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
41	ZTEL1	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
42	ZTEL2	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
43	ZFAX1	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
44	ZFAX2	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
45	ZBNKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
46	ZBNKY	☐	DZBNKY	BANKK	CHAR	15	0	Bank key of the payee's bank
47	ZBNKL	☐	DZBNKL	BANKL	CHAR	15	0	Bank number of the payee's bank
48	ZSWIF	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
49	ZBNKN	☐	DZBNKN	BANKN	CHAR	18	0	Bank account number of the payee
50	ZBKON	☐	DZBKON	BKONT	CHAR	2	0	Bank Control Key of the Payee's Bank
51	ZBKRF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
52	ZBKIN	☐	KOINH_KK	KOINH	CHAR	60	0	Name of Holder of Bank Account/Check Issuer/Cardholder
53	BBUKR	☐	BUKRS_PAY	BUKRS	CHAR	4	0	Company Code in Payment Document	T001
54	BGSBR	☐	GSBER_PAY	GSBER	CHAR	4	0	Business area in payment document	TGSB
55	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
56	RBETR	☐	RBETR	WRTV7	CURR	13	2	Amount in Local Currency
57	RWBTR	☐	RWBTR	WRTV7	CURR	13	2	Amount Paid in the Payment Currency
58	RSKON	☐	RSKON	WRTV7	CURR	13	2	Total Cash Discount for the Payment Trans. (Local Currency)
59	RWSKT	☐	RWSKT	WRTV7	CURR	13	2	Total Cash Discount for the Pmnt Transactn in Pmnt Currency
60	ZALDT	☐	DZALDT_ZHL	DATUM	DATS	8	0	Posting date of the payment document
61	DIFFB	☐	DIFFB_KK	WRTV7	CURR	13	2	Difference Amount in Clearing Processing
62	AUSFD	☐	AUSFD	DATUM	DATS	8	0	Due date of the paid items
63	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
64	RZAWE	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
65	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
66	AVISG	☐	AVISG	AVISG	CHAR	1	0	Reason for Printing Payment Advice
67	RPOST	☐	RPOST	PACK3	DEC	5	0	Number of Items Paid
68	RTEXT	☐	RTEXT_D	PACK3	DEC	5	0	Number of Text Lines for the Items Paid
69	PYGRP	☐	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
70	PAYGR	☐	PAYGR_PAY	CHAR50	CHAR	50	0	Generated grouping field in payments
71	EIGBV	☐	EIGBV_KK	EIGBV_KK	CHAR	25	0	Own Bank Details	*
72	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
73	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
74	UBNKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
75	UBNKY	☐	UBNKY	BANKK	CHAR	15	0	Bank key of our bank
76	UBNKL	☐	UBNKL	BANKL	CHAR	15	0	Bank number of our bank
77	UBKNT	☐	UBKNT	BANKN	CHAR	18	0	Our account number at the bank
78	UBKON	☐	UBKON	BKONT	CHAR	2	0	Bank control key at our bank
79	UBHKT	☐	UBHKT	SAKNR	CHAR	10	0	G/L Account Number for Our Bank Account / Bank Sub-Account	SKA1
80	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	TFK015W
81	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
82	TXTSL	☐	TXTSL_042Z	CHAR2	CHAR	2	0	Text key for the code line on the form
83	TXERG	☐	TXERG	CHAR3	CHAR	3	0	Text key supplement
84	CCINS	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
85	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
86	RQSTW	☐	RQSTW	WRTV7	CURR	13	2	Withholding Tax In Payment Currency (Credit-Side)
87	RQSTH	☐	RQSTH	WRTV7	CURR	13	2	Withholding Tax In Local Currency (Credit-Side)
88	RQSEW	☐	RQSEW	WRTV7	CURR	13	2	Withholding Tax In Payment Currency (Debit-Side)
89	RQSEH	☐	RQSEH	WRTV7	CURR	13	2	Withholding Tax In Local Currency (Debit-Side)
90	ORIBD	☐	ORIBD_KK	ORIBD_KK	CHAR	1	0	Payment Program: Origin of Business Partner Bank Data
91	XNOLC	☐	XNOLC_KK	XFELD	CHAR	1	0	Payment Program: Local Currency Amounts Incomplete
92	ZIBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
93	PDKEY	☐	PDKEY_KK	PDKEY_KK	NUMC	12	0	Number of Payment Specification
94	PDREF	☐	PDREF_KK	PDREF_KK	CHAR	16	0	Reference Number of Payment Specification
95	MGUID	☐	GUID16	GUID16	RAW	16	0	Generic Data Element for GUID Fields (X16)
96	.INCLUDE	☐				0	0	Payment Cards: Data for Encryption
97	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
98	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
99	.INCLUDE	☐				0	0	Payment Program - Data for Payment (SEPA Mandate)
100	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
101	SEQ_TYPE	☐	SEPA_SEQ_TYPE	SEPA_SEQ_TYPE	CHAR	4	0	SEPA: Sequence Type
102	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
103	B2B	☐	SEPA_B2B	XFELD	CHAR	1	0	SEPA-Mandate: B2B Mandate
104	INST_CODE	☐	FSEPA_INST_CODE	FSEPA_INST_CODE	CHAR	4	0	Local Instrument Code (Direct Debit Type)
105	.INCLUDE	☐				0	0
106	.INCLUDE	☐				0	0	Insurance Industry Include for DPAYH
107	.INCLUDE	☐				0	0
108	.INCLUDE	☐				0	0
109	.INCLUDE	☐				0	0
110	.INCLUDE	☐				0	0
111	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPAYH	BBUKR	T001	BUKRS
2	DPAYH	BGSBR	TGSB	GSBER
3	DPAYH	CCINS	TB033	CCINS
4	DPAYH	DTAWS	TFK015W	DTAWS
5	DPAYH	HBKID	T012	HBKID
6	DPAYH	HKTID	T012K	HKTID
7	DPAYH	MANDT	T000	MANDT
8	DPAYH	RZAWE	TFK042Z	ZLSCH
9	DPAYH	UBHKT	SKA1	SAKNR
10	DPAYH	UBNKS	T005	LAND1
11	DPAYH	UZAWE	T042F	UZAWE
12	DPAYH	WAERS	TCURC	WAERS
13	DPAYH	ZADNR	ADRC	ADDRNUMBER
14	DPAYH	ZBNKS	T005	LAND1
15	DPAYH	ZLAND	T005	LAND1
16	DPAYH	ZREGI	T005S	BLAND
17	DPAYH	ZSPRA	T002	SPRAS

History

Last changed by/on	SAP	20131127
SAP Release Created in