C_MaintenancePlanCategoryDP

DDL: C_MAINTENANCEPLANCATEGORYDP Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
13 Fields 1 Data Sources 1 Associations 1 OData Services

Maintenance Plan Category Param

C_MaintenancePlanCategoryDP is a Consumption CDS View that provides data about "Maintenance Plan Category Param" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanCatParam) and exposes 13 fields with key field MaintenancePlanCategory. It has 1 association to related views. It is exposed through 1 OData service (DP_MAINTENANCEPLAN). Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanCatParam I_MaintenancePlanCatParam from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MaintPlanCategoryTextDP _Text

Annotations (12)

NameValueLevelField
EndUserText.label Maintenance Plan Category Param view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey MaintenancePlanCategory view
ObjectModel.sapObjectNodeType.name MaintenancePlanCategory view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
DataIntegration.deltaReplication.intended true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_MAINTENANCEPLAN DP_MAINTENANCEPLAN C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanCategory I_MaintenancePlanCatParam MaintenancePlanCategory MPlan cat.
MaintenancePlanCallObject I_MaintenancePlanCatParam MaintenancePlanCallObject Call Type
MaintPlanExternalRangeCode I_MaintenancePlanCatParam MaintPlanExternalRangeCode ExtNoRgMaintPln
MaintPlanInternalRangeCode I_MaintenancePlanCatParam MaintPlanInternalRangeCode IntNoRgMaintPln
MaintPlanIncludeScreenCatCode I_MaintenancePlanCatParam MaintPlanIncludeScreenCatCode Screen Number
OrderCategoryScreenTypeCode I_MaintenancePlanCatParam OrderCategoryScreenTypeCode Type
MaintPlanHasContract I_MaintenancePlanCatParam MaintPlanHasContract Outl. agreement
MaintCallDteHasSeparateCompltn I_MaintenancePlanCatParam MaintCallDteHasSeparateCompltn Confirm. data
ChangeDocumentCreationIsActive I_MaintenancePlanCatParam ChangeDocumentCreationIsActive Change document
MaintPlnSchedgRelIsToBeChgDocd I_MaintenancePlanCatParam MaintPlnSchedgRelIsToBeChgDocd DocumentRelease
MaintItemCausesAreDisplayed I_MaintenancePlanCatParam MaintItemCausesAreDisplayed Show Causes
MaintItemReasonsAreDisplayed I_MaintenancePlanCatParam MaintItemReasonsAreDisplayed Show Reasons
_Text _Text

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_MaintenancePlanCategoryDP.
-- 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.

CREATE VIEW C_MaintenancePlanCategoryDP AS
SELECT
  I_MaintenancePlanCatParam.MaintenancePlanCategory AS MaintenancePlanCategory,
  I_MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject,
  I_MaintenancePlanCatParam.MaintPlanExternalRangeCode AS MaintPlanExternalRangeCode,
  I_MaintenancePlanCatParam.MaintPlanInternalRangeCode AS MaintPlanInternalRangeCode,
  I_MaintenancePlanCatParam.MaintPlanIncludeScreenCatCode AS MaintPlanIncludeScreenCatCode,
  I_MaintenancePlanCatParam.OrderCategoryScreenTypeCode AS OrderCategoryScreenTypeCode,
  I_MaintenancePlanCatParam.MaintPlanHasContract AS MaintPlanHasContract,
  I_MaintenancePlanCatParam.MaintCallDteHasSeparateCompltn AS MaintCallDteHasSeparateCompltn,
  I_MaintenancePlanCatParam.ChangeDocumentCreationIsActive AS ChangeDocumentCreationIsActive,
  I_MaintenancePlanCatParam.MaintPlnSchedgRelIsToBeChgDocd AS MaintPlnSchedgRelIsToBeChgDocd,
  I_MaintenancePlanCatParam.MaintItemCausesAreDisplayed AS MaintItemCausesAreDisplayed,
  I_MaintenancePlanCatParam.MaintItemReasonsAreDisplayed AS MaintItemReasonsAreDisplayed
FROM I_MaintenancePlanCatParam
LEFT OUTER JOIN C_MaintPlanCategoryTextDP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More