PAYR

Transparent Table Application Table

Zahlungsträgerdatei

PAYR is an SAP database table in S/4HANA. Zahlungsträgerdatei. It contains 63 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_Outgoingcheck view from EXTENSION Include view of outgoing checks mngmnt
P_OutgoingCheck view from BASIC CDS view OutgoingCheck basic

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY zbukr dzbukr Paying co. code
KEY hbkid hbkid House Bank
KEY hktid hktid Account ID
KEY rzawe dzlsch Pymt Meth.
KEY chect chect Check number
checf checf Check Number
laufd laufd Run On
laufi laufi Identification
lifnr lifnr Supplier
kunnr kunnr Customer
empfg empfg Pmnt Recipient
ubhkt ubhkt G/L Account No.
vblnr vblnr Payment Doc.No.
gjahr gjahr Fiscal Year
zaldt dzaldt Payment Date
waers waers Currency
rwbtr rwbtr Amount Paid
strgb gsber Business Area
pridt pridt Date
priti priti Time
prius prius Print User
xmanu xmanu Manual
xbanc xbanc Paid Check
bancd bancd Date
extrd extrd Date
extrt extrt Time
xbukr xbukr Intercompany
zanre dzanre Title
znme1 dznme1 Name
znme2 dznme1 Name
znme3 dznme1 Name
znme4 dznme1 Name
zpstl dzpstl Payee Postal Code
zort1 dzort1 City
zstra dzstra Street
zpfac dzpfac PO Box
zland dzland Country/Region
zregi dzregi Regional code
zbnks dzbnks Country/Region
zbnkn dzbnkn Payee acct no.
zbnkl dzbnkl Bank number
zbkon dzbkon Control Key
zswif swift SWIFT/BIC
ziban dziban IBAN of the Payee
uetr fpm_uetr Unique Reference
voidr voidr Void reason
voidd voidd Voided on
voidu voidu Voided by
checv checv Replaced by
hbkiv hbkiv Replacement check bank
hktiv hktiv Replacement check account
zpst2 dzpst2 PO box post cde
xragl xragl Reverse Clearing
pernr pernr_d Personnel No.
seqnr seqc5 Sequence Number
btznr btznr Assignment of Transfers
rec_belnr belnr_d Document Number
rec_gjahr gjahr Fiscal Year
zpfor pfort_z PO box city
uzawe uzawe Pmnt Meth. Sup.
ichec ichec Type of Payment Medium
irefe icref Information as to Whether a Reference to This Payment Exists

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.

-- Zahlungsträgerdatei
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYR (
    MANDT,      -- Client [mandt]
    ZBUKR,      -- Paying co. code [dzbukr]
    HBKID,      -- House Bank [hbkid]
    HKTID,      -- Account ID [hktid]
    RZAWE,      -- Pymt Meth. [dzlsch]
    CHECT,      -- Check number [chect]
    CHECF,      -- Check Number [checf]
    LAUFD,      -- Run On [laufd]
    LAUFI,      -- Identification [laufi]
    LIFNR,      -- Supplier [lifnr]
    KUNNR,      -- Customer [kunnr]
    EMPFG,      -- Pmnt Recipient [empfg]
    UBHKT,      -- G/L Account No. [ubhkt]
    VBLNR,      -- Payment Doc.No. [vblnr]
    GJAHR,      -- Fiscal Year [gjahr]
    ZALDT,      -- Payment Date [dzaldt]
    WAERS,      -- Currency [waers]
    RWBTR,      -- Amount Paid [rwbtr]
    STRGB,      -- Business Area [gsber]
    PRIDT,      -- Date [pridt]
    PRITI,      -- Time [priti]
    PRIUS,      -- Print User [prius]
    XMANU,      -- Manual [xmanu]
    XBANC,      -- Paid Check [xbanc]
    BANCD,      -- Date [bancd]
    EXTRD,      -- Date [extrd]
    EXTRT,      -- Time [extrt]
    XBUKR,      -- Intercompany [xbukr]
    ZANRE,      -- Title [dzanre]
    ZNME1,      -- Name [dznme1]
    ZNME2,      -- Name [dznme1]
    ZNME3,      -- Name [dznme1]
    ZNME4,      -- Name [dznme1]
    ZPSTL,      -- Payee Postal Code [dzpstl]
    ZORT1,      -- City [dzort1]
    ZSTRA,      -- Street [dzstra]
    ZPFAC,      -- PO Box [dzpfac]
    ZLAND,      -- Country/Region [dzland]
    ZREGI,      -- Regional code [dzregi]
    ZBNKS,      -- Country/Region [dzbnks]
    ZBNKN,      -- Payee acct no. [dzbnkn]
    ZBNKL,      -- Bank number [dzbnkl]
    ZBKON,      -- Control Key [dzbkon]
    ZSWIF,      -- SWIFT/BIC [swift]
    ZIBAN,      -- IBAN of the Payee [dziban]
    UETR,       -- Unique Reference [fpm_uetr]
    VOIDR,      -- Void reason [voidr]
    VOIDD,      -- Voided on [voidd]
    VOIDU,      -- Voided by [voidu]
    CHECV,      -- Replaced by [checv]
    HBKIV,      -- Replacement check bank [hbkiv]
    HKTIV,      -- Replacement check account [hktiv]
    ZPST2,      -- PO box post cde [dzpst2]
    XRAGL,      -- Reverse Clearing [xragl]
    PERNR,      -- Personnel No. [pernr_d]
    SEQNR,      -- Sequence Number [seqc5]
    BTZNR,      -- Assignment of Transfers [btznr]
    REC_BELNR,  -- Document Number [belnr_d]
    REC_GJAHR,  -- Fiscal Year [gjahr]
    ZPFOR,      -- PO box city [pfort_z]
    UZAWE,      -- Pmnt Meth. Sup. [uzawe]
    ICHEC,      -- Type of Payment Medium [ichec]
    IREFE,      -- Information as to Whether a Reference to This Payment Exists [icref]
    PRIMARY KEY (MANDT, ZBUKR, HBKID, HKTID, RZAWE, CHECT)
);