DPAYH

Transparent Table Application Table
115 Fields 1 CDS Views

Payment program - data for payment

DPAYH is an SAP database table in S/4HANA. Payment program - data for payment. It contains 115 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAPaymentRunHeader view_entity from BASIC Payment Run Header Data

Fields (115)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY laufd LAUFD_KK Date ID
KEY laufi LAUFI_PAY Identification
KEY orign ORIGN_PAY Source
KEY xvorl XVORL Indicator: Only Proposal Run?
KEY payno PAYNO_PAY Seq. number
KEY subno SUBNO_PAY Job Number
grpno GRPNO_PAY Group number
pmf_key PMFKEY_PAY Redundant Key for Payment Medium Print
srtf1 SRTF1_PAY Sorting
srtf2 SRTF2_PAY Sorting
xavis XAVIS_PAY Output payment advice
org1t ORG1T_PAY Organiz. Type
org1r ORG1R_PAY Organization Ref.
org2t ORG2T_PAY Organizatn Type
org2r ORG2R_PAY Company Code
gpa1t GPA1T_PAY Bus.Partner Cat
gpa1r GPA1R_PAY BusPartner
acc1t ACC1T_PAY Cont. Acct Cat.
acc1r ACC1R_PAY Cont Acct Ref.
doc1t DOC1T_PAY Pay. doc. cat.
doc1r DOC1R_PAY Ref.to payt doc
mastt MASTT_KK Type
mastr MASTR_KK MasterRec Items
nrzaa NRZAA_KK Repaymt Request
zadnr AD_ADDRNUM Address Number
znme1 NAMEZ_KK Payee Name
znme2 NAMEZ_KK Payee Name
zspra SPRAS Language
zland LAND1 Country/Reg.
zregi REGIO Region
zort1 AD_CITY1 City
zort2 AD_CITY2 District
zortp AD_POBXLOC PO Box City
zpst1 AD_PSTCD1 Postal Code
zpst2 AD_PSTCD2 PO Box Post Cde
zpst3 AD_PSTCD3 Company Post Cd
zpfac AD_POBX PO Box
zstra AD_STREET Street
zstr1 AD_HSNM1 House Number
zstr2 AD_HSNM2 Supplement
ztel1 AD_TLNMBR Telephone
ztel2 AD_TLXTNS Extension
zfax1 AD_FXNMBR Fax
zfax2 AD_FXXTNS Extension
zbnks BANKS Bank Ctry/Reg.
zbnky DZBNKY Payee bank key
zbnkl DZBNKL Bank number
zswif SWIFT SWIFT/BIC
zbnkn DZBNKN Payee acct no.
zbkon DZBKON Control Key
zbkrf BKREF Reference
zbkin KOINH_KK Sold-To Party
zpayment_system PAYEE_PAYMENT_SYSTEM_KK Payment System
zalias_type PAYEE_ALIAS_TYPE_KK Alias Type
zbank_alias PAYEE_BANK_ALIAS_KK Bank Alias
bbukr BUKRS_PAY CC in paymtDoc.
bgsbr GSBER_PAY Business area in payment document
waers WAERS Currency
rbetr RBETR_CS Local Curr.Pmnt Amnt
rwbtr RWBTR_CS Amount Paid
rskon RSKON_CS Cash Discnt(LC)
rwskt RWSKT_CS Cash Discount Amount
zaldt DZALDT_ZHL Doc. Pstg Date
diffb DIFFB_KK Difference
ausfd AUSFD Due Date
valut VALUT Value date
rzawe PYMET_KK Payment Method
uzawe UZAWE Pmnt Meth. Sup.
avisg AVISG Advice Reason
rpost RPOST Number of Items Paid
rtext RTEXT_D No.Txt Lines for Items Paid
pygrp PYGRP_KK Pymt Grouping
paygr PAYGR_PAY Grouping
eigbv EIGBV_KK Own Bank Dtls
hbkid HBKID House Bank
hktid HKTID Account ID
ubnks BANKS Bank Ctry/Reg.
ubnky UBNKY House Bank Key
ubnkl UBNKL House bank no.
ubknt UBKNT Our account number
ubkon UBKON Control Key
ubhkt UBHKT G/L Account No.
dtaws DTAWS Instruction Key
dtams DTAMS DME Rec. Code
txtsl TXTSL_042Z Key in code line
txerg TXERG Text key supplement
ccins CC_INSTITUTE Card type
ccnum CCNUM Card number
masked_id DP_MASK_NUMBER Card Number
rqstw RQSTW W/H tax creditor
rqsth RQSTH W/H tax cred.
rqsew RQSEW W/H tax cust.
rqseh RQSEH W/H tax cust.
oribd ORIBD_KK Bank Data
xnolc XNOLC_KK No Local Crcy
ziban IBAN IBAN
pdkey PDKEY_KK Specification
pdref PDREF_KK Reference No.
ppkey PPKEY_KK Promise to Pay
prdat PRODT_KK Payment Date
mguid GUID16 GUID
cguid CARD_GUID GUID of a Payment Card
enctp CCSECA_ENCTYPE Encryption Type
pay_type SEPA_PAY_TYPE Payment Type
seq_type SEPA_SEQ_TYPE Sequence Type
mndid SEPA_MNDID Mandate Ref.
b2b SEPA_B2B B2B Mandate
inst_code FSEPA_INST_CODE Direct Debit Type
anwnd SEPA_ANWND Application
rcrsp_cc RCRSP_CC Card check
rtext_cc RTEXT_CC Text
depot_vkont DEPOT_VKONT_VK Clrg Acct
depot_gpart DEPOT_GPART_VK Clrg Acct BP
depot_insobject DEPOT_INSOBJECT_VK Clrg Acct IO

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 program - data for payment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPAYH (
    MANDT,            -- Client [MANDT]
    LAUFD,            -- Date ID [LAUFD_KK]
    LAUFI,            -- Identification [LAUFI_PAY]
    ORIGN,            -- Source [ORIGN_PAY]
    XVORL,            -- Indicator: Only Proposal Run? [XVORL]
    PAYNO,            -- Seq. number [PAYNO_PAY]
    SUBNO,            -- Job Number [SUBNO_PAY]
    GRPNO,            -- Group number [GRPNO_PAY]
    PMF_KEY,          -- Redundant Key for Payment Medium Print [PMFKEY_PAY]
    SRTF1,            -- Sorting [SRTF1_PAY]
    SRTF2,            -- Sorting [SRTF2_PAY]
    XAVIS,            -- Output payment advice [XAVIS_PAY]
    ORG1T,            -- Organiz. Type [ORG1T_PAY]
    ORG1R,            -- Organization Ref. [ORG1R_PAY]
    ORG2T,            -- Organizatn Type [ORG2T_PAY]
    ORG2R,            -- Company Code [ORG2R_PAY]
    GPA1T,            -- Bus.Partner Cat [GPA1T_PAY]
    GPA1R,            -- BusPartner [GPA1R_PAY]
    ACC1T,            -- Cont. Acct Cat. [ACC1T_PAY]
    ACC1R,            -- Cont Acct Ref. [ACC1R_PAY]
    DOC1T,            -- Pay. doc. cat. [DOC1T_PAY]
    DOC1R,            -- Ref.to payt doc [DOC1R_PAY]
    MASTT,            -- Type [MASTT_KK]
    MASTR,            -- MasterRec Items [MASTR_KK]
    NRZAA,            -- Repaymt Request [NRZAA_KK]
    ZADNR,            -- Address Number [AD_ADDRNUM]
    ZNME1,            -- Payee Name [NAMEZ_KK]
    ZNME2,            -- Payee Name [NAMEZ_KK]
    ZSPRA,            -- Language [SPRAS]
    ZLAND,            -- Country/Reg. [LAND1]
    ZREGI,            -- Region [REGIO]
    ZORT1,            -- City [AD_CITY1]
    ZORT2,            -- District [AD_CITY2]
    ZORTP,            -- PO Box City [AD_POBXLOC]
    ZPST1,            -- Postal Code [AD_PSTCD1]
    ZPST2,            -- PO Box Post Cde [AD_PSTCD2]
    ZPST3,            -- Company Post Cd [AD_PSTCD3]
    ZPFAC,            -- PO Box [AD_POBX]
    ZSTRA,            -- Street [AD_STREET]
    ZSTR1,            -- House Number [AD_HSNM1]
    ZSTR2,            -- Supplement [AD_HSNM2]
    ZTEL1,            -- Telephone [AD_TLNMBR]
    ZTEL2,            -- Extension [AD_TLXTNS]
    ZFAX1,            -- Fax [AD_FXNMBR]
    ZFAX2,            -- Extension [AD_FXXTNS]
    ZBNKS,            -- Bank Ctry/Reg. [BANKS]
    ZBNKY,            -- Payee bank key [DZBNKY]
    ZBNKL,            -- Bank number [DZBNKL]
    ZSWIF,            -- SWIFT/BIC [SWIFT]
    ZBNKN,            -- Payee acct no. [DZBNKN]
    ZBKON,            -- Control Key [DZBKON]
    ZBKRF,            -- Reference [BKREF]
    ZBKIN,            -- Sold-To Party [KOINH_KK]
    ZPAYMENT_SYSTEM,  -- Payment System [PAYEE_PAYMENT_SYSTEM_KK]
    ZALIAS_TYPE,      -- Alias Type [PAYEE_ALIAS_TYPE_KK]
    ZBANK_ALIAS,      -- Bank Alias [PAYEE_BANK_ALIAS_KK]
    BBUKR,            -- CC in paymtDoc. [BUKRS_PAY]
    BGSBR,            -- Business area in payment document [GSBER_PAY]
    WAERS,            -- Currency [WAERS]
    RBETR,            -- Local Curr.Pmnt Amnt [RBETR_CS]
    RWBTR,            -- Amount Paid [RWBTR_CS]
    RSKON,            -- Cash Discnt(LC) [RSKON_CS]
    RWSKT,            -- Cash Discount Amount [RWSKT_CS]
    ZALDT,            -- Doc. Pstg Date [DZALDT_ZHL]
    DIFFB,            -- Difference [DIFFB_KK]
    AUSFD,            -- Due Date [AUSFD]
    VALUT,            -- Value date [VALUT]
    RZAWE,            -- Payment Method [PYMET_KK]
    UZAWE,            -- Pmnt Meth. Sup. [UZAWE]
    AVISG,            -- Advice Reason [AVISG]
    RPOST,            -- Number of Items Paid [RPOST]
    RTEXT,            -- No.Txt Lines for Items Paid [RTEXT_D]
    PYGRP,            -- Pymt Grouping [PYGRP_KK]
    PAYGR,            -- Grouping [PAYGR_PAY]
    EIGBV,            -- Own Bank Dtls [EIGBV_KK]
    HBKID,            -- House Bank [HBKID]
    HKTID,            -- Account ID [HKTID]
    UBNKS,            -- Bank Ctry/Reg. [BANKS]
    UBNKY,            -- House Bank Key [UBNKY]
    UBNKL,            -- House bank no. [UBNKL]
    UBKNT,            -- Our account number [UBKNT]
    UBKON,            -- Control Key [UBKON]
    UBHKT,            -- G/L Account No. [UBHKT]
    DTAWS,            -- Instruction Key [DTAWS]
    DTAMS,            -- DME Rec. Code [DTAMS]
    TXTSL,            -- Key in code line [TXTSL_042Z]
    TXERG,            -- Text key supplement [TXERG]
    CCINS,            -- Card type [CC_INSTITUTE]
    CCNUM,            -- Card number [CCNUM]
    MASKED_ID,        -- Card Number [DP_MASK_NUMBER]
    RQSTW,            -- W/H tax creditor [RQSTW]
    RQSTH,            -- W/H tax cred. [RQSTH]
    RQSEW,            -- W/H tax cust. [RQSEW]
    RQSEH,            -- W/H tax cust. [RQSEH]
    ORIBD,            -- Bank Data [ORIBD_KK]
    XNOLC,            -- No Local Crcy [XNOLC_KK]
    ZIBAN,            -- IBAN [IBAN]
    PDKEY,            -- Specification [PDKEY_KK]
    PDREF,            -- Reference No. [PDREF_KK]
    PPKEY,            -- Promise to Pay [PPKEY_KK]
    PRDAT,            -- Payment Date [PRODT_KK]
    MGUID,            -- GUID [GUID16]
    CGUID,            -- GUID of a Payment Card [CARD_GUID]
    ENCTP,            -- Encryption Type [CCSECA_ENCTYPE]
    PAY_TYPE,         -- Payment Type [SEPA_PAY_TYPE]
    SEQ_TYPE,         -- Sequence Type [SEPA_SEQ_TYPE]
    MNDID,            -- Mandate Ref. [SEPA_MNDID]
    B2B,              -- B2B Mandate [SEPA_B2B]
    INST_CODE,        -- Direct Debit Type [FSEPA_INST_CODE]
    ANWND,            -- Application [SEPA_ANWND]
    RCRSP_CC,         -- Card check [RCRSP_CC]
    RTEXT_CC,         -- Text [RTEXT_CC]
    DEPOT_VKONT,      -- Clrg Acct [DEPOT_VKONT_VK]
    DEPOT_GPART,      -- Clrg Acct BP [DEPOT_GPART_VK]
    DEPOT_INSOBJECT,  -- Clrg Acct IO [DEPOT_INSOBJECT_VK]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, ORIGN, XVORL, PAYNO, SUBNO)
);

Learn More