V_PLT_SINGLE

DDL: V_PLT_SINGLE SQL: VPLTSNGL Type: view
2 Fields 2 Data Sources

Planning Type Single Mapping

V_PLT_SINGLE is a CDS View that provides data about "Planning Type Single Mapping" in SAP S/4HANA. It reads from 2 data sources (t037, V_PLT_COUNT) and exposes 2 fields.

Data Sources (2)

SourceAliasJoin Type
t037 plt inner
V_PLT_COUNT plt_count from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VPLTSNGL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Planning Type Single Mapping view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view

Fields (2)

KeyFieldSource TableSource FieldDescription
PlanningLevel V_PLT_COUNT PlanningLevel Planning Level
PlanningType t037 dsart Memo Recd Type

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 V_PLT_SINGLE.
-- 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: VPLTSNGL

CREATE VIEW V_PLT_SINGLE AS
SELECT
  plt_count.PlanningLevel AS PlanningLevel,
  plt.dsart AS PlanningType
FROM V_PLT_COUNT AS plt_count
INNER JOIN t037 AS plt ON /* join condition not captured in parsed metadata */
;

Learn More