SAP ABAP Table DTFIAP_51 (Check Register Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	INTTAB	Structure
Structure	DTFIAP_51	Table Relationship Diagram
Short Description	Check Register Items

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	.INCLUDE	☐				0	0	Check Register Headers
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	ZBUKR	☐	DZBUKR	BUKRS	CHAR	4	0	Paying company code	T001
4	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
5	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
6	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
7	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
8	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
9	RZAWE	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
10	CHECT	☐	CHECT	CHCKN	CHAR	13	0	Check number
11	CHECF	☐	CHECF	CHCKN	CHAR	13	0	Check Number From
12	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
13	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
14	UBHKT	☐	UBHKT	SAKNR	CHAR	10	0	G/L Account Number for Our Bank Account / Bank Sub-Account	*
15	VBLNR	☐	VBLNR	BELNR	CHAR	10	0	Document Number of the Payment Document
16	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
17	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
18	ZALDT	☐	DZALDT	DATUM	DATS	8	0	Probable Payment Date (Cash Discount 1 Due)
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	RWBTR	☐	RWBTR	WRTV7	CURR	13	2	Amount Paid in the Payment Currency
21	BANCD	☐	BANCD	DATUM	DATS	8	0	Check encashment date
22	ZANRE	☐	DZANRE	TEXT15	CHAR	15	0	Title of the payee
23	ZNME1	☐	DZNME1	TEXT35	CHAR	35	0	Name of the payee
24	ZPSTL	☐	DZPSTL	PSTLZ	CHAR	10	0	Postal code of the payee
25	ZORT1	☐	DZORT1	TEXT35	CHAR	35	0	City of the payee
26	ZSTRA	☐	DZSTRA	TEXT35	CHAR	35	0	Street and house number of the payee
27	ZPFAC	☐	DZPFAC	PFACH	CHAR	10	0	P.O. box of the payee
28	ZLAND	☐	DZLAND	LAND1	CHAR	3	0	Country Key	T005
29	ZREGI	☐	DZREGI	REGIO	CHAR	3	0	Regional code of the payee	T005S
30	ZBNKS	☐	DZBNKS	LAND1	CHAR	3	0	Country Key	T005
31	ZBNKN	☐	DZBNKN	BANKN	CHAR	18	0	Bank account number of the payee
32	ZBNKL	☐	DZBNKL	BANKL	CHAR	15	0	Bank number of the payee's bank
33	ZBKON	☐	DZBKON	BKONT	CHAR	2	0	Bank Control Key of the Payee's Bank
34	ZSWIF	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
35	ZIBAN	☐	DZIBAN	IBAN	CHAR	34	0	IBAN of the Payee
36	VOIDR	☐	VOIDR	VOIDR	NUMC	2	0	Check void reason code	TVOID
37	VOIDD	☐	VOIDD	DATUM	DATS	8	0	Voided Check Date
38	VOIDU	☐	VOIDU	UNAME	CHAR	12	0	Voided check user
39	ZPST2	☐	DZPST2	PSTLZ	CHAR	10	0	P.O. box postal code of the payee
40	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
41	REC_BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
42	REC_GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
43	ZPFOR	☐	PFORT_Z	TEXT35	CHAR	35	0	City of payee's PO box
44	RWSKT	☐	RWSKT	WRTV7	CURR	13	2	Total Cash Discount for the Pmnt Transactn in Pmnt Currency
45	XAUSC	☐	CHKNXAUS	XFELD	CHAR	1	0	List of Outstanding Checks
46	CHECM	☐	CHECM	CHECM	CHAR	27	0	Check Lots
47	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
48	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
49	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
50	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
51	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
52	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
53	WAERS_I	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
55	ABZUG	☐	WSKTO_VZ	WRTV7	CURR	13	2	Cash discount amount in document currency with +/- sign
56	NETTO	☐	WRSHBN	WRTV7	CURR	13	2	Net Amount in Foreign Currency
57	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
58	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DTFIAP_51	HBKID	T012	HBKID
2	DTFIAP_51	HKTID	T012K	HKTID
3	DTFIAP_51	RZAWE	T042Z	ZLSCH
4	DTFIAP_51	VOIDR	TVOID	VOIDR
5	DTFIAP_51	WAERS	TCURC	WAERS
6	DTFIAP_51	ZBNKS	T005	LAND1
7	DTFIAP_51	ZBUKR	T001	BUKRS
8	DTFIAP_51	ZLAND	T005	LAND1
9	DTFIAP_51	ZREGI	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in	603