BIW_FI_TV_02 SAP (Extract Structure for Infosource 0FI_TV_02) Structure details
Dictionary Type: Structure
Description: Extract Structure for Infosource 0FI_TV_02
Description: Extract Structure for Infosource 0FI_TV_02
Structure field list including key, data, relationships and ABAP select examples
BIW_FI_TV_02 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 "Extract Structure for Infosource 0FI_TV_02" 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_BIW_FI_TV_02 TYPE BIW_FI_TV_02.
The BIW_FI_TV_02 table consists of various fields, each holding specific information or linking keys about Extract Structure for Infosource 0FI_TV_02 data available in SAP. These include REINR (Trip Number), ENTRY_TYPE (Type of Trip Data), WAERS (Currency Key), MOLGA (Country Grouping).. 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 BIW_FI_TV_02 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 |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
| REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
| ENTRY_TYPE | Type of Trip Data | PTRV_BW_ENTRY_TYPE | CHAR | 1 | PTRV_BW_ENTRY_TYPE | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| MOLGA | Country Grouping | MOLGA | CHAR | 2 | Assigned to domain | MOLGA | MOL | ||
| MOREI | Trip Provision Variant | MOREI | CHAR | 2 | Assigned to domain | MOREI | MOR | ||
| SCHEM | Trip schema | RSCHE | CHAR | 2 | Assigned to domain | RSCHE | |||
| KZREA | Trip Type: Statutory | KZREA | CHAR | 1 | Assigned to domain | KZREA | |||
| BEREI | Trip Type: Enterprise-Specific | BEREI | CHAR | 1 | Assigned to domain | BEREI | |||
| KZTKT | Trip Activity Type | KZTKT | CHAR | 1 | Assigned to domain | KZTKT | |||
| ZLAND | Trip Country / Trip Country Group | LNDGR | CHAR | 3 | Assigned to domain | LNDGR | |||
| HRGIO | Region of Main Destination | HRGIO | CHAR | 5 | Assigned to domain | RGION | |||
| DATV1 | Beginning Date of Trip Segment | REBED | DATS | 8 | REDAT | ||||
| UHRV1 | Beginning Time of Trip Segment | REBEU | TIMS | 6 | REUHR | ||||
| DATB1 | End Date of Trip Segment | REEND | DATS | 8 | REDAT | ||||
| UHRB1 | End Time of Trip Segment | REENU | TIMS | 6 | REUHR | ||||
| PLAN_STATUS | Travel Plan Status | PLAN_STATUS | CHAR | 1 | FTPD_PSTAT | ||||
| ACTIVITY_TYPE | Trip Activity Type | PLAN_ACTIVITY | CHAR | 1 | Assigned to domain | FTPD_PLAN_ACTIVITY | |||
| REC_LOCATOR | Passenger Name Record Locator | PNR_RECORD_LOCATOR | CHAR | 20 | FTPD_PNR_RECORD_LOCATOR | ||||
| USERG | User Grouping for Travel Planning | EMPLOYEE_GROUP_TP | CHAR | 2 | Assigned to domain | FTPD_EMPLOYEE_GROUP | |||
| CATEGORY | Enterprise-Specific Travel Service Category | ITEMPOS_USER_CAT | CHAR | 1 | Assigned to domain | FTPD_USER_CAT | |||
| BELNR | Document Number | NRBEL | CHAR | 3 | NRBEL | ||||
| REAL_CAT | Travel service category | CATEGORY | CHAR | 1 | FTPD_ITEM_CATEGORY | ||||
| HOTEL_CHAIN | Hotel Chain | HOTEL_PROVIDER | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| HOTEL_PROPERTY | Hotel Code (Key for an Individual Hotel) | HOTEL_PROPERTY | CHAR | 6 | FTPD_HOTEL_PROP | ||||
| HOTEL_DATE_ARR | Arrival Date Hotel | HOTEL_DATE_ARR | DATS | 8 | FTPD_DATE | ||||
| HOTEL_DATE_DEP | Departure Date Hotel | HOTEL_DATE_DEP | DATS | 8 | FTPD_DATE | ||||
| HOTEL_LOC | Hotel Location | HOTEL_SLOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| HOTEL_NAME | Name of Hotel | HOTEL_NAME | CHAR | 40 | TEXT40 | ||||
| HOTEL_ROOMTYPE | Hotel Room Type | HOTEL_ROOMTYPE | CHAR | 1 | FTPD_HOTEL_ROOMTYPE | ||||
| HOTEL_MEALS | Hotel Meals | HOTEL_MEALS | CHAR | 1 | FTPD_HOTEL_MEALS | ||||
| HOTEL_RATE | Rate/Price Per Night | HOTEL_RATE | CURR | 10(2) | FTPD_PRICE | ||||
| HOTEL_PRICE | Total Price for Hotel Stay | HOTEL_PRICE | CURR | 10(2) | FTPD_PRICE | ||||
| HOTEL_STATUS | Hotel Status | HOTEL_STATUS | CHAR | 2 | FTPD_SERVICE_STATUS | ||||
| HOTEL_RATE_CODE | Hotel Rate Category | HOTEL_RATE_PLAN_CODE | CHAR | 3 | Assigned to domain | FTPD_HOTEL_RATE_CODE | |||
| ROOM_RATE_CODE | Rate Code (Hotel-Specific) | HOTEL_ROOM_RATE_CODE | CHAR | 3 | CHAR3 | ||||
| HOTEL_AREA | Hotel Area | HOTEL_AREA_LOC | CHAR | 1 | FTPD_HOTEL_AREA | ||||
| HOTEL_NIGHTS | No.of Hotel Nights | PTRV_BW_HOTEL_NIGHTS | INT4 | 10 | INT4 | ||||
| HOTEL_BOOKINGS | Number of Hotel Bookings | PTRV_BW_HOTEL_BOOKINGS | INT4 | 10 | INT4 | ||||
| CAR_PROVIDER | Car Rental Provider | CAR_PROVIDER | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| CAR_DATE_BEG | Start Date for Rental Car | CAR_DATE_BEG | DATS | 8 | FTPD_DATE | ||||
| CAR_LOC_BEG | Rental Car Starting Location | CAR_LOC_BEG | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| CAR_DATE_END | End date for car rental | CAR_DATE_END | DATS | 8 | FTPD_DATE | ||||
| CAR_LOC_END | Dropoff Location | CAR_LOC_END | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| CAR_CLASS | Rental Car Vehicle Class | CAR_CLASS | CHAR | 1 | FTPD_CAR_CLASS | ||||
| CAR_TYPE | Rental Car Vehicle Type | CAR_TYPE | CHAR | 1 | FTPD_CAR_TYPE | ||||
| CAR_PRICE | Car Rental Price Per Day/Week/Etc. | CAR_PRICE | CURR | 10(2) | FTPD_PRICE | ||||
| CAR_RATE_CODE | Rental Car Rate Key (Provider-Dependent) | CAR_RATECODE | CHAR | 12 | CHAR12 | ||||
| CAR_TOT_RATETYPE | Car rental rate indicator (total amount) | CAR_TOTAL_RATE_TYPE | CHAR | 3 | FTPD_CAR_RATE_CODE | ||||
| CAR_TOTAL_RATE | Total Price for Car Rental | CAR_TOTAL_RATE_AMOUNT | CURR | 10(2) | FTPD_PRICE | ||||
| CAR_STATUS | Car Rental Status | CAR_STATUS | CHAR | 2 | FTPD_SERVICE_STATUS | ||||
| CAR_AREA | City of car rental office (location) | CAR_AREA | CHAR | 1 | FTPD_CAR_AREA | ||||
| CAR_DAYS | Number of Car Rental Days | PTRV_BW_CAR_DAYS | INT4 | 10 | INT4 | ||||
| CAR_BOOKINGS | Number of Car Rental Bookings | PTRV_BW_CAR_BOOKINGS | INT4 | 10 | INT4 | ||||
| CAR_PICKUP_LOC | Car rental branch office for vehicle pickup | CAR_PICKUP_LOC | CHAR | 6 | CHAR6 | ||||
| AIRLINE | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| FLIGHT_NR | Flight Number | FLIGHT_NR | CHAR | 6 | FTPD_FLIGHT_NR | ||||
| FLIGHT_DATE_DEP | Flight departure date | FLIGHT_DATE_DEP | DATS | 8 | FTPD_DATE | ||||
| FLIGHT_TIME_DEP | Flight departure time | FLIGHT_TIME_DEP | TIMS | 6 | FTPD_TIME | ||||
| FLIGHT_LOC_DEP | Departure Location | FLIGHT_SLOC_DEP | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| FLIGHT_LOC_ARR | Flight Arrival Location | FLIGHT_SLOC_ARR | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| RESTRICT_FARE | Lowest Fare Search | FFARE_TYPES | CHAR | 1 | FTPD_FARE_CHOICE | ||||
| FLIGHT_CABIN | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_RBD | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_STATUS | Flight Status | FLIGHT_STATUS | CHAR | 2 | FTPD_SERVICE_STATUS | ||||
| FLIGHT_NUMBER | Number of Flights | PTRV_BW_FLIGHT_NUMBER | INT4 | 10 | INT4 | ||||
| FARE_BASIS_CODE | Basis code of rate component | FARE_BASIS_CODE | CHAR | 10 | CHAR10 | ||||
| LOCAL_TST | Ticket element is local (not in booking system) | LOCAL_TST | CHAR | 1 | CHAR1_X | ||||
| LAST_DATE | Last Ticketing Date | TST_LAST_DATE | DATS | 8 | FTPD_DATE | ||||
| TICKET_MODE | Ticketing Mode of Airline Ticket | TST_TICKET_MODE | CHAR | 1 | FTPD_TST_MODE | ||||
| SALES_IND | Sales Type of Airline Ticket Rate | TST_SALES_IND | CHAR | 4 | FTPD_TST_SALES_IND | ||||
| FARE | Basic rate for flight ticket without tax | TST_FARE | CURR | 10(2) | FTPD_PRICE | ||||
| TOTAL_FARE | Total price of flight ticket | TST_TOTAL_FARE | CURR | 10(2) | FTPD_PRICE | ||||
| AIRLINE1 | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| AIRLINE2 | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| AIRLINE3 | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| AIRLINE4 | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| AIRLINE_UNIQUE | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| FLIGHT_CABIN1 | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_CABIN2 | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_CABIN3 | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_CABIN4 | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_CABIN_UNI | Flight Cabin Class | FLIGHT_CABIN | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
| FLIGHT_RBD1 | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_RBD2 | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_RBD3 | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_RBD4 | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_RBD_UNI | Flight Booking Code (RBD) | FLIGHT_RBD | CHAR | 1 | FTPD_FLIGHT_RBD | ||||
| FLIGHT_LOC_VIA1 | Connection Airport for Round Trip | PTRV_BW_SLOC_VIA | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| FLIGHT_LOC_VIA2 | Connection Airport for Round Trip | PTRV_BW_SLOC_VIA | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
| FLIGHT_RETURNS | Number of Return Flights | PTRV_BW_FLIGHT_RETURNS | INT4 | 10 | INT4 | ||||
| CAR_CORPORATE_ID | Company ID for Negotiated Rates | CAR_CORPORATE_ID | CHAR | 30 | FTPD_CORPORATION_ID | ||||
| OP_AIRLINE | Airline | FLIGHT_AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| HOTEL_CORP_ID | Company identification for room reservation | HOTEL_CORPORATE_ID | CHAR | 30 | FTPD_CORPORATION_ID | ||||
| PLATING_CARRIER | Plating Carrier | PLATING_CARRIER | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
| TST_ISSUE_TYPE | Airline Ticket Issue | TST_ISSUE_TYPE | CHAR | 1 | FTPD_TST_ISSUE_TYPE | ||||
| REBATE_FARE | Discount price of flight ticket | TST_REBATED_FARE | CURR | 10(2) | FTPD_PRICE | ||||
| TICKETNUMBER | Ticket Number | TICKET_NUMBER | NUMC | 15 | FTPD_TICKET_NUMBER | ||||
| TICKETTYPE | Ticket Type | TICKETTYPE | CHAR | 1 | FTPD_TICKET_TYPE | ||||
| TST_FARE_TYPE | Fare Type (Normal, Negotiated, Etc.) | TST_FARE_TYPE | CHAR | 2 | FTPD_TST_FARE_TYPE |
| Key field | Non-key field |
How do I retrieve data from SAP structure BIW_FI_TV_02 using ABAP code?
As BIW_FI_TV_02 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 BIW_FI_TV_02 as there is no data to select.How to access SAP table BIW_FI_TV_02
Within an ECC or HANA version of SAP you can also view further information about BIW_FI_TV_02 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