KBLK_DRAFT2

Transparent Table Application Table
65 Fields 2 CDS Views

R_EARMARKEDFUNDSDOCUMENTTP R_EARMARKEDFUNDSDOCUMENTTP

KBLK_DRAFT2 is an SAP database table in S/4HANA. R_EARMARKEDFUNDSDOCUMENTTP R_EARMARKEDFUNDSDOCUMENTTP. It contains 65 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_EarmarkedFundsDocumentDraft view_entity from EXTENSION Earmarked Funds Document Item - Extn
R_EarmarkedFundsDocumentDraft view_entity from BASIC Earmarked Funds Document - Draft

Fields (65)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY earmarkedfundsdocument KBLNR_DY Document Number
KEY draftuuid SDRAFT_UUID Draft Document ID
earmarkedfundsdocumentforedit FMIS_EARMARKEDFUNDSDOCEXT External Document Number
earmarkedfundsdocumentcategory FMIS_EFD_DOCCATEGORY Document Category
earmarkedfundsdocumenttype FMRE_BLART Document Type
companycode BUKRS Company Code
financialmanagementarea FIKRS FM Area
controllingarea KOKRS CO Area
transactioncurrency TWAER Trans. Currency
companycodecurrency HSWAE Local currency
earmarkedfundsdocreference XBLNR1 Reference
earmarkedfundsdocreference2 FMRE_XBLNR2 Reference 2
earmarkedfundsdocreference3 FMRE_XBLNR3 Reference 3
earmarkedfundsheadertext KBLKTEXT Document Text
earmarkedfundshaslongtext KBLLTEXT Long Txt Exists
postingdate BUDAT Posting Date
documentdate BLDAT Document Date
exchangeratedate WWERT_D Translatn Date
absoluteexchangerate FIS_ABSOLUTE_EXCHANGERATE Absolute Exchange Rate
exchrateisindirectquotation FIS_INDIRECT_QUOTATION Exchange Rate Is Indirect Quotation
emrkdfndsdoccreatedbyuser KBLERF Entered By
emrkdfndsdoccreationdate KBLERDAT Entered On
emrkdfndsdoclastchangedbyuser KBLAEN Last Changed By
emrkdfndsdoclastchangedate KBLAEDAT Changed On
emrkdfndsdoclastchangedatetime FMRE_LASTCHANGEDATETIME Last Changed On
orgnlbusinesstransactiontype CO_ORGVG Original BTran.
referencedocumenttype AWTYP Ref. procedure
referencedocument AWREF Reference Doc.
referencedocumentcontext AWORG Refer. Org.Unit
referencedocumentlogicalsystem AWSYS Logical System
emrkdfndsismarkedforarchiving KBLKLOEKZ Can Be Archived
emrkdfndshasnegativeamounts NEGVAL Neg.Values
emrkdfndsisblockedagainstusage BLKKZ Doc.Blocked
earmarkedfundsiscompleted FEXEC Doc.Completed
earmarkedfundsisapproved WKAPK Doc. Approved
emrkdfndswasalreadyaprvdonce WKAOK Already Apprvd
emrkdfndshasaddlcnsmpnlogic ADDITIV_CONSUMPTION_LOGIC Add. Rdctn Logic
earmarkedfundsdecisionreason FMREASON Decision Reason
earmarkedfundsstartworkflow FMIS_EFD_START_APPROVAL_WF Start Approval by Workflow
earmarkedfundsmanualeditblock FMRDOCLOCK Document Block
emrkdfndsmnleditblkforedit FMRDOCLOCK Document Block
emrkdfndshasvalueadjustments FMPMDOCS Value Adjustmts
earmarkedfundsdocentrystatus FMR_MVSTAT Status
emrkdfndstotalintranscrcy KBLWTG Total Amount
emrkdfndsreltotalintranscrcy WTGESAPP Release Amount
emrkdfndsopentotalintranscrcy FMWTFREE Open Amount
emrkdfndschgdtotalintranscrcy DELTAWTAPP Amount Changed
emrkdfndscnsmdtotalintranscrcy KBLWTABG Reduced Amount
emrkdfndsorigltotalintranscrcy FMWTORIG Original Amount
emrkdfndstotalincccrcy FMIS_EFD_AMOUNTINCCCRCY Total Amount in Local Currency
emrkdfndsreltotalincccrcy HWGESAPP Amt for Release
emrkdfndsopentotalincccrcy FMIS_EFD_OPENAMTINCCCRCY Open Amount in Local Currency
emrkdfndschgdtotalincccrcy FMIS_EFD_CHGDAMTINCCCRCY Amount Changed in Local Currency
emrkdfndscnsmdtotalincccrcy KBLWTABG Reduced Amount
emrkdfndsorigltotalincccrcy FMHWORIG Original Amount
bopfuuid SDRAFT_UUID Draft Document ID
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_incl_eew_kblk_ps CFD_DUMMY Dummy

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.

-- R_EARMARKEDFUNDSDOCUMENTTP R_EARMARKEDFUNDSDOCUMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KBLK_DRAFT2 (
    MANDT,                           -- Client [MANDT]
    EARMARKEDFUNDSDOCUMENT,          -- Document Number [KBLNR_DY]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    EARMARKEDFUNDSDOCUMENTFOREDIT,   -- External Document Number [FMIS_EARMARKEDFUNDSDOCEXT]
    EARMARKEDFUNDSDOCUMENTCATEGORY,  -- Document Category [FMIS_EFD_DOCCATEGORY]
    EARMARKEDFUNDSDOCUMENTTYPE,      -- Document Type [FMRE_BLART]
    COMPANYCODE,                     -- Company Code [BUKRS]
    FINANCIALMANAGEMENTAREA,         -- FM Area [FIKRS]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    TRANSACTIONCURRENCY,             -- Trans. Currency [TWAER]
    COMPANYCODECURRENCY,             -- Local currency [HSWAE]
    EARMARKEDFUNDSDOCREFERENCE,      -- Reference [XBLNR1]
    EARMARKEDFUNDSDOCREFERENCE2,     -- Reference 2 [FMRE_XBLNR2]
    EARMARKEDFUNDSDOCREFERENCE3,     -- Reference 3 [FMRE_XBLNR3]
    EARMARKEDFUNDSHEADERTEXT,        -- Document Text [KBLKTEXT]
    EARMARKEDFUNDSHASLONGTEXT,       -- Long Txt Exists [KBLLTEXT]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    DOCUMENTDATE,                    -- Document Date [BLDAT]
    EXCHANGERATEDATE,                -- Translatn Date [WWERT_D]
    ABSOLUTEEXCHANGERATE,            -- Absolute Exchange Rate [FIS_ABSOLUTE_EXCHANGERATE]
    EXCHRATEISINDIRECTQUOTATION,     -- Exchange Rate Is Indirect Quotation [FIS_INDIRECT_QUOTATION]
    EMRKDFNDSDOCCREATEDBYUSER,       -- Entered By [KBLERF]
    EMRKDFNDSDOCCREATIONDATE,        -- Entered On [KBLERDAT]
    EMRKDFNDSDOCLASTCHANGEDBYUSER,   -- Last Changed By [KBLAEN]
    EMRKDFNDSDOCLASTCHANGEDATE,      -- Changed On [KBLAEDAT]
    EMRKDFNDSDOCLASTCHANGEDATETIME,  -- Last Changed On [FMRE_LASTCHANGEDATETIME]
    ORGNLBUSINESSTRANSACTIONTYPE,    -- Original BTran. [CO_ORGVG]
    REFERENCEDOCUMENTTYPE,           -- Ref. procedure [AWTYP]
    REFERENCEDOCUMENT,               -- Reference Doc. [AWREF]
    REFERENCEDOCUMENTCONTEXT,        -- Refer. Org.Unit [AWORG]
    REFERENCEDOCUMENTLOGICALSYSTEM,  -- Logical System [AWSYS]
    EMRKDFNDSISMARKEDFORARCHIVING,   -- Can Be Archived [KBLKLOEKZ]
    EMRKDFNDSHASNEGATIVEAMOUNTS,     -- Neg.Values [NEGVAL]
    EMRKDFNDSISBLOCKEDAGAINSTUSAGE,  -- Doc.Blocked [BLKKZ]
    EARMARKEDFUNDSISCOMPLETED,       -- Doc.Completed [FEXEC]
    EARMARKEDFUNDSISAPPROVED,        -- Doc. Approved [WKAPK]
    EMRKDFNDSWASALREADYAPRVDONCE,    -- Already Apprvd [WKAOK]
    EMRKDFNDSHASADDLCNSMPNLOGIC,     -- Add. Rdctn Logic [ADDITIV_CONSUMPTION_LOGIC]
    EARMARKEDFUNDSDECISIONREASON,    -- Decision Reason [FMREASON]
    EARMARKEDFUNDSSTARTWORKFLOW,     -- Start Approval by Workflow [FMIS_EFD_START_APPROVAL_WF]
    EARMARKEDFUNDSMANUALEDITBLOCK,   -- Document Block [FMRDOCLOCK]
    EMRKDFNDSMNLEDITBLKFOREDIT,      -- Document Block [FMRDOCLOCK]
    EMRKDFNDSHASVALUEADJUSTMENTS,    -- Value Adjustmts [FMPMDOCS]
    EARMARKEDFUNDSDOCENTRYSTATUS,    -- Status [FMR_MVSTAT]
    EMRKDFNDSTOTALINTRANSCRCY,       -- Total Amount [KBLWTG]
    EMRKDFNDSRELTOTALINTRANSCRCY,    -- Release Amount [WTGESAPP]
    EMRKDFNDSOPENTOTALINTRANSCRCY,   -- Open Amount [FMWTFREE]
    EMRKDFNDSCHGDTOTALINTRANSCRCY,   -- Amount Changed [DELTAWTAPP]
    EMRKDFNDSCNSMDTOTALINTRANSCRCY,  -- Reduced Amount [KBLWTABG]
    EMRKDFNDSORIGLTOTALINTRANSCRCY,  -- Original Amount [FMWTORIG]
    EMRKDFNDSTOTALINCCCRCY,          -- Total Amount in Local Currency [FMIS_EFD_AMOUNTINCCCRCY]
    EMRKDFNDSRELTOTALINCCCRCY,       -- Amt for Release [HWGESAPP]
    EMRKDFNDSOPENTOTALINCCCRCY,      -- Open Amount in Local Currency [FMIS_EFD_OPENAMTINCCCRCY]
    EMRKDFNDSCHGDTOTALINCCCRCY,      -- Amount Changed in Local Currency [FMIS_EFD_CHGDAMTINCCCRCY]
    EMRKDFNDSCNSMDTOTALINCCCRCY,     -- Reduced Amount [KBLWTABG]
    EMRKDFNDSORIGLTOTALINCCCRCY,     -- Original Amount [FMHWORIG]
    BOPFUUID,                        -- Draft Document ID [SDRAFT_UUID]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_INCL_EEW_KBLK_PS,          -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, EARMARKEDFUNDSDOCUMENT, DRAFTUUID)
);

Learn More