FIN_DD_BKINST_D

Transparent Table Application Table
31 Fields 1 CDS Views

Draft table for entity C_DirectDebitMandtInstrnTP

FIN_DD_BKINST_D is an SAP database table in S/4HANA. Draft table for entity C_DirectDebitMandtInstrnTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_DirectDebitMandtInstrnDraft view_entity from BASIC Data for DDM Instructions

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY directdebitmandateuuid SEPA_MGUID Mandate GUID
KEY mandateinstructionsqncnumber DDMA_SEQNR3 Seq.number
parentdraftuuid SDRAFT_UUID Draft Document ID
sortingfield DDMA_SRT1 Sorting
mandateinstructiontype DDMA_BKINSTY Instruction Type
directdebitmandate SEPA_MNDID Mandate Ref.
mandateapplication SEPA_ANWND Application
mandatecreditor SEPA_CRDID Creditor ID
mandateversion SEPA_MVERS Mandate Version
mandateinstructionstatus DDMA_BKINSTAT Mandate Instr.Status
companycodeautompaymenttrans DDMA_PYBUK Company Code
shortkeyhousebank HBKID House Bank
accountdetails HKTID Account ID
mandateinstructioncrtedbyuser ERNAM Created By
mandtinstructioncrtedondtetime TIMESTAMPL Time Stamp
mandateinstructionchgdbyuser AENAM Changed By
mandtinstructionchgdondatetime TIMESTAMPL Time Stamp
mandateinstructionrundate LAUFD Run On
mandaterunidentification LAUFI Identification
sequentialnumberrun DDMA_LAUFN Sequential Number
mandateinstructionextsqncnmbr DDMA_EXT_SEQN External seq. number
mandateinstructionoutdate DDMA_OUT_DATE Output Date
mandateinstructionouttime DDMA_OUT_TIME Output Time
mandateinstructionoutbyuser DDMA_OUT_BY Output generated by
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity C_DirectDebitMandtInstrnTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIN_DD_BKINST_D (
    MANDT,                           -- Client [MANDT]
    DIRECTDEBITMANDATEUUID,          -- Mandate GUID [SEPA_MGUID]
    MANDATEINSTRUCTIONSQNCNUMBER,    -- Seq.number [DDMA_SEQNR3]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    SORTINGFIELD,                    -- Sorting [DDMA_SRT1]
    MANDATEINSTRUCTIONTYPE,          -- Instruction Type [DDMA_BKINSTY]
    DIRECTDEBITMANDATE,              -- Mandate Ref. [SEPA_MNDID]
    MANDATEAPPLICATION,              -- Application [SEPA_ANWND]
    MANDATECREDITOR,                 -- Creditor ID [SEPA_CRDID]
    MANDATEVERSION,                  -- Mandate Version [SEPA_MVERS]
    MANDATEINSTRUCTIONSTATUS,        -- Mandate Instr.Status [DDMA_BKINSTAT]
    COMPANYCODEAUTOMPAYMENTTRANS,    -- Company Code [DDMA_PYBUK]
    SHORTKEYHOUSEBANK,               -- House Bank [HBKID]
    ACCOUNTDETAILS,                  -- Account ID [HKTID]
    MANDATEINSTRUCTIONCRTEDBYUSER,   -- Created By [ERNAM]
    MANDTINSTRUCTIONCRTEDONDTETIME,  -- Time Stamp [TIMESTAMPL]
    MANDATEINSTRUCTIONCHGDBYUSER,    -- Changed By [AENAM]
    MANDTINSTRUCTIONCHGDONDATETIME,  -- Time Stamp [TIMESTAMPL]
    MANDATEINSTRUCTIONRUNDATE,       -- Run On [LAUFD]
    MANDATERUNIDENTIFICATION,        -- Identification [LAUFI]
    SEQUENTIALNUMBERRUN,             -- Sequential Number [DDMA_LAUFN]
    MANDATEINSTRUCTIONEXTSQNCNMBR,   -- External seq. number [DDMA_EXT_SEQN]
    MANDATEINSTRUCTIONOUTDATE,       -- Output Date [DDMA_OUT_DATE]
    MANDATEINSTRUCTIONOUTTIME,       -- Output Time [DDMA_OUT_TIME]
    MANDATEINSTRUCTIONOUTBYUSER,     -- Output generated by [DDMA_OUT_BY]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, DIRECTDEBITMANDATEUUID, MANDATEINSTRUCTIONSQNCNUMBER)
);

Learn More