DPAYP

Transparent Table Application Table
67 Fields 1 CDS Views

Payment program - data on paid item

DPAYP is an SAP database table in S/4HANA. Payment program - data on paid item. It contains 67 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 (67)

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
perslt PERSLT_KK Period Text
vkbez VKBEZ_KK Cont. acct name
exvko EXVKO_KK Reference No.
stxtact STXTACT_KK Trans. Text
opbuk PYBUK_KK Paying Co. Code
blart BLART_KK Document Type
spart SPART Division
vtext VTXTK Name

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 on paid item
-- 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]
    PERSLT,   -- Period Text [PERSLT_KK]
    VKBEZ,    -- Cont. acct name [VKBEZ_KK]
    EXVKO,    -- Reference No. [EXVKO_KK]
    STXTACT,  -- Trans. Text [STXTACT_KK]
    OPBUK,    -- Paying Co. Code [PYBUK_KK]
    BLART,    -- Document Type [BLART_KK]
    SPART,    -- Division [SPART]
    VTEXT,    -- Name [VTXTK]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, ORIGN, XVORL, PAYNO, SUBNO, DOC2T, DOC2R)
);

Learn More