SAP ABAP View LOYV_ADM_ARPT_CD (Airport Code Maintenance View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-MA (Application Component) Member Activity
     ⤷ LOY_ADMIN_DATA_DB (Package) Loyalty Admin Data DB

Basic Data

View Type	C	Maintenance View
Maintenance View	LOYV_ADM_ARPT_CD
Short Description	Airport Code Maintenance View
Root table	LOYC_ADM_ARPT_CD	Table to store Airport Code Details

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOYC_ADM_ARPT_CD	LOYC_ADM_ARPT_CD
2	LOYC_ADM_ARPCD_T	LOYC_ADM_ARPT_CD	CLIENT	I

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	CLIENT	LOYC_ADM_ARPT_CD	CLIENT		☐	MANDT	☐	Client
2	AIRPORT_ID	LOYC_ADM_ARPT_CD	AIRPORT_ID		☐	LOY_ADM_AIRPORT_ID	☐	Unique Four Character ICAO Code of the Airport
3	AIRPORT_CD	LOYC_ADM_ARPT_CD	AIRPORT_CD		☐	LOY_ADM_AIRPORT_CD	☐	IATA code of the Airport
4	AIRPORT_COUNTRY	LOYC_ADM_ARPT_CD	AIRPORT_COUNTRY		☐	LOY_COM_COUNTRY	☐	Country
5	AIRPORT_NAME	LOYC_ADM_ARPCD_T	AIRPORT_NAME		☐	LOY_ADM_AIRPORT_NAME	☐	Origin Airport Name
6	AIRPORT_LOC	LOYC_ADM_ARPCD_T	AIRPORT_LOC		☐	LOY_ADM_AIRPORT_LOC	☐	Airport Location Details
7	AIRPORT_NAME_UC	LOYC_ADM_ARPCD_T	AIRPORT_NAME_UC		☐	LOY_ADM_AIRPORT_NAME_UC	☐	Airport Name in Upper Case
8	AIRPORT_LOC_UC	LOYC_ADM_ARPCD_T	AIRPORT_LOC_UC		☐	LOY_ADM_AIRPORT_LOC_UC	☐	Airport Location Upper Case

Maintenance Status

Access

☐   read only

☐   read and change

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

☑   read, change, delete and insert

Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20110908
SAP Release Created in	700