DFKKPRNH

Transparent Table Application Table
29 Fields 1 CDS Views

SEPA: Lastschriftankündigungen (FI-CA)

DFKKPRNH is an SAP database table in S/4HANA. SEPA: Lastschriftankündigungen (FI-CA). It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CADirectDebitAdvNoticeHeader view_entity from BASIC Direct Debit Advance Notice in CA

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pnnum pnnum_kk Pre-Notif.
KEY pnhkf pnhkf_kk Mandate Origin
gpart gpart_kk Bus. Partner
ori_gpart ori_gpart_kk Alternative Partner
pnexd pnexd_kk Exec.Date
pnsta pnsta_kk Status
mndid sepa_mndid Mandate Ref.
betrw betrw_kk Amount
betrw_act betrw_act_kk Current Amount
waers waers Currency
laufd_cre laufd_kk Date ID
laufi_cre laufi_kk Run ID
payno payno_pay Seq. number
doc1r doc1r_pay Ref.to payt doc
doc1t doc1t_pay Pay. doc. cat.
cpudt cpudt Entered On
cputm cputm Entered at
cotyp cotyp_kk Corresp. Type
cokey cokey_kk Correspond. Key
pnxref pnxref_kk Reference
pybuk pybuk_kk Paying Co. Code
ernam ernam_kk Created By
aenam aenam_kk Changed By
aedat aedat_kk Changed On
aetim aetim_kk Time
ziban iban_kk IBAN
embvt embvt_kk Bank Details
xcrea xcrea_kk Credit Memos

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.

-- SEPA: Lastschriftankündigungen (FI-CA)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKPRNH (
    MANDT,      -- Client [mandt]
    PNNUM,      -- Pre-Notif. [pnnum_kk]
    PNHKF,      -- Mandate Origin [pnhkf_kk]
    GPART,      -- Bus. Partner [gpart_kk]
    ORI_GPART,  -- Alternative Partner [ori_gpart_kk]
    PNEXD,      -- Exec.Date [pnexd_kk]
    PNSTA,      -- Status [pnsta_kk]
    MNDID,      -- Mandate Ref. [sepa_mndid]
    BETRW,      -- Amount [betrw_kk]
    BETRW_ACT,  -- Current Amount [betrw_act_kk]
    WAERS,      -- Currency [waers]
    LAUFD_CRE,  -- Date ID [laufd_kk]
    LAUFI_CRE,  -- Run ID [laufi_kk]
    PAYNO,      -- Seq. number [payno_pay]
    DOC1R,      -- Ref.to payt doc [doc1r_pay]
    DOC1T,      -- Pay. doc. cat. [doc1t_pay]
    CPUDT,      -- Entered On [cpudt]
    CPUTM,      -- Entered at [cputm]
    COTYP,      -- Corresp. Type [cotyp_kk]
    COKEY,      -- Correspond. Key [cokey_kk]
    PNXREF,     -- Reference [pnxref_kk]
    PYBUK,      -- Paying Co. Code [pybuk_kk]
    ERNAM,      -- Created By [ernam_kk]
    AENAM,      -- Changed By [aenam_kk]
    AEDAT,      -- Changed On [aedat_kk]
    AETIM,      -- Time [aetim_kk]
    ZIBAN,      -- IBAN [iban_kk]
    EMBVT,      -- Bank Details [embvt_kk]
    XCREA,      -- Credit Memos [xcrea_kk]
    PRIMARY KEY (MANDT, PNNUM, PNHKF)
);

Learn More