C_MaintenancePlanValueHelp

DDL: C_MAINTENANCEPLANVALUEHELP SQL: CMPLANVH Type: view CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
8 Fields 1 Data Sources

Maintenance Plan

C_MaintenancePlanValueHelp is a Consumption CDS View that provides data about "Maintenance Plan" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanStdVH) and exposes 8 fields with key field MaintenancePlan. Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanStdVH I_MaintenancePlanStdVH from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMPLANVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.resultSet.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #CONSUMPTION view
Consumption.ranked true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc Maintenance Plan Description
MaintenancePlanCategory MaintenancePlanCategory Maintenance Plan Category
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
Customer Customer Sold-to Party
AuthorizationGroup AuthorizationGroup AuthorizGroup
_Customer _Customer
_MaintenancePlanCatParam _MaintenancePlanCatParam

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_MaintenancePlanValueHelp.
-- 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: CMPLANVH

CREATE VIEW C_MaintenancePlanValueHelp AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  MaintenancePlanCategory,
  MaintenanceStrategy,
  Customer,
  AuthorizationGroup
FROM I_MaintenancePlanStdVH
;

Learn More