PlanningLevelFinal

DDL: PLANNINGLEVELFINAL SQL: FCLMPLFINAL Type: view Package: FCLM_CP
10 Fields 6 Data Sources

planning level with all priority

PlanningLevelFinal is a CDS View that provides data about "planning level with all priority" in SAP S/4HANA. It reads from 6 data sources and exposes 10 fields with key fields PlanningLevel, CompanyCode, ChartOfAccount, PlanningLevelasPlanningLevel, CompanyCode. Part of development package FCLM_CP.

Data Sources (6)

SourceAliasJoin Type
Fclm_Glgrouponlyepl epl left_outer
Fclm_Glgrouponlyepl epl left_outer
Fclm_Glgrouponlyepl epl left_outer
PlanningLevel1 pl from
PlanningLevel2 pl union
PlanningLevel3 pl union

Annotations (7)

NameValueLevelField
EndUserText.label planning level with all priority view
AbapCatalog.sqlViewName FCLMPLFINAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.compiler.compareFilter true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PlanningLevel PlanningLevel3 PlanningLevel Planning Level
KEY CompanyCode PlanningLevel3 CompanyCode Receiver Company Code
KEY ChartOfAccount PlanningLevel3 ChartOfAccount Node Class
KEY PlanningLevelasPlanningLevel
KEY CompanyCode PlanningLevel3 CompanyCode Receiver Company Code
KEY ChartOfAccount PlanningLevel3 ChartOfAccount Node Class
KEY PlanningLevelasPlanningLevel
KEY CompanyCode PlanningLevel3 CompanyCode Receiver Company Code
KEY ChartOfAccount PlanningLevel3 ChartOfAccount Node Class
KEY SUMGroupping PlanningLevel3 SUMGroupping

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 PlanningLevelFinal.
-- 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: FCLMPLFINAL

CREATE VIEW PlanningLevelFinal AS
SELECT
  pl.PlanningLevel AS PlanningLevel,
  pl.CompanyCode AS CompanyCode,
  pl.ChartOfAccount AS ChartOfAccount,
  pl.SUMGroupping as SUMGroupping AS PlanningLevelasPlanningLevel,
  pl.SUMGroupping AS SUMGroupping
FROM PlanningLevel1 AS pl
LEFT OUTER JOIN Fclm_Glgrouponlyepl AS epl ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): PlanningLevel2, PlanningLevel3
;

Learn More