A_PlanningLevel

DDL: A_PLANNINGLEVEL SQL: APLANNINGLEVEL Type: view BASIC

API FIN Planning Level

A_PlanningLevel is a Basic CDS View that provides data about "API FIN Planning Level" in SAP S/4HANA. It reads from 1 data source (I_PlanningLevel) and exposes 3 fields with key field PlanningLevel.

Data Sources (1)

SourceAliasJoin Type
I_PlanningLevel I_PlanningLevel from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName APLANNINGLEVEL view
EndUserText.label API FIN Planning Level view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PlanningLevel PlanningLevel Planning Level
ResourceSectionType PlanningLevelSourceSymbol Source
PlanningLevelName

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 A_PlanningLevel.
-- 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: APLANNINGLEVEL

CREATE VIEW A_PlanningLevel AS
SELECT
  PlanningLevel,
  PlanningLevelSourceSymbol AS ResourceSectionType,
  _Text[1:Language = $session.system_language].PlanningLevelName AS PlanningLevelName
FROM I_PlanningLevel
;