BELEG_EXBEL SAP (Travel Expense Specifications According to Indiv. Receipt) Structure details
Dictionary Type: Structure
Description: Travel Expense Specifications According to Indiv. Receipt
Description: Travel Expense Specifications According to Indiv. Receipt
Structure field list including key, data, relationships and ABAP select examples
BELEG_EXBEL 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 "Travel Expense Specifications According to Indiv. Receipt" 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_BELEG_EXBEL TYPE BELEG_EXBEL.
The BELEG_EXBEL table consists of various fields, each holding specific information or linking keys about Travel Expense Specifications According to Indiv. Receipt data available in SAP. These include BELNR (Document Number), SPKZL (Travel Expense Type), BEART (Travel Expense Category), MWSKZ (Tax on sales/purchases code).. 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 (Deep)
SAP BELEG_EXBEL 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 |
| BELNR | Document Number | NRBEL | CHAR | 3 | NRBEL | ||||
| SPKZL | Travel Expense Type | SPKZL | CHAR | 4 | T706B1 | SPKZL | RSA | SH_EXPENSE_TYPES | |
| BEART | Travel Expense Category | BELAR | CHAR | 1 | BELAR | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| BETRG | Amount on Individual Receipt | GESBB | CURR | 10(2) | GESBE | ||||
| BLDAT | Receipt Date | BELDT | DATS | 8 | REDAT | ||||
| BTEXT | Short Receipt Information | TXBEL | CHAR | 10 | TXBEL | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| KURSB | Exchange Rate | UKURS_CURR | DEC | 9(5) | EXCRT | UKURS | |||
| FFACT | Ratio for the 'From' Currency Units | FFACT_CURR | DEC | 9 | DEC9 | ||||
| TFACT | Ratio for the 'To' Currency Units | TFACT_CURR | DEC | 9 | DEC9 | ||||
| ANZFR | Number of Breakfasts | FRANZ | DEC | 2 | FRANZ | ||||
| LNDFR | Country of Receipt | LNDFR | CHAR | 3 | T702O | LNDGR | |||
| BERFR | Trip Type: Enterprise-Specific | BEREI | CHAR | 1 | T702X | BEREI | |||
| RGION | Trip Country/Trip Country Group/Trip Region | RGION | CHAR | 5 | T702O | RGION | |||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| PAYOT | Service Provider | PAYOT | CHAR | 2 | T706B4 | PAYOT | |||
| PAYCURR | Accounting Currency of Expense Receipt or Advance | PTRV_PAYCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| ABOVE_LIMIT | Customizing Limit for Travel Expense Type Exceeded | PTRV_ABOVE_LIMIT | CHAR | 1 | P_ATYPE | ||||
| PROTECT | Protection Indicator of Entry | PROTECT | CHAR | 1 | PRTV_PROTECT | ||||
| .INCLU--AP | 0 | ||||||||
| REFNR | Reference Document Number | NOBEL | CHAR | 3 | NRBEL | ||||
| PAPER_RECEIPT | Paper Receipt Exists | PAPER_RECEIPT | CHAR | 1 | XFELD | ||||
| RECEIPT_VALIDATED | Expense Receipt Checked | RECEIPT_VALIDATED | CHAR | 1 | XFELD | ||||
| GENEHM_U_BELEG | Reimbursement of Accommodations Receipt in Full | PTRV_GENEHM_U_BELEG | CHAR | 1 | CHAR1 | ||||
| PAPER_MISSING | Required Paper Receipt Is Missing | PAPER_MISSING | CHAR | 1 | P_ATYPE | ||||
| RECEIPT_NO | Invoice Number of Original Receipt | PTRV_RECEIPT_NO | CHAR | 16 | |||||
| RECEIPT_ITEM | Number of Invoice Item | PTRV_RECEIPT_ITEM | NUMC | 3 | |||||
| FWSTE | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
| VAT_POSTING_TYPE | Reporting and Posting of VAT Amount | PTRV_VAT_POSTING_TYPE | CHAR | 1 | PTRV_VAT_POSTING_TYPE | ||||
| VAT_SERVICE_CODE | VAT Refund Code | PTRV_VAT_SERVICE_CODE | CHAR | 3 | Assigned to domain | PTRV_VAT_SERVICE_CODE | |||
| VAT_SERVICE_DESC | Description of Goods and Services | PTRV_VAT_SERVICE_DESC | CHAR | 100 | TEXT100 | ||||
| VAT_STATUS | Status of Data for VAT Refund | PTRV_VAT_STATUS | CHAR | 1 | PTRV_VAT_STATUS | ||||
| VAT_CHANGED_MAN | VAT Amount Changed Manually | PTRV_VAT_CHANGED_MAN | CHAR | 1 | |||||
| DIFF_VIOLATION | Maximum Difference Exceeded | DIFF_VIOLATION | CHAR | 1 | P_ATYPE | ||||
| VAT_SUB_SRV_CODE | Subcodes for Goods and Services | PTRV_VAT_SUB_SRV_CODE | CHAR | 15 | PTRV_VAT_SUB_SRV_CODE | ||||
| VAT_SRV_DESC_LANGU | Language of Description of Goods and Services | PTRV_VAT_SRV_DESC_LANGU | LANG | 1 | ISOLA | SYLANGU | |||
| DATV1 | From Date | FRDAT | DATS | 8 | DATUM | ||||
| DATB1 | To Date | TODAT | DATS | 8 | DATUM | ||||
| ANZAL | Number | ERANZ | DEC | 3 | DEC3 | ||||
| DESCR | Description | ERDES | CHAR | 50 | TEXT50 | ||||
| PLACE | Location | ERPLC | CHAR | 50 | TEXT50 | ||||
| BUSPU | Business Purpose | BUSPU | CHAR | 50 | TEXT50 | ||||
| BUSRE | Business Partners | BUSRE | CHAR | 50 | TEXT50 | ||||
| CCOMP | Code of Payment Card Company | CCOMP | CHAR | 2 | Assigned to domain | CCOMP | |||
| C_DOC | Document Number of Credit Card Receipt | C_DOC | CHAR | 20 | TEXT20 | ||||
| C_TXT | Delivered Description of a Credit Card Transaction | C_TXT | CHAR | 50 | TEXT50 | ||||
| P_CTG | Provider Category | PROVIDER_CATEGORY | CHAR | 1 | FTPD_PROVIDER_CATEGORY | ||||
| P_PRV | Provider Code | PROVIDER_CODE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| P_DOC | Document Number of a (Paper) Document | P_DOC | CHAR | 20 | TEXT20 | ||||
| CCARD | Credit Card Number | C_NUM | CHAR | 19 | TEXT19 | ||||
| CEKEY | Transaction Key (Supplied by Credit Card Company) | CEKEY | CHAR | 10 | CEKEY | ||||
| CFIRMA | Paid by Company | BEZFA | CHAR | 1 | XFELD | TRV_PAID_COMPANY | |||
| N_STF | Number of Employees | CH_NO_STAFF | CHAR | 3 | CHAR3 | ||||
| N_PTN | Number of Employees of Business Partners | CH_NO_PARTNERS | CHAR | 3 | CHAR3 | ||||
| N_GST | Number of Additional Guests | CH_NO_GUESTS | CHAR | 3 | CHAR3 | ||||
| GUID_CCC | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
| PAY_AMOUNT | Amount on Individual Receipt | GESBB | CURR | 10(2) | GESBE | ||||
| PRIEXP | Expense Type for Private Shares | PRIEXP | CHAR | 4 | Assigned to domain | SPKZL | |||
| T_GUEST | 0 | ||||||||
| ANZLU | Number of Lunches in Hotel Receipt | PTRV_ANZLU | CHAR | 3 | CHAR3 | ||||
| ANZDI | Number of Dinners in Hotel Receipt | PTRV_ANZDI | CHAR | 3 | CHAR3 | ||||
| BOOKED_PRICE | Booked Price from Travel Planning | BOOKED_PRICE | CURR | 10(2) | GESBE | ||||
| BOOKED_CURR | Booked Currency from Planning | BOOKED_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| DIFF_AMOUNT | Difference Amount | DIFF_AMOUNT | CURR | 10(2) | GESBE | ||||
| DIFF_CURR | Currency of Difference Amount | DIFF_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| REASON | Reason for Difference | PTRV_REASON | CHAR | 50 | TEXT50 | ||||
| IMAGE_LINK | Contains the UUID for a Document on the Archive Server | PTRA_IMAGE_LINK | CHAR | 32 | SYSUUID_C | ||||
| FROM_MOBILE | Receipt from Mobile Application | PTRA_FROM_MOBILE | CHAR | 1 | XFELD | ||||
| AIR_DEPARTURE | IATA - Airport Location | AIR_LOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| AIR_ARRIVAL | IATA - Airport Location | AIR_LOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| AIRLINE | Airline | AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| AIR_CABIN_CLASS | Cabin Class | AIR_CABIN_CLASS | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| AIR_TICKET_NUMBER | Ticket Number | PTRV_TICKET_NUMBER | CHAR | 15 | PTRV_TICKET_NUMBER | ||||
| CAR_ODOMETER_READING | Odometer Mileage | CAR_ODOMETER_READING | NUMC | 8 | |||||
| SE_NAME | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
| SE_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
| SE_CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
| SE_STATE_PROVINCE | District (US: County) | SE_STATE_PROVINCE | CHAR | 40 | TEXT40 | ||||
| SE_COUNTRY | Country of Vendor | SE_COUNTRY | CHAR | 3 | Assigned to domain | LNDGR | |||
| SE_POSTAL_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
| SE_CUSTOMER_SERVICE_PHONE | Customer Service Telephone No. of Vendor | SE_CUSTOMER_SERVICE_PHONE | CHAR | 30 | CHAR30 | ||||
| BELSA | Receipt Contains Collective Item | PTRVPS_BELSA | CHAR | 1 | PTRV_DETAIL_ACCOMODATION_REC | ||||
| MAZUB | Meals Included in Accommodations Receipt | PTRVPS_MAZUB | CHAR | 1 | PTRV_DETAIL_ACCOMODATION_REC | ||||
| RECAG | Invoice Issued to Employer | PTRVPS_RECAG | CHAR | 1 | PTRV_DETAIL_ACCOMODATION_REC | ||||
| SADV | Collective Item Is Business Related Only | PTRVPS_SADV | CHAR | 1 | PTRV_DETAIL_ACCOMODATION_REC |
| Key field | Non-key field |
How do I retrieve data from SAP structure BELEG_EXBEL using ABAP code?
As BELEG_EXBEL 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 BELEG_EXBEL as there is no data to select.How to access SAP table BELEG_EXBEL
Within an ECC or HANA version of SAP you can also view further information about BELEG_EXBEL 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