SAP ABAP Table ADFSH_PRTDET (Flight Scheduling: PRT Detail)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PLM-LBK (Application Component) Logbook
     ⤷ AD_FSH_DDIC (Package) Flight Scheduling (DDIC)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ADFSH_PRTDET	Table Relationship Diagram
Short Description	Flight Scheduling: PRT Detail

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	T000
2	AIRLN	☑	ADFSH_AIRCODE	ADFSH_AIRCODE	CHAR	3	0	Flight Scheduling: Airline Code	ADFSH_AIRLNCD
3	FLTNR	☑	ADFSH_FLTNUM	ADFSH_FLTNUM	CHAR	5	0	Flight Scheduling: Flight Number	ADFSH_FLGTDET
4	SECNR	☑	ADFSH_SECNR	ADFSH_SECNR	CHAR	5	0	Flight Scheduling: Sector Number	ADFSH_SECTMAS
5	ACDATE	☑	ADFSH_ACDATE	ADFSH_ACDATE	DATS	8	0	Flight Scheduling: Actual Date of Flight
6	ARRDEP	☑	ADFSH_ARRDEP	ADFSH_ARRDEP	CHAR	1	0	Flight Scheduling: Arrival / Departure Indicator
7	ITMNR	☑	ADFSH_ITMNR	ADFSH_ITMNR	NUMC	4	0	Flight Scheduling: Item number for a flight
8	DELFLG	☐	ADFSH_DELFLAG	XFELD	CHAR	1	0	Flight Scheduling: Flag for deletion
9	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	PLKO
10	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group	PLKO
11	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter	PLKO
12	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
13	.INCLUDE	☐				0	0	Flight Scheduling: Structure for tracking Created By/Changed
14	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	CREATED_DT	☐	ADFSH_CDATE	DATUM	DATS	8	0	Created on
16	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
17	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADFSH_PRTDET	AIRLN	ADFSH_AIRLNCD	AIRLN	KEY	1	CN
2	ADFSH_PRTDET	FLTNR	ADFSH_FLGTDET	FLTNR	KEY	1	CN
3	ADFSH_PRTDET	MANDT	T000	MANDT	KEY	1	CN
4	ADFSH_PRTDET	PLNAL	PLKO	PLNAL	KEY	1	CN
5	ADFSH_PRTDET	PLNNR	PLKO	PLNNR	KEY	1	CN
6	ADFSH_PRTDET	PLNTY	PLKO	PLNTY	KEY	1	CN
7	ADFSH_PRTDET	SECNR	ADFSH_SECTMAS	SECNR	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in	46C2