Flying Hours for Pilots (Planned)

DataSource Transactional Data DataSource Transactional Data: 0DF_IS_DFS_53

This DataSource allows you to access data about planned flying hours for pilots from the source system.

Technical Data

Application Components ISDFPS BW Business Content (IS-DFS-BW)
Available as of Release SAP Defense Forces & Public Security 6.10
Shipment NW 2004s BI Content Add-On 3
Content Versions There are no content versions.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure Description of the Field in the Extract Structure Table of Origin Field in the Table of Origin
MANDT Client - -
TPROG_ID Training Program ID TRAIN_PLAN_VAL TPROG_ID
FUNCT_ID Function ID TRAIN_PLAN_VAL FUNCT_ID
STATUS_ID Training Status ID TRAIN_PLAN_VAL STATUS_ID
TRAIN_ID Training ID TRAIN_PLAN_VAL TRAIN_ID
ENDDA End Date TRAIN_PLAN_VAL ENDDA
BEGDA Start Date TRAIN_PLAN_VAL BEGDA
MIN_VALUE Minimum Training to Be Completed TRAIN_PLAN_VAL MIN_VALUE
PLAN_VALUE Planned Amount of Training to Be Completed TRAIN_PLAN_VAL PLAN_VALUE
UNIT_VALUE Unit TRAIN_PLAN_VAL UNIT_VALUE
Extractor Logic

Description of the Key Figures:

The extractor provides the following key figures:

  • MIN_VALUE: Minimal Requirement

  • PLAN_VALUE: Planned Requirement

Extraction Logic:

The extractor provides unenriched and unmanipulated data from the TRAIN_PLAN_VAL table.