I_PlanningLevelText

DDL: I_PLANNINGLEVELTEXT SQL: IPLANNINGLEVELT Type: view BASIC Package: FFCORE
5 Fields 1 Data Sources 1 Associations 11 OData Services

Planning Level - Text

I_PlanningLevelText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cash Flow Planning Level · Financial Operations

I_PlanningLevelText is a Basic CDS View that provides data about "Planning Level - Text" in SAP S/4HANA. It reads from 1 data source (t036t) and exposes 5 fields with key fields PlanningLevel, Language. It has 1 association to related views. It is exposed through 11 OData services (ASQL_F0731A, ASQL_F0735, ASQL_F1737, ...). Part of development package FFCORE.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-FQM-2CL
CapabilitiesLanguage-Dependent Text
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view helps to show planning levels and source symbols. With this view, you can get planning levels and relevant texts, and you can also know the exact sources for planning levels.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the planning levels and the sources?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t036t a from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
EndUserText.label Planning Level - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IPLANNINGLEVELT view
ObjectModel.representativeKey PlanningLevel view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.sapObjectNodeType.name CashFlowPlanningLevel view

OData Services (11)

ServiceBindingVersionContractRelease
ASQL_F0731A ASQL_F0731A C2 NOT_RELEASED
ASQL_F0735 ASQL_F0735 C2 NOT_RELEASED
ASQL_F1737 ASQL_F1737 C2 NOT_RELEASED
ASQL_F2332 ASQL_F2332 C2 NOT_RELEASED
ASQL_F2986 ASQL_F2986 C2 NOT_RELEASED
ASQL_F3029 ASQL_F3029 C2 NOT_RELEASED
ASQL_F3265 ASQL_F3265 C2 NOT_RELEASED
ASQL_F3266 ASQL_F3266 C2 NOT_RELEASED
ASQL_F3266A ASQL_F3266A C2 NOT_RELEASED
ASQL_F3446 ASQL_F3446 C2 NOT_RELEASED
ASQL_F4763 ASQL_F4763 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PlanningLevel ebene Planning Level
KEY Language spras Off. Language
PlanningLevelDescription Planning Level Description
PlanningLevelName Planning Level Name
_Language _Language

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 I_PlanningLevelText.
-- 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: IPLANNINGLEVELT

CREATE VIEW I_PlanningLevelText AS
SELECT
  ebene AS PlanningLevel,
  spras AS Language,
  cast( ltext as fclm_pl_desc preserving type ) AS PlanningLevelDescription,
  cast( ktext as fclm_pl_name preserving type ) AS PlanningLevelName
FROM t036t AS a
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More