SE11 ABAP Dictionary SE11 PAYR

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

PAYR

Payment Medium File

SAP HR Transparent Table 63 Fields

Primary Key:

MANDT ZBUKR HBKID HKTID RZAWE CHECT

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	ZBUKR	KEY	CoCd	CHAR	4	-	-	Paying company code
3	HBKID	KEY	House Bank	CHAR	5	-	-	Short Key for a House Bank
4	HKTID	KEY	Acct ID	CHAR	5	-	-	ID for account details
5	RZAWE	KEY	Pay.Method	CHAR	1	-	-	Payment Method
6	CHECT	KEY	To	CHAR	13	-	-	Check number
7	CHECF	-	From	CHAR	13	-	-	Check Number From
8	LAUFD	-	Date	DATS	8	-	-	Date on Which the Program Is to Be Run
9	LAUFI	-	ID	CHAR	6	-	-	Additional Identification
10	LIFNR	-	Vendor	CHAR	10	-	LFA1	Account Number of Vendor or Creditor
11	KUNNR	-	Customer	CHAR	10	-	KNA1	Customer Number 1
12	EMPFG	-	Payee	CHAR	16	-	-	Payee code
13	UBHKT	-	Account No	CHAR	10	-	-	G/L Account Number for Our Bank Account / Bank Sub-Account
14	VBLNR	-	Payment	CHAR	10	-	-	Document Number of the Payment Document
15	GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year
16	ZALDT	-	Pmnt date	DATS	8	-	-	Probable Payment Date (Cash Discount 1 Due)
17	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
18	RWBTR	-	Amount	CURR	13	2	-	Amount Paid in the Payment Currency
19	STRGB	-	Bus. Area	CHAR	4	-	-	Business Area
20	PRIDT	-	Print Date	DATS	8	-	-	Print Date
21	PRITI	-	Print time	TIMS	6	-	-	Print Time
22	PRIUS	-	User	CHAR	12	-	-	Print User
23	XMANU	-	Manual	CHAR	1	-	-	X - Manual check
24	XBANC	-	Paid check	CHAR	1	-	-	X - Paid Check
25	BANCD	-	Date	DATS	8	-	-	Check encashment date
26	EXTRD	-	Date	DATS	8	-	-	Date of Extract Creation
27	EXTRT	-	Time	TIMS	6	-	-	Time of Extract Creation
28	XBUKR	-	Intercomp.	CHAR	1	-	-	X - Intercompany Payment
29	ZANRE	-	Title	CHAR	15	-	-	Title of the payee
30	ZNME1	-	Name	CHAR	35	-	-	Name of the payee
31	ZNME2	-	Name	CHAR	35	-	-	Name of the payee
32	ZNME3	-	Name	CHAR	35	-	-	Name of the payee
33	ZNME4	-	Name	CHAR	35	-	-	Name of the payee
34	ZPSTL	-	Post.code	CHAR	10	-	-	Postal code of the payee
35	ZORT1	-	City	CHAR	35	-	-	City of the payee
36	ZSTRA	-	Street	CHAR	35	-	-	Street and house number of the payee
37	ZPFAC	-	PO Box	CHAR	10	-	-	P.O. box of the payee
38	ZLAND	-	Country	CHAR	3	-	-	Country Key
39	ZREGI	-	Reg. code	CHAR	3	-	-	Regional code of the payee
40	ZBNKS	-	Cntry key	CHAR	3	-	-	Country Key
41	ZBNKN	-	Account No	CHAR	18	-	-	Bank account number of the payee
42	ZBNKL	-	Bank no.	CHAR	15	-	-	Bank number of the payee's bank
43	ZBKON	-	Cntrl key	CHAR	2	-	-	Bank Control Key of the Payee's Bank
44	ZSWIF	-	SWIFT code	CHAR	11	-	-	SWIFT Code for International Payments
45	ZIBAN	-	IBAN	CHAR	34	-	-	IBAN of the Payee
46	VOIDR	-	Reason	NUMC	2	-	-	Check void reason code
47	VOIDD	-	Date	DATS	8	-	-	Voided Check Date
48	VOIDU	-	User	CHAR	12	-	-	Voided check user
49	CHECV	-	Alternativ	CHAR	13	-	-	Replacement check number
50	HBKIV	-	Replacement check bank	CHAR	5	-	-	Replacement check bank
51	HKTIV	-	Replacement check account	CHAR	5	-	-	Replacement check account
52	ZPST2	-	P.O. box postal code of the payee	CHAR	10	-	-	P.O. box postal code of the payee
53	XRAGL	-	Indicator: Clearing was Reversed	CHAR	1	-	-	Indicator: Clearing was Reversed
54	PERNR	-	Pers.No.	NUMC	8	-	-	Personnel Number
55	SEQNR	-	Sequence Number	CHAR	5	-	-	Sequence Number
56	BTZNR	-	Assignment of Transfers	RAW	1	-	-	Assignment of Transfers
57	REC_BELNR	-	DocumentNo	CHAR	10	-	-	Accounting Document Number
58	REC_GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year
59	ZPFOR	-	PO Bx city	CHAR	35	-	-	City of payee's PO box
60	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
61	ICHEC	-	Type of Payment Medium (Stored in Payment Register)	CHAR	1	-	-	Type of Payment Medium (Stored in Payment Register)
62	IREFE	-	Information as to Whether a Reference to this Payment Exists	CHAR	1	-	-	Information as to Whether a Reference to this Payment Exists
63	RWSKT	-	Cash disc.	CURR	13	2	-	Total Cash Discount for the Pmnt Transactn in Pmnt Currency

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk PAYR.

Interactive ERD Diagrams

SAP Finance - FI/CO Document Tables →

Standard T-Codes

FCHN FCH1 F110 FBZ5

Related Tables

LFA1 KNA1 TCURC BKPF BSEG BSAD BSID BSIK

ANSI SQL Query

SELECT a.ZBUKR,
       a.HBKID,
       a.HKTID,
       a.RZAWE,
       a.CHECT,
       a.CHECF,
       a.LAUFD
FROM PAYR AS a
WHERE a.ZBUKR = '0001'
  AND a.HBKID = '0001';

ABAP OpenSQL (7.40+)

SELECT a~zbukr,
       a~hbkid,
       a~hktid,
       a~rzawe,
       a~chect,
       a~checf,
       a~laufd
  FROM payr AS a
  WHERE a~zbukr = '0001'
  and a~hbkid = '0001'
  INTO TABLE @DATA(lt_payr)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 PAYR

PAYR

Dictionary Fields Fields

Related References & SQL