PAYRQ

Transparent Table Application Table
174 Fields 7 CDS Views

Payment Requests

PAYRQ is an SAP database table in S/4HANA. Payment Requests. It contains 174 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MakeBankTransferLog view from BASIC make bank transfer log
I_MakeBkTransfWithFilter view from BASIC Items of Track Bank Transfer
I_PaymentRequest view_entity from BASIC Payment Requests
I_PaytReqWthPaytPrpslItm view from BASIC Payt Request with Proposal Item
P_MBTPAYMENTREQUESTTYPE view from BASIC
P_MBTTARGETBANKACCOUNTINFO view from BASIC
SHSM_COPC_PAYRQ view from CDS View Replacing in search help

Fields (174)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY keyno PRQ_KEYNO Key Number
zbukr PRQ_ZBUKR Paying CoCd
absbu PRQ_ABSBU Snd.co.cde
bukrs BUKRS Company Code
belnr BELNR_D Document Number
buzei BUZEI Item
gjahr GJAHR Fiscal Year
gsber GSBER Business Area
usnam USNAM User Name
monat MONAT Period
cpudt CPUDT Entered On
hwaer HWAER Local Currency
waers PRQ_DOCUR Invoice curr.
hwae2 HWAE2 Local curr. 2
hwae3 HWAE3 Local curr. 3
pacur PRQ_PACUR Paymnt currency
dmbtr DMBTR Amount in LC
dmbe2 DMBE2 LC2 Amount
dmbe3 DMBE3 LC3 Amount
wrbtr WRBTR Amount
pamtl PRQ_AMTLC LC Amount
pamtf PRQ_AMTFC PC Amount
shkzg SHKZG Debit/Credit
koart KOART Account type
parno PRQ_PARNO Business partner
hkont HKONT G/L Acct
payee PRQ_PAYEE Alternat. payee
filkd FILKD Branch
anred ANRED Title
name1 NAME1_GP Name
name2 NAME2_GP Name 2
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
pstlz PSTLZ Postal Code
ort01 ORT01_GP City
pstl2 PSTL2 PO Box PCode
stras STRAS_GP Street
pfach PFACH PO Box
land1 LAND1 Country/Reg.
regio REGIO Region
busab BUSAB Clerk Abbrev.
stcd1 STCD1 Tax Number 1
dtams DTAMS DME Rec. Code
dtaws DTAWS Instruction Key
dtws1 DTAT16 Instruct. Key 1
dtws2 DTAT17 Instruct. Key 2
dtws3 DTAT18 Instruct. key 3
dtws4 DTAT19 Instruct. key 4
lzbkz LZBKZ SCB Ind.
landl LANDL Supply C/R
zanre DZANRE Title
znme1 DZNME1 Name
znme2 DZNME1 Name
znme3 DZNME1 Name
znme4 DZNME1 Name
zpstl DZPSTL Payee Postal Code
zort1 DZORT1 City
zpst2 DZPST2 PO box post cde
zstra DZSTRA Street
zpfac DZPFAC PO Box
zland DZLAND Country/Region
zregi DZREGI Regional code
zspra SPRAS Language
eikto EIKTO Acct at Cust.
ztlfx TELFX Fax Number
ztelf TELF1 Telephone 1
ztelx TELX1 Telex
hktid HKTID Account ID
hbkid HBKID House Bank
ubnky UBNKY House Bank Key
ubnks BANKS Bank Ctry/Reg.
ubnkl UBNKL House bank no.
uiban UIBAN IBAN House Bank
ubknt UBKNT Our account number
ubkon UBKON Control Key
ubnkr PRQ_UBNKR Regional Code
ubhkt UBHKT G/L Account No.
bkhbk PRQ_BKHBK Bank G/L account
btyp1 BNTYP Bank type in chain
bnks1 BANKS Bank Ctry/Reg.
bnkl1 BANKK Bank Key
bnkn1 BANKN Bank Account
bkon1 BKONT Control Key
bkrf1 BKREF Reference
iban1 IBAN IBAN
btyp2 BNTYP Bank type in chain
bnks2 BANKS Bank Ctry/Reg.
bnkl2 BANKK Bank Key
bnkn2 BANKN Bank Account
bkon2 BKONT Control Key
bkrf2 BKREF Reference
iban2 IBAN IBAN
btyp3 BNTYP Bank type in chain
bnks3 BANKS Bank Ctry/Reg.
bnkl3 BANKK Bank Key
bnkn3 BANKN Bank Account
bkon3 BKONT Control Key
bkrf3 BKREF Reference
iban3 IBAN IBAN
bvtyp BVTYP Part.bank type
zbnks DZBNKS Country/Region
zbnkn DZBNKN Payee acct no.
zbnkl DZBNKL Bank number
zbnky DZBNKY Payee bank key
zbkon DZBKON Control Key
bkref BKREF Reference
zbnkr PRQ_ZBNKR Regional Code
swift SWIFT SWIFT/BIC
koinh KOINH_FI Account holder
zgsbr PRQ_ZGSBR Business area
ggrup PRQ_ZHKONT Bank Account
xreld PRQ_XRELD Posted
xreli PRQ_XRELI Complete
xrelp PRQ_XRELP Ind: Rel.for Payment
xreve PRQ_XREVE Revrse
stgrd STGRD Reversal Reason
xurge PRQ_XURGE Ind.: Urgent
tage1 TAGE1 Resid. time 1
duedt PRQ_DUEDT Paym. req. due date
valut PRQ_VALDT Value date
crval PRQ_CRVAL Value date payee
imper PRQ_IMPER Imper.Value Date
zuonr DZUONR Assignment
xpore PRQ_XPORE Individual Payt
uzawe UZAWE Pmnt Meth. Sup.
zwels DZWELS Payment Methods
xezer XEZER Collect.author.
swtxt PRQ_SWTXT SWIFT Text
xblnr XBLNR1 Reference
bldat BLDAT Document Date
sgtxt SGTXT Text
paygr PAYGR Grouping
xkdfb XKDFB_042E No Exch. Rate Diffr
zlspr DZLSPR Pmnt block
vbund RASSC Trading Partner
augdt AUGDT Clearing
augcp AUGCP ClearingEntDate
augbl AUGBL Clrng doc.
awsys LOGSYSTEM Logical System
awtyp AWTYP Ref. procedure
awkey AWKEY Reference Key
origin FIBL_ORIGIN Origin
hbkgr FIBL_HBG Group of house bank accts
rfttrn RFTTRN_BF Payment code
post_name PRQ_POSTNAME User: Posting
post_date PRQ_POSTDATE Posting Date
rel_name PRQ_RELNAME User: Release
rel_date PRQ_RELDATE Release Date
deduamntp PRQ_DEDUAMNTP Amount
deduamntl PRQ_DEDUAMNTL Amount
wtamntp PRQ_WTAMNTP Amount
wtamntl PRQ_WTAMNTL Amount
kidno KIDNO Payment Ref.
ziban DZIBAN IBAN of the Payee
sname1 NAME1_GP Name
sort01 ORT01_GP City
sland1 LAND1_GP Country/Region Key
vertn RANL Contract Number
extaccount TPM_EXT_ACCOUNT External Account
zpfor PFORT_Z PO box city
mguid SEPA_MGUID Mandate GUID
sname2 NAME2_GP Name 2
sname3 NAME3_GP Name 3
sname4 NAME4_GP Name 4
sstras STRAS_GP Street
sstrs2 STRAS_GP Street
spstlz PSTLZ_BAS Postal Code
sid SENDER_ID Payer of a Payment
purp_code FPM_PURP_CODE SEPA Purpose Code: Classification of a Payment/Debit Memo
payt_rsn FARP_PAYT_RSN Payment Reason
zpayment_system PAYEE_PAYMENT_SYSTEM Payee Payment System
zalias_type PAYEE_ALIAS_TYPE Payee Alias Type
zbank_alias PAYEE_BANK_ALIAS Payee Alias

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Payment Requests
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYRQ (
    MANDT,            -- Client [MANDT]
    KEYNO,            -- Key Number [PRQ_KEYNO]
    ZBUKR,            -- Paying CoCd [PRQ_ZBUKR]
    ABSBU,            -- Snd.co.cde [PRQ_ABSBU]
    BUKRS,            -- Company Code [BUKRS]
    BELNR,            -- Document Number [BELNR_D]
    BUZEI,            -- Item [BUZEI]
    GJAHR,            -- Fiscal Year [GJAHR]
    GSBER,            -- Business Area [GSBER]
    USNAM,            -- User Name [USNAM]
    MONAT,            -- Period [MONAT]
    CPUDT,            -- Entered On [CPUDT]
    HWAER,            -- Local Currency [HWAER]
    WAERS,            -- Invoice curr. [PRQ_DOCUR]
    HWAE2,            -- Local curr. 2 [HWAE2]
    HWAE3,            -- Local curr. 3 [HWAE3]
    PACUR,            -- Paymnt currency [PRQ_PACUR]
    DMBTR,            -- Amount in LC [DMBTR]
    DMBE2,            -- LC2 Amount [DMBE2]
    DMBE3,            -- LC3 Amount [DMBE3]
    WRBTR,            -- Amount [WRBTR]
    PAMTL,            -- LC Amount [PRQ_AMTLC]
    PAMTF,            -- PC Amount [PRQ_AMTFC]
    SHKZG,            -- Debit/Credit [SHKZG]
    KOART,            -- Account type [KOART]
    PARNO,            -- Business partner [PRQ_PARNO]
    HKONT,            -- G/L Acct [HKONT]
    PAYEE,            -- Alternat. payee [PRQ_PAYEE]
    FILKD,            -- Branch [FILKD]
    ANRED,            -- Title [ANRED]
    NAME1,            -- Name [NAME1_GP]
    NAME2,            -- Name 2 [NAME2_GP]
    NAME3,            -- Name 3 [NAME3_GP]
    NAME4,            -- Name 4 [NAME4_GP]
    PSTLZ,            -- Postal Code [PSTLZ]
    ORT01,            -- City [ORT01_GP]
    PSTL2,            -- PO Box PCode [PSTL2]
    STRAS,            -- Street [STRAS_GP]
    PFACH,            -- PO Box [PFACH]
    LAND1,            -- Country/Reg. [LAND1]
    REGIO,            -- Region [REGIO]
    BUSAB,            -- Clerk Abbrev. [BUSAB]
    STCD1,            -- Tax Number 1 [STCD1]
    DTAMS,            -- DME Rec. Code [DTAMS]
    DTAWS,            -- Instruction Key [DTAWS]
    DTWS1,            -- Instruct. Key 1 [DTAT16]
    DTWS2,            -- Instruct. Key 2 [DTAT17]
    DTWS3,            -- Instruct. key 3 [DTAT18]
    DTWS4,            -- Instruct. key 4 [DTAT19]
    LZBKZ,            -- SCB Ind. [LZBKZ]
    LANDL,            -- Supply C/R [LANDL]
    ZANRE,            -- Title [DZANRE]
    ZNME1,            -- Name [DZNME1]
    ZNME2,            -- Name [DZNME1]
    ZNME3,            -- Name [DZNME1]
    ZNME4,            -- Name [DZNME1]
    ZPSTL,            -- Payee Postal Code [DZPSTL]
    ZORT1,            -- City [DZORT1]
    ZPST2,            -- PO box post cde [DZPST2]
    ZSTRA,            -- Street [DZSTRA]
    ZPFAC,            -- PO Box [DZPFAC]
    ZLAND,            -- Country/Region [DZLAND]
    ZREGI,            -- Regional code [DZREGI]
    ZSPRA,            -- Language [SPRAS]
    EIKTO,            -- Acct at Cust. [EIKTO]
    ZTLFX,            -- Fax Number [TELFX]
    ZTELF,            -- Telephone 1 [TELF1]
    ZTELX,            -- Telex [TELX1]
    HKTID,            -- Account ID [HKTID]
    HBKID,            -- House Bank [HBKID]
    UBNKY,            -- House Bank Key [UBNKY]
    UBNKS,            -- Bank Ctry/Reg. [BANKS]
    UBNKL,            -- House bank no. [UBNKL]
    UIBAN,            -- IBAN House Bank [UIBAN]
    UBKNT,            -- Our account number [UBKNT]
    UBKON,            -- Control Key [UBKON]
    UBNKR,            -- Regional Code [PRQ_UBNKR]
    UBHKT,            -- G/L Account No. [UBHKT]
    BKHBK,            -- Bank G/L account [PRQ_BKHBK]
    BTYP1,            -- Bank type in chain [BNTYP]
    BNKS1,            -- Bank Ctry/Reg. [BANKS]
    BNKL1,            -- Bank Key [BANKK]
    BNKN1,            -- Bank Account [BANKN]
    BKON1,            -- Control Key [BKONT]
    BKRF1,            -- Reference [BKREF]
    IBAN1,            -- IBAN [IBAN]
    BTYP2,            -- Bank type in chain [BNTYP]
    BNKS2,            -- Bank Ctry/Reg. [BANKS]
    BNKL2,            -- Bank Key [BANKK]
    BNKN2,            -- Bank Account [BANKN]
    BKON2,            -- Control Key [BKONT]
    BKRF2,            -- Reference [BKREF]
    IBAN2,            -- IBAN [IBAN]
    BTYP3,            -- Bank type in chain [BNTYP]
    BNKS3,            -- Bank Ctry/Reg. [BANKS]
    BNKL3,            -- Bank Key [BANKK]
    BNKN3,            -- Bank Account [BANKN]
    BKON3,            -- Control Key [BKONT]
    BKRF3,            -- Reference [BKREF]
    IBAN3,            -- IBAN [IBAN]
    BVTYP,            -- Part.bank type [BVTYP]
    ZBNKS,            -- Country/Region [DZBNKS]
    ZBNKN,            -- Payee acct no. [DZBNKN]
    ZBNKL,            -- Bank number [DZBNKL]
    ZBNKY,            -- Payee bank key [DZBNKY]
    ZBKON,            -- Control Key [DZBKON]
    BKREF,            -- Reference [BKREF]
    ZBNKR,            -- Regional Code [PRQ_ZBNKR]
    SWIFT,            -- SWIFT/BIC [SWIFT]
    KOINH,            -- Account holder [KOINH_FI]
    ZGSBR,            -- Business area [PRQ_ZGSBR]
    GGRUP,            -- Bank Account [PRQ_ZHKONT]
    XRELD,            -- Posted [PRQ_XRELD]
    XRELI,            -- Complete [PRQ_XRELI]
    XRELP,            -- Ind: Rel.for Payment [PRQ_XRELP]
    XREVE,            -- Revrse [PRQ_XREVE]
    STGRD,            -- Reversal Reason [STGRD]
    XURGE,            -- Ind.: Urgent [PRQ_XURGE]
    TAGE1,            -- Resid. time 1 [TAGE1]
    DUEDT,            -- Paym. req. due date [PRQ_DUEDT]
    VALUT,            -- Value date [PRQ_VALDT]
    CRVAL,            -- Value date payee [PRQ_CRVAL]
    IMPER,            -- Imper.Value Date [PRQ_IMPER]
    ZUONR,            -- Assignment [DZUONR]
    XPORE,            -- Individual Payt [PRQ_XPORE]
    UZAWE,            -- Pmnt Meth. Sup. [UZAWE]
    ZWELS,            -- Payment Methods [DZWELS]
    XEZER,            -- Collect.author. [XEZER]
    SWTXT,            -- SWIFT Text [PRQ_SWTXT]
    XBLNR,            -- Reference [XBLNR1]
    BLDAT,            -- Document Date [BLDAT]
    SGTXT,            -- Text [SGTXT]
    PAYGR,            -- Grouping [PAYGR]
    XKDFB,            -- No Exch. Rate Diffr [XKDFB_042E]
    ZLSPR,            -- Pmnt block [DZLSPR]
    VBUND,            -- Trading Partner [RASSC]
    AUGDT,            -- Clearing [AUGDT]
    AUGCP,            -- ClearingEntDate [AUGCP]
    AUGBL,            -- Clrng doc. [AUGBL]
    AWSYS,            -- Logical System [LOGSYSTEM]
    AWTYP,            -- Ref. procedure [AWTYP]
    AWKEY,            -- Reference Key [AWKEY]
    ORIGIN,           -- Origin [FIBL_ORIGIN]
    HBKGR,            -- Group of house bank accts [FIBL_HBG]
    RFTTRN,           -- Payment code [RFTTRN_BF]
    POST_NAME,        -- User: Posting [PRQ_POSTNAME]
    POST_DATE,        -- Posting Date [PRQ_POSTDATE]
    REL_NAME,         -- User: Release [PRQ_RELNAME]
    REL_DATE,         -- Release Date [PRQ_RELDATE]
    DEDUAMNTP,        -- Amount [PRQ_DEDUAMNTP]
    DEDUAMNTL,        -- Amount [PRQ_DEDUAMNTL]
    WTAMNTP,          -- Amount [PRQ_WTAMNTP]
    WTAMNTL,          -- Amount [PRQ_WTAMNTL]
    KIDNO,            -- Payment Ref. [KIDNO]
    ZIBAN,            -- IBAN of the Payee [DZIBAN]
    SNAME1,           -- Name [NAME1_GP]
    SORT01,           -- City [ORT01_GP]
    SLAND1,           -- Country/Region Key [LAND1_GP]
    VERTN,            -- Contract Number [RANL]
    EXTACCOUNT,       -- External Account [TPM_EXT_ACCOUNT]
    ZPFOR,            -- PO box city [PFORT_Z]
    MGUID,            -- Mandate GUID [SEPA_MGUID]
    SNAME2,           -- Name 2 [NAME2_GP]
    SNAME3,           -- Name 3 [NAME3_GP]
    SNAME4,           -- Name 4 [NAME4_GP]
    SSTRAS,           -- Street [STRAS_GP]
    SSTRS2,           -- Street [STRAS_GP]
    SPSTLZ,           -- Postal Code [PSTLZ_BAS]
    SID,              -- Payer of a Payment [SENDER_ID]
    PURP_CODE,        -- SEPA Purpose Code: Classification of a Payment/Debit Memo [FPM_PURP_CODE]
    PAYT_RSN,         -- Payment Reason [FARP_PAYT_RSN]
    ZPAYMENT_SYSTEM,  -- Payee Payment System [PAYEE_PAYMENT_SYSTEM]
    ZALIAS_TYPE,      -- Payee Alias Type [PAYEE_ALIAS_TYPE]
    ZBANK_ALIAS,      -- Payee Alias [PAYEE_BANK_ALIAS]
    PRIMARY KEY (MANDT, KEYNO)
);

Learn More