SAP ABAP Table PCFT_BSP_EXAMPLE_SPFLI (Blueprint Structure for Database Table SPFLI)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-PCF (Application Component) People Centric UI Framework
     ⤷ CRM_BSP_FRAME_SAMPLE (Package) Examples for People-Centric UI

Basic Data

Table Category	INTTAB	Structure
Structure	PCFT_BSP_EXAMPLE_SPFLI	Table Relationship Diagram
Short Description	Blueprint Structure for Database Table SPFLI

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
3	.INCLUDE	☐				0	0	Flight schedule
4	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client	T000
5	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	*
6	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	*
7	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
8	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
9	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
10	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
11	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
12	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
13	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
14	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
15	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
16	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
17	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)	*
18	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
19	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PCFT_BSP_EXAMPLE_SPFLI	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	PCFT_BSP_EXAMPLE_SPFLI	AIRPTO	SAIRPORT	ID	REF	1	CN
3	PCFT_BSP_EXAMPLE_SPFLI	CITYFROM	SGEOCITY	CITY	REF	1	CN
4	PCFT_BSP_EXAMPLE_SPFLI	CITYTO	SGEOCITY	CITY	REF	1	CN
5	PCFT_BSP_EXAMPLE_SPFLI	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
6	PCFT_BSP_EXAMPLE_SPFLI	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
7	PCFT_BSP_EXAMPLE_SPFLI	MANDT	T000	MANDT

History

Last changed by/on	SAP	20130604
SAP Release Created in