SAP ABAP View BW_FI_TV_HOTEL (View for Table FTPT_HOTEL)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ FTBW (Package) Data Transfer FI-TV to BW

Basic Data

View Type	D	Database View
Database View	BW_FI_TV_HOTEL
Short Description	View for Table FTPT_HOTEL
Root table	FTPT_HOTEL	Travel Request Item - Hotel Service

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FTPT_HOTEL	FTPT_HOTEL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FTPT_HOTEL	MANDT		☐	MANDT	☐	Client
2	PERNR	FTPT_HOTEL	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	FTPT_HOTEL	REINR		☐	REINR	☐	Trip Number
4	PLANNR	FTPT_HOTEL	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
5	VARIANT	FTPT_HOTEL	VARIANT		☐	VARIANT_NR	☐	Plan variant number (sequential number)
6	VARIANTVRS	FTPT_HOTEL	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
7	ITEM	FTPT_HOTEL	ITEM		☐	ITEMPOS_NR	☐	Travel Request Item Number (Sequential Number)
8	SERVICE	FTPT_HOTEL	SERVICE		☐	HOTEL_SERVICE_NR	☐	Hotel number
9	HOTEL_CHAIN	FTPT_HOTEL	HOTEL		☐	HOTEL_PROVIDER	☐	Hotel Chain
10	HOTEL_PROPERTY	FTPT_HOTEL	PROPERTY		☐	HOTEL_PROPERTY	☐	Hotel Code (Key for an Individual Hotel)
11	HOTEL_DATE_ARR	FTPT_HOTEL	DATE_ARR		☐	HOTEL_DATE_ARR	☐	Arrival Date Hotel
12	HOTEL_DATE_DEP	FTPT_HOTEL	DATE_DEP		☐	HOTEL_DATE_DEP	☐	Departure Date Hotel
13	HOTEL_LOC	FTPT_HOTEL	LOC		☐	HOTEL_SLOCATION	☐	Hotel Location
14	HOTEL_NAME	FTPT_HOTEL	NAME		☐	HOTEL_NAME	☐	Name of Hotel
15	HOTEL_ROOMTYPE	FTPT_HOTEL	ROOMTYPE		☐	HOTEL_ROOMTYPE	☐	Hotel Room Type
16	HOTEL_MEALS	FTPT_HOTEL	MEALS		☐	HOTEL_MEALS	☐	Hotel Meals
17	ROOM_RATE_CODE	FTPT_HOTEL	ROOM_RATE_CODE		☐	HOTEL_ROOM_RATE_CODE	☐	Rate Code (Hotel-Specific)
18	HOTEL_RATE_CODE	FTPT_HOTEL	RATE_CODE		☐	HOTEL_RATE_PLAN_CODE	☐	Hotel Rate Category
19	HOTEL_RATE	FTPT_HOTEL	RATE		☐	HOTEL_RATE	☐	Rate/Price Per Night
20	HOTEL_PRICE	FTPT_HOTEL	PRICE		☐	HOTEL_PRICE	☐	Total Price for Hotel Stay
21	HOTEL_CURRENCY	FTPT_HOTEL	CURRENCY		☐	HOTEL_CURRENCY	☐	Currency
22	HOTEL_STATUS	FTPT_HOTEL	STATUS		☐	HOTEL_STATUS	☐	Hotel Status
23	HOTEL_AREA	FTPT_HOTEL	AREA_LOC		☐	HOTEL_AREA_LOC	☐	Hotel Area
24	HOTEL_CORP_ID	FTPT_HOTEL	CORPORATE_ID		☐	HOTEL_CORPORATE_ID	☐	Company identification for room reservation

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in