SAP ABAP Table LCCHOTEL_AVAILABILITY_QUERY (Proxy Structure (Generated))

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ PTRXI (Package) Travel Management Repository XI

Basic Data

Table Category	INTTAB	Structure
Structure	LCCHOTEL_AVAILABILITY_QUERY	Table Relationship Diagram
Short Description	Proxy Structure (Generated)

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	LOCATION	☐	LCCHOTEL_LOCATION		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	ADDRESS	☐	LCCADDRESS1		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	ORGANISATION_FORMATTED_NAME	☐	LCCADDRESS_ORGANISATION_F_TAB1		TTYP	0	0
7	PERSON_NAME	☐	LCCPERSON_NAME1		STRU	0	0
8	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
9	FORMATTED_NAME	☐			CHAR	80	0
10	LEGAL_NAME	☐			CHAR	80	0
11	GIVEN_NAME	☐	LCCPERSON_NAME_GIVEN_NAME_TAB1		TTYP	0	0
12	PREFERRED_GIVEN_NAME	☐			CHAR	40	0
13	MIDDLE_NAME	☐	LCCPERSON_NAME_MIDDLE_NAM_TAB1		TTYP	0	0
14	FAMILY	☐	LCCPERSON_NAME_FAMILY_TAB1		TTYP	0	0
15	AFFIX	☐	LCCPERSON_NAME_AFFIX_TAB1		TTYP	0	0
16	FUNCTIONAL_TITLE_NAME	☐			CHAR	40	0
17	DEPARTMENT_NAME	☐			CHAR	40	0
18	OFFICE	☐	LCCADDRESS_OFFICE1		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	BUILDING_ID	☐			CHAR	10	0
21	FLOOR_ID	☐			CHAR	10	0
22	ROOM_ID	☐			CHAR	10	0
23	INHOUSE_MAIL_ID	☐			CHAR	10	0
24	CORRESPONDENCE_SHORT_NAME	☐			CHAR	10	0
25	PHYSICAL_ADDRESS	☐	LCCADDRESS_PHYSICAL_ADDRESS1		STRU	0	0
26	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
27	COUNTRY_CODE	☐	LCCCOUNTRY_CODE1		CHAR	3	0	Proxy Data Element (Generated)
28	REGION_CODE	☐	LCCREGION_CODE1		STRU	0	0
29	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
30	LIST_ID	☐			CHAR	60	0
31	LIST_VERSION_ID	☐			CHAR	15	0
32	LIST_AGENCY_ID	☐			CHAR	60	0
33	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
34	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
35	VALUE	☐	LCCREGION_CODE_CONTENT1		CHAR	9	0	Proxy Data Element (Generated)
36	STREET_POSTAL_CODE	☐			CHAR	10	0
37	POBOX_POSTAL_CODE	☐			CHAR	10	0
38	COMPANY_POSTAL_CODE	☐			CHAR	10	0
39	CITY_NAME	☐			CHAR	40	0
40	ADDITIONAL_CITY_NAME	☐			CHAR	40	0
41	DISTRICT_NAME	☐			CHAR	40	0
42	POBOX_ID	☐			CHAR	10	0
43	POBOX_INDICATOR	☐			CHAR	5	0
44	POBOX_COUNTRY_CODE	☐	LCCCOUNTRY_CODE1		CHAR	3	0	Proxy Data Element (Generated)
45	POBOX_REGION_CODE	☐	LCCREGION_CODE1		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	LIST_ID	☐			CHAR	60	0
48	LIST_VERSION_ID	☐			CHAR	15	0
49	LIST_AGENCY_ID	☐			CHAR	60	0
50	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
51	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
52	VALUE	☐	LCCREGION_CODE_CONTENT1		CHAR	9	0	Proxy Data Element (Generated)
53	POBOX_CITY_NAME	☐			CHAR	40	0
54	STREET_NAME	☐			CHAR	80	0
55	STREET_PREFIX_NAME	☐	LCCADDRESS_STREET_PREFIX__TAB1		TTYP	0	0
56	STREET_SUFFIX_NAME	☐	LCCADDRESS_STREET_SUFFIX__TAB1		TTYP	0	0
57	HOUSE_ID	☐			CHAR	10	0
58	ADDITIONAL_HOUSE_ID	☐			CHAR	10	0
59	BUILDING_ID	☐			CHAR	20	0
60	FLOOR_ID	☐			CHAR	10	0
61	ROOM_ID	☐			CHAR	10	0
62	CARE_OF_NAME	☐			CHAR	40	0
63	DESCRIPTION	☐	LCCDESCRIPTION_TAB1		TTYP	0	0
64	TAX_JURISDICTION_CODE	☐	LCCTAX_JURISDICTION_CODE1		STRU	0	0
65	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
66	LIST_ID	☐			CHAR	60	0
67	LIST_VERSION_ID	☐			CHAR	15	0
68	LIST_AGENCY_ID	☐			CHAR	60	0
69	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
70	LIST_AGENCY_SCHEME_AGENCY_ID	☐			CHAR	3	0
71	VALUE	☐	LCCTAX_JURISDICTION_CODE_CONT1		CHAR	15	0	Proxy Data Element (Generated)
72	TIME_ZONE_DIFFERENCE_VALUE	☐	LCCTIME_ZONE_DIFFERENCE_VALUE1		DEC	4	2	Proxy Data Element (Generated)
73	GEO_COORDINATES	☐	LCCGEO_COORDINATES1		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	LATITUDE_MEASURE	☐	LCCMEASURE1		STRU	0	0
76	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
77	UNIT_CODE	☐			CHAR	3	0
78	VALUE	☐			STRG	0	0
79	LONGITUDE_MEASURE	☐	LCCMEASURE1		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	UNIT_CODE	☐			CHAR	3	0
82	VALUE	☐			STRG	0	0
83	COMMUNICATION	☐	LCCADDRESS_COMMUNICATION1		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	CORRESPONDENCE_LANGUAGE_CODE	☐	LCCLANGUAGE_CODE1		CHAR	9	0	Proxy Data Element (Generated)
86	TELEPHONE	☐	LCCADDRESS_TELEPHONE_TAB1		TTYP	0	0
87	MOBILE_PHONE	☐	LCCADDRESS_MOBILE_PHONE_TAB1		TTYP	0	0
88	FACSIMILE	☐	LCCADDRESS_FACSIMILE_TAB1		TTYP	0	0
89	EMAIL	☐	LCCADDRESS_EMAIL_TAB1		TTYP	0	0
90	WEB	☐	LCCADDRESS_WEB_TAB1		TTYP	0	0
91	IATACODE_ID	☐	LCCLOCATION_STANDARD_ID1		STRU	0	0
92	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
93	SCHEME_AGENCY_ID	☐			CHAR	3	0
94	VALUE	☐	LCCLOCATION_STANDARD_IDCONTEN1		CHAR	13	0	Proxy Data Element (Generated)
95	CODE	☐			CHAR	20	0
96	TEXT	☐			STRG	0	0
97	STAY_PERIOD	☐	LCCDATE_PERIOD		STRU	0	0
98	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
99	START_DATE	☐	LCCDATE1		DATS	8	0	Proxy Data Element (Generated)
100	END_DATE	☐	LCCDATE1		DATS	8	0	Proxy Data Element (Generated)
101	DURATION	☐	LCCDURATION		STRG	0	0	Proxy Data Element (Generated)
102	HOTEL	☐	LCCHOTEL_TAB		TTYP	0	0
103	ROOM	☐	LCCHOTEL_ROOM_TAB		TTYP	0	0
104	SEARCH_RADIUS_MEASURE	☐	LCCMEASURE1		STRU	0	0
105	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
106	UNIT_CODE	☐			CHAR	3	0
107	VALUE	☐			STRG	0	0
108	HOTEL_CHAIN	☐	LCCHOTEL_CHAIN_TAB		TTYP	0	0
109	HOTEL_TYPE_CODE	☐	LCCHOTEL_TYPE_CODE_TAB		TTYP	0	0
110	CUSTOMER_CURRENCY_CODE	☐	LCCCURRENCY_CODE1		CHAR	3	0	Proxy Data Element (Generated)
111	CUSTOMER_LANGUAGE_CODE	☐	LCCLANGUAGE_CODE1		CHAR	9	0	Proxy Data Element (Generated)
112	MODE_CODE	☐	LCCHOTEL_AVAILABILITY_QUERY_MO		CHAR	10	0	Proxy Datenelement (generiert)
113	MINIMUM_AMOUNT	☐	LCCAMOUNT1		STRU	0	0
114	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
115	CURRENCY_CODE	☐			CHAR	3	0
116	VALUE	☐	LCCAMOUNT_CONTENT1		DEC	28	6	Proxy Data Element (Generated)
117	MAXIMUM_AMOUNT	☐	LCCAMOUNT1		STRU	0	0
118	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
119	CURRENCY_CODE	☐			CHAR	3	0
120	VALUE	☐	LCCAMOUNT_CONTENT1		DEC	28	6	Proxy Data Element (Generated)
121	MINIMUM_CLASS_CODE	☐	LCCHOTEL_ACCOMODATION_CLASS_CO		CHAR	1	0	Proxy Datenelement (generiert)
122	MAXIMUM_CLASS_CODE	☐	LCCHOTEL_ACCOMODATION_CLASS_CO		CHAR	1	0	Proxy Datenelement (generiert)
123	HOTEL_AMENITY	☐	LCCHOTEL_AMENITY_TAB		TTYP	0	0
124	POINT_OF_INTEREST_SEARCH_INDI	☐			CHAR	5	0
125	ROOM_RATE	☐	LCCHOTEL_ROOM_RATE_TAB		TTYP	0	0
126	BOOKING_SOURCE_NOTE	☐			STRG	0	0
127	CORPORATE_PROGRAM_NOTE	☐			STRG	0	0
128	LOYALITY_CARD	☐	LCCLOYALITY_CARD_TAB1		TTYP	0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	600