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

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Expenses

Basic Data

Table Category	INTTAB	Structure
Structure	BELEG_EXBEL	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	.INCLUDE	☐				0	0	Travel Expense Specifications According to Indiv. Receipt
2	BELNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
3	SPKZL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
4	BEART	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
5	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
6	BETRG	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
7	BLDAT	☐	BELDT	REDAT	DATS	8	0	Receipt Date
8	BTEXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	KURSB	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
11	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
12	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
13	ANZFR	☐	FRANZ	FRANZ	DEC	2	0	Number of Breakfasts
14	LNDFR	☐	LNDFR	LNDGR	CHAR	3	0	Country of Receipt	T702O
15	BERFR	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	T702X
16	RGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	T702O
17	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
18	PAYOT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	T706B4
19	PAYCURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	*
20	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
21	PROTECT	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
22	.INCLU--AP	☐				0	0	Enhancement For PTK03 in Extension System
23	REFNR	☐	NOBEL	NRBEL	CHAR	3	0	Reference Document Number
24	PAPER_RECEIPT	☐	PAPER_RECEIPT	XFELD	CHAR	1	0	Paper Receipt Exists
25	RECEIPT_VALIDATED	☐	RECEIPT_VALIDATED	XFELD	CHAR	1	0	Expense Receipt Checked
26	GENEHM_U_BELEG	☐	PTRV_GENEHM_U_BELEG	CHAR1	CHAR	1	0	Reimbursement of Accommodations Receipt in Full
27	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
28	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
29	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
30	FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
31	VAT_POSTING_TYPE	☐	PTRV_VAT_POSTING_TYPE	PTRV_VAT_POSTING_TYPE	CHAR	1	0	Reporting and Posting of VAT Amount
32	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
33	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
34	VAT_STATUS	☐	PTRV_VAT_STATUS	PTRV_VAT_STATUS	CHAR	1	0	Status of Data for VAT Refund
35	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually
36	DIFF_VIOLATION	☐	DIFF_VIOLATION	P_ATYPE	CHAR	1	0	Maximum Difference Exceeded
37	VAT_SUB_SRV_CODE	☐	PTRV_VAT_SUB_SRV_CODE	PTRV_VAT_SUB_SRV_CODE	CHAR	15	0	Subcodes for Goods and Services
38	VAT_SRV_DESC_LANGU	☐	PTRV_VAT_SRV_DESC_LANGU	SYLANGU	LANG	1	0	Language of Description of Goods and Services
39	DATV1	☐	FRDAT	DATUM	DATS	8	0	From Date
40	DATB1	☐	TODAT	DATUM	DATS	8	0	To Date
41	ANZAL	☐	ERANZ	DEC3	DEC	3	0	Number
42	DESCR	☐	ERDES	TEXT50	CHAR	50	0	Description
43	PLACE	☐	ERPLC	TEXT50	CHAR	50	0	Location
44	BUSPU	☐	BUSPU	TEXT50	CHAR	50	0	Business Purpose
45	BUSRE	☐	BUSRE	TEXT50	CHAR	50	0	Business Partners
46	CCOMP	☐	CCOMP	CCOMP	CHAR	2	0	Code of Payment Card Company	*
47	C_DOC	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
48	C_TXT	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
49	P_CTG	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
50	P_PRV	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	*
51	P_DOC	☐	P_DOC	TEXT20	CHAR	20	0	Document Number of a (Paper) Document
52	CCARD	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
53	CEKEY	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
54	CFIRMA	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
55	N_STF	☐	CH_NO_STAFF	CHAR3	CHAR	3	0	Number of Employees
56	N_PTN	☐	CH_NO_PARTNERS	CHAR3	CHAR	3	0	Number of Employees of Business Partners
57	N_GST	☐	CH_NO_GUESTS	CHAR3	CHAR	3	0	Number of Additional Guests
58	GUID_CCC	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
59	PAY_AMOUNT	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
60	ANZLU	☐	PTRV_ANZLU	CHAR3	CHAR	3	0	Number of Lunches in Hotel Receipt
61	ANZDI	☐	PTRV_ANZDI	CHAR3	CHAR	3	0	Number of Dinners in Hotel Receipt

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BELEG_EXBEL	BERFR	T702X	BEREI	KEY	1	CN
2	BELEG_EXBEL	LNDFR	T702O	LAND1	KEY
3	BELEG_EXBEL	MWSKZ	T007A	MWSKZ
4	BELEG_EXBEL	PAYOT	T706B4	PAYOT	KEY	1	CN
5	BELEG_EXBEL	RGION	T702O	RGION		1	CN
6	BELEG_EXBEL	SPKZL	T706B1	SPKZL	KEY	1	CN
7	BELEG_EXBEL	WAERS	TCURC	WAERS	KEY	1	CN

History

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