TXI_KBLP SAP (Document Item: Manual Document Entry) Structure details
Description: Document Item: Manual Document Entry
Structure field list including key, data, relationships and ABAP select examples
TXI_KBLP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Document Item: Manual Document Entry" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TXI_KBLP TYPE TXI_KBLP.
The TXI_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 MANDT (Client), BELNR (Document Number for Earmarked Funds), BLPOS (Earmarked Funds: Document Item), VRGNG (Business Transaction).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TXI_KBLP structure 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 | Assigned to domain | 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 | ||||
WTGES_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
MENGE_QY | Unit | UNIT | UNIT | 3 | CUNIT | EINHEIT | |||
PREIS_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWGES_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WTABB_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWABB_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WTABG_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWABG_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WTGESAPP_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWGESAPP_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
DELTAWTAPP_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
DELTAHWAPP_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WTFREE_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWFREE_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WTORIG_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
HWORIG_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
REVSUM_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
REVAPPSUM_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
WMWST_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
MWSTS_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
NETBTR_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
NETHW_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
GROSBTR_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY | ||||
GROSHW_CY | CUKY for SYST | SYCUKY | CUKY | 5 | SYCUKY |
Key field | Non-key field |
How do I retrieve data from SAP structure TXI_KBLP using ABAP code?
As TXI_KBLP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_KBLP as there is no data to select.How to access SAP table TXI_KBLP
Within an ECC or HANA version of SAP you can also view further information about TXI_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