SAP ABAP Table TXW_BELEG (Travel Expense Specifications According to Indiv. Receipt)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	INTTAB	Structure
Structure	TXW_BELEG	Table Relationship Diagram
Short Description	Travel Expense Specifications According to Indiv. Receipt

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☐				0	0	TE key for trip data
3	PERNR	☐	TXW_PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☐	TXW_REINR	REINR	NUMC	10	0	Trip number
5	PERIO	☐	PERIODE	NUM3	NUMC	3	0	Period
6	PDVRS	☐	TXW_PDVRS	NUMC2	NUMC	2	0	Sequential number of period
7	BELNR	☐	TXW_PT_BELNR	CHAR3	CHAR	3	0	Document number
8	SPKZL	☐	TXW_PT_SPKZL	CHAR4	CHAR	4	0	Travel expense type
9	BEART	☐	TXW_PT_BEART	CHAR1	CHAR	1	0	Travel expense category
10	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
11	BETRG	☐	TXW_BELEG_BETRG		CHAR	14	0	Amount on individual receipt
12	BLDAT	☐	TXW_PT_BLDAT	DATS	DATS	8	0	Receipt Date
13	BTEXT	☐	TXW_PT_BTEXT	CHAR10	CHAR	10	0	Short receipt information
14	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
15	KURSB	☐	TXW_PT_KURSB	CHAR12	CHAR	12	0	Exchange rate
16	FFACT	☐	TXW_PT_FFACT	CHAR11	CHAR	11	0	Ratio for the "from" currency units
17	TFACT	☐	TXW_PT_TFACT	CHAR11	CHAR	11	0	Ratio for the "to" currency units
18	ANZFR	☐	TXW_PT_ANZFR	CHAR2	CHAR	2	0	Number of breakfasts
19	LNDFR	☐	TXW_PT_LNDFR	CHAR3	CHAR	3	0	Country of receipt
20	BERFR	☐	TXW_PT_BERFR	CHAR1	CHAR	1	0	Trip type: Enterprise-specific
21	RGION	☐	TXW_PT_RGION	CHAR5	CHAR	5	0	Trip country/trip country group/trip region
22	TXJCD	☐	TXW_PT_TXJCD	CHAR15	CHAR	15	0	Jurisdiction for tax calculation - tax jurisdiction code
23	PAYOT	☐	TXW_PT_PAYOT	CHAR2	CHAR	2	0	Service provider
24	PAYCURR	☐	TXW_PT_PAYCURR	CUKY5	CUKY	5	0	Accounting currency of expense receipt or advance
25	ABOVE_LIMIT	☐	TXW_PT_ABOVELIM	CHAR1	CHAR	1	0	Customizing limit for travel expense type exceeded
26	PROTECT	☐	TXW_PT_PROTECT	CHAR1	CHAR	1	0	Protection indicator of entry
27	REFNR	☐	TXW_PT_REFNR	CHAR3	CHAR	3	0	Reference Document Number
28	PAPER_RECEIPT	☐	TXW_PT_PAPREC	CHAR1	CHAR	1	0	Paper Receipt Exists
29	RECEIPT_VALIDATED	☐	TXW_PT_RECVAL	CHAR1	CHAR	1	0	Expense Receipt Checked

History

Last changed by/on	SAP	20130529
SAP Release Created in	470