/GBTRV/S_TERB_EXPENSETYPE SAP (TER Collection: Customizing - Expense Types) Structure details

Dictionary Type: Structure
Description: TER Collection: Customizing - Expense Types




ABAP Code to SELECT data from /GBTRV/S_TERB_EXPENSETYPE
Related tables to /GBTRV/S_TERB_EXPENSETYPE
Access table /GBTRV/S_TERB_EXPENSETYPE




Structure field list including key, data, relationships and ABAP select examples

/GBTRV/S_TERB_EXPENSETYPE 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 "TER Collection: Customizing - Expense Types" 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_/GBTRV/S_TERB_EXPENSETYPE TYPE /GBTRV/S_TERB_EXPENSETYPE.

The /GBTRV/S_TERB_EXPENSETYPE table consists of various fields, each holding specific information or linking keys about TER Collection: Customizing - Expense Types data available in SAP. These include PR04_SORT (Sequence of Expense Types in Weekly Report), EXP_TYPE (Travel Expense Type), TAX_CODE (Tax on sales/purchases code), EXP_CATE (Travel Expense Category).. 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 /GBTRV/S_TERB_EXPENSETYPE 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
PR04_SORTSequence of Expense Types in Weekly Report PR04XCHAR1PR04X
EXP_TYPETravel Expense Type SPKZLCHAR4T706B1SPKZLRSASH_EXPENSE_TYPES
TAX_CODETax on sales/purchases code MWSKZCHAR2T007AMWSKZ
EXP_CATETravel Expense Category BELARCHAR1BELAR
PAID_COMPaid by Company BEZFACHAR1XFELDTRV_PAID_COMPANY
MAX_AMOUNTMaximum Receipt Amount MAX_AMOUNTDEC23(4) BAPICURR
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
MESS_FLAGError Message When Maximum Value Exceeded MESSA_DCHAR1XFELD
SCDV1From date field control SCDV1CHAR1AUSWL
SCDB1To date field control SCDB1CHAR1AUSWL
SCANZNumber field control SCANZCHAR1AUSWL
ANZCACalculation of Default Value for Number Field ANZCACHAR1ANZCA
SCLNDCountry/Region field control SCLNDCHAR1AUSWL
SCRAUField control for enterprise-specific trip type SCRAUCHAR1AUSWL
SCFRFField control for number of breakfasts SCFRFCHAR1AUSWL
SCDECDescription field control SCDECCHAR1AUSWL
SCPLAField control: Place SCPLACHAR1AUSWL
SCBPUField control for business purpose on receipt SCBPUCHAR1AUSWL
SCBREField control for business partner SCBRECHAR1AUSWL
SCEDTEditor field control SCEDTCHAR1AUSWL
EXP_TEXTName of Travel Expense Type TEXT_SPKZLCHAR30REITX
SCPRVField Control for Provider (Airline, Hotel Chain, ...) SCPRVCHAR1AUSWL
SCMERField control for service provider SCMERCHAR1AUSWL
SCDOCField Control for (Paper) Document Number SCDOCCHAR1AUSWL
CATEGORYProvider Category PROVIDER_CATEGORYCHAR1FTPD_PROVIDER_CATEGORY
SCSTFField Control Number of Employees SC_NO_STAFFCHAR1AUSWL
SCPTNField Control Number of Employees of Business Partners SC_NO_PARTNERSCHAR1AUSWL
SCGSTField Control Number of Additional Guests SC_NO_GUESTSCHAR1AUSWL
REWIZReceipt Wizard RECWIZCHAR1RECWIZ
PREXPExpense Type Pay Back Private Share PRVEXPCHAR4Assigned to domainSPKZL
PREXCExpense Type Private Share Paid by Company PRVEXCCHAR4Assigned to domainSPKZL
SCFRAField Control for Number of Dinners SCFRACHAR1AUSWL
SCFRLField Control for Number of Lunches SCFRLCHAR1AUSWL
REV_CHARGE_MWSKZVAT Code Reverse Charge PTRV_REVCHARGE_MWSKZCHAR2Assigned to domainMWSKZ
VAT_IRRELEVANTExpense Type Not Relevant for VAT Refund PTRV_VATIRRELEVANTCHAR1PTRV_VATIRRELEVANT
SCAIRDEPField Control IATA - Location of Departure Airport SCAIRDPCHAR1AUSWL
SCAIRAIAField Control IATA - Location of Arrival Airport SCAIRARCHAR1AUSWL
SCAIRLField Control for Airline SCAIRCHAR1AUSWL
SCAIRAICField Control for Cabin Class SCAIRAICCHAR1AUSWL
SCAIRAITField Control for Ticket Number SCAIRAITCHAR1AUSWL
SCCARODOField Control for Tachometer Mileage SCCARODOCHAR1AUSWL
SCKRDSNAField Control for Name of Vendor SCKRDSNACHAR1AUSWL
SCKRDSSTField Control for Street of Vendor SCKRDSSTCHAR1AUSWL
SCKRDSCIField Control for Vendor Location SCKRDSCICHAR1AUSWL
SCKRDSPRField Control for District/County of Vendor SCKRDSPRCHAR1AUSWL
SCKRDSCOField Control for Country of Vendor SCKRDSCOCHAR1AUSWL
SCKRDSPCField Control for Postal Code of Vendor SCKRDSPCCHAR1AUSWL
SCKRDSPHField Control for Vendor's Telephone Number SCKRDSPHCHAR1AUSWL
TRIP_OR_WEEKLY_REPORTUse of Expense Type in Weekly Report/Business Trip PR04OCHAR1PR04O
GROUPINGTravel Expense Type Grouping P_GRUPNCHAR1CHAR1
EST_CIndicator for Expense Type Containing Estimated Costs PTRV_ESTCCHAR1XFELD
PRIVCExpense Type that Includes Private Costs (Indicator) PTRV_PRIVCHAR1XFELD
PRIEXPExpense Type for Private Shares PRIEXPCHAR4Assigned to domainSPKZL
SCENTField Control for Participants in Entertainment Receipt SCENTCHAR1AUSWL
USEFLUsage indicator of travel expense type PTRV_USEFLCHAR1PTRV_USEFL
BUSPAPossibility for Entering Business Partners PTRV_BUSPACHAR1PTRV_BUSPA
FILTER_EXPTYPEIndicator for the validity of the expense type (manual, CC) /GBTRV/TER_C_EXPTYPE_INDCHAR1/GBTRV/TER_EXP_TYPE_IND

Key field Non-key field



How do I retrieve data from SAP structure /GBTRV/S_TERB_EXPENSETYPE using ABAP code?

As /GBTRV/S_TERB_EXPENSETYPE 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 /GBTRV/S_TERB_EXPENSETYPE as there is no data to select.

How to access SAP table /GBTRV/S_TERB_EXPENSETYPE

Within an ECC or HANA version of SAP you can also view further information about /GBTRV/S_TERB_EXPENSETYPE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!