PAYR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Outgoingcheck | view | from | EXTENSION | Include view of outgoing checks mngmnt |
| P_OutgoingCheck | view | from | BASIC | CDS view OutgoingCheck basic |
Fields (63)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA