KBLP SAP table for – Document Item: Manual Document Entry

Here we would like to draw your attention to KBLP table in SAP. As we know it is being mainly used with the SAP FI-FM (Funds Management in FI) component which is coming under FI module (Financial Accounting). KBLP is a SAP standard transp table used for storing Document Item: Manual Document Entry related data in SAP. It comes under the package FMRE.

SAP KBLP table

Table KBLP technical data

TableKBLP
Data storingDocument Item: Manual Document Entry
ModuleFI
Sub ModuleFI-FM-PO
SAP PackageFMRE
Delivery ClassA – Application table (master and transaction data)
ComponentBBPCRM
Table CategoryTRANSP

SAP KBLP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in KBLP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BELNR : Document Number for Earmarked Funds
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BLPOS : Earmarked Funds: Document Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • VRGNG : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • ERFAS : Created by
    Its data type is CHAR (Character String) with field length 12
  • ERDAT : Entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENDE : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTEXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • ERLKZ : Completion indicator for line item
    Its data type is CHAR (Character String) with field length 1
  • ERLDAT : Completion date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOEKZ : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • WTGES : Total reserved amount in transaction currency
    Its data type is CURR (Currency Field) with field length 15
  • MENGE : Reserved quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINH : Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PREIS : Price
    Its data type is CURR (Currency Field) with field length 15
  • PEINH : Price unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PRMEN : Price unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PRUMN : Denominator for converting price unit into quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PRUMZ : Counter for converting price unit into quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • KSTAR : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • FIPOS : Commitment item
    Its data type is CHAR (Character String) with field length 14
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • PSPNR : Work breakdown structure element (WBS element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • FDATK : Costs due on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • ERLAR : Rev.elem.
    Its data type is CHAR (Character String) with field length 10
  • ERL_PSPNR : WBS Element
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • XSENDER : Indicator: Sender
    Its data type is CHAR (Character String) with field length 1
  • XEMPFGR : Indicator: Receiver
    Its data type is CHAR (Character String) with field length 1
  • AUFPL : Routing number of operations in the order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • APLZL : General counter for order
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • SKOSTL : Sender Cost Center
    Its data type is CHAR (Character String) with field length 10
  • SAUFNR : Sender order
    Its data type is CHAR (Character String) with field length 12
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • HWGES : Total value in local currency
    Its data type is CURR (Currency Field) with field length 15
  • WTABB : Amount used in budget
    Its data type is CURR (Currency Field) with field length 15
  • HWABB : Reduction amount in budget
    Its data type is CURR (Currency Field) with field length 15
  • CWTFREE : Available amount in transaction currency (character)
    Its data type is CHAR (Character String) with field length 16
  • WTABG : Funds reservation amount reduced
    Its data type is CURR (Currency Field) with field length 15
  • HWABG : Funds reservation amount reduced
    Its data type is CURR (Currency Field) with field length 15
  • .INCLUDE : Additional Fields for the KBLP Tables and Others
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • STATS : Funds Management Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • BLPKZ : Blocking Indicator (Item)
    Its data type is CHAR (Character String) with field length 1
  • CONSUMEKZ : Usage may exceed reserved amount without limit
    Its data type is CHAR (Character String) with field length 1
  • UEBTO : Tolerance limit for overrun
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ABGWAERS : Reduction in local currency only
    Its data type is CHAR (Character String) with field length 1
  • WKAPP : Item approved
    Its data type is CHAR (Character String) with field length 1
  • CARRYOV : Do not carry forward open documents in the fiscal year chge
    Its data type is CHAR (Character String) with field length 1
  • ACCHANG : FM account assignment can be changed in follow-on document
    Its data type is CHAR (Character String) with field length 1
  • LNRZA : Account Number of the Alternative Payee
    Its data type is CHAR (Character String) with field length 10
  • REFBLTYP : Reference doc.category: funds precommitment or reservation
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REFBELNR : Reference document number: reservation/funds precommitment
    Its data type is CHAR (Character String) with field length 10
  • REFBLPOS : Item in reference document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REFSETERLK : Used earmarked funds set to “Complete”
    Its data type is CHAR (Character String) with field length 1
  • WTGESAPP : Item amount to be released (transaction currency)
    Its data type is CURR (Currency Field) with field length 15
  • HWGESAPP : Item amount to be released (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • DELTAWTAPP : Amount change to be approved (transaction currency)
    Its data type is CURR (Currency Field) with field length 15
  • DELTAHWAPP : Amount change to be approved (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • SAKNR : G/L Account Number
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • KURSUP : Last revaluation rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DATUP : Date of last revaluation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WTFREE : Open amount (transaction currency)
    Its data type is CURR (Currency Field) with field length 15
  • HWFREE : Open amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • EWSCOUNT : Number of history records in KBLE
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • RFPOS : Reference line item
    Its data type is CHAR (Character String) with field length 10
  • WTORIG : Original Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWORIG : Original amount in local currency
    Its data type is CURR (Currency Field) with field length 15
  • POSLOCK : Earmarked funds item block
    Its data type is CHAR (Character String) with field length 2
  • PMACTIVE : Indicator: Amount Change Only with Value Adjustment Document
    Its data type is CHAR (Character String) with field length 1
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • TOLOV : Indicator: Override Global (Percentage-Based) Tolerance
    Its data type is CHAR (Character String) with field length 1
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEROP_BEG : Period of Performance Start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEROP_END : Period of Performance End
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PPA_EX_IND : PPA Exclude Indicator
    Its data type is CHAR (Character String) with field length 1
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • PDATE : ITFM: Peremption Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_FROM : Contract Period From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : Contract Period To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : FMFG Additional Fields for Structure IA1KBLP
  • FMFGUS_KEY : United States Federal Government Fields
    Its data type is CHAR (Character String) with field length 22
  • .INCLU–AP : Fields for Rule-Based Account Distributions
  • FM_SPLIT_BATCH : Batch to group results from an PSM assignment distribution
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FM_SPLIT_BEGRU : Authorization group for PSM account assignment distribution
    Its data type is CHAR (Character String) with field length 4
  • VORNR : Operation/Activity Number
    Its data type is CHAR (Character String) with field length 4
  • REVSUM : Total of all revaluations per line (approved amount)
    Its data type is CURR (Currency Field) with field length 15
  • REVAPPSUM : Total of all revaluations per line (amount to be approved)
    Its data type is CURR (Currency Field) with field length 15
  • EF_GROUP_NUMBER : Grouping Number for Earmarked Funds
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLU–AP : Append to KBLP for Payment Card (Card Document)
  • .INCLUDE : Card Document: (Item) Account Assignment Data for FI Doc.
  • MWSKZ : Card Document: Tax on Sales/Purchases Code
    Its data type is CHAR (Character String) with field length 2
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • WMWST : Card Document: Tax on Sales/Purchases Paid
    Its data type is CURR (Currency Field) with field length 15
  • MWSTS : Card Document: Tax on Sales/Purchases Paid in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • NETBTR : Card Document: Net Amount Paid
    Its data type is CURR (Currency Field) with field length 15
  • NETHW : Card Document: Net Amount Paid in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • GROSBTR : Card Document: Gross Amount Paid
    Its data type is CURR (Currency Field) with field length 15
  • GROSHW : Card Document: Gross Amount Paid in Local Currency
    Its data type is CURR (Currency Field) with field length 15