BW_FI_TV_HOTEL SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from BW_FI_TV_HOTEL
Related tables to BW_FI_TV_HOTEL
Access table BW_FI_TV_HOTEL




Table View field list including key, data, relationships and ABAP select examples

BW_FI_TV_HOTEL is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The BW_FI_TV_HOTEL table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PERNR (Personnel Number), REINR (Trip Number), PLANNR (Travel Plan Number (Sequential Number)), VARIANT (Plan variant number (sequential number)).. 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: Not classified


SAP BW_FI_TV_HOTEL table view 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
MANDTClient MANDTCLNT3MANDT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
REINRTrip Number REINRNUMC10REINR
PLANNRTravel Plan Number (Sequential Number) PLAN_NRNUMC2FTPD_PLAN_NR
VARIANTPlan variant number (sequential number) VARIANT_NRNUMC2FTPD_VARIANT_NR
VARIANTVRSVersion of travel plan VARIANT_VERSIONNUMC2FTPD_VARIANT_VERSION
ITEMTravel Request Item Number (Sequential Number) ITEMPOS_NRNUMC3FTPT_ITEMFTPD_ITEM_ID
SERVICEHotel number HOTEL_SERVICE_NRNUMC3FTPD_HOTEL_ID
HOTEL_CHAINHotel Chain HOTEL_PROVIDERCHAR3TA21PFTPD_PROVIDER_CODE
HOTEL_PROPERTYHotel Code (Key for an Individual Hotel) HOTEL_PROPERTYCHAR6FTPD_HOTEL_PROP
HOTEL_DATE_ARRArrival Date Hotel HOTEL_DATE_ARRDATS8FTPD_DATE
HOTEL_DATE_DEPDeparture Date Hotel HOTEL_DATE_DEPDATS8FTPD_DATE
HOTEL_LOCHotel Location HOTEL_SLOCATIONCHAR3TA21LFTPD_IATA_LOCATION
HOTEL_NAMEName of Hotel HOTEL_NAMECHAR40TEXT40
HOTEL_ROOMTYPEHotel Room Type HOTEL_ROOMTYPECHAR1FTPD_HOTEL_ROOMTYPE
HOTEL_MEALSHotel Meals HOTEL_MEALSCHAR1FTPD_HOTEL_MEALS
ROOM_RATE_CODERate Code (Hotel-Specific) HOTEL_ROOM_RATE_CODECHAR3CHAR3
HOTEL_RATE_CODEHotel Rate Category HOTEL_RATE_PLAN_CODECHAR3FTPD_HOTEL_RATE_CODE
HOTEL_RATERate/Price Per Night HOTEL_RATECURR10(2) FTPD_PRICE
HOTEL_PRICETotal Price for Hotel Stay HOTEL_PRICECURR10(2) FTPD_PRICE
HOTEL_CURRENCYCurrency HOTEL_CURRENCYCUKY5TCURCWAERS
HOTEL_STATUSHotel Status HOTEL_STATUSCHAR2FTPD_SERVICE_STATUS
HOTEL_AREAHotel Area HOTEL_AREA_LOCCHAR1FTPD_HOTEL_AREA
HOTEL_CORP_IDCompany identification for room reservation HOTEL_CORPORATE_IDCHAR30FTPD_CORPORATION_ID

Key field Non-key field



How do I retrieve data from SAP table BW_FI_TV_HOTEL using ABAP code

The following ABAP code Example will allow you to do a basic selection on BW_FI_TV_HOTEL to SELECT all data from the table
DATA: WA_BW_FI_TV_HOTEL TYPE BW_FI_TV_HOTEL.

SELECT SINGLE *
FROM BW_FI_TV_HOTEL
INTO CORRESPONDING FIELDS OF WA_BW_FI_TV_HOTEL
WHERE...

How to access SAP table BW_FI_TV_HOTEL

Within an ECC or HANA version of SAP you can also view further information about BW_FI_TV_HOTEL 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!