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

History

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