DPAYP

Transparent Table Application Table
59 Fields 1 CDS Views

Zahlungsprogramm - Daten zum bezahlten Posten

DPAYP is an SAP database table in S/4HANA. Zahlungsprogramm - Daten zum bezahlten Posten. It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAPaymentRunItem view_entity from BASIC Contract Accounting Payment Run Item

Fields (59)

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
KEY doc2t doc2t_pay Document Categ.
KEY doc2r doc2r_pay Paid Document
gpa2t gpa2t_pay Partner Categy
gpa2r gpa2r_pay Business Partner
acc1t acc1t_pay Cont. Acct Cat.
acc1r acc1r_pay Cont Acct Ref.
vor1t vor1t_pay Activity type
vor1r vor1r_pay Main Transactn
vor2t vor1t_pay Activity type
vor2r vor2r_pay Subtransaction
txt1t txt1t_pay Long text type
txt1r txt1r_pay Long text reference
adrnr ad_addrnum Address Number
name1 ad_name1 Name
land1 land1 Country/Reg.
regio regio Region
ort01 ad_city1 City
bldat bldat Document Date
budat budat Posting Date
faedt faedt_f110 Due Date
sktpa sktpa_kk Agreed disct %
waers waers Currency
betrw betrw_kk Amount
augbh augbh_kk LC clearing amt
augbw augbw_kk TC Clearing Amt
askth askth_kk Prop.disc in LC
asktw asktw_kk Prop.disc in TC
sttax sttax_kk Tax Portion
poken poken_pay Payt Exception
zlspr spzah_kk Pymt Lock Rsn
clrlo clrlo_kk Clearing Lock
bukrs bukrs Company Code
gsber gsber Business Area
c4eye c4eye_kk Check Reason
optxt sgtxt Text
ref1t refit_pay Reference information type
ref1r refin_pay Reference
ref2t refit_pay Reference information type
ref2r refin_pay Reference
ref3t refit_pay Reference information type
ref3r refin_pay Reference
vtref vtref_kk Contract
vtpos vtpos_kk Contract Item
vtre2 vtref_kk Contract
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
stcd1 stcd1 Tax Number 1
aqsbw aqsbw_kk Prop.W/HtaxTC
aqsbh aqsbh_kk PropW/HtaxLC
qsskz qsskz WTax Code
stakz stakz_kk Statistical key
subap subap_kk Subapplication

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.

-- Zahlungsprogramm - Daten zum bezahlten Posten
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPAYP (
    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]
    DOC2T,  -- Document Categ. [doc2t_pay]
    DOC2R,  -- Paid Document [doc2r_pay]
    GPA2T,  -- Partner Categy [gpa2t_pay]
    GPA2R,  -- Business Partner [gpa2r_pay]
    ACC1T,  -- Cont. Acct Cat. [acc1t_pay]
    ACC1R,  -- Cont Acct Ref. [acc1r_pay]
    VOR1T,  -- Activity type [vor1t_pay]
    VOR1R,  -- Main Transactn [vor1r_pay]
    VOR2T,  -- Activity type [vor1t_pay]
    VOR2R,  -- Subtransaction [vor2r_pay]
    TXT1T,  -- Long text type [txt1t_pay]
    TXT1R,  -- Long text reference [txt1r_pay]
    ADRNR,  -- Address Number [ad_addrnum]
    NAME1,  -- Name [ad_name1]
    LAND1,  -- Country/Reg. [land1]
    REGIO,  -- Region [regio]
    ORT01,  -- City [ad_city1]
    BLDAT,  -- Document Date [bldat]
    BUDAT,  -- Posting Date [budat]
    FAEDT,  -- Due Date [faedt_f110]
    SKTPA,  -- Agreed disct % [sktpa_kk]
    WAERS,  -- Currency [waers]
    BETRW,  -- Amount [betrw_kk]
    AUGBH,  -- LC clearing amt [augbh_kk]
    AUGBW,  -- TC Clearing Amt [augbw_kk]
    ASKTH,  -- Prop.disc in LC [askth_kk]
    ASKTW,  -- Prop.disc in TC [asktw_kk]
    STTAX,  -- Tax Portion [sttax_kk]
    POKEN,  -- Payt Exception [poken_pay]
    ZLSPR,  -- Pymt Lock Rsn [spzah_kk]
    CLRLO,  -- Clearing Lock [clrlo_kk]
    BUKRS,  -- Company Code [bukrs]
    GSBER,  -- Business Area [gsber]
    C4EYE,  -- Check Reason [c4eye_kk]
    OPTXT,  -- Text [sgtxt]
    REF1T,  -- Reference information type [refit_pay]
    REF1R,  -- Reference [refin_pay]
    REF2T,  -- Reference information type [refit_pay]
    REF2R,  -- Reference [refin_pay]
    REF3T,  -- Reference information type [refit_pay]
    REF3R,  -- Reference [refin_pay]
    VTREF,  -- Contract [vtref_kk]
    VTPOS,  -- Contract Item [vtpos_kk]
    VTRE2,  -- Contract [vtref_kk]
    LZBKZ,  -- SCB Ind. [lzbkz]
    LANDL,  -- Supply C/R [landl]
    STCD1,  -- Tax Number 1 [stcd1]
    AQSBW,  -- Prop.W/HtaxTC [aqsbw_kk]
    AQSBH,  -- PropW/HtaxLC [aqsbh_kk]
    QSSKZ,  -- WTax Code [qsskz]
    STAKZ,  -- Statistical key [stakz_kk]
    SUBAP,  -- Subapplication [subap_kk]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, ORIGN, XVORL, PAYNO, SUBNO, DOC2T, DOC2R)
);

Learn More