SAP ABAP Table TXI_KBLP (Document Item: Manual Document Entry)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_KBLP	Table Relationship Diagram
Short Description	Document Item: Manual Document Entry

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Document Item: Manual Document Entry
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BELNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	KBLK
4	BLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
5	VRGNG	☐	KBLVORGANG	J_VORGANG	CHAR	4	0	Business Transaction	TJ01
6	ERFAS	☐	KBLERF	USNAM	CHAR	12	0	Created by
7	ERDAT	☐	KBLERDAT	DATUM	DATS	8	0	Entry date
8	AENDE	☐	KBLAEN	USNAM	CHAR	12	0	Last changed by
9	AEDAT	☐	KBLAEDAT	DATUM	DATS	8	0	Date of Last Change
10	PTEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
11	ERLKZ	☐	KBLERLKZ	CHAR1_X	CHAR	1	0	Completion indicator for line item
12	ERLDAT	☐	KBLERLDAT	DATUM	DATS	8	0	Completion date
13	LOEKZ	☐	KBLLOEKZ	CHAR1_X	CHAR	1	0	Deletion Indicator
14	WTGES	☐	KBLWTG	WERTV8	CURR	15	2	Total reserved amount in transaction currency
15	MENGE	☐	KBLMENGE	MENG13V	QUAN	13	3	Reserved quantity
16	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
17	PREIS	☐	KBLPREIS	WERT8	CURR	15	2	Price
18	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
19	PRMEN	☐	KBLPRMEN	MEINS	UNIT	3	0	Price unit	T006
20	PRUMN	☐	KBLPRUMN	UMBSN	DEC	5	0	Denominator for converting price unit into quantity
21	PRUMZ	☐	KBLPRUMZ	UMBSZ	DEC	5	0	Counter for converting price unit into quantity
22	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
23	FIPOS	☐	FIPOS_XPO	FIPOS	CHAR	14	0	Commitment item	FMFXPO
24	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
25	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
26	PSPNR	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
27	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
28	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
29	FDATK	☐	KBLFDATK	DATUM	DATS	8	0	Costs due on
30	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
31	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
32	ERLAR	☐	KBLERLAR	KSTAR	CHAR	10	0	Rev.elem.	CSKA
33	ERL_PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
34	XSENDER	☐	XSENDER	XFELD	CHAR	1	0	Indicator: Sender
35	XEMPFGR	☐	XEMPFGR	XFELD	CHAR	1	0	Indicator: Receiver
36	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
37	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
38	SKOSTL	☐	SKOSTL	KOSTL	CHAR	10	0	Sender Cost Center	*
39	SAUFNR	☐	SAUFNR	AUFNR	CHAR	12	0	Sender order	AUFK
40	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
41	HWGES	☐	KBLHWG	WERTV8	CURR	15	2	Total value in local currency
42	WTABB	☐	FMWTABB	WERTV8	CURR	15	2	Amount used in budget
43	HWABB	☐	FMHWABB	WERTV8	CURR	15	2	Reduction amount in budget
44	CWTFREE	☐	CWTFREE	CHAR16	CHAR	16	0	Available amount in transaction currency (character)
45	WTABG	☐	KBLWTABG	WERTV8	CURR	15	2	Funds reservation amount reduced
46	HWABG	☐	KBLWTABG	WERTV8	CURR	15	2	Funds reservation amount reduced
47	.INCLUDE	☐				0	0	Additional Fields for the KBLP Tables and Others
48	.INCLUDE	☐				0	0
49	.INCLUDE	☐				0	0
50	.INCLUDE	☐				0	0
51	STATS	☐	FMRE_STATS	FMRE_STATS	CHAR	1	0	Funds Management Statistical Indicator
52	BLPKZ	☐	BLPKZ	CHAR1_X	CHAR	1	0	Blocking Indicator (Item)
53	CONSUMEKZ	☐	FMCONSUME	XFELD	CHAR	1	0	Usage may exceed reserved amount without limit
54	UEBTO	☐	FMUEBTO	PRZ31	DEC	4	1	Tolerance limit for overrun
55	ABGWAERS	☐	FMABGWAERS	XFELD	CHAR	1	0	Reduction in local currency only
56	WKAPP	☐	WKAPP	CHAR1	CHAR	1	0	Item approved
57	CARRYOV	☐	CARRYOV	XFELD	CHAR	1	0	Do not carry forward open documents in the fiscal year chge
58	ACCHANG	☐	FM_ACCHANG	XFELD	CHAR	1	0	FM account assignment can be changed in follow-on document
59	LNRZA	☐	LNRZA	LIFNR	CHAR	10	0	Account Number of the Alternative Payee	*
60	REFBLTYP	☐	REFBLTYP	KBLTYP	NUMC	3	0	Reference doc.category: funds precommitment or reservation
61	REFBELNR	☐	REFKBLNR	KBLNR	CHAR	10	0	Reference document number: reservation/funds precommitment	*
62	REFBLPOS	☐	REFKBLPOS	KBLPOS	NUMC	3	0	Item in reference document	*
63	REFSETERLK	☐	REFSETERLK	CHAR1_X	CHAR	1	0	Used earmarked funds set to "Complete"
64	WTGESAPP	☐	WTGESAPP	WERTV8	CURR	15	2	Item amount to be released (transaction currency)
65	HWGESAPP	☐	HWGESAPP	WERTV8	CURR	15	2	Item amount to be released (local currency)
66	DELTAWTAPP	☐	DELTAWTAPP	WERTV8	CURR	15	2	Amount change to be approved (transaction currency)
67	DELTAHWAPP	☐	DELTAHWAPP	WERTV8	CURR	15	2	Amount change to be approved (local currency)
68	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
69	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
70	KURSUP	☐	KURSU	KURSF	DEC	9	5	Last revaluation rate
71	DATUP	☐	DATU	DATUM	DATS	8	0	Date of last revaluation
72	WTFREE	☐	FMWTFREE	WERTV8	CURR	15	2	Open amount (transaction currency)
73	HWFREE	☐	FMHWFREE	WERTV8	CURR	15	2	Open amount (local currency)
74	EWSCOUNT	☐	FMEWSCOUNT	NUMC5	NUMC	5	0	Number of history records in KBLE
75	RFPOS	☐	AWPOS	AWPOS	CHAR	10	0	Reference line item
76	WTORIG	☐	FMWTORIG	WERTV8	CURR	15	2	Original Amount in Transaction Currency
77	HWORIG	☐	FMHWORIG	WERTV8	CURR	15	2	Original amount in local currency
78	POSLOCK	☐	FMRPOSLOCK	FMRLOCK	CHAR	2	0	Earmarked funds item block	FMRESLOCKS
79	PMACTIVE	☐	FMRPMACTIVE	XFELD	CHAR	1	0	Indicator: Amount Change Only with Value Adjustment Document
80	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
81	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
82	TOLOV	☐	FMRTOLOV	XFELD	CHAR	1	0	Indicator: Override Global (Percentage-Based) Tolerance
83	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
84	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
85	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
86	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
87	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
88	PEROP_BEG	☐	FM_PEROP_LOW	DATUM	DATS	8	0	Period of Performance Start
89	PEROP_END	☐	FM_PEROP_HIGH	DATUM	DATS	8	0	Period of Performance End
90	PPA_EX_IND	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
91	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
92	PDATE	☐	ITFM_PDATE	DATUM	DATS	8	0	ITFM: Peremption Date
93	DATE_FROM	☐	SAFM_DATE_FROM	DATUM	DATS	8	0	Contract Period From Date
94	DATE_TO	☐	SAFM_DATE_TO	DATUM	DATS	8	0	Contract Period To Date
95	.INCLU--AP	☐				0	0	FMFG Additional Fields for Structure IA1KBLP
96	FMFGUS_KEY	☐	FMFG_US_KEY	SYSUUID_22	CHAR	22	0	United States Federal Government Fields
97	.INCLU--AP	☐				0	0	Fields for Rule-Based Account Distributions
98	FM_SPLIT_BATCH	☐	FMSP_SPLIT_BATCH	NUMC3	NUMC	3	0	Batch to group results from an PSM assignment distribution
99	FM_SPLIT_BEGRU	☐	FMSP_SPLIT_AUTG	FMSP_SPLIT_AUTG	CHAR	4	0	Authorization group for PSM account assignment distribution	*
100	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
101	REVSUM	☐	REVSUM	WERTV8	CURR	15	2	Total of all revaluations per line (approved amount)
102	REVAPPSUM	☐	REVAPPSUM	WERTV8	CURR	15	2	Total of all revaluations per line (amount to be approved)
103	EF_GROUP_NUMBER	☐	EF_GROUP_NUMBER	NUMC10	NUMC	10	0	Grouping Number for Earmarked Funds
104	.INCLU--AP	☐				0	0	Append to KBLP for Payment Card (Card Document)
105	.INCLUDE	☐				0	0	Card Document: (Item) Account Assignment Data for FI Doc.
106	MWSKZ	☐	CRMWSKZ	MWSKZ	CHAR	2	0	Card Document: Tax on Sales/Purchases Code	T007A
107	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
108	WMWST	☐	CRWMWST	WERT8	CURR	15	2	Card Document: Tax on Sales/Purchases Paid
109	MWSTS	☐	CRMWSTS	WERT8	CURR	15	2	Card Document: Tax on Sales/Purchases Paid in Local Currency
110	NETBTR	☐	CRNETBTR	WERT8	CURR	15	2	Card Document: Net Amount Paid
111	NETHW	☐	CRNETDMBTR	WERT8	CURR	15	2	Card Document: Net Amount Paid in Local Currency
112	GROSBTR	☐	CRGROSBTR	WERT8	CURR	15	2	Card Document: Gross Amount Paid
113	GROSHW	☐	CRGROSHW	WERT8	CURR	15	2	Card Document: Gross Amount Paid in Local Currency
114	WTGES_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
115	MENGE_QY	☐	UNIT	EINHEIT	UNIT	3	0	Unit
116	PREIS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
117	HWGES_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
118	WTABB_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
119	HWABB_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
120	WTABG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
121	HWABG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
122	WTGESAPP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
123	HWGESAPP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
124	DELTAWTAPP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
125	DELTAHWAPP_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
126	WTFREE_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
127	HWFREE_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
128	WTORIG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
129	HWORIG_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
130	REVSUM_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
131	REVAPPSUM_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
132	WMWST_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
133	MWSTS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
134	NETBTR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
135	NETHW_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
136	GROSBTR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
137	GROSHW_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_KBLP	AUFNR	AUFK	AUFNR	KEY	1	CN
2	TXI_KBLP	BELNR	KBLK	BELNR	KEY	1	CN
3	TXI_KBLP	ERLAR	CSKA	KSTAR	KEY	1	CN
4	TXI_KBLP	ERL_PSPNR	PRPS	PSPNR	KEY	1	CN
5	TXI_KBLP	FIPOS	FMFXPO	FIPOS	REF	1	CN
6	TXI_KBLP	FISTL	FMFCTR	FICTR	KEY	1	CN
7	TXI_KBLP	FKBER	TFKB	FKBER
8	TXI_KBLP	GEBER	FMFINCODE	FINCODE	KEY	1	CN
9	TXI_KBLP	KOSTL	CSKS	KOSTL	KEY	1	CN
10	TXI_KBLP	KSTAR	CSKA	KSTAR	KEY	1	CN
11	TXI_KBLP	KUNNR	KNA1	KUNNR		1	CN
12	TXI_KBLP	LIFNR	LFA1	LIFNR	KEY	1	CN
13	TXI_KBLP	MANDT	T000	MANDT	KEY	1	CN
14	TXI_KBLP	MATNR	MARA	MATNR	KEY	1	CN
15	TXI_KBLP	MEINH	T006	MSEHI	KEY	1	CN
16	TXI_KBLP	MWSKZ	T007A	MWSKZ
17	TXI_KBLP	POSLOCK	FMRESLOCKS	LOCKTYPE
18	TXI_KBLP	PRMEN	T006	MSEHI	KEY	1	CN
19	TXI_KBLP	PSPNR	PRPS	PSPNR	KEY	1	CN
20	TXI_KBLP	SAKNR	SKA1	SAKNR		1	CN
21	TXI_KBLP	SAUFNR	AUFK	AUFNR	KEY	1	CN
22	TXI_KBLP	TXJCD	TTXJ	TXJCD
23	TXI_KBLP	VRGNG	TJ01	VRGNG	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in