C_ProjectPlanningCategoryVH

DDL: C_PROJECTPLANNINGCATEGORYVH SQL: CPROJPLANCATEVH Type: view CONSUMPTION Package: ODATA_PS_COST_PROJ_OVERVIEW
10 Fields 1 Data Sources 1 Associations

Project Planning Category

C_ProjectPlanningCategoryVH is a Consumption CDS View (Dimension) that provides data about "Project Planning Category" in SAP S/4HANA. It reads from 1 data source (I_PlanningCategory) and exposes 10 fields with key field PlanningCategory. It has 1 association to related views. Part of development package ODATA_PS_COST_PROJ_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
I_PlanningCategory I_PlanningCategory from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PlanningCatApplicationType _PlanningCatApplicationType $projection.PlngCategoryApplicationType = _PlanningCatApplicationType.PlngCategoryApplicationType

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPROJPLANCATEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Planning Category view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PlanningCategory view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PlanningCategory PlanningCategory Plan Category
_Text _Text
PlngCategoryApplicationType PlngCategoryApplicationType Application type
PlngCatApplicationTypeName
ExchangeRateType ExchangeRateType Exch. Rate Type
CopyToPlngCategoryIsAllowed CopyToPlngCategoryIsAllowed Copy Allowed
PlanDataDeletionIsAllowed PlanDataDeletionIsAllowed Deletion Allowed
PlanDataCompressionIsAllowed PlanDataCompressionIsAllowed Comp. Allowed
PlanningCategoryUsage PlanningCategoryUsage Category Usage
PlanningCatIsForAvailyCtrl PlanningCatIsForAvailyCtrl AVC Active

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 C_ProjectPlanningCategoryVH.
-- 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: CPROJPLANCATEVH

CREATE VIEW C_ProjectPlanningCategoryVH AS
SELECT
  PlanningCategory,
  PlngCategoryApplicationType,
  cast ( _PlanningCatApplicationType._Text.PlngCatApplicationTypeName as fis_application_type_name ) AS PlngCatApplicationTypeName,
  ExchangeRateType,
  CopyToPlngCategoryIsAllowed,
  PlanDataDeletionIsAllowed,
  PlanDataCompressionIsAllowed,
  PlanningCategoryUsage,
  PlanningCatIsForAvailyCtrl
FROM I_PlanningCategory
LEFT OUTER JOIN I_PlanningCatApplicationType AS _PlanningCatApplicationType ON PlngCategoryApplicationType = _PlanningCatApplicationType.PlngCategoryApplicationType  -- association [0..1]
;

Learn More