DDMA_BKINST

Transparent Table Application Table
24 Fields 1 CDS Views

Mandate changes - instructions for bank communication

DDMA_BKINST is an SAP database table in S/4HANA. Mandate changes - instructions for bank communication. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DirectDebitMandtInstructions view_entity from BASIC Direct Debit Mandate Instructions

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mguid SEPA_MGUID Mandate GUID
KEY seqnr DDMA_SEQNR3 Seq.number
srt1 DDMA_SRT1 Sorting
bkinsty DDMA_BKINSTY Instruction Type
mndid SEPA_MNDID Mandate Ref.
anwnd SEPA_ANWND Application
rec_crdid SEPA_CRDID Creditor ID
mvers_prev SEPA_MVERS Mandate Version
bkinstat DDMA_BKINSTAT Mandate Instr.Status
pybuk DDMA_PYBUK Company Code
hbkid HBKID House Bank
hktid HKTID Account ID
created_by ERNAM Created By
created_on TIMESTAMPL Time Stamp
changed_by AENAM Changed By
changed_on TIMESTAMPL Time Stamp
laufd LAUFD Run On
laufi LAUFI Identification
laufn DDMA_LAUFN Sequential Number
out_seqn DDMA_EXT_SEQN External seq. number
out_date DDMA_OUT_DATE Output Date
out_time DDMA_OUT_TIME Output Time
out_uname DDMA_OUT_BY Output generated by

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.

-- Mandate changes - instructions for bank communication
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDMA_BKINST (
    MANDT,       -- Client [MANDT]
    MGUID,       -- Mandate GUID [SEPA_MGUID]
    SEQNR,       -- Seq.number [DDMA_SEQNR3]
    SRT1,        -- Sorting [DDMA_SRT1]
    BKINSTY,     -- Instruction Type [DDMA_BKINSTY]
    MNDID,       -- Mandate Ref. [SEPA_MNDID]
    ANWND,       -- Application [SEPA_ANWND]
    REC_CRDID,   -- Creditor ID [SEPA_CRDID]
    MVERS_PREV,  -- Mandate Version [SEPA_MVERS]
    BKINSTAT,    -- Mandate Instr.Status [DDMA_BKINSTAT]
    PYBUK,       -- Company Code [DDMA_PYBUK]
    HBKID,       -- House Bank [HBKID]
    HKTID,       -- Account ID [HKTID]
    CREATED_BY,  -- Created By [ERNAM]
    CREATED_ON,  -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,  -- Changed By [AENAM]
    CHANGED_ON,  -- Time Stamp [TIMESTAMPL]
    LAUFD,       -- Run On [LAUFD]
    LAUFI,       -- Identification [LAUFI]
    LAUFN,       -- Sequential Number [DDMA_LAUFN]
    OUT_SEQN,    -- External seq. number [DDMA_EXT_SEQN]
    OUT_DATE,    -- Output Date [DDMA_OUT_DATE]
    OUT_TIME,    -- Output Time [DDMA_OUT_TIME]
    OUT_UNAME,   -- Output generated by [DDMA_OUT_BY]
    PRIMARY KEY (MANDT, MGUID, SEQNR)
);

Learn More