KBLK

Transparent Table Application Table
80 Fields 7 CDS Views

Document Header: Manual Document Entry

KBLK is an SAP database table in S/4HANA. Document Header: Manual Document Entry. It contains 80 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_EarmarkedFundsDocument view_entity from EXTENSION Earmarked Funds Document - Extension
I_EarmarkedFunds_Basic view from BASIC DEPRECATED -> use I_EarmarkedFundsDocument
I_EarmarkedFunds_Sum view from BASIC DEPRECATED -> use I_EarmarkedFundsDocumentItem
I_EarmarkedFundsDocTotals view_entity inner BASIC Earmarked Funds Document Totals
I_EarmarkedFundsDocument view_entity from BASIC Earmarked Funds Document
R_DspDocFlwEmrkdFundsDocument view from BASIC DDF Interface for Earmarked Funds
shsm_efditm_cc view_entity inner Search Help Sel. EFD Items Credit Cards

Fields (80)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY belnr KBLNR Earmarked Funds
kvrgng KBLVORGANG Activity
kerfas KBLERF Entered By
kerdat KBLERDAT Entered On
kaende KBLAEN Last Changed By
kaedat KBLAEDAT Changed On
bldat BLDAT Document Date
ktext KBLKTEXT Document Text
xblnr XBLNR1 Reference
blart KBLART Document Type
bltyp KBLTYP Doc. Category
varnr KBLVAR Entry Variant
waers TWAER Trans. Currency
kloekz KBLLOEKZ Del. Ind.
bukrs BUKRS Company Code
kokrs KOKRS CO Area
fikrs FIKRS FM Area
ltext KBLLTEXT Long Txt Exists
rbelnr KBLRBELNR Ref. Doc. No.
lotkz LOTKZ Lot No.
hwaer HSWAE Local currency
kursf KURSF Exchange rate
wwert WWERT_D Translatn Date
negval NEGVAL Neg.Values
budat BUDAT Posting Date
fmre_xblnr2 FMRE_XBLNR2 Reference 2
fmre_xblnr3 FMRE_XBLNR3 Reference 3
psoef_mltyr FMRE_PSOEF_MLTYR MultiY.EarmarkdFnd
lastchangedatetime FMRE_LASTCHANGEDATETIME Last Changed On
dummy_incl_eew_kblk_ps CFD_DUMMY Dummy
blkkz BLKKZ Doc.Blocked
fexec FEXEC Doc.Completed
wkapk WKAPK Doc. Approved
wkaok WKAOK Already Apprvd
additiv_cons_log ADDITIV_CONSUMPTION_LOGIC Add. Rdctn Logic
fmreason FMREASON Decision Reason
wf_start WF_START Start Workflow
orgvg CO_ORGVG Original BTran.
kursuk KURSU Revaltn Rate
datuk DATU Reval.Date
nprbudget FM_NPRBUDG Non-Prof.Budget
paybudget FM_PAYBUDG Payment Budget
combudget FM_COMBUDG Commt Budget
doclock FMRDOCLOCK Document Block
pmdocs FMPMDOCS Value Adjustmts
rfblnr AWREF Reference Doc.
rforg AWORG Refer. Org.Unit
rftyp AWTYP Ref. procedure
rfsys AWSYS Logical System
mvstat FMR_MVSTAT Status
inv_cons FMRE_INV_CONS Invoice Verification
xdate SAFM_XDATE Reference Date
fmro_template FMRO_TEMPLATE Recurring Obl.
reft CHAR30 30 Characters
moda NUMC3 Dummy
pfm_foa PFM_FOA Form of Amendment
pfm_spec PFM_SPEC Specification Code
pfm_contract PFM_CONTRACT Contract
ccins CCINS_30F Card type
ccnum CCNUM_30F Card Number
ccname CCNAME_30F Cardholder Name
cctyp CCTYP_30F Card category
crpudate CRPUDATE Transaction Dte
crauthno CRAUTHNO Authoriz. No.
crsupplier CRSUPPLIER Trader
crwrbtr CRWRBTR Trans. Amount
crmwskz CRMWSKZ Tax code
crtxjcd TXJCD Tax Jur.
crwmwst CRWMWST Tax amount
crcalctax CRCALCTAX Calculate tax
crnetbtr CRNETBTR Net amount
crdmbtr CRDMBTR Local currency amt
crmwsts CRMWSTS LC tax amount
crnetdmbtr CRNETDMBTR LC Net Amount
crmatgot CRRECIEVED Goods Received
create_res CREATE_RES Reserve Amount
crmatch CRMATCH Reduc. Earmarked
crmatchdt CRMATCHDT Reduc. Earmarked
crsupnam CRSUPNAM Vendor Name

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.

-- Document Header: Manual Document Entry
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KBLK (
    MANDT,                   -- Client [MANDT]
    BELNR,                   -- Earmarked Funds [KBLNR]
    KVRGNG,                  -- Activity [KBLVORGANG]
    KERFAS,                  -- Entered By [KBLERF]
    KERDAT,                  -- Entered On [KBLERDAT]
    KAENDE,                  -- Last Changed By [KBLAEN]
    KAEDAT,                  -- Changed On [KBLAEDAT]
    BLDAT,                   -- Document Date [BLDAT]
    KTEXT,                   -- Document Text [KBLKTEXT]
    XBLNR,                   -- Reference [XBLNR1]
    BLART,                   -- Document Type [KBLART]
    BLTYP,                   -- Doc. Category [KBLTYP]
    VARNR,                   -- Entry Variant [KBLVAR]
    WAERS,                   -- Trans. Currency [TWAER]
    KLOEKZ,                  -- Del. Ind. [KBLLOEKZ]
    BUKRS,                   -- Company Code [BUKRS]
    KOKRS,                   -- CO Area [KOKRS]
    FIKRS,                   -- FM Area [FIKRS]
    LTEXT,                   -- Long Txt Exists [KBLLTEXT]
    RBELNR,                  -- Ref. Doc. No. [KBLRBELNR]
    LOTKZ,                   -- Lot No. [LOTKZ]
    HWAER,                   -- Local currency [HSWAE]
    KURSF,                   -- Exchange rate [KURSF]
    WWERT,                   -- Translatn Date [WWERT_D]
    NEGVAL,                  -- Neg.Values [NEGVAL]
    BUDAT,                   -- Posting Date [BUDAT]
    FMRE_XBLNR2,             -- Reference 2 [FMRE_XBLNR2]
    FMRE_XBLNR3,             -- Reference 3 [FMRE_XBLNR3]
    PSOEF_MLTYR,             -- MultiY.EarmarkdFnd [FMRE_PSOEF_MLTYR]
    LASTCHANGEDATETIME,      -- Last Changed On [FMRE_LASTCHANGEDATETIME]
    DUMMY_INCL_EEW_KBLK_PS,  -- Dummy [CFD_DUMMY]
    BLKKZ,                   -- Doc.Blocked [BLKKZ]
    FEXEC,                   -- Doc.Completed [FEXEC]
    WKAPK,                   -- Doc. Approved [WKAPK]
    WKAOK,                   -- Already Apprvd [WKAOK]
    ADDITIV_CONS_LOG,        -- Add. Rdctn Logic [ADDITIV_CONSUMPTION_LOGIC]
    FMREASON,                -- Decision Reason [FMREASON]
    WF_START,                -- Start Workflow [WF_START]
    ORGVG,                   -- Original BTran. [CO_ORGVG]
    KURSUK,                  -- Revaltn Rate [KURSU]
    DATUK,                   -- Reval.Date [DATU]
    NPRBUDGET,               -- Non-Prof.Budget [FM_NPRBUDG]
    PAYBUDGET,               -- Payment Budget [FM_PAYBUDG]
    COMBUDGET,               -- Commt Budget [FM_COMBUDG]
    DOCLOCK,                 -- Document Block [FMRDOCLOCK]
    PMDOCS,                  -- Value Adjustmts [FMPMDOCS]
    RFBLNR,                  -- Reference Doc. [AWREF]
    RFORG,                   -- Refer. Org.Unit [AWORG]
    RFTYP,                   -- Ref. procedure [AWTYP]
    RFSYS,                   -- Logical System [AWSYS]
    MVSTAT,                  -- Status [FMR_MVSTAT]
    INV_CONS,                -- Invoice Verification [FMRE_INV_CONS]
    XDATE,                   -- Reference Date [SAFM_XDATE]
    FMRO_TEMPLATE,           -- Recurring Obl. [FMRO_TEMPLATE]
    REFT,                    -- 30 Characters [CHAR30]
    MODA,                    -- Dummy [NUMC3]
    PFM_FOA,                 -- Form of Amendment [PFM_FOA]
    PFM_SPEC,                -- Specification Code [PFM_SPEC]
    PFM_CONTRACT,            -- Contract [PFM_CONTRACT]
    CCINS,                   -- Card type [CCINS_30F]
    CCNUM,                   -- Card Number [CCNUM_30F]
    CCNAME,                  -- Cardholder Name [CCNAME_30F]
    CCTYP,                   -- Card category [CCTYP_30F]
    CRPUDATE,                -- Transaction Dte [CRPUDATE]
    CRAUTHNO,                -- Authoriz. No. [CRAUTHNO]
    CRSUPPLIER,              -- Trader [CRSUPPLIER]
    CRWRBTR,                 -- Trans. Amount [CRWRBTR]
    CRMWSKZ,                 -- Tax code [CRMWSKZ]
    CRTXJCD,                 -- Tax Jur. [TXJCD]
    CRWMWST,                 -- Tax amount [CRWMWST]
    CRCALCTAX,               -- Calculate tax [CRCALCTAX]
    CRNETBTR,                -- Net amount [CRNETBTR]
    CRDMBTR,                 -- Local currency amt [CRDMBTR]
    CRMWSTS,                 -- LC tax amount [CRMWSTS]
    CRNETDMBTR,              -- LC Net Amount [CRNETDMBTR]
    CRMATGOT,                -- Goods Received [CRRECIEVED]
    CREATE_RES,              -- Reserve Amount [CREATE_RES]
    CRMATCH,                 -- Reduc. Earmarked [CRMATCH]
    CRMATCHDT,               -- Reduc. Earmarked [CRMATCHDT]
    CRSUPNAM,                -- Vendor Name [CRSUPNAM]
    PRIMARY KEY (MANDT, BELNR)
);

Learn More