KBLP_DRAFT2

Transparent Table Application Table
95 Fields 2 CDS Views

R_EARMARKEDFUNDSDOCUMENTTP R_EARMARKEDFUNDSDOCUMENTITEMTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_EarmarkedFundsDocItemDraft view_entity from EXTENSION Earmarked Funds Document Item - Extn
R_EarmarkedFundsDocItemDraft view_entity from BASIC Earmarked Funds Document Item - Draft

Fields (95)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY earmarkedfundsdocument KBLNR_DY Document Number
KEY earmarkedfundsdocumentitem KBLPOS Document Item
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
earmarkedfundsdocitemforedit KBLPOS Document Item
controllingarea KOKRS CO Area
companycode BUKRS Company Code
financialmanagementarea FIKRS FM Area
transactioncurrency TWAER Trans. Currency
companycodecurrency HSWAE Local currency
postingdate BUDAT Posting Date
emrkdfndsdocitmcreatedbyuser KBLERF Entered By
emrkdfndsdocitmcreationdate KBLERDAT Entered On
emrkdfndsdocitmlastchgdbyusr KBLAEN Last Changed By
emrkdfndsdocitmlastchangedate KBLAEDAT Changed On
glaccount SAKNR G/L Account
costcenter KOSTL Cost Center
internalorder AUFNR Order
wbselementinternalid PS_S4_PSPNR WBS Internal ID
wbselementexternalid PS_POSID_EDIT WBS Element
projectnetwork NPLNR Network
costelement KSTAR Cost Element
commitmentitemfiscalyear FMIS_COMMITITEM_YEAR Commit. Item FY
commitmentitem FM_FIPEX Commitment Item
fundscenter FISTL Funds Center
fund BP_GEBER Fund
fundedprogram FM_MEASURE Funded Program
budgetperiod FM_BUDGET_PERIOD Budget Period
functionalarea FKBER Functional Area
grantid GM_GRANT_NBR Grant
businessarea GSBER Business Area
product PRODUCTNUMBER Product
supplier LIFNR Supplier
customer KUNNR Customer
alternativepayee LNRZA Alternat. Payee
documentitemtext SGTXT Text
emrkdfndsreferencedocumentitem AWPOS Reference item
referencedocumentitem AWPOS Reference item
duedate KBLFDATK Due On
emrkdfndsitmcompletiondate KBLERLDAT Completed On
emrkdfndsdocitmgroupingnumber EF_GROUP_NUMBER Grouping Number
profitcenter FIS_PRCTR Profit Center
emrkdfndsitmprdcssrdoccat REFBLTYP Ref.Doc.Cat.
emrkdfndsitmpredecessor REFKBLNR Ref. Document
emrkdfndsitmprdcssritem REFKBLPOS Reference Item
emrkdfndsitmprdcssrcompleted REFSETERLK Set "Completed"
prdcssrfundsreservationdoc FMIS_EFD_PRED_FUNDSRESDOC Funds Reservation
prdcssrfundsreservationdocitem FMIS_EFD_PRED_FUNDSRESDOCITEM Funds Reservation Item
prdcssrfundsprecmtmtdoc FMIS_EFD_PRED_FUNDSPRECOMDOC Funds Precommitment
prdcssrfundsprecmtmtdocitem FMIS_EFD_PRED_FUNDSPRECOMDOCIT Funds Precommitment Item
emrkdfndsitmiscompleted FMRE_ERLKZ Item Completed
emrkdfndsitmisstatistical FMRE_STATS Statistical
emrkdfndsitmisdeleted KBLLOEKZ Del. Ind.
emrkdfndsitmissender XSENDER Sender
emrkdfndsitmisreceiver XEMPFGR Receiver
emrkdfndsitmmanualeditblock FMRPOSLOCK Item Block
emrkdfndsitmisblkdagainstusage BLPKZ Item Blocked
emrkdfndsitmisunlimited FMCONSUME Unlimited
emrkdfndsitmtolerancelmtinpct FMUEBTO Overrun Tol.
emrkdfndsoverrideglobtolerance FMIS_EFD_OVERRIDEGLOBTOL Override Global Tolerance
emrkdfndsitmisapproved FMIS_EFD_ITMISAPPROVED Item Approved
emrkdfndsitmnocarryforward CARRYOV No Carryforward
emrkdfndsacctassgmtchangeable FMIS_EFD_ACCTASSGMTCHANGEABLE Account Assignment Changeable
emrkdfndshasvalueadjustments FMRPMACTIVE Val.Adjust.Req.
emrkdfndsitmcnsmpnincccrcyonly FMIS_EFD_CNSMPNINCCCRCYONLY Reduction in Local Currency only
emrkdfndsdocitmnmbrofprocgitms FMEWSCOUNT Devel. Records
pubsecsplitbatchnumberid FMSP_SPLIT_BATCH Dist.Batch No.
pubsecsplitauthzngroup FMSP_SPLIT_AUTG Auth.Group
usfedgovernmentuuid FMFG_US_KEY US Govt
fundsmgmtperiodofperfstartdate FM_PEROP_LOW Per. of Perf. Start
fundsmgmtperiodofperfenddate FM_PEROP_HIGH Per. of Perf. End
usfedpromptpaytactexclude EXCLUDE_FLG PPA Exclude
emrkdfndsamountintranscrcy KBLWTG Total Amount
emrkdfndsrelamtintranscrcy WTGESAPP Release Amount
emrkdfndsopenamtintranscrcy FMWTFREE Open Amount
emrkdfndschgdamtintranscrcy DELTAWTAPP Amount Changed
emrkdfndscnsmdamtintranscrcy KBLWTABG Reduced Amount
emrkdfndsoriglamtintranscrcy FMWTORIG Original Amount
emrkdfndsamountincccrcy FMIS_EFD_AMOUNTINCCCRCY Total Amount in Local Currency
emrkdfndsrelamtincccrcy HWGESAPP Amt for Release
emrkdfndsopenamtincccrcy FMIS_EFD_OPENAMTINCCCRCY Open Amount in Local Currency
emrkdfndschgdamtincccrcy DELTAHWAPP Amount Changed
emrkdfndscnsmdamtincccrcy KBLWTABG Reduced Amount
emrkdfndsoriglamtincccrcy FMHWORIG Original Amount
bopfuuid SDRAFT_UUID Draft Document ID
bopfparentuuid 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_kblp_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_EARMARKEDFUNDSDOCUMENTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KBLP_DRAFT2 (
    MANDT,                           -- Client [MANDT]
    EARMARKEDFUNDSDOCUMENT,          -- Document Number [KBLNR_DY]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [KBLPOS]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    EARMARKEDFUNDSDOCITEMFOREDIT,    -- Document Item [KBLPOS]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    COMPANYCODE,                     -- Company Code [BUKRS]
    FINANCIALMANAGEMENTAREA,         -- FM Area [FIKRS]
    TRANSACTIONCURRENCY,             -- Trans. Currency [TWAER]
    COMPANYCODECURRENCY,             -- Local currency [HSWAE]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    EMRKDFNDSDOCITMCREATEDBYUSER,    -- Entered By [KBLERF]
    EMRKDFNDSDOCITMCREATIONDATE,     -- Entered On [KBLERDAT]
    EMRKDFNDSDOCITMLASTCHGDBYUSR,    -- Last Changed By [KBLAEN]
    EMRKDFNDSDOCITMLASTCHANGEDATE,   -- Changed On [KBLAEDAT]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    INTERNALORDER,                   -- Order [AUFNR]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID_EDIT]
    PROJECTNETWORK,                  -- Network [NPLNR]
    COSTELEMENT,                     -- Cost Element [KSTAR]
    COMMITMENTITEMFISCALYEAR,        -- Commit. Item FY [FMIS_COMMITITEM_YEAR]
    COMMITMENTITEM,                  -- Commitment Item [FM_FIPEX]
    FUNDSCENTER,                     -- Funds Center [FISTL]
    FUND,                            -- Fund [BP_GEBER]
    FUNDEDPROGRAM,                   -- Funded Program [FM_MEASURE]
    BUDGETPERIOD,                    -- Budget Period [FM_BUDGET_PERIOD]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    GRANTID,                         -- Grant [GM_GRANT_NBR]
    BUSINESSAREA,                    -- Business Area [GSBER]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    SUPPLIER,                        -- Supplier [LIFNR]
    CUSTOMER,                        -- Customer [KUNNR]
    ALTERNATIVEPAYEE,                -- Alternat. Payee [LNRZA]
    DOCUMENTITEMTEXT,                -- Text [SGTXT]
    EMRKDFNDSREFERENCEDOCUMENTITEM,  -- Reference item [AWPOS]
    REFERENCEDOCUMENTITEM,           -- Reference item [AWPOS]
    DUEDATE,                         -- Due On [KBLFDATK]
    EMRKDFNDSITMCOMPLETIONDATE,      -- Completed On [KBLERLDAT]
    EMRKDFNDSDOCITMGROUPINGNUMBER,   -- Grouping Number [EF_GROUP_NUMBER]
    PROFITCENTER,                    -- Profit Center [FIS_PRCTR]
    EMRKDFNDSITMPRDCSSRDOCCAT,       -- Ref.Doc.Cat. [REFBLTYP]
    EMRKDFNDSITMPREDECESSOR,         -- Ref. Document [REFKBLNR]
    EMRKDFNDSITMPRDCSSRITEM,         -- Reference Item [REFKBLPOS]
    EMRKDFNDSITMPRDCSSRCOMPLETED,    -- Set "Completed" [REFSETERLK]
    PRDCSSRFUNDSRESERVATIONDOC,      -- Funds Reservation [FMIS_EFD_PRED_FUNDSRESDOC]
    PRDCSSRFUNDSRESERVATIONDOCITEM,  -- Funds Reservation Item [FMIS_EFD_PRED_FUNDSRESDOCITEM]
    PRDCSSRFUNDSPRECMTMTDOC,         -- Funds Precommitment [FMIS_EFD_PRED_FUNDSPRECOMDOC]
    PRDCSSRFUNDSPRECMTMTDOCITEM,     -- Funds Precommitment Item [FMIS_EFD_PRED_FUNDSPRECOMDOCIT]
    EMRKDFNDSITMISCOMPLETED,         -- Item Completed [FMRE_ERLKZ]
    EMRKDFNDSITMISSTATISTICAL,       -- Statistical [FMRE_STATS]
    EMRKDFNDSITMISDELETED,           -- Del. Ind. [KBLLOEKZ]
    EMRKDFNDSITMISSENDER,            -- Sender [XSENDER]
    EMRKDFNDSITMISRECEIVER,          -- Receiver [XEMPFGR]
    EMRKDFNDSITMMANUALEDITBLOCK,     -- Item Block [FMRPOSLOCK]
    EMRKDFNDSITMISBLKDAGAINSTUSAGE,  -- Item Blocked [BLPKZ]
    EMRKDFNDSITMISUNLIMITED,         -- Unlimited [FMCONSUME]
    EMRKDFNDSITMTOLERANCELMTINPCT,   -- Overrun Tol. [FMUEBTO]
    EMRKDFNDSOVERRIDEGLOBTOLERANCE,  -- Override Global Tolerance [FMIS_EFD_OVERRIDEGLOBTOL]
    EMRKDFNDSITMISAPPROVED,          -- Item Approved [FMIS_EFD_ITMISAPPROVED]
    EMRKDFNDSITMNOCARRYFORWARD,      -- No Carryforward [CARRYOV]
    EMRKDFNDSACCTASSGMTCHANGEABLE,   -- Account Assignment Changeable [FMIS_EFD_ACCTASSGMTCHANGEABLE]
    EMRKDFNDSHASVALUEADJUSTMENTS,    -- Val.Adjust.Req. [FMRPMACTIVE]
    EMRKDFNDSITMCNSMPNINCCCRCYONLY,  -- Reduction in Local Currency only [FMIS_EFD_CNSMPNINCCCRCYONLY]
    EMRKDFNDSDOCITMNMBROFPROCGITMS,  -- Devel. Records [FMEWSCOUNT]
    PUBSECSPLITBATCHNUMBERID,        -- Dist.Batch No. [FMSP_SPLIT_BATCH]
    PUBSECSPLITAUTHZNGROUP,          -- Auth.Group [FMSP_SPLIT_AUTG]
    USFEDGOVERNMENTUUID,             -- US Govt [FMFG_US_KEY]
    FUNDSMGMTPERIODOFPERFSTARTDATE,  -- Per. of Perf. Start [FM_PEROP_LOW]
    FUNDSMGMTPERIODOFPERFENDDATE,    -- Per. of Perf. End [FM_PEROP_HIGH]
    USFEDPROMPTPAYTACTEXCLUDE,       -- PPA Exclude [EXCLUDE_FLG]
    EMRKDFNDSAMOUNTINTRANSCRCY,      -- Total Amount [KBLWTG]
    EMRKDFNDSRELAMTINTRANSCRCY,      -- Release Amount [WTGESAPP]
    EMRKDFNDSOPENAMTINTRANSCRCY,     -- Open Amount [FMWTFREE]
    EMRKDFNDSCHGDAMTINTRANSCRCY,     -- Amount Changed [DELTAWTAPP]
    EMRKDFNDSCNSMDAMTINTRANSCRCY,    -- Reduced Amount [KBLWTABG]
    EMRKDFNDSORIGLAMTINTRANSCRCY,    -- Original Amount [FMWTORIG]
    EMRKDFNDSAMOUNTINCCCRCY,         -- Total Amount in Local Currency [FMIS_EFD_AMOUNTINCCCRCY]
    EMRKDFNDSRELAMTINCCCRCY,         -- Amt for Release [HWGESAPP]
    EMRKDFNDSOPENAMTINCCCRCY,        -- Open Amount in Local Currency [FMIS_EFD_OPENAMTINCCCRCY]
    EMRKDFNDSCHGDAMTINCCCRCY,        -- Amount Changed [DELTAHWAPP]
    EMRKDFNDSCNSMDAMTINCCCRCY,       -- Reduced Amount [KBLWTABG]
    EMRKDFNDSORIGLAMTINCCCRCY,       -- Original Amount [FMHWORIG]
    BOPFUUID,                        -- Draft Document ID [SDRAFT_UUID]
    BOPFPARENTUUID,                  -- 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_KBLP_PS,          -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, EARMARKEDFUNDSDOCUMENT, EARMARKEDFUNDSDOCUMENTITEM, DRAFTUUID)
);

Learn More