KBLP SAP (Document Item: Manual Document Entry) Table details
Dictionary Type: Table
Description: Document Item: Manual Document Entry
Description: Document Item: Manual Document Entry
Table field list including key, data, relationships and ABAP select examples
KBLP is a standard SAP Table which is used to store Document Item: Manual Document Entry data and is available within R/3 SAP systems depending on the version and release level.
The KBLP table consists of various fields, each holding specific information or linking keys about Document Item: Manual Document Entry data available in SAP. These include BELNR (Document Number for Earmarked Funds), BLPOS (Earmarked Funds: Document Item), VRGNG (Business Transaction), ERFAS (Created by).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KBLP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BELNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | KBLK | ALPHA | KBLNR | KBL | |
BLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLPOS | KBP | |||
VRGNG | Business Transaction | KBLVORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
ERFAS | Created by | KBLERF | CHAR | 12 | USNAM | ||||
ERDAT | Entry date | KBLERDAT | DATS | 8 | DATUM | ||||
AENDE | Last changed by | KBLAEN | CHAR | 12 | USNAM | ||||
AEDAT | Date of Last Change | KBLAEDAT | DATS | 8 | DATUM | ||||
PTEXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ERLKZ | Completion indicator for line item | KBLERLKZ | CHAR | 1 | CHAR1_X | ||||
ERLDAT | Completion date | KBLERLDAT | DATS | 8 | DATUM | ||||
LOEKZ | Deletion Indicator | KBLLOEKZ | CHAR | 1 | CHAR1_X | ||||
WTGES | Total reserved amount in transaction currency | KBLWTG | CURR | 15(2) | WERTV8 | ||||
MENGE | Reserved quantity | KBLMENGE | QUAN | 13(3) | MENG13V | ||||
MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
PREIS | Price | KBLPREIS | CURR | 15(2) | WERT8 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
PRMEN | Price unit | KBLPRMEN | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRUMN | Denominator for converting price unit into quantity | KBLPRUMN | DEC | 5 | UMBSN | ||||
PRUMZ | Counter for converting price unit into quantity | KBLPRUMZ | DEC | 5 | UMBSZ | ||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
FIPOS | Commitment item | FIPOS_XPO | CHAR | 14 | FMFXPO | FMCIS | FIPOS | FIP | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
PSPNR | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
FISTL | Funds Center | FISTL | CHAR | 16 | FMFCTR | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
FDATK | Costs due on | KBLFDATK | DATS | 8 | DATUM | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
ERLAR | Rev.elem. | KBLERLAR | CHAR | 10 | CSKA | ALPHA | KSTAR | ||
ERL_PSPNR | WBS Element | PS_POSNR | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
XSENDER | Indicator: Sender | XSENDER | CHAR | 1 | XFELD | ||||
XEMPFGR | Indicator: Receiver | XEMPFGR | CHAR | 1 | XFELD | ||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
SAUFNR | Sender order | SAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
HWGES | Total value in local currency | KBLHWG | CURR | 15(2) | WERTV8 | ||||
WTABB | Amount used in budget | FMWTABB | CURR | 15(2) | WERTV8 | ||||
HWABB | Reduction amount in budget | FMHWABB | CURR | 15(2) | WERTV8 | ||||
CWTFREE | Available amount in transaction currency (character) | CWTFREE | CHAR | 16 | CHAR16 | ||||
WTABG | Funds reservation amount reduced | KBLWTABG | CURR | 15(2) | WERTV8 | ||||
HWABG | Funds reservation amount reduced | KBLWTABG | CURR | 15(2) | WERTV8 | ||||
STATS | Funds Management Statistical Indicator | FMRE_STATS | CHAR | 1 | FMRE_STATS | ||||
BLPKZ | Blocking Indicator (Item) | BLPKZ | CHAR | 1 | CHAR1_X | ||||
CONSUMEKZ | Usage may exceed reserved amount without limit | FMCONSUME | CHAR | 1 | XFELD | ||||
UEBTO | Tolerance limit for overrun | FMUEBTO | DEC | 4(1) | PRZ31 | ||||
ABGWAERS | Reduction in local currency only | FMABGWAERS | CHAR | 1 | XFELD | ||||
WKAPP | Item approved | WKAPP | CHAR | 1 | CHAR1 | ||||
CARRYOV | Do not carry forward open documents in the fiscal year chge | CARRYOV | CHAR | 1 | XFELD | ||||
ACCHANG | FM account assignment can be changed in follow-on document | FM_ACCHANG | CHAR | 1 | XFELD | ||||
LNRZA | Account Number of the Alternative Payee | LNRZA | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
REFBLTYP | Reference doc.category: funds precommitment or reservation | REFBLTYP | NUMC | 3 | KBLTYP | ||||
REFBELNR | Reference document number: reservation/funds precommitment | REFKBLNR | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | ||
REFBLPOS | Item in reference document | REFKBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | |||
REFSETERLK | Used earmarked funds set to 'Complete' | REFSETERLK | CHAR | 1 | CHAR1_X | ||||
WTGESAPP | Item amount to be released (transaction currency) | WTGESAPP | CURR | 15(2) | WERTV8 | ||||
HWGESAPP | Item amount to be released (local currency) | HWGESAPP | CURR | 15(2) | WERTV8 | ||||
DELTAWTAPP | Amount change to be approved (transaction currency) | DELTAWTAPP | CURR | 15(2) | WERTV8 | ||||
DELTAHWAPP | Amount change to be approved (local currency) | DELTAHWAPP | CURR | 15(2) | WERTV8 | ||||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
KURSUP | Last revaluation rate | KURSU | DEC | 9(5) | EXCRT | KURSF | |||
DATUP | Date of last revaluation | DATU | DATS | 8 | DATUM | ||||
WTFREE | Open amount (transaction currency) | FMWTFREE | CURR | 15(2) | WERTV8 | ||||
HWFREE | Open amount (local currency) | FMHWFREE | CURR | 15(2) | WERTV8 | ||||
EWSCOUNT | Number of history records in KBLE | FMEWSCOUNT | NUMC | 5 | NUMC5 | ||||
RFPOS | Reference line item | AWPOS | CHAR | 10 | AWPOS | ||||
WTORIG | Original Amount in Transaction Currency | FMWTORIG | CURR | 15(2) | WERTV8 | ||||
HWORIG | Original amount in local currency | FMHWORIG | CURR | 15(2) | WERTV8 | ||||
POSLOCK | Earmarked funds item block | FMRPOSLOCK | CHAR | 2 | FMRESLOCKS | FMRLOCK | |||
PMACTIVE | Indicator: Amount Change Only with Value Adjustment Document | FMRPMACTIVE | CHAR | 1 | XFELD | ||||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FKBER | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
TOLOV | Indicator: Override Global (Percentage-Based) Tolerance | FMRTOLOV | CHAR | 1 | XFELD | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
PEROP_BEG | Period of Performance Start | FM_PEROP_LOW | DATS | 8 | DATUM | ||||
PEROP_END | Period of Performance End | FM_PEROP_HIGH | DATS | 8 | DATUM | ||||
PPA_EX_IND | PPA Exclude Indicator | EXCLUDE_FLG | CHAR | 1 | XFELD | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PDATE | ITFM: Peremption Date | ITFM_PDATE | DATS | 8 | DATUM | ||||
DATE_FROM | Contract Period From Date | SAFM_DATE_FROM | DATS | 8 | DATUM | ||||
DATE_TO | Contract Period To Date | SAFM_DATE_TO | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
FM_SPLIT_BATCH | Batch to group results from an PSM assignment distribution | FMSP_SPLIT_BATCH | NUMC | 3 | NUMC3 | ||||
FM_SPLIT_BEGRU | Authorization group for PSM account assignment distribution | FMSP_SPLIT_AUTG | CHAR | 4 | Assigned to domain | FMSP_SPLIT_AUTG | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
REVSUM | Total of all revaluations per line (approved amount) | REVSUM | CURR | 15(2) | WERTV8 | ||||
REVAPPSUM | Total of all revaluations per line (amount to be approved) | REVAPPSUM | CURR | 15(2) | WERTV8 | ||||
EF_GROUP_NUMBER | Grouping Number for Earmarked Funds | EF_GROUP_NUMBER | NUMC | 10 | NUMC10 | FM_RESERV_GRPNO | |||
.INCLU--AP | 0 | ||||||||
MWSKZ | Card Document: Tax on Sales/Purchases Code | CRMWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
WMWST | Card Document: Tax on Sales/Purchases Paid | CRWMWST | CURR | 15(2) | WERT8 | ||||
MWSTS | Card Document: Tax on Sales/Purchases Paid in Local Currency | CRMWSTS | CURR | 15(2) | WERT8 | ||||
NETBTR | Card Document: Net Amount Paid | CRNETBTR | CURR | 15(2) | WERT8 | ||||
NETHW | Card Document: Net Amount Paid in Local Currency | CRNETDMBTR | CURR | 15(2) | WERT8 | ||||
GROSBTR | Card Document: Gross Amount Paid | CRGROSBTR | CURR | 15(2) | WERT8 | ||||
GROSHW | Card Document: Gross Amount Paid in Local Currency | CRGROSHW | CURR | 15(2) | WERT8 |
Key field | Non-key field |
How do I retrieve data from SAP table KBLP using ABAP code
The following ABAP code Example will allow you to do a basic selection on KBLP to SELECT all data from the tableDATA: WA_KBLP TYPE KBLP.
SELECT SINGLE *
FROM KBLP
INTO CORRESPONDING FIELDS OF WA_KBLP
WHERE...
How to access SAP table KBLP
Within an ECC or HANA version of SAP you can also view further information about KBLP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects