DFKKINVBILL_PY

Transparent Table Application Table
18 Fields 2 CDS Views

Payment Data Items of Billing Document

DFKKINVBILL_PY is an SAP database table in S/4HANA. Payment Data Items of Billing Document. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CABillgDocPaymentItem view_entity from EXTENSION Billg Document Payment Item - Extension
I_CABillgDocPayment view_entity from BASIC Zahldatenpositionen des Abr.belegs

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY billdocno BILLDOCNO_KK Billing Doc.
KEY billdocpayitem BILLDOCPAYITEM_KK Pmt Data Item
refpayitem REFPAYITEM_KK Ext.PmtData Itm
reversalitem REVERSALITEM_KK Reversal Item
py_group PY_GROUP_KK Pmt Data Group
pymet PYMET_KK Payment Method
embvt EMBVT_KK Bank Details
emgpa EMGPA_KK Partner
emcrd EMCRD_KK Card ID
emadr EMADR_KK Address Number
pcard_guid XGUID_PC_KK Pmt Card Suppl.
pcard_xsett XSETT_KK Billing
pyref PYREF_KK Reference
py_amount PY_AMOUNT_KK Max.Payment Amt
py_curr BLWAE_KK Currency
py_prio PY_PRIO_KK Priority
src_group SRC_GROUP_KK Source Item Grp

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 Data Items of Billing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVBILL_PY (
    MANDT,           -- Client [MANDT]
    BILLDOCNO,       -- Billing Doc. [BILLDOCNO_KK]
    BILLDOCPAYITEM,  -- Pmt Data Item [BILLDOCPAYITEM_KK]
    REFPAYITEM,      -- Ext.PmtData Itm [REFPAYITEM_KK]
    REVERSALITEM,    -- Reversal Item [REVERSALITEM_KK]
    PY_GROUP,        -- Pmt Data Group [PY_GROUP_KK]
    PYMET,           -- Payment Method [PYMET_KK]
    EMBVT,           -- Bank Details [EMBVT_KK]
    EMGPA,           -- Partner [EMGPA_KK]
    EMCRD,           -- Card ID [EMCRD_KK]
    EMADR,           -- Address Number [EMADR_KK]
    PCARD_GUID,      -- Pmt Card Suppl. [XGUID_PC_KK]
    PCARD_XSETT,     -- Billing [XSETT_KK]
    PYREF,           -- Reference [PYREF_KK]
    PY_AMOUNT,       -- Max.Payment Amt [PY_AMOUNT_KK]
    PY_CURR,         -- Currency [BLWAE_KK]
    PY_PRIO,         -- Priority [PY_PRIO_KK]
    SRC_GROUP,       -- Source Item Grp [SRC_GROUP_KK]
    PRIMARY KEY (MANDT, BILLDOCNO, BILLDOCPAYITEM)
);

Learn More