SAP ABAP Table BW_FI_TV_HOTEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BW_FI_TV_HOTEL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
4	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)
5	VARIANT	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
6	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan
7	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
8	SERVICE	☑	HOTEL_SERVICE_NR	FTPD_HOTEL_ID	NUMC	3	0	Hotel number
9	HOTEL_CHAIN	☐	HOTEL_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Hotel Chain	TA21P
10	HOTEL_PROPERTY	☐	HOTEL_PROPERTY	FTPD_HOTEL_PROP	CHAR	6	0	Hotel Code (Key for an Individual Hotel)
11	HOTEL_DATE_ARR	☐	HOTEL_DATE_ARR	FTPD_DATE	DATS	8	0	Arrival Date Hotel
12	HOTEL_DATE_DEP	☐	HOTEL_DATE_DEP	FTPD_DATE	DATS	8	0	Departure Date Hotel
13	HOTEL_LOC	☐	HOTEL_SLOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Hotel Location	TA21L
14	HOTEL_NAME	☐	HOTEL_NAME	TEXT40	CHAR	40	0	Name of Hotel
15	HOTEL_ROOMTYPE	☐	HOTEL_ROOMTYPE	FTPD_HOTEL_ROOMTYPE	CHAR	1	0	Hotel Room Type
16	HOTEL_MEALS	☐	HOTEL_MEALS	FTPD_HOTEL_MEALS	CHAR	1	0	Hotel Meals
17	ROOM_RATE_CODE	☐	HOTEL_ROOM_RATE_CODE	CHAR3	CHAR	3	0	Rate Code (Hotel-Specific)
18	HOTEL_RATE_CODE	☐	HOTEL_RATE_PLAN_CODE	FTPD_HOTEL_RATE_CODE	CHAR	3	0	Hotel Rate Category
19	HOTEL_RATE	☐	HOTEL_RATE	FTPD_PRICE	CURR	10	2	Rate/Price Per Night
20	HOTEL_PRICE	☐	HOTEL_PRICE	FTPD_PRICE	CURR	10	2	Total Price for Hotel Stay
21	HOTEL_CURRENCY	☐	HOTEL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
22	HOTEL_STATUS	☐	HOTEL_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Hotel Status
23	HOTEL_AREA	☐	HOTEL_AREA_LOC	FTPD_HOTEL_AREA	CHAR	1	0	Hotel Area
24	HOTEL_CORP_ID	☐	HOTEL_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company identification for room reservation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_FI_TV_HOTEL	HOTEL_CHAIN	TA21P	PROVIDER	REF	1	CN
2	BW_FI_TV_HOTEL	HOTEL_CURRENCY	TCURC	WAERS	REF	1	CN
3	BW_FI_TV_HOTEL	HOTEL_LOC	TA21L	LOCID	REF	1	CN
4	BW_FI_TV_HOTEL	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in