FPMT_PLANE_H

DDL: FPMT_PLANE_H SQL: FPMT_VPLANE_H Type: view Package: BW_REPORTING_FPM_TESTS
10 Fields 1 Data Sources

Airplane Hierarchy

FPMT_PLANE_H is a CDS View that provides data about "Airplane Hierarchy" in SAP S/4HANA. It reads from 1 data source (fpmt_airplane_h) and exposes 10 fields with key fields Hieid, Nodeid. Part of development package BW_REPORTING_FPM_TESTS.

Data Sources (1)

SourceAliasJoin Type
fpmt_airplane_h fpmt_airplane_h from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FPMT_VPLANE_H view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Airplane Hierarchy view
ObjectModel.dataCategory #HIERARCHY view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Hieid hieid R/2 table
KEY Nodeid nodeid Workflow Step
Parentid parentid UUID
Planetype planetype Planetype
Nodename nodename Node Text
Seqno seqno Tab Seq. No.
_Airplane _Airplane
_HierDir _HierDir
_Node _Node
_Parent _Parent

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FPMT_PLANE_H.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FPMT_VPLANE_H

CREATE VIEW FPMT_PLANE_H AS
SELECT
  Hieid,
  Nodeid,
  Parentid,
  Planetype,
  Nodename,
  Seqno
FROM fpmt_airplane_h
;

Learn More